FUDforum: Database discussions » Getting aborted connections

Home » General » Database discussions » Getting aborted connections

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

Getting aborted connections [message #4635]

Thu, 01 August 2002 16:13

smike

Messages: 182
Registered: April 2002
Location: Munich/Germany

Karma: 0

Senior Member

I noticed some entries in my mysql error-log file which are created by fud forum.

Aborted connection <number> to db: 'forum' user: '<username>' host: 'localhost' (Got timeout reading communication packets)

How can I make them disappear?

Thanks, Mike

Report message to a moderator

Re: Getting aborted connections [message #4637 is a reply to message #4635]

Thu, 01 August 2002 16:25

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Are you using persistant connections, if so turning them of may solve the problem.

It occurs for the following reason, when they are on each Apache child which has been used to serve a FUDforum request keeps an open MySQL connection. If that apache child did not serve a page in a long time eventually the MySQL timeout is reached and MySQL kills the connection.

FUDforum Core Developer

Report message to a moderator

Re: Getting aborted connections [message #4638 is a reply to message #4637]

Thu, 01 August 2002 16:33

smike

Messages: 182
Registered: April 2002
Location: Munich/Germany

Karma: 0

Senior Member

Is there (where?) a possibility to set that timeout to a higher value?
Does this cause any security problems?

Report message to a moderator

Re: Getting aborted connections [message #4640 is a reply to message #4638]

Thu, 01 August 2002 16:41

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

No, as far as I know this does not cause security problems. You can specify your own timeout value to your MySQL server via the 'wait_timeout' option you pass to safe_mysqld script, which starts the MySQL deamon.
Of course you need root access to do so, so unless you got your own server you will not be able to do it yourself.

FUDforum Core Developer

Report message to a moderator

Re: Getting aborted connections [message #6980 is a reply to message #4640]

Wed, 30 October 2002 23:56

CanSuperMuay

Messages: 1
Registered: July 2002

Karma: 0

Junior Member

1.Which directive in httpd.conf ?
MaxKeepAliveRequests?
Please help me ,I got the same problem.

2.One thing I try to set mysql variable but,I can not find /etc/my.cnf in the server.But "mysqladmin variables" can see the variables.

3.What the command to set max_connections variable?

I am newbie and dont know how to.

Any help 'd be great appriciated! Razz

Report message to a moderator

Re: Getting aborted connections [message #6982 is a reply to message #6980]

Thu, 31 October 2002 00:16

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Read the documentation inside httpd.conf. That file has explanation of most options, MaxKeepAliveRequests is NOT it however. MySQL documentation can be found on www.mysql.com

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Scheduling Actions - Automation 101 question.
Next Topic:	Is Postgres Still a viable option for this package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 18:14:43 GMT 2024

Total time taken to generate the page: 0.04609 seconds