Have been trying to get vpopmail + qmail + vqadmin etc... to work... no luck... simply
going round and round (for five days now -- does not make one feel too good about
nothing ;-)
Clues:
------
telnet localhost 110
returns with an error:
vmysql: sql error[3]: Table 'vpopmail.vpopmail' doesn't exist
-ERR authorization failed
Over some of the build iterations, telnet localhost 110 did succeed but there were
additional issues, promoting a rebuild with a different set, etc... my guess is that
solving this one, may solve all... and get me smiling again!
mysql shows the vpopmail database, though no vpopmail.vpopmail table...
./vadddomain www9.landings.com PW
reports:
Error: Domain already exists
./vdeldomain www9.landings.com
reports:
Warning: Could not access (/var/vpopmail/domains/www9.landings.com)
Warning: Failed while attempting to delete domain from auth backend
Warning: Failed to delete directory tree: www9.landings.com
ls -l /var/vpopmail
total 24
drwxr-xr-x 2 vpopmail vchkpw 4096 Dec 28 22:59 bin
drwxr-xr-x 4 vpopmail vchkpw 4096 Dec 28 22:59 doc
drwx------ 2 vpopmail vchkpw 4096 Dec 28 22:59 domains
drwxr-xr-x 2 vpopmail vchkpw 4096 Dec 29 00:21 etc
drwxr-xr-x 2 vpopmail vchkpw 4096 Dec 28 22:59 include
drwxr-xr-x 2 vpopmail vchkpw 4096 Dec 28 22:59 lib
How can the above be fixed?
The concept:
arrive at RH7.2 server capable of ezmlm with web admin, webmail, virtual domains...
with backend support via mysql.
Thanks,
Yonatan.
=================================
setup:
RH7.2
MySQL 4.1.1
vpopmail-5.4.0-pre2
vqadmin-2.3.6
qmailadmin-1.2.0-rc1
netqmail-1.04 (qmail)
ezmlm-idx-0.40
ezmlm-0.53
qmail-scanner-1.20
ucspi-tcp-0.88
autorespond-2.0.2
vqadmin
=======
It seems that where it gets into trouble now (and me too ;-) is when trying to add a
new-domain (the first one).
Vqadmin reports:
Database error
display_add_domain: Access denied for user: 'my_user'@'localhost' (Using password: YES)
vpopmail is not able to complete the connection either (see above)
vpopmail conf:
-------------
contents of vpopmail.mysql
localhost|0|vpopmail|PW|vpopmail
configured as:
./configure \
--enable-vpopuser=vpopmail \
--enable-vpopgroup=vchkpw \
--enable-tcpserver-file=/var/vpopmail/etc/tcp.smtp \
--enable-log-name=vpopmail \
--enable-roaming-users=y \
--enable-logging=p \
--enable-defaultquota=52428800 \
--enable-ip-alias-domains=n \
--enable-passwd=n \
--enable-clear-passwd=y \
--enable-domain-quotas=y \
--enable-many-domains=y \
--enable-auth-logging=y \
--enable-mysql-logging=y \
--enable-valias=y \
--enable-mysql-limits=y \
--enable-relay-clear-minutes=30 \
--enable-domains-dir=domains \
--enable-qmail-ext=y \
--enable-auth-module=mysql \
--enable-learn-passwords=y \
--enable-mysql-replication=y
Current settings
---------------------------------------
vpopmail directory = /var/vpopmail
uid = 89
gid = 89
roaming users = ON --enable-roaming-users
tcpserver file = /var/vpopmail/etc/tcp.smtp
open_smtp file = /var/vpopmail/etc/open-smtp
rebuild tcpserver file = ON --enable-rebuild-tcpserver-file (default)
password learning = ON --enable-learn-passwords
md5 passwords = ON --enable-md5-passwords (default)
file locking = ON --enable-file-locking (default)
vdelivermail fsync = OFF --disable-file-sync (default)
make seekable = ON --enable-make-seekable (default)
clear passwd = ON --enable-clear-passwd (default)
user dir hashing = ON --enable-users-big-dir (default)
address extensions = ON --enable-qmail-ext
ip alias = OFF --disable-ip-alias-domains (default)
user quota = 52428800 --enable-hardquota=52428800
domain quotas = OFF --disable-domainquotas (default)
auth module = mysql --enable-auth-module=mysql
mysql replication = ON --enable-mysql-replication
mysql logging = ON --enable-mysql-logging
mysql limits = ON --enable-mysql-limits
MySQL valias = ON --enable-valias
auth inc = -I/usr/include/mysql
auth lib = -L/usr/lib/mysql -lmysqlclient -lz
system passwords = OFF --disable-passwd (default)
pop syslog = show failed attempts with clear text password
--enable-logging=p
auth logging = ON --enable-auth-logging
all domains in one SQL table = --enable-many-domains (default)
vqadmin:
---------
./configure --enable-cgibindir=/home/httpd/cgi-bin --enable-mysql=y \
--enable-htmldir=/home/httpd/htdocs/
Current settings
---------------------------------------
vpopmail directory = /var/vpopmail
uid = 89
gid = 89
cgi-bin dir = /home/httpd/cgi-bin/
vqadmin dir = /home/httpd/cgi-bin//vqadmin
with some patches found for 2.3.6
