MySQL Forums
Forum List  »  Perl

undefined symbol 'mysql_close' lazy binding failed!
Posted by: Roman LE NEGRATE
Date: February 11, 2005 01:29PM

Hi all, I'm new to mod_perl and the MySQL usage. I use mod_perl for mass virtual hosting through MySQL, I used this wonderful howto :

So my httpd.conf contains that :
package My::MySQLTrans;
use Apache::DBI;
use DBI;
use Apache::Constants qw(:common);

Apache::DBI->connect_on_init("DBI:mysql:iglou:localhost","iglou","xxxxx", {
PrintError => 1, #warn() on errors
RaiseError => 0, #don't die on error
AutoCommit => 1, #commit executes immediately
sub get_hosting_info {
my $h = shift;
$h =~ tr/[A-Z]/[a-z]/;
if($h =~ /^www\.(.+)$/) {
$sth=$dbh->prepare("SELECT dir FROM webaliases WHERE alias='".$h."'");
$dbh->{mysql_auto_reconnect} = 1;
if($row=$sth->fetchrow_hashref()) {
return $h;
sub handler {
my $r = shift;
$u = $r->uri;
if($u =~ /^\/icons\/.+/) {
return OK;
if($1 eq "cgi-bin") {
return OK;
PerlTransHandler My::MySQLTrans

I'm running OpenBSD 3.6 with Apache 1.29 and the needed perl modules (DBD::MySQL, DBI and some other ones) and when I just restarted the PC, Apache works well with these settings, but if I do an "apachectl graceful" or "apachectl restart", then I get this message in the error_log :

/usr/sbin/httpd:/usr/local/libdata/perl5/site_perl/i386-openbsd/auto/DBD/mysql/ undefined symbol 'mysql_close' lazy binding failed!

(apache starts normally if I put another httpd.conf that doesn't contains any perl code, for exemple just mod_rewrite stuff)

It's the same if I try "apachectl stop" then "apachectl start" : apache writes it to the error_log and it doesn't start.
Where does this error come from ? How to fix it ? Or maybe there is an error in my perl code ? (or something to optimize or whatever)

Another thing is that before that I put "$dbh->{mysql_auto_reconnect} = 1;" in the code, I had errors like that in the error_log : "MySQL has gone away, fetchrow_hashref without execute()" (I don't remember exactly).
I googled and found that I must start MySQL with the "--skip-reconnect" option but MySQL doesn't work to start with that option. What must I do to fix that ?

Can you help me please ? I'm really lost.
Thanks in advance,
Best regards.

Options: ReplyQuote

Written By
undefined symbol 'mysql_close' lazy binding failed!
February 11, 2005 01:29PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.