Hi everybody, In order to authentify our web Apache users, we have decided to use AuthDBI. We have installed the following software on our web 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 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 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 internet, we have realised that there are lot of people having the same problem, but no one can reply to it clearly. 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 : [EMAIL PROTECTED] 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