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

Piccolo

I am getting this exact error. I only have one DB in the RDBMS. I know the user name works because I can connect from my Windows systems to the osTicket db using MySQL Workbench. I can also connect using my PHPAdmin from the same Windows machine but the setup part to create the tables is not recognizing the user name and password provided.

I got this to work the first time but the HDD failed and I had to reinstalled everything from scratch. The first time went flawless now it is giving me the error posted in this thread. Same server is being used to reinstall osTicket with a local MySQL and PHP.

So let's make this clear as it is very obvious there is something wrong with the script. I have tried to doing locally in the system. I used lynx to run the set up and also same error. I have used the localhost, 127.0.0.1 and still failed. Unless I need to run this manually it would be appreciated a GOOD set of instructions as I notice the lack of good instructions for osTicket.

The server config is as fallow:

osTicket 1.6

OS: Ubuntu 12.04

MySQL: 5.5

PHP: 5.3

Many thanks in advance//

ntozier

Where is the MySQL server (is it on the webserver)?

Because if you can connect to it from other machines but not the webserver it sounds like that username does not have permissions for the webserver to connect.

When you rebuilt the webserver did you give it the same hostname?

Because if you didn't, and you never updated the users connection privs in MySQL you wont be able to connect.

nichenet

I am getting this exact error. I only have one DB in the RDBMS. I know the user name works because I can connect from my Windows systems to the osTicket db using MySQL Workbench. I can also connect using my PHPAdmin from the same Windows machine but the setup part to create the tables is not recognizing the user name and password provided.

Im getting the same error and I can access the db using phpadmin and the provided user/pass.

any ideas?

Piccolo

@ ntozier:

As provided in the information, installed all software from scratch but used the same hardware it was used before. Meaning, Linux, MySQL, PHP and osTicket were reinstalled as if they never were installed before. Just like, it was a brand new server.

Every component is local to osTicket. Apache2, PHP, MySQL and PHPMyadmin are all installed in the same server as osTicket. The user is root in MySQL. How is it possible it doesn’t have permission for the server to connect when I can use PHPMyadmin through the Apache2 webserver? If that were correct then PHPMyAmin shouldn’t connect either. Here is another tip as provided in the original information, I can connect using MySQL Workbench using the same user name provided and creates any tables under the database from a remote computer or local computer.

If everything is rebuilt from scratch, it doesn't matter what name you give to the server as everything is being reinstalled from ground up, including the operating system. I am not sure what your technical expertise is but it seems to make simple things complicated.

I have created another user osticket where the user had full access from anywhere and still same error. I have tried so for three different users and they all work except under osTicket.

Can you provide a solution to the problem? Throwing guesses but I haven’t see a set on instruction to try something. Can you provide any instructions to try to fix the issue? Can the script be ran in a different manner?

Another thread was closed with this same issue but I din’t see any resolution.

Thank you.

Piccolo

Does any one knows where to see the error log for osTicket?

Thank you.

Piccolo

All right! I found way around the issue. Here is what I did:

From your PHPMyAdmin drop the user and the database. Once your drop them reload MySQL. The way I reloaded for a complete reload, I just rebooted my server.

To generate and error log, edit my.conf:

vi /etc/mysql/my.conf

Find the lines and remove the # to uncomment the line and make it active:

#general_log_file = /var/log/mysql/mysql.log

#general_log = 1

Change it to:

general_log_file = /var/log/mysql/mysql.log

general_log = 1

I also edit:

#log_slow_queries = /var/log/mysql/mysql-slow.log

#long_query_time = 2

#log-queries-not-using-indexes

#log_bin = /var/log/mysql/mysql-bin.log

#binlog_do_db = include_database_name

#binlog_ignore_db = include_database_name

#binlog_do_db = include_database_name

Log in back into PHPMyAdmin and create the database and the user for osTicket. Reload MySQL or reboot the server. I reboot the server to reload all the MySQL modules. Then I was able to complete the installation process. Finally go back and reedit the my.conf file as the changes will affect performance. The user created had all data and structure access but not admin access at all.

I hope this will help someone else.

ntozier

@[deleted],

I asked some clarifying questions to ensure that the permissions in MySQL were correct. I'm not sure how that makes things more complicated. The more information provided the easier it is for someone to help troubleshoot your problem, did you read the sticky post at the top of the forums?

If you made a new server and gave it a different hostname, and MySQL was hosted on another server it would make perfect sense that you could no longer connect to the MySQL server from the new server, but could still from other machines.

Also I closed the other thread because: it was from 2011; the original poster never replied; 6 months later someone else zombied it; then this month you zombied it.

I'm glad that you found your solution. I'm also glad that you posted it here where it may help other people.