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


Reply via email to