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$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



!DSPAM:489afab432311794110871!

Reply via email to