Wierd. ----- Original Message ----- From: "Dirk Tanneberger" <[EMAIL PROTECTED]> To: <vchkpw@inter7.com> Sent: Wednesday, May 11, 2005 3:19 AM Subject: Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'
> 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 > >>> > >>> > >>> > > > >