> Well it is clear what the problem is. Have you granted privilages to the > user vpopmail in your mysql database? Have you edited > /home/vpopmail/etc/vpopmail.mysql?
/home/vpopmail/etc/vpopmail.mysql is edited correctly and user vpopmail in my mysql database has not enough privileges to do this. He has only the rights for read and write in the table. This should be enough for an incoming only server, or? I'm wondering what is the reason that vmysql will create this table? The only tool that works during the smtp-session is chkuser, or?
regards Dirk Tanneberger
Am 10.05.2005 14:24 schrieb Chris Godwin:
Well it is clear what the problem is. Have you granted privilages to the user vpopmail in your mysql database? Have you edited /home/vpopmail/etc/vpopmail.mysql?
----- Original Message ----- From: "Dirk Tanneberger" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, May 10, 2005 2:32 AM
Subject: [vchkpw] undefined entry in smtpd-log - vmysql: error creating
table 'valias'
hello,
i'm using a server for incoming mail only, with the following software: - netqmail-1.05 - vpopmail-5.4.10 with mysql-server on other host - chkuser-2.0.8b-release - qmail-scanner-1.25
vpopmail-configure-options:
./configure --enable-roaming-users=y --enable-auth-module=mysql --enable-mys ql-replication=y \
--enable-incdir=/space/software/mailserver/mysql-standard-4.0.24-pc-linux-
gnu-i686/include \
--enable-libdir=/space/software/mailserver/mysql-standard-4.0.24-pc-linux-
gnu-i686/lib \
--enable-relay-clear-minutes=60 --enable-logging=v --enable-clear-passwd=y
\
--enable-valias=y --enable-auth-logging=y --disable-passwd --disable-md5-p
asswords
in my smtpd-log i see sometimes a entry like this: +++++++++++++++++ @4000000042804ea611514bd4 vmysql: error creating table 'valias': create
command denied to user: '[EMAIL PROTECTED]' for table 'valias'
+++++++++++++++++ user vpopmail has no rights to create the valias-table on remote mysql-db,
that's right, but
on remote mysql-db valias-tables already exists.
What is the reason that vmysql will create this table and where can i shut
up this action?
Thanks for any answer.
regards
Dirk Tanneberger
