Re: RE: [Phpgroupware-users] DB init hanging

[Dave Hall]

GAY Samuel <address@hidden> wrote:

> 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.
> 

Did you run
GRANT ALL on phpgroupware.* TO phpgw_user IDENTIFIED BY
"IReallyShouldUseShorterPasswordsSoICanRememberThem"; ??

in mysql?

I have phpgw running on mysql 4.0.iforget on my laptop ... runs well 

> 
> -----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
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>