Re: [vchkpw] vmysql: can't read settings from
Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja !DSPAM:489af35632311887213678!
Re: [vchkpw] vmysql: can't read settings from
Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net !DSPAM:489af51232317979431900!
Re: [vchkpw] vmysql: can't read settings from
Is the command executed inside Apache? So the user executing the command is the apache user, and not vpopmail. Ciao, Tonino Mitja Pirih ha scritto: Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- [EMAIL PROTECTED]Interazioni di Antonio Nati http://www.interazioni.it [EMAIL PROTECTED] !DSPAM:489af5ab32311952118000!
Re: [vchkpw] vmysql: can't read settings from
I'm just wondering the same... Why is it appearing the Apache log? - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:13 PM Subject: Re: [vchkpw] vmysql: can't read settings from Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net !DSPAM:489af6f032312115357448!
Re: [vchkpw] vmysql: can't read settings from
Ciao, Hmmm...I forgot to mention that the error happens when I am using qmailadmin (sorry, my mistake) and it looks that I am in the wrong list now Apache is not chrooted and yes qmailadmin is probably executed as apache user. Tonix (Antonio Nati) wrote: Is the command executed inside Apache? So the user executing the command is the apache user, and not vpopmail. Ciao, Tonino Mitja Pirih ha scritto: Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net !DSPAM:489afab432311794110871!
Re: [vchkpw] vmysql: can't read settings from
Because it is executed by qmailadminforgot to mention. Wouter van der Schagt wrote: I'm just wondering the same... Why is it appearing the Apache log? - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:13 PM Subject: Re: [vchkpw] vmysql: can't read settings from Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net !DSPAM:489afaf332311758032478!
Re: [vchkpw] vmysql: can't read settings from
On Thursday 07 August 2008 14:38, Mitja Pirih wrote: Because it is executed by qmailadminforgot to mention. qmailadmin needs to be set user id on execution and set group id on execution -rwsr-sr-x 1 vpopmail vchkpw 140568 2006-05-12 12:50 qmailadmin Wouter van der Schagt wrote: I'm just wondering the same... Why is it appearing the Apache log? - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:13 PM Subject: Re: [vchkpw] vmysql: can't read settings from Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- - Bob Hutchinson Midwales dot com - !DSPAM:489b13b632312052316246!
Re: [vchkpw] vmysql: can't read settings from SOLVED
Just for the record... Obviously it was my mistake when configuring disk partitions. On my other installations I always mounted my apache partition as suid. This time I mounted http document root partition not the whole apache installation. Stupid mistakeit looks like I should take a vacation. Thank you! Mitja Bob Hutchinson wrote: On Thursday 07 August 2008 14:38, Mitja Pirih wrote: Because it is executed by qmailadminforgot to mention. qmailadmin needs to be set user id on execution and set group id on execution -rwsr-sr-x 1 vpopmail vchkpw 140568 2006-05-12 12:50 qmailadmin Wouter van der Schagt wrote: I'm just wondering the same... Why is it appearing the Apache log? - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:13 PM Subject: Re: [vchkpw] vmysql: can't read settings from Hi, Yes, the file exists. The permissions are also OK. # ls -l /home/vpopmail/etc/vpopmail.mysql -rw-r- 1 vpopmail vchkpw 45 Aug 7 14:01 /home/vpopmail/etc/vpopmail.mysql # cat /home/vpopmail/etc/vpopmail.mysql localhost|0|vpopmailuser|vpoppasswd|vpopmail # mysql -h localhost -u vpopmailuser -pvpoppasswd vpopmail Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.0.51a-log OpenBSD port: mysql-server-5.0.51a Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye Other ideas? Thank you, Mitja Wouter van der Schagt wrote: Hi, Does the file exist ? it should have permissions 640 and owned by vpopmail:vchkpw in a standard installation. The file itself contains mysql login settings like (example contents below). # MYSQL CONNECTION SETTINGS FOR VPOPMAIL # # Line 1 defines the connection to use for database reads, # Line 2 defines the connection to use for database updates/writes. # # If you omit line 2, then the same settings will be # used for both read and write. # # settings for each line: # host|port|user|password|database # #localhost|0|root|secret|vpopmail localhost|0|databaseusername|databasepassword|database # # Note: # The value of host may be either a hostname or an IP address. # If host is 'localhost', then sockets (Unix) or named pipes (Windows) # will be used instead of TCP/IP to connect to the server. I hope this can help, it works for me, im not getting any error messages. - Wouter - Original Message - From: Mitja Pirih [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, August 07, 2008 9:01 PM Subject: [vchkpw] vmysql: can't read settings from Hello, I searched through the mailing lists and did not find a solution to my problem. I am getting in apache log: vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Vpopmail looks fully operational in cmd and it can connect to mysql, so should not be related to permissions. # /home/vpopmail/bin/vuserinfo [EMAIL PROTECTED] name: postmaster passwd: $1$X clear passwd: hello comment/gecos: Postmaster uid:0 gid:0 flags: 0 gecos: Postmaster limits: No user limits set. dir: /home/vpopmail/domains/.yy/postmaster quota: NOQUOTA usage: NOQUOTA account created: Thu Aug 7 14:24:36 2008 last auth: Never logged in mount: /dev/raid0a on / type ffs (local) /dev/raid0f on /tmp type ffs (local, nodev, nosuid, softdep) /dev/raid0g on /usr type ffs (local, nodev, softdep) /dev/raid0d on /var type ffs (local, nodev, nosuid, softdep) /dev/raid0e on /var/log type ffs (local, nodev, nosuid, softdep) /dev/raid1a on /var/mysql type ffs (local, nodev, nosuid, softdep) /dev/raid1d on /var/www/webpages type ffs (local, nodev, nosuid, softdep) /dev/raid1e on /var/qmail type ffs (local, nodev, softdep) vpopmail home dir is in /var/qmail/vpopmail and symlinked to /home/vpopmail. # userinfo vpopmail login vpopmail passwd * uid 98 groups vchkpw change NEVER class gecos dir /home/vpopmail shell /bin/ksh expire NEVER Any ideas what to check? Other details: -OS OpenBSD 4.3-stable -mysql 5.0.51a -php5-core-5.2.5p2 -vpopmail-5.4.18 -netqmail-1.05 -- Mitja __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net __ NOD32 3336 (20080807) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- Mitja Pirih IT Security Manager Phone: +386 59 212 000 Mobile: +386 40 685 464 http://www.simple-it.net !DSPAM:489b736f32311404275091!