Re: DBD::mysql always fails

Mohammad Junaid wrote:

>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
>
>  
>
Hi Mohammad,

It isn't always happening on solaris, this . I have installed the DBD 
version (using CPAN and also from tar.gz file) that you quoted on both 
Solaris 8 and 9. I've just rebuilt my perl to 5.8.5 without any issue 
and everything is going well.

How did you install/build your version of mysql? What version are you using?

Regards

-- 

David Logan
South Australia

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