Install 7.14 - MySQL Failure

📦 Install & Upgrade Help
1

I am installing 7.14 on Linux to replace our old version of CRM but when I run the install file it stops when accessing the MySQL databases on the server. I have give it multiple logins and made sure in MySQL those logins have access to the database it is supposed to use. Any tips that I might have missed.

I even ran it once with the root password thinking it has access to everthing in MySQL database and it still gives errors that it cannot create tables in that database.

Or is there a way to get it to skip the creating tables in the MySQL since I want to restore a backup of my SuiteCRM from another server onto this one and have those tables replace whatever this process is going to create.

2

Is it new installation or you upgrade to v7.14 from the older version?

3

A new installation, I needed to update the OS, SuiteCRM and a bunch of other features but the OS is at end of life. It seemed like it was safer to build a newer server and migrate the CRM database and then upgrade. Also less of a headache for my co-workers as they are not kicked out of the older version until I have this one running.

Ironically on this server I was able to install SuiteCRM 8 onto it and log in, but I could not get it to use the older database, all guides pointed to setting up on the older version & database, then upgrade to 8.

So for now I am open to tips on either getting 7.14 to complete the installation & connect to MySQL, or if there is a easier way to get SuiteCRM8 to access a backup of an 7.14’s database if that is a viable option.

4

Okay, if it is new installation, then good place to check if configuration is at:

  • config.php file

You can check DB config and site URL settings. Make sure those are correct. Also, check if you have correct file permissions.

‘site_url’ => ‘http://example.com/suitecrm’,

5

I am running some more tests on the installation and now I no longer think it is a database issue. I cleared out the database and checked it after the installation runs and it looks like the tables are created.

I also found the log and the only errors are on the outbound email tables that I have not configured for this anyway.

However the installation screen looks like it stops either at the end of the tables or on the next step. Below is what I am getting on the screen when I run the installation of 7.14. Anyone know what it would be running on the next step?

Creating SuiteCRM configuration file (config.php)

Creating SuiteCRM application tables, audit tables and relationship metadata
Creating the database [database_name_here] on localhost…done

…

6

You need to refresh or revisit the page. You should see login page.

Are you able to see login page?

7

I go back to the main page and get a database error pointing me to suitecrm.log

All it has are errors accessing a table [outbound_email] but I am not setting up SuiteCRM to be able to send outbound emails. I found another installation log file, but there are no errors in that log for me to look into.

8

Are you able to login in your system and use it?

For now, you can ignore that outbound email error.

You can share screenshots here for more clarification.

9

I just manually created the [outbound_email] table in the MySQL database.
It stopped giving me that error in the log file, but now when I go to the main page I am just getting a generic HTTP error 500 page.

I am going to abandon this process and try to upgrade the live SuiteCRM to 8, then migrate it to this secondary server so all pages and database tables match for the migration.

10

You do not have to add table manually. You can just ignore that message on the page. You are getting it since you did not set up outbound mailbox.