RE: DBD::mysql always fails - Mohammad - com.mysql.lists.perl

7 messages in com.mysql.lists.perlRE: DBD::mysql always fails

From	Sent On	Attachments
Mohammad Junaid	30 Jan 2005 06:40
Mohammad	30 Jan 2005 23:49
Yair Lapin	31 Jan 2005 00:04
Mohammad	31 Jan 2005 01:03
David Logan	31 Jan 2005 01:42
Mohammad	31 Jan 2005 04:25
Mohammad	05 Feb 2005 02:09

Subject:	RE: DBD::mysql always fails
From:	Mohammad (ph...@cyberia.net.sa)
Date:	02/05/2005 02:09:04 AM
List:	com.mysql.lists.perl

Hi all,

On a freshly installed Solaris 8 OS, I installed gcc, make, tar and perl from sunfreeware.com, downloaded the 32bit version of mysql from mysql.com, DBI and DBD::mysql from CPAN. Now everything is working fine, actually I was trying to install first a 64bit version of mysql and after the failure I was trying to install 32 bit version on the same OS which were giving me the error so I installed a fresh OS and then started the installation of 32 bit version which works fine.

Thanks to all who responded.

David, I installed first 64bit and then 32bit binary version 4.1.8 downloaded from mysql.com, every time I am getting the same problem. I was using a perl 5.8.3 binary downloaded from sunfreeware.com. Every time I was getting same error only when I installed active perl as per Lapin's suggestion it started working with a warning that multi-threaded perl should not be used in production.

-----Original Message----- From: David Logan [mailto:dav...@lcscreative.com] Sent: Monday, January 31, 2005 12:43 PM To: Mohammad Junaid Cc: pe...@lists.mysql.com Subject: 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.

-----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.

Thanks David, I tried this also but no luck.

-----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

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