SuiteCRM-7.7.9 fails on CentOS 7

ASB · 11 January 2017 05:02

Hi guys,

I recently downloaded the latest copy of SuiteCRM, and have been attempting to install it on my CentOS 7 machine. I fulfill all the prerequisites as prescribed by the install wizard.

However, I cannot seem to get the installation to work. After proceeding through the wizard, it would seem that none of the suitecrm tables are created in the database, even though the database itself is created by the installer. When attempting to go to the main SuiteCRM page, I simply get a blank page, assumable because the database is not correctly created.

I am attempting to create the database with the root user, so I do not see how SQL permissions could be an issue.

My install log says this:

2017-01-11 04:49:02…installerHook: Could not find custom/install/install_hooks.php
2017-01-11 04:49:06…Begin System Check Process *************
2017-01-11 04:49:06…XML Parsing Support Found
2017-01-11 04:49:06…MBString Support Found
2017-01-11 04:49:06…ZIP Support Found
2017-01-11 04:49:06…/custom directory and subdirectory check passed
2017-01-11 04:49:06…cache directory and subdirectory check passed
2017-01-11 04:49:06…/module directory and subdirectory check passed
2017-01-11 04:49:06…/upload directory check passed
2017-01-11 04:49:06…/zip check passed
2017-01-11 04:49:06…PCRE version check passed
2017-01-11 04:49:06…installerHook: Could not find custom/install/install_hooks.php
2017-01-11 04:49:06…php.ini location found. /etc/php.ini
2017-01-11 04:49:06…Outputting HTML for System check
2017-01-11 04:49:06…No Errors were found *************
2017-01-11 04:49:06…installerHook: Could not find custom/install/install_hooks.php
2017-01-11 04:49:12…installerHook: Could not find custom/install/install_hooks.php
2017-01-11 04:49:33…Begin DB Check Process *************
2017-01-11 04:49:33…testing with mysql:mysqli
2017-01-11 04:49:33…Basic form info is valid, continuing Process.
2017-01-11 04:49:33…Testing user account…
2017-01-11 04:49:33…Connection made using host: localhost, usr: root
2017-01-11 04:49:33…SUCCESS:: no errors detected!
2017-01-11 04:49:33…End DB Check Process *************
2017-01-11 04:49:34…installerHook: Could not find custom/install/install_hooks.php
2017-01-11 04:49:34…calling handleSugarConfig()
2017-01-11 04:49:34…calling handleHtaccess()
2017-01-11 04:49:34…calling handleDbCreateDatabase()
2017-01-11 04:49:34…looping through all the Beans and create their tables
2017-01-11 04:49:34…processing table acl_actions
2017-01-11 04:49:34…creating table acl_actions
2017-01-11 04:49:34…creating Relationship Meta for ACLAction
2017-01-11 04:49:34…processing table acl_roles
2017-01-11 04:49:34…creating table acl_roles
2017-01-11 04:49:34…creating Relationship Meta for ACLRole
2017-01-11 04:49:34…processing table relationships
2017-01-11 04:49:34…creating table relationships
2017-01-11 04:49:34…creating Relationship Meta for Relationship
2017-01-11 04:49:34…processing table leads
2017-01-11 04:49:35…creating table leads
2017-01-11 04:49:35…creating Relationship Meta for Lead
2017-01-11 04:49:35…processing table cases
2017-01-11 04:49:35…creating table cases
2017-01-11 04:49:35…creating Relationship Meta for Case

My sugarcrm log says this:

