RE: [Phpgroupware-users] DB init hanging

[GAY Samuel]

I checked the MySQL parameters, nothing seems to be "strange"... but there are 
many parameters, perhaps I missed something.

I migrate to PHP 4.3.2 and MySQL 4.0.13, I've still the same problem. Of course 
I tested the new configuration with anonther php/mysql 'application'.

But I've something more interesting. I activate for a test the text update log 
of MysQL. Each time I click on the "Install" button there is a create table and 
a drop table. I clicked 6 times, here is the log :


# mysqld-nt, Version: 4.0.13-nt-log at 030710  8:51:55
use phpgroupware;
CREATE TABLE phpgw_testrights ( testfield varchar(5) NOT NULL );
DROP TABLE phpgw_testrights;
CREATE TABLE phpgw_testrights ( testfield varchar(5) NOT NULL );
DROP TABLE phpgw_testrights;
CREATE TABLE phpgw_testrights ( testfield varchar(5) NOT NULL );
DROP TABLE phpgw_testrights;
CREATE TABLE phpgw_testrights ( testfield varchar(5) NOT NULL );
DROP TABLE phpgw_testrights;
CREATE TABLE phpgw_testrights ( testfield varchar(5) NOT NULL );
DROP TABLE phpgw_testrights;
CREATE TABLE phpgw_testrights ( testfield varchar(5) NOT NULL );
DROP TABLE phpgw_testrights;


I don't understand why it doesn't run correctly... I hate not understanding ! 
:o)
Sam.


-----Message d'origine-----
De : Daryl L. L. Houston [mailto:address@hidden
Envoyé : mercredi 9 juillet 2003 20:55
À : address@hidden
Objet : Re: [Phpgroupware-users] DB init hanging


I just know that I had to change the out-of-the box settings on mysql 4. 
  Whether it came this way out of the box or whether I screwed up the 
initial config of mysql 4, it was set to allow something like one 
connection or a very limited number of connection failures or something 
like that.  This was on a test system and not a production system as 
well, and I was the only person attempting to connect.  Couldn't hurt to 
look at the mysql config, at any rate.

D