Install on Godaddy

[ajwaka]

Greetings! Just heard about osTicket last night, and installed it perfectly fine on my home computer and LOVED it!! I'm trying to install it now on Godaddy and I keep hitting issues.

I've placed in the info Godaddy gave me with regards to my mysql database - but when I click install - I get: Unable to connect to MySQL server. Possibly invalid login info. I called godaddy support and they said everything is working on their end. I know for a fact the username, database, and password are all correct - and I'm using the HostName Godaddy gave me.

I've been noodling around I can't figure this out! I'm a .NET guy (booo) - and noodled for hours and couldn't even get it close on IIS - so I figured to try GoDaddy out.

At home I dual boot XP and PCLinuxOS (noobie) and got it working quickly on pclos - Please, any suggestions?

[ajwaka]

I should also state that I chose the MySql 4.1 installation for the database... maybe that helps.... probably not?

[ajwaka]

I saw This post (http://osticket.com/forums/showthread.php?t=88)- where Peter mentioned to use this script $link = mysql_connect('hostname', 'user', 'password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link); I get the following:Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Would that also be why osTicket is probably unable to install through the installer? Is it trying to verifiy the connection string and Godaddy won't allow that?

I appreciate any help/ideas/advice you can offer

[4ice]

It looks like a db version error... the test script should normally work like a charm.

I found the following, maybe it helps:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Edit: just to be sure... you did replace 'hostname', 'user', 'password' with your own right? :)

[ajwaka]

Thanks for the link!!! Yes I did replace with my connection info - although I did forget to the first time:o

With that link - it sounds as if it's on godaddy's end correct? So I'll try to notify them - anybody here speak "Call Center"-eese?:D

[Sparklesperson]

Mine's on GoDaddy, and it works fine.

1. Go to GoDaddy and log in. Click on "my account".
2. scroll down and in the "my products area, click on "hosting account list"
3. find the hosting account that corresponds to your website, and click on "open" under the "Control Panel" column. This takes you to your hosting manager.
4. Mouseover "databases", and click on "mysql". This displays your list of databases.
5. Find the database you set up for the help desk, and mouseover the pencil icon on the right hand side of the page. The tool tip should read "Edit/View details".
6. Click on the icon to look at your details. This shows you your hostname, the database name, the description and the username, all of which you NEED to set up the script. You will also need the password.

No I'm not this tech minded. I got the info from Godaddy as I use them, and then had to figure it out again when I reinstalled.

:D

Hope this helps!
Patricia

[webminx]

I'm receving the same message and not sure what I'm doing wrong..

***GoDaddy information***
Status:Setup
Host Name:blah.secureserver.net
Database Name:dbstuff
Database Version:5.0
Description:dbstuff
User Name:dbstuff
DSN:Not Installed (Install)


//Constants
define("SERVER", "blah.secureserver.net");
define("USER", "dbstuff");
define("PASSWORD", "xyz123");
define("DATABASE", "dbstuff");

//
function db_connect()
{
/*
This will connect to the database using the username and password given.
If succesful, mysql_connect will pass back a valid link.
If unsuccessful, mysql_connect will pass back False, then the or part of the line will execute.
*/
$link = mysql_connect(SERVER, USER, PASSWORD) or die( 'Could not connect: ' .mysql_error ());
return $link;
}

[4ice]

Hi webminx,

what message do you actually get? And did you try to connect to you database with the connect example you posted?

Because if that connect function does not work the problem is probably something with you connection info.