RE: :mysql problem

Did you read my posting an year back for this issue. Here is the link
http://lists.mysql.com/perl/2548


Madhu

-----Original Message-----
From: W [mailto:just_a_w@yahoo.com]
Sent: Tuesday, May 25, 2004 9:29 AM
To: perl@lists.mysql.com
Subject: DBD::mysql problem


When I try to run "make test" on DBD::mysql, I get a
ton of "unresolved symbol" errors looking for mysql
functions. For example:

/usr/lib/dld.sl: Unresolved symbol: mysql_store_result
(code) from blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_stat (code)
from blib/arch/auto/DBD/mysql/mysql.sl
/usr/lib/dld.sl: Unresolved symbol: mysql_field_seek
(code) from blib/arch/auto/DBD/mysql/mysql.sl

I installed MySQL (version 4) from the HP-UX 11.0
binaries into /opt/mysql/mysql. When I run the "perl
Makefile.PL" command, I'm passing in
"--cflags=-I/opt/mysql/mysql/include
--libs=-L/opt/mysql/mysql/lib" (along with MySQL
database parameters).

Anyone have any idea what's missing?

Thanks




__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=madhu.kangara@t-mobile.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: :mysql problem

On Tue, 25 May 2004, Kangara, Madhu wrote:

>
> When I try to run "make test" on DBD::mysql, I get a
> ton of "unresolved symbol" errors looking for mysql
> functions. For example:

Try linking statically.

Rudy



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: :mysql problem

On Tue, 25 May 2004, Kangara, Madhu wrote:

>
> When I try to run "make test" on DBD::mysql, I get a
> ton of "unresolved symbol" errors looking for mysql
> functions. For example:

Try linking statically.

Rudy



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: :mysql problem

When I try to pass in -lmysqlclient, I get an error:
'ld: Can't find library: "mysqlclient"'

Configuration is:

cflags (mysql_config) =
-I/opt/mysql/mysql/include +DAportable
libs (mysql_config) = -L/opt/mysql/mysql/lib
-lmysqlclient -lcrypt -lnsl -lm

The lib directory contains the file libmysqlclient.a,
so I don't understand why it can't find mysqlclient.


--- "Kangara, Madhu"
wrote:
> Did you read my posting an year back for this issue.
> Here is the link
> http://lists.mysql.com/perl/2548
>
>
> Madhu





__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: :mysql problem

When I try to pass in -lmysqlclient, I get an error:
'ld: Can't find library: "mysqlclient"'

Configuration is:

cflags (mysql_config) =
-I/opt/mysql/mysql/include +DAportable
libs (mysql_config) = -L/opt/mysql/mysql/lib
-lmysqlclient -lcrypt -lnsl -lm

The lib directory contains the file libmysqlclient.a,
so I don't understand why it can't find mysqlclient.


--- "Kangara, Madhu"
wrote:
> Did you read my posting an year back for this issue.
> Here is the link
> http://lists.mysql.com/perl/2548
>
>
> Madhu





__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

W wrote:

> The lib directory contains the file libmysqlclient.a,
> so I don't understand why it can't find mysqlclient.

Does the lib directory also contain libmysqlclient.so? In that case, create
a separate directory with only the .a files and use that. (This directory
can be deleted after building the driver.)


Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

W wrote:

> The lib directory contains the file libmysqlclient.a,
> so I don't understand why it can't find mysqlclient.

Does the lib directory also contain libmysqlclient.so? In that case, create
a separate directory with only the .a files and use that. (This directory
can be deleted after building the driver.)


Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

--- Jochen Wiedmann wrote:
>
> Does the lib directory also contain libmysqlclient.so? In that case, create
> a separate directory with only the .a files and use that. (This directory
> can be deleted after building the driver.)
>
>
> Jochen


Unfortunately, the lib directory only has .a files.

