Mailing List Archive: exim: users

cannot get mysql support

Index | Next | Previous | View Threaded

dmitry_sh at pisem

May 7, 2008, 11:16 PM

Post #1 of 5 (96 views)
Permalink

cannot get mysql support

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

In Local/Makefile:
LOOKUP_MYSQL=yes
LOOKUP_INCLUDE=-I /usr/include/mysql
LOOKUP_LIBS=-L/usr/lib -lmysqlclient -lz -lcrypt -lnsl -lm

After compilation i see:
ldd bin/exim
/lib/libcwait.so (0x005d1000)
libresolv.so.2 => /usr/local/lib/libresolv.so.2 (0x00b87000)
libnsl.so.1 => /usr/local/lib/libnsl.so.1 (0x00ddc000)
libcrypt.so.1 => /usr/local/lib/libcrypt.so.1 (0x00302000)
libm.so.6 => /usr/local/lib/tls/libm.so.6 (0x0092b000)
libdb-4.2.so => /usr/local/lib/tls/i686/libdb-4.2.so
(0x00179000)
libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15
(0x00c01000)
libz.so.1 => /usr/local/lib/libz.so.1 (0x00111000)
libperl.so =>
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/CORE/libperl.so
(0x00473000)
libdl.so.2 => /usr/local/lib/libdl.so.2 (0x00ec9000)
libutil.so.1 => /usr/local/lib/libutil.so.1 (0x00122000)
libpthread.so.0 => /usr/local/lib/tls/libpthread.so.0
(0x00ac0000)
libc.so.6 => /usr/local/lib/tls/libc.so.6 (0x00741000)
libssl.so.4 => /usr/local/lib/libssl.so.4 (0x00126000)
libcrypto.so.4 => /usr/local/lib/libcrypto.so.4 (0x00330000)
/lib/ld-linux.so.2 (0x009e4000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2
(0x0015a000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00247000)
libcom_err.so.2 => /usr/local/lib/libcom_err.so.2
(0x0016e000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x002ac000)

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

and check:
exim -bV
Exim version 4.69 #1 built 08-May-2008 05:24:28
Copyright (c) University of Cambridge 2006
Berkeley DB: Sleepycat Software: Berkeley DB 4.2.52: (December 11,
2004)
Support for: crypteq iconv() Perl OpenSSL move_frozen_messages
Content_Scanning
Lookups: lsearch wildlsearch nwildlsearch iplsearch dbm dbmnz mysql
Authenticators: cram_md5 dovecot plaintext
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir autoreply pipe smtp
Fixed never_users: 0
Size of off_t: 8
2008-05-08 06:03:07 Exim configuration error in line 823 of
/usr/exim/exim.conf:
option "mysql_servers" unknown

Can anybody help me why i can't get mysql suppot?

It seems all in right places.

I will appreciate any help.
Thank you.

dmitry scherbinin

--
## 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/

wbh at conducive

May 7, 2008, 11:46 PM

Post #2 of 5 (91 views)
Permalink

Re: cannot get mysql support [In reply to]

ï¿½ï¿½ 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
>
*snip*

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

*snip*

See below in re what line that appears on.

> Lookups: lsearch wildlsearch nwildlsearch iplsearch dbm dbmnz mysql

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

*snip*

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

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

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

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

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

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

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

/tmp/.s.PGSQL.5432

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

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

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

HTH,

Bill

--
## 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/

peter at bowyer

May 8, 2008, 12:42 AM

Post #3 of 5 (88 views)
Permalink

Re: cannot get mysql support [In reply to]

On 08/05/2008, äÏËÖÆËÌ øÅÆÞËÐËÐ <dmitry_sh[at]pisem.net> wrote:
> 2008-05-08 06:03:07 Exim configuration error in line 823 of
> /usr/exim/exim.conf:
> option "mysql_servers" unknown
>
> Can anybody help me why i can't get mysql suppot?
>
> It seems all in right places.
>

If its in line 823, then it's probably in the wrong place -
mysql_servers is a main configuration option which goes in the first
section of the config file.

Peter

--
Peter Bowyer
Email: peter[at]bowyer.org
Follow me on Twitter: twitter.com/peeebeee
--
## 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/

martin at antibodymx

May 8, 2008, 1:19 AM

Post #4 of 5 (86 views)
Permalink

Re: cannot get mysql support [In reply to]

??????? ???????? wrote:
> Here is my configuration:
> RHEL 4

If you're using RHEL then you should be using the official Redhat RPMs
for exim. To my knowledge, these include MySQL support.

--
Martin A. Brooks | http://www.antibodymx.net/ | Anti-spam & anti-virus
Consultant | martin[at]antibodymx.net | filtering. Inoculate
antibodymx.net | m: +447792493388 | your mail system.

--
## 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/

DScherbinin at semsk

May 11, 2008, 10:38 PM

Post #5 of 5 (45 views)
Permalink

Re: cannot get mysql support [In reply to]

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[at]semsk.telecom.kz

--
## 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/

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com