Arch Linux

Bueno

Member

Registered: 2009-06-21

Posts: 10

Problem with Exim+mysql

how to build Exim with mysql support?

I add these options in PKGBUILD

  sed 's|^# LOOKUP_MYSQL=yes$|LOOKUP_MYSQL=yes|' | \
  sed 's|^# LOOKUP_INCLUDE=-I /usr/include/mysql|LOOKUP_LIBS=-lmysqlclient|' | \

--> makepkg
...
gcc dkim-exim.c

awk '{ print ($1+1) }' cnumber.h > cnumber.temp
rm -f cnumber.h; mv cnumber.temp cnumber.h
gcc version.c
rm -f exim
gcc -o exim
drtables.o:(.data+0x188): undefined reference to `mysql_open'
drtables.o:(.data+0x190): undefined reference to `mysql_find'
drtables.o:(.data+0x198): undefined reference to `mysql_tidy'
drtables.o:(.data+0x19c): undefined reference to `mysql_quote'
collect2: ld returned 1 exit status
make[1]: *** [exim] Error 1
make[1]: Leaving directory `/home/abs/exim/src/exim-4.69/build-Linux-i386'
make: *** [go] Error 2
==> ERROR: Build Failed.
    Aborting...

What am I doing wrong?

Bueno

Member

Registered: 2009-06-21

Posts: 10

Re: Problem with Exim+mysql

I find error:

make[2]: Entering directory `/home/abs/exim/src/exim-4.69/build-Linux-i386/lookups'
gcc cdb.c
gcc dbmdb.c
gcc dkim.c
gcc dnsdb.c
gcc dsearch.c
gcc ibase.c
gcc ldap.c
gcc lsearch.c
gcc mysql.c
mysql.c:33:49: error: mysql.h: No such file or directory
mysql.c:41: error: expected specifier-qualifier-list before Б─≤MYSQLБ─≥
mysql.c: In function Б─≤mysql_tidyБ─≥:
mysql.c:76: error: Б─≤mysql_connectionБ─≥ has no member named Б─≤handleБ─≥
mysql.c: In function Б─≤perform_mysql_searchБ─≥:
mysql.c:108: error: Б─≤MYSQLБ─≥ undeclared (first use in this function)
mysql.c:108: error: (Each undeclared identifier is reported only once
mysql.c:108: error: for each function it appears in.)
mysql.c:108: error: Б─≤mysql_handleБ─≥ undeclared (first use in this function)
mysql.c:109: error: Б─≤MYSQL_RESБ─≥ undeclared (first use in this function)
mysql.c:109: error: Б─≤mysql_resultБ─≥ undeclared (first use in this function)
mysql.c:110: error: Б─≤MYSQL_ROWБ─≥ undeclared (first use in this function)
mysql.c:110: error: expected Б─≤;Б─≥ before Б─≤mysql_row_dataБ─≥
mysql.c:111: error: Б─≤MYSQL_FIELDБ─≥ undeclared (first use in this function)
mysql.c:111: error: Б─≤fieldsБ─≥ undeclared (first use in this function)
mysql.c:150: error: Б─≤mysql_connectionБ─≥ has no member named Б─≤handleБ─≥
mysql.c:205: warning: comparison between pointer and integer
mysql.c:217: error: Б─≤mysql_connectionБ─≥ has no member named Б─≤handleБ─≥
mysql.c:273: error: Б─≤mysql_row_dataБ─≥ undeclared (first use in this function)
mysql.c:275: warning: initialization makes pointer from integer without a cast
make[2]: *** [mysql.o] Error 1
make[2]: Leaving directory `/home/abs/exim/src/exim-4.69/build-Linux-i386/lookups'

/home/abs/exim/src/exim-4.69/build-Linux-i386/lookups <- here it is

Where he looks for this file?

Last edited by Bueno (2009-06-21 21:18:58)

foutrelis

Developer

From: Athens, Greece

Registered: 2008-07-28

Posts: 705

Website

Re: Problem with Exim+mysql

Your second sed command doesn't look right. Here's a working PKGBUILD for you. Additions/Changes are highlighted.

Bueno

Member

Registered: 2009-06-21

Posts: 10

Re: Problem with Exim+mysql

Thank you very much! Now everything works.