Loading...
 
Skip to main content

Architecture / Installation


Cannot connect to MySQL

I am trying to install tiki on my hosts server and I am getting the following error message.

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /... hold-6.org/lib/adodb/drivers/adodb-mysql.inc.php on line 340

I found another topic on this forum that looked promising but it was about the non-support of MySQL 4.1, and my host is using 4.0.16.

I have a phpnuke site that successfully connects to the hosts MySQL server, so I tried just pointing tiki at that database thru the reset database screen, and received the same error message.

The table exists, the user exists, I know the password is correct, it appears to be a supported version of MySQL.

Anyone have any ideas?

Thanks--Janet

Edited to add:

I found the following thread which I don't pretent to understand, but it may shed some light on the problem for someone with more understanding than I.

http://www.techiegroups.com/showthread.php?t=46985Question

OK, I've solved this. The problem was that in the local.php file in the db directory, which I assume the tiki-install.php creates, there was a space after the name of the host_tiki. I don't know when it happened, although I can guess at the "how"-- probably when I cut and pasted the addressed into the form. Perhaps the install program could be changed to check for blanks and strip them out at the beginning or the end of the lines? Or at least give an error message.