$ ll lib/
total 34980
-rwxrwxrwx 1 mysql mysql 20060 Feb 10 08:13 libdbug.a
-rwxrwxrwx 1 mysql mysql 625386 Feb 10 08:11 libmysqlclient.a
-rwxrwxrwx 1 mysql mysql 673182 Feb 10 08:05 libmysqlclient_r.a
-rwxrwxrwx 1 mysql mysql 15757238 Feb 10 09:25 libmysqld.a
-rwxrwxrwx 1 mysql mysql 256948 Feb 10 08:13 libmystrings.a
-rwxrwxrwx 1 mysql mysql 574616 Feb 10 08:17 libmysys.a

David






__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

--- Jochen Wiedmann wrote:
>
> Does the lib directory also contain libmysqlclient.so? In that case, create
> a separate directory with only the .a files and use that. (This directory
> can be deleted after building the driver.)
>
>
> Jochen


Unfortunately, the lib directory only has .a files.

$ ll lib/
total 34980
-rwxrwxrwx 1 mysql mysql 20060 Feb 10 08:13 libdbug.a
-rwxrwxrwx 1 mysql mysql 625386 Feb 10 08:11 libmysqlclient.a
-rwxrwxrwx 1 mysql mysql 673182 Feb 10 08:05 libmysqlclient_r.a
-rwxrwxrwx 1 mysql mysql 15757238 Feb 10 09:25 libmysqld.a
-rwxrwxrwx 1 mysql mysql 256948 Feb 10 08:13 libmystrings.a
-rwxrwxrwx 1 mysql mysql 574616 Feb 10 08:17 libmysys.a

David






__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

Looking at the documentation for "Problems Using the Perl DBI/DBD Interface"
(http://dev.mysql.com/doc/mysql/en/Perl_support_problems.htm l), it says I should be including
'libmysqlclient.so' with a -L when I compile. But I don't have a libmysqlclient.so anywhere in
the MySQL install (v4 for HP-UX 11.0). I tried downloading an older (v3) install and it didn't
have libmysqlclient.so either.

Why doesn't my install have libmysqlclient.so.....and how/where can I get it?






__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

Looking at the documentation for "Problems Using the Perl DBI/DBD Interface"
(http://dev.mysql.com/doc/mysql/en/Perl_support_problems.htm l), it says I should be including
'libmysqlclient.so' with a -L when I compile. But I don't have a libmysqlclient.so anywhere in
the MySQL install (v4 for HP-UX 11.0). I tried downloading an older (v3) install and it didn't
have libmysqlclient.so either.

Why doesn't my install have libmysqlclient.so.....and how/where can I get it?






__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

W wrote:
> Looking at the documentation for "Problems Using the Perl DBI/DBD Interface"
> (http://dev.mysql.com/doc/mysql/en/Perl_support_problems.htm l), it says I should be including
> 'libmysqlclient.so' with a -L when I compile. But I don't have a libmysqlclient.so anywhere in
> the MySQL install (v4 for HP-UX 11.0). I tried downloading an older (v3) install and it didn't
> have libmysqlclient.so either.
>
> Why doesn't my install have libmysqlclient.so.....and how/where can I get it?

libmysqlclient.a is essentially the same than libmysqlclient.so (static
library vs. dynamic)

In your case, there is no reason, why a dynamic library should fix your
problem. In contrary, it can only add more problems. (My previous mail was
assuming that you had dynamic libraries and I told you how to fix the
related problems.)


Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: :mysql problem

W wrote:
> Looking at the documentation for "Problems Using the Perl DBI/DBD Interface"
> (http://dev.mysql.com/doc/mysql/en/Perl_support_problems.htm l), it says I should be including
> 'libmysqlclient.so' with a -L when I compile. But I don't have a libmysqlclient.so anywhere in
> the MySQL install (v4 for HP-UX 11.0). I tried downloading an older (v3) install and it didn't
> have libmysqlclient.so either.
>
> Why doesn't my install have libmysqlclient.so.....and how/where can I get it?

libmysqlclient.a is essentially the same than libmysqlclient.so (static
library vs. dynamic)

In your case, there is no reason, why a dynamic library should fix your
problem. In contrary, it can only add more problems. (My previous mail was
assuming that you had dynamic libraries and I told you how to fix the
related problems.)


Jochen

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org