[prev in list] [next in list] [prev in thread] [next in thread] 

List:       apache-modperl
Subject:    RE: MSQL server has gone away   ( Apache::AuthDBI.pm )
From:       Artero Alain <artero () ebu ! ch>
Date:       2001-01-31 11:55:17
[Download RAW message or body]


Is there someone using the combination DBI, AuthDBI and  mSQL ?

I am wondering whether the "ping method" for msql in DBD::Msql exists
already.


PS:Thanks for your answer Daniel.

Alain
-----Original Message-----
From: Daniel [mailto:daniel@pl14759.demon.co.uk]
Sent: lundi, 29. janvier 2001 23:37
To: Artero Alain
Cc: 'modperl@apache.org'
Subject: Re: MSQL server has gone away ( Apache::AuthDBI.pm )


On Mon, Jan 29, 2001 at 09:40:02AM +0100, Artero Alain wrote:
> Hi everybody,
> 
>           In order to authentify our web Apache users, we have decided to
> use
>  AuthDBI and Msql.  
> 
>        We have noticed that in the logfile, we have often messages (
>  several times per hour) like:
>  
>          >> [Wed Dec 13 15:04:23 2000] [error] access to /pols_006.pdf
> failed
>  for gateway.dr
>          .dk, reason: 14491 Apache::AuthDBI::authen can not execute
>  statement: MSQL server has gone away
>  

I'll admit to having absolutly no experiance with mSQL
whatsoever, but i had similar problems with mySQL. the mysql
server daemon would crash every now and again, but the wrapper
script for mysql would restart the daemon as soon as it
segfaulted. this is like the morning bug, except that it didn't
generally happen in the morning!

As your chap below says, the solutions for the morning bug should
sort you out. take a look in the mod_perl guide
http://perl.apache.org/guide for morning bug. you'll probably
need to write your own ping method for msql.

you also should look into what's making your mSQL server "go
away" - check it's logfiles to see if it's got any useful
messages.

hth,
daniel




> 
>          But we can still connect to the mSQL server through a shell or
even
>  a new try on the same page is successful. After looking at newsgroups, we
> have
>  realised that there are lot of people having the same problem, but no one
>  can reply to it clearly.
> 
>  We are using on our  server (DEC Alpha OSF1  V4.0).
>  
>          Perl               	version 5.004_04
>          MSQL			      msql-2.0.3
>          DBI			      DBI-1.13
>          mod_perl	            mod_perl-1.21
>          Apache::AuthDBI.pm       ApacheDBI-0.87
>          PHP			      php-3.0.14        (not used for the
> authentification process)
>  
>   
> 
>  
>          We are wondering whether the problem comes from DBI, AuthDBI,
mSQL?
> 		
> 	   Do you have any idea?
>  
>          Thanks in advance
> 
> 
> Alain Artero
> EBU Webmaster
> 
> ____________________________________________________
> 
> Union Européenne de Radio-Télévision	    Fax : (41) 2274.74.158
> Ancienne route 17A                           Email : artero@ebu.ch 
> CH-1218 Grand-Saconnex GE                  Web: http://www.ebu.ch/
> ____________________________________________________
> 
> 
> Below answer of Edmund Mergl.
> 
> <<if you use Apache::DBI, the apache process will
> <<initially connect to the databas once, and this database
> <<handle is supposed to live forever (in fact, it lives
> <<as long as the httpd does).
> <<I have heard several times, that this does not work
> <<with mSQL.
> <<Try posting your problem on the mod_perl mailing list
> <<or search the archives for the 'morning bug'.
> 
> 
> <<Edmund
> 
> <<-- 
> <<http://www.edmund-mergl.de

[prev in list] [next in list] [prev in thread] [next in thread]