7 messages in com.mysql.lists.perlRe: DBD::mysql always fails
FromSent OnAttachments
Mohammad Junaid30 Jan 2005 06:40 
Mohammad30 Jan 2005 23:49 
Yair Lapin31 Jan 2005 00:04 
Mohammad31 Jan 2005 01:03 
David Logan31 Jan 2005 01:42 
Mohammad31 Jan 2005 04:25 
Mohammad05 Feb 2005 02:09 
Subject:Re: DBD::mysql always fails
From:David Logan (dav@lcscreative.com)
Date:01/31/2005 01:42:48 AM
List:com.mysql.lists.perl

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:yai@savion.cc.huji.ac.il] Sent: Monday, January 31, 2005 11:04 AM To: Mohammad; dav@lcscreative.com Cc: pe@lists.mysql.com 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:ph@cyberia.net.sa] Sent: Monday, January 31, 2005 9:50 AM To: dav@lcscreative.com Cc: pe@lists.mysql.com Subject: RE: DBD::mysql always fails

Thanks David, I tried this also but no luck.

Mohammad Junaid

-----Original Message----- From: David Logan [mailto:dav@lcscreative.com] 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