On Thursday 07 August 2008 14:38, Mitja Pirih wrote: > Because it is executed by qmailadmin....forgot 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$XXXXXXXXXXXXX > >>>> clear passwd: hello > >>>> comment/gecos: Postmaster > >>>> uid: 0 > >>>> gid: 0 > >>>> flags: 0 > >>>> gecos: Postmaster > >>>> limits: No user limits set. > >>>> dir: /home/vpopmail/domains/xxxx.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!
