> 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: <vchkpw@inter7.com>
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



Reply via email to