FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Lost connection to MySQL server during query
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Lost connection to MySQL server during query [message #30402] Wed, 22 February 2006 23:18 Go to next message
carmi is currently offline  carmi   United States
Messages: 3
Registered: February 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 503 times)
Re: Lost connection to MySQL server during query [message #30410 is a reply to message #30402] Thu, 23 February 2006 13:09 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Try increasing the timeout value to >90 seconds.

FUDforum Core Developer
Re: Lost connection to MySQL server during query [message #30423 is a reply to message #30402] Thu, 23 February 2006 22:38 Go to previous messageGo to next message
carmi is currently offline  carmi   United States
Messages: 3
Registered: February 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
to
[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
Re: Lost connection to MySQL server during query [message #30431 is a reply to message #30423] Fri, 24 February 2006 13:35 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Does "SHOW VARIABLES" query show the modified value?

FUDforum Core Developer
Re: Lost connection to MySQL server during query [message #30441 is a reply to message #30402] Sat, 25 February 2006 02:40 Go to previous messageGo to next message
carmi is currently offline  carmi   United States
Messages: 3
Registered: February 2006
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
show veriables said
 
| wait_timeout                    | 28800

Should I change any other variables?

Thanks Evan
Re: Lost connection to MySQL server during query [message #30448 is a reply to message #30441] Sun, 26 February 2006 00:49 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Mon Jun 18 21:04:38 EDT 2018

Total time taken to generate the page: 0.00777 seconds