Installation: Database Issue:

📦 Install & Upgrade Help
1

I am a wee bit stuck as to how to configure the database settings from the setup wizard.

I am running this on a Ubuntu VPS.

I have another piece of software (Fusion Invoice) on the same box, so I know that MySQL works.

What am I supposed to enter into the fields on the DB settings? I have tried the mysql root user and password. I have tried creating a db, and entering a user will full privileges. Both times I get “…cannot access” in the logs.

What am I supposed to enter into those fields? What am I doing wrong?

2

Hi

you should enter the host name (probably localhost), the MySQL root user (or other, sufficiently privileged) and password.

You should not have any database called suitecrm there, the installer should create it for you.

You probably already tried all of this, so here are a few tips to troubleshoot:

  • try your credentials first on the command-line, running this

mysql -h localhost -u root -p

  • if your password uses any weird characters, like punctuation or accents, try with a simple password

  • check install.log and suitecrm.log for any errors

3

Still no dice. I have tried mysql root user. I verified that my mysql root credentials are correct, and still no luck. Again, this is all with the root mysql user…

2017-11-10 01:45:46…testing with mysql:mysqli
2017-11-10 01:45:46…Basic form info is valid, continuing Process.
2017-11-10 01:45:46…Testing user account…
2017-11-10 01:45:46…ERROR:: The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, user$
2017-11-10 01:45:46…FATAL:: errors have been detected! User will not be allowed to continue. Errors are as follow:
2017-11-10 01:45:46… The provided database host, username, and/or password is invalid, and a connection to the database could not be established. Please enter a valid host, username a$
2017-11-10 01:45:46…End DB Check Process *************

Just to see what happens, I tired creating the database suitecrmdb and a user. Of course, I get stuck on the next page… 500 error after I try to refresh the page.

2017-11-10 02:36:09…Basic form info is valid, continuing Process.
2017-11-10 02:36:09…Testing user account…
2017-11-10 02:36:09…Connection made using host: localhost, usr: cradmin
2017-11-10 02:36:09…SUCCESS:: no errors detected!
2017-11-10 02:36:09…End DB Check Process *************
2017-11-10 02:36:09…installerHook: Could not find custom/install/install_hooks.php
2017-11-10 02:36:09…calling handleSugarConfig()
2017-11-10 02:36:09…calling handleHtaccess()
2017-11-10 02:36:09…calling handleDbCreateDatabase()

4

Sometimes these issues are solved by changing something in the MySQL / PHP interface. PHP accesses the database via modules, and there is more than one of them. You can change these settings in php.ini, I think, and if you’re on shared hosting then you might also find those options on your CPanel.

Look for PHP modules called mysqli or similar, and Google about this.

Another option is to try upgrades to MySql, and to PHP (v 7.x recommended). Sometimes these magically solve your issue.

5

By the way, I posted my install notes for Ubuntu 16.04 a while ago

https://suitecrm.com/forum/installation-upgrade-help/11561-installing-on-ubuntu-16-04-1

there you can find the commands to load all the PHP 7.0 modules you need. It normally works flawlessly.

1 Like
6

Well, I got it working. I just rebuilt that VPS and installed LAMP with taskel (which I didn’t do the first time). My issue had to have been that I was breaking a module somehow.

I appreciate all the help.