FUDforum: FUDforum Installation Issues » Lost connection to MySQL server during query

Home » FUDforum » FUDforum Installation Issues » Lost connection to MySQL server during query

Show: Today's Messages :: Polls :: Message Navigator

Lost connection to MySQL server during query [message #30402]

Thu, 23 February 2006 04:18

carmi

Messages: 3
Registered: February 2006

Karma: 0

Junior Member

Hello,

I am trying to install fudforum on a debian linode with mysql. I have moved over the install.php file and ran in but was stopped (Database Settings Step 2 of 5) on the second page of information by the following errors. (These errors were shown at the top of the page)

Warning: mysql_connect(): Lost connection to MySQL server during query in /var/www/fudforum_mysql/install.php on line 97

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/fudforum_mysql/install.php on line 101

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/www/fudforum_mysql/install.php on line 164

Next the the Host row was this error

Failed to connect to the MySQL Server, SQL Reason: Lost connection to MySQL server during query

Also in the Database section I got the error

Could not open the database you've specified, SQL Reason: Lost connection to MySQL server during query

I am currently not sure what is wrong?

The output of my /etc/mysql/my.cfn file is attached.

Thank You Very Much,
Evan

Attachment: my.txt
(Size: 3.18KB, Downloaded 1084 times)

Report message to a moderator

Re: Lost connection to MySQL server during query [message #30410 is a reply to message #30402]

Thu, 23 February 2006 18:09

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Try increasing the timeout value to >90 seconds.

FUDforum Core Developer

Report message to a moderator

Re: Lost connection to MySQL server during query [message #30423 is a reply to message #30402]

Fri, 24 February 2006 03:38

carmi

Messages: 3
Registered: February 2006

Karma: 0

Junior Member

I am not positve on the correct procedures to increase the timeout value to >90 seconds.

In /etc/mysql/my.cnf I changed

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
#added in an attempt to correct php install script timeout
set-variable = connect_timeout=90

[mysql]
#no-auto-rehash	# faster start of mysql but no tab completition
#added in an attempt to correct php install script timeout
set-variable = connect_timeout=14400

and then shutdown with:

cd /usr/bin
  # ./mysqladmin -u root shutdown

and started with:

cd /usr/bin
  # mysqld_safe &

I still got the errors so I am not sure where to go next. Im I going in the right direction?
Thanks Evan

Report message to a moderator

Re: Lost connection to MySQL server during query [message #30431 is a reply to message #30423]

Fri, 24 February 2006 18:35

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Does "SHOW VARIABLES" query show the modified value?

FUDforum Core Developer

Report message to a moderator

Re: Lost connection to MySQL server during query [message #30441 is a reply to message #30402]

Sat, 25 February 2006 07:40

carmi

Messages: 3
Registered: February 2006

Karma: 0

Junior Member

show veriables said

 
| wait_timeout                    | 28800

Should I change any other variables?

Thanks Evan

Report message to a moderator

Re: Lost connection to MySQL server during query [message #30448 is a reply to message #30441]

Sun, 26 February 2006 05:49

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

No that should do the trick. You may also want to look at the cpu usage of install.php on your machine, it really shouldn't take more then a few seconds to run at each stage.

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Synching Forum with Mail List
Next Topic:	What is supposed to be in the Globals.php file?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 18:04:50 GMT 2024

Total time taken to generate the page: 0.02403 seconds