FUDforum: Database discussions » Looking for some direction in solving SQL errors

Home » General » Database discussions » Looking for some direction in solving SQL errors

Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic

Looking for some direction in solving SQL errors [message #167578]

Tue, 17 July 2012 06:17

pips

Messages: 113
Registered: February 2012

Karma: 0

Senior Member

remove from buddy list
ignore all messages by this user

Seems we keep ketting SQL errors (FUD RC 3.04)

Quote:

(/vhosts/nomad-forum.com/httpdocs/fudforum/index.php:29
) 2003: Can't connect to MySQL server on '192.168.1.7' (4)
Query: Initiating MasterDB mysql_connect
Database version: Unknown

I appreciate SQL is a field all in itself, but i'm just wondering if you have any pointers in where i begin in solvin these problems?

Are they Host issues or is our Forum setup wrong (its a fresh set up)

After about 10 mins, the forum resets, i do a consistancy check and everything seems ok again.

(Could this be a permissions issue?)

Any help appreciated. :toppa:

Report message to a moderator

Rate author: +1 -1

Re: Looking for some direction in solving SQL errors [message #167582 is a reply to message #167578]

Wed, 18 July 2012 12:14

naudefj

Messages: 3771
Registered: December 2004

Karma: 27

Senior Member
Administrator
Core Developer

remove from buddy list
ignore all messages by this user

Is the forum and DB on the same server? If so, connect with a socket (something like :/var/run/mysqld/mysqld.sock) and add "skip-networking" to your my.cnf file.

How busy is the DB server? You may need a bigger server with more RAM / faster disks.

Report message to a moderator

Rate author: +1 -1