Wed Jan 11 04:49:34 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:34 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:34 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:34 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:34 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:34 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist
Wed Jan 11 04:49:35 2017 [3337][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrmdata.aow_workflow’ doesn’t exist

And there doesn’t appear to be a suitecrm.log as there would normally be.

I’m at a loss for what is going on. Could I please request your assistance?

Kind Regards.

erevodifosin · 11 January 2017 11:26

FYI: I am running Centos 7 with PHP 7 and SuiteCRM flawless.
I didn’t ever use Mysql root for SuiteCRM installation. I created a separate mysql user before the installation.

ASB · 11 January 2017 16:58

Hi erevodifosin,

Thanks for your response.

I also have attempted to create a separate mysql user prior to the installation, and using that user’s credentials to create the database; the installation failed the same way.

I have set up XAMPP on my Windows 10 computer just as a test, and SuiteCRM had no issues installing using the root account. As it stands, it had no issues installing whatsoever.

I’m at a loss for why it is failing on my CentOS 7 install.

Thanks.

ASB · 11 January 2017 17:15

Hi guys, a quick update.

I have been able to circumvent this issue by exporting the successfully-installed database using phpMyAdmin on my XAMPP stack. I performed the install on my CentOS 7 machine, like before, which still failed to install. Using phpMyAdmin on that machine, I dropped the previous database, and imported the correctly-installed one. SuiteCRM appears to be working now.

I still cannot say why the installer was failing to configure the database correctly, but this workaround is satisfying enough.

Kind Regards.

erevodifosin · 11 January 2017 17:21

Nice workaround! This issue is weird. You might face issues later on also you might not. I had permission issues while using a wamp that’s why i switched to centos.

ASB · 11 January 2017 17:24

Hi erevodifosin,

Thanks for the approval

Let’s hope that there are no other issues. I was diligent to assign full recursive permissions to the Apache user on the SuiteCRM folder.

If I have any other issues, I’ll create a different forum post.

Thanks for your assistance.

howarddon · 11 January 2017 17:57

I’m trying to install on Mac OSX 10.12.2 and getting the same errors as your first post–lots of missing tables. Can you explain your workaround a little more? How did you get a “correctly-installed one”? Thanks.

erevodifosin · 11 January 2017 18:07

Open a terminal(command line) locate the suitecrm folder and use the below commands:
chown -R apache:apache .
chmod -R 755 .
chmod -R 775 cache custom modules themes data upload config_override.php

Just to mention that there is a . (Dot) at the end of the first 2 commands. Copy this too.

ASB · 11 January 2017 18:12

Hi erevodifosin,

I have performed the commands as you requested. Is there anything I should be on the lookout for that would indicate a permissions failure?

Kind Regards.

ASB · 12 January 2017 23:10

Hi guys,

So I thought I would give a quick update on my SuiteCRM install.

Basically, even though I manually imported a “correct” database over the top of the failed one, I still had errors within the application. For example, I could not create modules and such, which indicated to me that PHP was still broken.

On this VM, I had used PHP 7.1. I don’t know if it’s drastically different from 7.0, or if in fact it caused any issues at all, but at this point, I decided to call it quits, and reinstall the entire LAMP stack from scratch.

I followed this guide to the letter:

https://hostpresto.com/community/tutorials/how-to-install-suitecrm-on-centos-7/

Which installs PHP 7.0 as a part of it’s process, and pre-creates a SuiteCRM database and user.

Following this guide, my install completed perfectly, and I have been working in SuiteCRM and creating modules/customizing things ever since.

Hope this helps someone.

erevodifosin · 13 January 2017 09:17

Mainly “undefined” text within pages indicates permission issues, and also 404 errors (file not found).

Very nice guide, i’ll keep it for future reference.

So it seems that for some reason SuiteCRM is not fully compatible with PHP 7.1

rob897 · 18 January 2017 13:40

I cannot get this to install with PHP7.1.
Installer log show always ends with this line:
2017-01-18 13:14:07…creating Relationship Meta for Case

socom · 18 June 2017 22:07

I’m having the exact same issues and logs on Debian 9. My install went smooth, but I am seeing these errors. A few other issues as well such a not being able to create tabs and get CT GSync working properly.

Sat Jun 17 23:32:56 2017 [12765][-none-][FATAL]  Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = 'ACLActions' AND aow_workflow.status = 'Active' AND (aow_workflow.run_when = 'Always' OR aow_workflow.run_when = 'On_Save' OR aow_workflow.run_when = 'Create') AND aow_workflow.deleted = 0 : MySQL error 1146: Table 'socom_suitecrm.aow_workflow' doesn't exist
Sat Jun 17 23:32:56 2017 [12765][-none-][FATAL]  Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = 'ACLActions' AND aow_workflow.status = 'Active' AND (aow_workflow.run_when = 'Always' OR aow_workflow.run_when = 'On_Save' OR aow_workflow.run_when = 'Create') AND aow_workflow.deleted = 0 : MySQL error 1146: Table 'socom_suitecrm.aow_workflow' doesn't exist
Sat Jun 17 23:32:56 2017 [12765][-none-][FATAL]  Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = 'ACLActions' AND aow_workflow.status = 'Active' AND (aow_workflow.run_when = 'Always' OR aow_workflow.run_when = 'On_Save' OR aow_workflow.run_when = 'Create') AND aow_workflow.deleted = 0 : MySQL error 1146: Table 'socom_suitecrm.aow_workflow' doesn't exist
Sat Jun 17 23:32:56 2017 [12765][-none-][FATAL]  Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = 'ACLActions' AND aow_workflow.status = 'Active' AND (aow_workflow.run_when = 'Always' OR aow_workflow.run_when = 'On_Save' OR aow_workflow.run_when = 'Create') AND aow_workflow.deleted = 0 : MySQL error 1146: Table 'socom_suitecrm.aow_workflow' doesn't exist

Regarding the RT GSync module, I did find a configuration area but had to search for it. What came up was “Google Apps Configuration”… Now I’m questioning whether this is for the Intellisys RT GSync module that I installed or if this part of SuiteCRM now natively.

Loving SuiteCRM! Seriously. I’ve got some learning to do though, just started last night. I’d think that integrating SuiteCRM and Google G-Suite (drive, docs, email, calendar, etc) would be a simple task considering SuiteCRM supporting OAuth and G-Suite API or the like. I do like the RT GSync Gmail integration though!