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: <[email protected]> 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: <[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 > > > > > >
