when i do "SELECT * FROM valias;" on vpopmail host, i see an output like this: +-------+---------------+--------------------------------+ | alias | domain | valias_line | +-------+---------------+--------------------------------+ | tanne | envia-tel.net | [EMAIL PROTECTED] |
There is no problem. I can get data from valias-table. When i do "valias -s [EMAIL PROTECTED]", i see the following: [EMAIL PROTECTED] -> [EMAIL PROTECTED] This looks also ok.
regards Dirk
Am 10.05.2005 18:51 schrieb Chris Godwin:
My first action would be to login to the mysql server from the box that
vpopmail is on. See if you can run this query "SELECT * FROM valias;".
Sometimes if your mysql server is on another box host permissions can get
fowled up.
----- Original Message ----- From: "Dirk Tanneberger" <[EMAIL PROTECTED]>
To: <vchkpw@inter7.com>
Sent: Tuesday, May 10, 2005 10:05 AM
Subject: Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating
table 'valias'
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
