Re: Re: [moto-devel] Re: [moto-users] Moto drops Mysql connection

Okay, I have a rather repeatable error.

It boils down to this:
Debian/Apache/Php/Mysql  : works fine every time
Debian/Apache/Moto/Mysql : works fine every time
Debian/Apache/Php/Moto/Mysql : moto fails to make mysql connection about
90% of the time, whereas php works just fine.

I say 90% because if you /etc/init.d/mysql restart, you can get a moto
connection once in a great while.

the phpmodule Im using is the stock module provided by debian and is in
the httpd.conf as such:

 LoadModule moto_module /usr/lib/apache/1.3/mod_moto.so
 LoadModule php4_module /usr/lib/apache/1.3/libphp4.so

I had the order of loading reversed with no change in behavior.  
So I guess I'll just be adding and removing support for php as I work on
learning moto.

I will try the cgi version of php, I presume that it will not have the
same issues, but I don't know.

Thanks,
Jack


On Thu, 2003-02-27 at 09:56, Cory Wright wrote:
> On Wed, Feb 26, 2003 at 10:34:48AM -0500, David Hakim wrote:
> > 	Cory: I think the problem with your installation is that the MySQL 
> > extension needs to be linked to the libz library (by adding Library: 
> > -lz to the MySQL.i file). Certain installations of MySQL have drivers 
> > that depend on that library. We will need to look into the configure 
> > scripts for the MySQL driver to find out why this dependency wasn't 
> > identified at build time.
> 
> I will try this tonight and see.  Maybe this is something that should go
> on the support page.
> 
> > 	Cory: Didn't you tell me once that the default PHP MySQL driver was 
> > limited to a single database connection ? I'm wondering if what's going 
> > on here is that the database is accessed on one page, it works fine, 
> > and then something tries to access it again before the connection is 
> > closed. If PHP is loaded Moto could be using symbols from the PHP MySQL 
> > driver ... and that's never good :)
> 
> Even when not configured for MySQL, PHP still includes a single connection
> driver.  You may be on to something with this though.
> 
> Jack:  Do you have PHP installed too?
> 
> Cory
> 
> --
> Cory Wright
> Stand Blue Technology
> http://www.standblue.net/