Error MySQL

rene_calo

I get "Unable to connect to MySQL server , possibly invalid login info ", but all my data is correct, what is the possible cause? Do I have to edit the files?

masino_sinaga

Have you checked your MySQL server connection? Is it up already?

Sincerely,

Masino Sinaga

kako

I am having the same problem, and xampp is installed correctly in local mode, because I run joomla without problems.

Thanks

kako

ntozier

Have you given the mysql user permission to the database?

kako

Hi,

the same user I use in joomla, with full powers

Kako

ntozier

So then your using the exact same database? (ie your OSTicket tables are in the same database as your joomla tables.) Because if not then you will need to setup permissions on the mysql user for the new database.

example:

MySQL server: myserver.domain.com

database: Joomla

tables: all joomla tables, all osticket tables

While this is fine you definitely should utilize the default ost_ prefix.

This setup allows you to utilize one username/password and set of permissions.

If you are set up like I am it would look more like:

MySQL server: myserver.domain.com

database: Joomla

tables: all joomla tables

database: osticket

tables: all osticket tables

This setup allows you to utilize one username/password but requires two sets of permissions.

note: I always utilize one username/password per database. I also do not mix my usernames access between products. If I am running say Drupal, Osticket, and PHPBB then I will have three separate database names, usernames, passwords, and permissions for just their database. I personally do this because like to segregate my products. If I decide to migrate to say Joomla or Wordpress I can simply drop the drupal database rather then have to write a query to drop all the tables beginning with say the drupal_ prefix. Also if I want to only back up/restore a specific set of tables its trivial and the backup files are much smaller and more manageable. Please realize that this is subjective and opinionated. You are free to set your stuff up however you want if it works for you.

Piccolo

I am getting this exact error. I only have on 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.

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.

I need a response ASAP. Thank you for your time and attention.

ntozier

@[deleted]

You haven't mentioned what version of OSTicket you are trying to install, or any pertinent server software versions. You also have not provided any php logs, nor have you proven that there is a problem with the script. You also haven't provided us with any idea of how you have your machines setup... is MySQL on the Webserver? When you rebuilt the webserver did you give it the same hostname?

These are some examples of why we ask people to open their own threads rather than piggy backing on another persons thread.