RE: DBD::mysql always fails

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.
 
Mohammad Junaid
 
-----Original Message-----
From: David Logan [mailto:[email protected]] 
Sent: Monday, January 31, 2005 12:43 PM
To: Mohammad Junaid
Cc: [email protected]
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.
 
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