Re: [exim] Failed to log in MySQL

On Thu, Sep 18, 2008 at 2:37 AM, aedi <ak@???> wrote:
>
> 1)
> 2008-09-18 13:20:30 1KgH6n-0000mf-IC failed to expand "@ : ${lookup
> mysql{SELECT DISTINCT domain FROM domains WHERE type = 'local' AND enabled =
> '1' AND domain = '${quote_mysql:$domain}'}} : ${lookup mysql{SELECT DISTINCT
> alias FROM domainalias WHERE alias = '${quote_mysql:$domain}'}}" while
> checking a list: lookup of "SELECT DISTINCT domain FROM domains WHERE type =
> 'local' AND enabled = '1' AND domain = 'DOMAINNAME'" gave DEFER: MYSQL
> connection failed: Access denied for user 'vexim'@'localhost' (using
> password: NO)
> why does he use no password??

It's not complaining about your query. It's complaining about the
user and password that exim is trying to use to connect to the mysql
database. That's set in your exim.conf by this line:

hide mysql_servers = localhost/$DATABASE/vexim/$PASSWORD

Replace $DATABASE with the database that you put your data in, and
replace $PASSWORD with the password you assigned to the vexim user to
access the mysql database. Refer to mysql documentation and the GRANT
command to allow user vexim to the database. The mysql manual has a
great example in it.

> 2)
> when i add a new local domain, he dont create a new maildir. about these
> error i didnt get an error log msg.

Make sure that the vexim user owns the directories and can create
directories where you are telling it to create them.
--
Regards... Todd