Can't connect to MySQL database

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
tjm-computers
Posts: 3
Joined: Sat May 13, 2006 5:27 pm

Can't connect to MySQL database

Post 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
Klemen
Site Admin
Posts: 10141
Joined: Fri Feb 11, 2005 4:04 pm

Post 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
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
tjm-computers
Posts: 3
Joined: Sat May 13, 2006 5:27 pm

MYSQL

Post 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.
Klemen
Site Admin
Posts: 10141
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

Huh, never heard of that? And you should get Hesk in .ZIP not .TAR.GZ! Where did you download it from?
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
tjm-computers
Posts: 3
Joined: Sat May 13, 2006 5:27 pm

MYSQL

Post 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
Post Reply