Re: table lookup errors when postfix tries to read mysql virtual

On Sat, 4 Jun 2005 09:36:52 -0400
Bud Roth <budroth@obitori.net> wrote:

> PROBLEM:
> postfix is delivering repetitive errors when trying to access the
> mysql backend for my virtual mail domains. Similarly, postfixadmin, a
> PHP-based front end, reports an error accessing mysql when trying to
> create a new mailbox. Any suggestions would be appreciated.
>


OK, so you've got two problems. I'd suggest fixing the postfixadmin one
first as it may be the cause of the postfix problem.


>
> 2. ERROR LOG -- SYSLOG (postfix table error messages)
>
> postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
> Jun 4 03:28:15 salmon postfix/trivial-rewrite[5017]: fatal:
> mysql:/usr/local/etc/
> postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
> Jun 4 03:28:40 salmon ctl_cyrusdb[5018]: checkpointing cyrus
> databases Jun 4 03:28:40 salmon ctl_cyrusdb[5018]: done checkpointing
> cyrus databases Jun 4 03:29:17 salmon postfix/trivial-rewrite[5019]:
> fatal: mysql:/usr/local/etc/
> postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
> Jun 4 03:30:18 salmon postfix/trivial-rewrite[5023]: fatal:
> mysql:/usr/local/etc/
> postfix/mysql_virtual_alias_maps.cf(0,100): table lookup problem
>
>
> 3. ERROR LOG -- POSTFIXADMIN (mysql error)
>
> DEBUG INFORMATION:
> Invalid query: You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near 'goto,domain,created,modified,active) VALUES
> ('bobby@obitori.net','bobby@obitori.' at line 1
> Please check the documentation and website for more information.
>
> This error is caused by trying to create an email mailbox for the
> obitori.net mail domain. The corresponding mailbox table in mysql is
> empty.
>

Run MySQL in debug mode and log each command. then try running them in
command line mode to debug them.

In all probability you've missed a column out or mis-spelt the name of
one but we can't tell from what you've posted.

You won't be able to tell unless you know exactly what command was
issued. It looks like a mis-matched set of quotes, but that could simply
be your cut-and-paste job.

> Nonetheless, I can see the domains created by postfixadmin, so it is
> connecting to that table.
>

That proves it's a table-level problem not a database level one. I'd
have expected that from the error you posted.

Once you have some rows in the database then try the same thing with the
postfix query.

--
I do not reply to directly addressed mail unless it is clearly a matter
that should be dealt with off-list.