RE: DBD::mysql always fails

Hi Lapin
As per your suggestion, I just installed active perl and nothing else.
Now it is working. But it is gives me a warning that multi-threaded perl
is not recommended in production environment. I hope we can have some
official comments from perl/msql officials that why this is happening
only with Solaris.

Anyways I am thankful to you for your suggestion.

Mohammad Junaid

-----Original Message-----
From: Yair Lapin [mailto:[email protected]] 
Sent: Monday, January 31, 2005 11:04 AM
To: Mohammad; [email protected]
Cc: [email protected]
Subject: RE: DBD::mysql always fails

Hi,

Yesterday a wrote in the forum a message , there is a strange bug with
the
linker I didn't find connection with 64 bit or 32 bit version, all my
version were 32 bit. Anyway I find a very simple solution: download perl

Binary for solaris from active state site (Active Perl) install it with
pkgadd -d , link it to /usr/local/bin and use ppm to install a binary
version of DBD::mysql, it's all. Now each module you want to install you
download binary from ActiveState through ppm program. They don't have
every
module compiled for solaris but there are the most used. I hope someone
will
be able to find exactly what is wrong with DBD:mysql in perl for
solaris, I
lost a lot of time with this trouble.


-----Original Message-----
From: Mohammad [mailto:[email protected]] 
Sent: Monday, January 31, 2005 9:50 AM
To: [email protected]
Cc: [email protected]
Subject: RE: DBD::mysql always fails

Thanks David,
I tried this also but no luck.

Mohammad Junaid

-----Original Message-----
From: David Logan [mailto:[email protected]] 
Sent: Sunday, January 30, 2005 10:44 PM
To: Mohammad Junaid
Subject: Re: DBD::mysql always fails

Mohammad Junaid wrote:

>Hi, 
>On solaris 8 (Sparc) I am trying to compile DBD::mysql since weeks but
no luck, tried all available suggestions but no luck, still getting same
following error while "make test" 
>
>DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so' for module
DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file
/export/home/DBD-mysql-2.9004/blib/arch/auto/DBD/mysql/mysql.so: symbol
mysql_real_escape_string: referenced symbol not found at
/usr/local/lib/perl5/5.8.6/sun4-solaris/DynaLoader.pm line 230. 
>at (eval 1) line 3 
>Compilation failed in require at (eval 1) line 3.
>
>Any idea?
>  
>
Hi Mohammad,

This could be caused by trying to use a 64bit mysql implementation and a

32bit perl setup. I had similar problems until I re-installed mysql as 
32bit and then everything worked fine *Solaris 8 and 9).

Regards

-- 

David Logan
South Australia

when in trouble, or in doubt
run in circles, scream and shout




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:
http://lists.mysql.com/[email protected]

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]