DBD::mysql always fails

DBD::mysql always fails

am 30.01.2005 15:41:20 von Mohammad Junaid

------=_NextPart_000_0005_01C506F2.E8CC90E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,=20
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"=20

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.=20
at (eval 1) line 3=20
Compilation failed in require at (eval 1) line 3.

Any idea?
------=_NextPart_000_0005_01C506F2.E8CC90E0--

RE: DBD::mysql always fails

am 31.01.2005 08:50:02 von Mohammad Junaid

Thanks David,
I tried this also but no luck.

Mohammad Junaid

-----Original Message-----
From: David Logan [mailto:david@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

--

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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: DBD::mysql always fails

am 31.01.2005 09:04:24 von Yair Lapin

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:php@cyberia.net.sa]
Sent: Monday, January 31, 2005 9:50 AM
To: david@lcscreative.com
Cc: perl@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:david@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

--

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/perl?unsub=yairl@savion.huji.ac.il

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: DBD::mysql always fails

am 31.01.2005 10:03:49 von Mohammad Junaid

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:yairl@savion.cc.huji.ac.il]
Sent: Monday, January 31, 2005 11:04 AM
To: Mohammad; david@lcscreative.com
Cc: perl@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:php@cyberia.net.sa]
Sent: Monday, January 31, 2005 9:50 AM
To: david@lcscreative.com
Cc: perl@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:david@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

--

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/perl?unsub=yairl@savion.huji.ac.il

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=php@cyberia.net.sa




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: DBD::mysql always fails

am 31.01.2005 10:43:10 von David Logan

--------------060405030705050909020302
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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:yairl@savion.cc.huji.ac.il]
>Sent: Monday, January 31, 2005 11:04 AM
>To: Mohammad; david@lcscreative.com
>Cc: perl@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:php@cyberia.net.sa]
>Sent: Monday, January 31, 2005 9:50 AM
>To: david@lcscreative.com
>Cc: perl@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:david@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/mysq l.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


--------------060405030705050909020302--

RE: DBD::mysql always fails

am 31.01.2005 13:26:13 von Mohammad Junaid

------=_NextPart_000_001A_01C507A9.32C49A60
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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:david@lcscreative.com]
Sent: Monday, January 31, 2005 12:43 PM
To: Mohammad Junaid
Cc: perl@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.

Mohammad Junaid

-----Original Message-----
From: Yair Lapin [mailto:yairl@savion.cc.huji.ac.il]
Sent: Monday, January 31, 2005 11:04 AM
To: Mohammad; david@lcscreative.com
Cc: perl@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:php@cyberia.net.sa]
Sent: Monday, January 31, 2005 9:50 AM
To: david@lcscreative.com
Cc: perl@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:david@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

------=_NextPart_000_001A_01C507A9.32C49A60--

RE: DBD::mysql always fails

am 05.02.2005 11:09:26 von Mohammad Junaid

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.

Mohammad Junaid

-----Original Message-----
From: Mohammad [mailto:php@cyberia.net.sa]
Sent: Monday, January 31, 2005 3:26 PM
To: david@lcscreative.com
Cc: perl@lists.mysql.com
Subject: 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:david@lcscreative.com]
Sent: Monday, January 31, 2005 12:43 PM
To: Mohammad Junaid
Cc: perl@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.

Mohammad Junaid

-----Original Message-----
From: Yair Lapin [mailto:yairl@savion.cc.huji.ac.il]
Sent: Monday, January 31, 2005 11:04 AM
To: Mohammad; david@lcscreative.com
Cc: perl@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:php@cyberia.net.sa]
Sent: Monday, January 31, 2005 9:50 AM
To: david@lcscreative.com
Cc: perl@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:david@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



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org