relocation error (DBD-mysql-2.1025)

am 26.02.2003 21:28:26 von Marc Delisle

Hi,

I have a problem with spamd trying to connect to MySQL:

/usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/i386-linux/auto/DBD/my
sql/mysql.so: undefined symbol: mysql_init

So I read the doc :) and found a suggestion to link statically libmysqlclient.a,
but I cannot find the right syntax with "perl Makefile.PL" to link statically
my libmysqlclient.a which is in /root/marc.

Marc Delisle

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2049@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: relocation error (DBD-mysql-2.1025)

am 03.03.2003 01:50:15 von Jochen Wiedmann

Quoting Marc Delisle :

> So I read the doc :) and found a suggestion to link statically
> libmysqlclient.a,
> but I cannot find the right syntax with "perl Makefile.PL" to link
> statically
> my libmysqlclient.a which is in /root/marc.

Should be --libs="/root/marc/libmysqlclient.a"

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2060@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: relocation error (DBD-mysql-2.1025)

am 03.03.2003 01:50:15 von Jochen Wiedmann

Re: relocation error (DBD-mysql-2.1025)

am 03.03.2003 15:50:41 von Marc Delisle

Jochen Wiedmann wrote:

> Quoting Marc Delisle :
>
>
>
>>So I read the doc :) and found a suggestion to link statically
>>libmysqlclient.a,
>>but I cannot find the right syntax with "perl Makefile.PL" to link
>>statically
>>my libmysqlclient.a which is in /root/marc.
>>
>
> Should be --libs="/root/marc/libmysqlclient.a"
>
>

Thanks Jochen.
My libmysqlclient.a is there:

/root/ftp/marc/perl/lib/mysql/libmysqlclient.a

So with DBD-mysql-2.1025 I tried this (on the same line)

perl Makefile.PL --testdb=xxx
--testuser=xxx
--testpassword=xxx
--testhost=xx
--cflags=-I/root/ftp/marc/perl/include/mysql
--libs="/root/ftp/marc/perl/lib/mysql/libmysqlclient.a"

and got:

Can't exec "mysql_config": No such file or directory at Makefile.PL line 169.
readline() on closed filehandle main::PIPE at Makefile.PL line 171.
....

Checking if your kit is complete...
Looks good
Unrecognized argument in LIBS ignored:
'/root/ftp/marc/perl/lib/mysql/libmysqlclient.a'
Using DBI 1.32 installed in /usr/lib/perl5/site_perl/i386-linux/auto/DBI

Marc Delisle

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2062@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: relocation error (DBD-mysql-2.1025)

am 03.03.2003 15:50:41 von Marc Delisle

Re: relocation error (DBD-mysql-2.1025)

am 03.03.2003 21:51:20 von Jochen Wiedmann

Quoting Marc Delisle :

> My libmysqlclient.a is there:
>
> /root/ftp/marc/perl/lib/mysql/libmysqlclient.a

Ok, new idea. If the directory /root/ftp/marc/perl/lib/mysql
contains shared libraries, create a new directory and copy
only the static libraries to the new directory.

Try using the option --libs="-L/new/directory -lmysqlclient".
If "mysql_config --libs" lists other libraries (for example
-lz or -lnsl), you have to include those as well.

Good luck,

Jochen

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2064@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: relocation error (DBD-mysql-2.1025)

am 03.03.2003 21:51:20 von Jochen Wiedmann

Re: relocation error (DBD-mysql-2.1025)

am 04.03.2003 16:12:33 von Marc Delisle

Jochen Wiedmann wrote:

> Quoting Marc Delisle :
>
>
>>My libmysqlclient.a is there:
>>
>>/root/ftp/marc/perl/lib/mysql/libmysqlclient.a
>>
>
> Ok, new idea. If the directory /root/ftp/marc/perl/lib/mysql
> contains shared libraries, create a new directory and copy
> only the static libraries to the new directory.
>
> Try using the option --libs="-L/new/directory -lmysqlclient".
> If "mysql_config --libs" lists other libraries (for example
> -lz or -lnsl), you have to include those as well.

Thanks! it compiles now.

Marc

------------------------------------------------------------ ---------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail msql-mysql-modules-thread2066@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail msql-mysql-modules-unsubscribe@lists.mysql.com instead.

Re: relocation error (DBD-mysql-2.1025)

am 04.03.2003 16:12:33 von Marc Delisle