PHPJunkyard support forum

Posted: **Mon Mar 09, 2009 8:05 pm**

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.

Posted: **Mon Mar 09, 2009 8:50 pm**

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.

Posted: **Tue Mar 10, 2009 5:27 pm**

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

Posted: **Tue Mar 10, 2009 6:34 pm**

asilveri wrote: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]

Posted: **Tue Mar 10, 2009 7:31 pm**

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

Posted: **Tue Mar 10, 2009 8:57 pm**

have you tried with localhost?

Posted: **Tue Mar 10, 2009 9:19 pm**

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.

Posted: **Tue Mar 10, 2009 9:23 pm**

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

Posted: **Wed Mar 11, 2009 2:56 pm**

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?

Posted: **Wed Mar 11, 2009 6:31 pm**

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

PHPJunkyard support forum

Database connection failed

Database connection failed

Thanks for reply

Re: Thanks for reply

Thanks for the responses