Problem using placeholders

am 28.04.2004 09:55:46 von Lazar Paul

Hi All,

I have a server running Red Hat Linux 7.3 with

mysql-3.23.49-3,
perl-DBD-mysql-2.9003-1,
mysqlclient9-3.23.22-6,
perl-DBI-1.21-1 and
perl 5.6.1

I am making a mysql query in a perl script which uses placeholders (?),
when the script executes it gives the following error message in my apache
error log and an "INTERNAL SERVER ERROR" on the browser.

/usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386-
linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_real_escape_string
[Wed Apr 28 13:03:57 2004] [error] Premature end of script
headers: /home/alpha/cgi-bin/domain/index.cgi

Example Code : select product from productmaster where productid=?;

I have tried upgrading MySql from the above version to mysql-3.23.58 but
the problem still persisted. Currently Iam using mysql-3.23.49-3.

It would be nice if someone could give a possible solution to this problem.

Thanks in advance.

Paul

--
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: Problem using placeholders

am 28.04.2004 15:44:07 von Rudy Lippan

On Wed, 28 Apr 2004, Lazar Paul wrote:

> I am making a mysql query in a perl script which uses placeholders (?),
> when the script executes it gives the following error message in my apache
> error log and an "INTERNAL SERVER ERROR" on the browser.
>
> /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386-
> linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_real_escape_string
> [Wed Apr 28 13:03:57 2004] [error] Premature end of script
> headers: /home/alpha/cgi-bin/domain/index.cgi
>

Recompile DBD::mysql and make sure that mysql_config is in your path, and that
'which mysql_config' is pointing correct one for your server.

Rudy

--
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: Problem using placeholders

am 28.04.2004 15:44:07 von Rudy Lippan

Re: Problem using placeholders

am 29.04.2004 14:44:15 von Lazar Paul

Rudy Lippan wrote:
>
>On Wed, 28 Apr 2004, Lazar Paul wrote:
>
>> I am making a mysql query in a perl script which uses placeholders
(?),
>> when the script executes it gives the following error message
in my
apache
>> error log and an "INTERNAL SERVER ERROR" on the browser.
>>
>> /usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386-
>> linux/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string
>> [Wed Apr 28 13:03:57 2004] [error] Premature end of script
>> headers: /home/alpha/cgi-bin/domain/index.cgi
>>
>
>Recompile DBD::mysql and make sure that mysql_config is in your path,
and
that
>'which mysql_config' is pointing correct one for your server.
>

I checked up mysql_config is in /usr/bin/,
I also recompiled DBD::mysql through MCPAN shell as you suggested, it
gives the messages that DBI and DBD are up-todate but i still get the
following error message while running the script.

DBI->connect using 'old-style' syntax is deprecated and will be an error
in future versions at ./test_placeholders.pl line 3
perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386-
linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_real_escape_string

Paul

--
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: Problem using placeholders

am 29.04.2004 14:44:15 von Lazar Paul

Re: Problem using placeholders

am 29.04.2004 14:53:54 von Rudy Lippan

On Thu, 29 Apr 2004, Lazar Paul wrote:

> I checked up mysql_config is in /usr/bin/,

Are you running the mysqld in /usr/bin ? or did you install your own copy in
/usr/local?

> I also recompiled DBD::mysql through MCPAN shell as you suggested, it
> gives the messages that DBI and DBD are up-todate but i still get the
> following error message while running the script.
>

It would probably be best to compile it by hand, or you can force a recompile
in cpan

> DBI->connect using 'old-style' syntax is deprecated and will be an error
> in future versions at ./test_placeholders.pl line 3
> perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386-
> linux/auto/DBD/mysql/mysql.so: undefined symbol: mysql_real_escape_string
>

Is the lib mysql shared object in your LD_LIBRARY_PATH? An other option would
be to compile DBD::mysql staticaly, and then you won't have to worry about
undefined symbols.

Rudy

--
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: Problem using placeholders

am 29.04.2004 14:53:54 von Rudy Lippan

Re: Problem using placeholders

am 29.04.2004 15:36:17 von Lazar Paul

Thanks a lot Rudy!! that helped. A force recompile in cpan solved the
problem.

Thank you once again.

Rudy Lippan wrote:
>
>On Thu, 29 Apr 2004, Lazar Paul wrote:
>
>> I checked up mysql_config is in /usr/bin/,
>
>Are you running the mysqld in /usr/bin ? or did you install your own copy
in
>/usr/local?
>
>> I also recompiled DBD::mysql through MCPAN shell as you suggested, it
>> gives the messages that DBI and DBD are up-todate but i still get the
>> following error message while running the script.
>>
>
>It would probably be best to compile it by hand, or you can force a
recompile
>in cpan
>
>> DBI->connect using 'old-style' syntax is deprecated and will be an error
>> in future versions at ./test_placeholders.pl line 3
>> perl: relocation error: /usr/lib/perl5/site_perl/5.6.1/i386-
>> linux/auto/DBD/mysql/mysql.so: undefined symbol:
mysql_real_escape_string
>>
>
>Is the lib mysql shared object in your LD_LIBRARY_PATH? An other option
would
>be to compile DBD::mysql staticaly, and then you won't have to worry
about
>undefined symbols.
>
>
>Rudy
>
>
>
>--
>MySQL Perl Mailing List
>For list archives: http://lists.mysql.com/perl
>To unsubscribe: http://lists.mysql.com/perl?unsub=paul.l@ebizchem.com
>
>
>

--
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: Problem using placeholders

am 29.04.2004 15:36:17 von Lazar Paul