Issue during installation

yuljk

Hi guys - I'm attmepting to install OSTicket on a Windows 2008 R2 box with IIS 7 installed. I already have MySQL 5.1 installed and PHP 5. Both are working correctly as I have a couple of wordpress sites working without any issues.

I have ensured the permissions are correct on the ost.config.php file and have enabled 'short_open_tag' in my php.ini.

I then went ahead and created a new database and associated user in phpmyadmin and granted all privilages.

When I run through the initial OSTicket setup I receive the following error

'Unable to connect to MySQL server. Possibly invalid login info.'

I am using the following details:-

MySQL table Prefix: _ost

Hostname: Localhost

MySQL Database: apollonticket

MySQL Username: ticketuser

MySQL password: passwordhere

I have tried deleting and re-creating the database and user, however the problem still occurs.

Anyone know how I can fix this? I'd love to use OSTicket, as it looks like it will fit my needs nicely.

Many thanks for any help.

ntozier

Couple quick suggestions for you:

1. try localhost (note all lowercase)

if that doesn't work try using the netbios name of the computer.

if that doesn't work try the ip address assigned to the computer.

2. not sure if you need to, but did you flush privileges; after you setup the user and gave him his permissions? I usually make users via CLI and remember to do this manually. I trust phpmyadmin does this automatically, but don't use phpmyadmin myself.

3. did you also give the user permission to connect to the db from localhost?

Good luck!

yuljk

Hi ntozier - Many thanks for your help. I've tried once again, this time trying the NETBIOS name and IP of the server. No dice.

I am creating the DB and username through phpmyadmin, so I assume the privilages are flushed on creation (though I'm not sure)

I'm not sure what you mean in point 3. Could you let me know how I can achieve this? It's not something I've ever had to do when creating MySQL databases for my php forums and wordpress sites.

I'm starting to wonder if IIS 7 might have a compatibility issue with OSTicket..

ntozier

When you create a user in MySQL you have to tell MySQL where the user is allowed to connect from. In the CLI this is done like this:

mysql> GRANT ALL ON osticket.* TO username@localhost IDENTIFIED BY 'mypassword';

see the @[deleted]? That means the user can only connect from localhost to the local server.

To dissect the rest of the command, you are granting all privs on the osticket database to username@localhost, and setting their password to mypassword. You could do username@* which means from anywhere. This is probably not a very secure thing to do, and do not recommend it. But you could try it to see if it resolves your connection issue. Just remember to change it later.

I run multiple instances of OST1.6ST under IIS, and have for years.

yuljk

Hi ntozier - I have now tried creating the user from the CLI, which worked fine. I then checked that the user had been created successfully from phpmyadmin, and it had been with all global privilages enabled.

However, after running through the install again, I get the same error.. No idea what could be causing this now.

Any other ideas? If you like, I can allow you to remote into the server via RDP to see whether theres something I'm missing.

Many thanks for your help so far!

yuljk

Hi ntozier - Managed to figure out the problem. Turned out that when creating the new user in phpmyadmin I needed to specify the IP address of the server instead of 'localhost'.

After doing that, the installation went through fine. Strange issue, as I've never had to do likewise when creating wordpress database users.

Anyway, many thanks for your help!

ntozier

Glad that you got it figured out. :) And thanks for posting back here letting everyone else know what the problem is so that maybe someone else experiencing similar behavior might find this useful.