Re: [exim] cannot get mysql support

Top Page
Delete this message
Reply to this message
Author: Щербинин Д.Г.
Date:  
To: exim-users
Subject: Re: [exim] cannot get mysql support
Hello W,

Thursday, May 8, 2008, 12:46:51 PM, you wrote:

WBH> ?? wrote:
>>
>> Good day!
>>
>> I am trying to build exim with mysql support.
>>
>> Here is my configuration:
>> RHEL 4
>> MySQL 5.0.45 community
>> Exim 4.69
>>
WBH> *snip*


>> Then in config:
>> hide mysql_servers = localhost/exim/mail/secret-pass


WBH> *snip*


WBH> See below in re what line that appears on.


>> Lookups: lsearch wildlsearch nwildlsearch iplsearch dbm dbmnz mysql


WBH> That says the build gave you the necessary MySQL support...


WBH> *snip*


>> 2008-05-08 06:03:07 Exim configuration error in line 823 of
>> /usr/exim/exim.conf:
>> option "mysql_servers" unknown


WBH> Can you confirm that this is indeed on line 823, is in the 'main'
WBH> section, i.e. before any acl's or router/transport sets appear, and is
WBH> the *only* such call in the entire config file?


WBH> N.B. Line 823 seems rather too high a line-count for the position of the
WBH> 'hide mysql..' call. Unless you've left all the comments in-place, this
WBH> is more often in the first 10 to 50 lines.


WBH> Further, the format you have used may not be quite correct. Do you need
WBH> a username as well as a password, for example?


WBH> PostgreSQL is *slightly* different from MYSQL, but ours looks like this:


WBH> hide pgsql_servers = (/tmp/<socketfilename>)/<table>/<user>/<password>


WBH> There are no "<" or ">" in the original, the parenthesis matter, and the
WBH> <socketfilename> is not an 'ordinary' file, but something akin to:


WBH> /tmp/.s.PGSQL.5432


WBH> You can also use an IP instead of a unix socket, pros and cons discussed
WBH> elsewhere, but if so, a specific IP would be my preference, AND NOT
WBH> 'localhost', even if you have to alias-up a bespoke IP just for MySQL
WBH> and the MTA to use.


WBH> In general IP is best if/as/when the DB is not on the same box as the
WBH> MTA, and the communication is on an internal-only LAN ELSE otherwise
WBH> secured (SSL tunnel, matching PEM certs, etc.)


WBH> Sockets are generally better all-around for same-box use.


WBH> HTH,


WBH> Bill




You were right - I've put <mysql_servers> in the end of config.
Now all works
Thanks


-- 
Best regards,
 Щербинин                            mailto:DScherbinin@semsk.telecom.kz