On Thu, Sep 18, 2008 at 2:37 AM, aedi <[EMAIL PROTECTED]> 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 -- ## List details at http://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
