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: 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: 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!
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: > > 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: > >>> 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,
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: 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: 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
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: 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
I'm just wondering the same... Why is it appearing the Apache log? - Original Message - From: "Mitja Pirih" <[EMAIL PROTECTED]> To: 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: 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
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: 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
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: 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
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: 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!
