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:489af51232317979431900!
