Error Connecting to Database

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
cbromley
Posts: 7
Joined: Wed Aug 02, 2006 9:31 pm

Error Connecting to Database

Post by cbromley »

Script URL: Internal
Version of script: .93.1
Version of PHP: 4.3.10
Hosting company: Internal Windows Apache Server
Have you searched THIS FORUM for your problem: Yes
(if not please do before posting)
If so, what terms did you try: Several..

Write your message below:

I have not found anything on the forum that addresses my problem yet, except one thing, which doesn't match my issue.

When I run the install.php, and test the database connection, I get 'error connecting to database'... I have verified multiple times that the user, password, dbname and host are correct. I can use the exact same settings, and connect to mysql via HeidiSQL (front end client). I have a few other php/mySQL packages installed and operating properly on the same server, just Hesk fails to connect.

I have not recently updated mySQL, however, OLD password support already exists. Then again, I created a new user specifically for hesk since I couldn't get root to work. However, root and the hesk user both work through HeidiSQL client, so I am sure mySQL is working properly.

I have triple checked the config file, and recreated it twice to make sure I wasn't accidentally deleting something.

User connections are limited to 200, but that isn't the issue since I don't even show one connection to the database other than root when I am monitoring it, trying to make it work. If I omit the password, it displays the proper template, but tells me to enter the password, so I know it is attempting a connection.

I am, by far, not an expert at mySQL, so bear with me if I have missed something basic here.


Any ideas on what else to look at?
cbromley
Posts: 7
Joined: Wed Aug 02, 2006 9:31 pm

Post by cbromley »

Well..

Nevermind. For no reason at all, after just walking away for about 15 minutes and coming back to it, it worked fine.

NO idea what was happening. Wish I could give you some insight so that others might be able to solve their issues.. but I can't. It just started working out of the blue...
Klemen
Site Admin
Posts: 10141
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

It was either a temporary problem with MySQL or little magic ferries fixed the problem for you :wink:
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
cbromley
Posts: 7
Joined: Wed Aug 02, 2006 9:31 pm

Post by cbromley »

I'm voting on the little fairies... :wink:
Post Reply