Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

DBSQL Error

Quote Reply
DBSQL Error
I just recieved a few emails from people with this error:

In Reply To:
DBSQL (28572): Fatal Error: Unable to connect to the SQL server. Reason: Can't connect to local MySQL server (61) at /usr/local/etc/httpd/vhosts/lessonplansearch.com/htdocs/cgi-bin/jump.cgi line 65
Now, they were (apperently) able to access the site, but got this message when clicking the links. Now I am VERY new to this, but is the SQL server somehow separate from the site server? Maybe someone can explain this to me.

It must not have giving this message too long, as I checked the site and links, and they appear to be OK.

Thanks for the explanation,

Chad


Quote Reply
Re: DBSQL Error In reply to
Yes...SQL servers for the most part are installed on separate machines. Make sure that you have the correct information stored in your .def files for your database, host, etc.

Regards,

Eliot

Quote Reply
Re: DBSQL Error In reply to
Now at least I know. Thanks Eliot.

Quote Reply
Re: DBSQL Error In reply to
You're welcome.

Regards,

Eliot Lee

Quote Reply
Re: DBSQL Error In reply to
Ok.

If you are being virtually hosted, or your ISP has given you a machine name for your MySQL server such as "db.myisp.com" or "db.yourdomain.com" then your MySQL server is probably on another machine.

If you are running a dedicated server, and you installed the MySQL your self, or you use "localhost" to connect to the Mysql database, the MySQL server is on your own physical machine.

If you get the "can't connect" error and the database is on another machine, either the network or their machine is havingproblems.

If you get it on your machine, it means you may need to reboot the mysql server, or --- specifically in jump.cgi -- there is a "too many connections" error that I don't remember exactly what the fix is, but it usually is a run-away process and rebooting the Mysql server, killing off the process, or rebooting the server-box (machine) will fix it.

just wanted to clarify a bit, since some people have the MySQL on their machine, and some have it on a remote or sister/network machine.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/