Page 1 of 1

Can't connect to MySQL database

Posted: Sat May 13, 2006 5:32 pm
by tjm-computers
Script URL:
Version of script: 0.93.1
Version of PHP: 5.0
Hosting company:
Have you searched THIS FORUM for your problem: Yes
(if not please do before posting)
If so, what terms did you try:

Write your message below:
I have created a mysql databse, added it to the hesk_settings.inc.php file. I then went to /install.php and clicked on test mysql test was ok.
I then went to install the tables but it said the following:
Can't connect to MySQL database! Please make sure all database settings in hesk_settings.inc.php are correct!

Even thought it could connect to the database when testing!

I contacted my hosting provider, they took a look at the hesk_settings.inc.php file and they could not see anything wrong!

Any one else had this problem?

Any suggestions would be appreciated.

Thanks

Posted: Sat May 13, 2006 7:57 pm
by Klemen
Did you set the SAME settings in hesk_settings.inc.php as the ones that returned a successful database connection in install.php? Open hesk_settings.inc.php again and make sure the settings are correct (note that CaSe MatTeRs!)

Nothing else can be wrong here, if test in install.php works but install tables not then you have wrong database settings in hesk_settings.inc.php

MYSQL

Posted: Sat May 13, 2006 8:37 pm
by tjm-computers
Found out why it does not work!!
If you have a Mac and try to unzip the .tar.gz it corrupts the files!
So I tried in on a Windows machine and it works.

Posted: Sat May 13, 2006 10:25 pm
by Klemen
Huh, never heard of that? And you should get Hesk in .ZIP not .TAR.GZ! Where did you download it from?

MYSQL

Posted: Sat May 13, 2006 10:35 pm
by tjm-computers
I'm sure I downloaded it here, my mac definitely said it was a .tar.gz (well that’s what the mac said).
I downloaded it using a windows pc and that recognized it as a .zip.

Anyway it works!

Regards