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 ;-)


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
Error: Domain already exists

./vdeldomain www9.landings.com
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.




MySQL 4.1.1
netqmail-1.04 (qmail)


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

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 \

           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
      auth logging = ON  --enable-auth-logging
all domains in one SQL table = --enable-many-domains (default)


./configure --enable-cgibindir=/home/httpd/cgi-bin --enable-mysql=y \

           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

Reply via email to