Database connection failed

[asilveri]

Script URL: http://www.phpjunkyard.com/free-helpdesk-software.php
Version of script: 2.0
Hosting company: Godaddy
URL of phpinfo.php: http://eden.rutgers.edu/~asilveri/Support/phpinfo.php
URL of session_test.php:http://eden.rutgers.edu/~asilveri/Suppo ... n_test.php

What terms did you try when SEARCHING for a solution: connection fail, database connection


Write your message below:
Hello all,

Hesk works great from what im hearing but i am doing something wrong. I uploaded all the files from the hesk.zip to my ftp server. When i get to step 3 in the installation process i put in all the information for

Database Host:Technician.db.3890028.hostedresource.com
Database Name:Technician
Database User (login):Technician
User Password:
Table prefix:Hesk_1


In phpmyadmin i create a database and add its information to the above. When i click next i get the following message.

Database connection failed!
Double-check database name and make sure the user has access to the database. If not sure contact your hosting company for the correct information!


I randomly named table prefix Hesk_1. Am i suppose to go into phpmyadmin and add a table called Hesk_1? or will this be done automatically in the next step.

If this is anymore information that is needed please let me know.
Im am new to this, thank you for the help.

[Klemen]

One of these isn't correct (probably the Database Name: one):

Database Host:
Database Name:
Database User (login):
User Password:

- OR -

The database user doesn't have permission to access the database (database name).

This is not something we can help you with, you need to check with your host for the correct login info. Once the script is able to connect to the database all tables will be setup automatically.

[asilveri]

I have verified all the information with my host and it is all correct. Anyone have any idea on what the issue could be?

[asilveri]

I have verified all the information with my host and it is all correct. Anyone have any idea on what the issue could be?

Here are some pictures if this helps


[/img]

[YankeePicker]

Can you verify that the dbuser (Hesksupport1) has rights to the database (Hesksupport1)?

[cata1do]

have you tried with localhost?

[Klemen]

First check/try what YankeePicker and cata1do suggested.

If you can't get it to work download this file:
http://www.phpjunkyard.com/extras/mysql_test.zip

Open it in a text editor and change the settings to

Code: Select all

$hesk_settings['db_host']='Hesksupport1.db.3890028.hostedresource.com';
$hesk_settings['db_name']='Hesksupport1';
$hesk_settings['db_user']='Hesksupport1';
$hesk_settings['db_pass']='enter your password here';

Upload to the server, open in browser and see what message you get.

[Klemen]

Just a heads up: database names and passwords are CaSe SeNSiTiVe! "Hesksupport1" isn't the same as "hesksupport1"

[asilveri]

I uploaded the sql test file and it says it connected successfully, the thing is it says this for any settings i put in the file. And i forgot to mention that i have all the hesk files uploaded through SSH. Would that matter?

[Klemen]

Try contacting your host and ask what info should be used for PHP scripts to connect to the database.