Iâm trying to install on a hostgator shared server account. I unpacked the zip file and changed the permissions and I can navigate to the installation web page. In Step 2, I kept getting errors that the database credentials werenât right. So I went into cpanel and created a mysql database and an admin user. I then provided that info in Step 2 and the errors went away. However every time I click Next, it says a pop-up appears saying that itâs validating the db and then it just returns back to the Step 2 page. I canât get it to proceed any further.
Normally you donât create the SuiteCRM database, the installer does it for you. Of course you have to be able to provide the installer with valid database credentials - your hosting can help you with that. You should probably be using âlocalhostâ as the database server address.
You also have install.log on the root of your SuiteCRM install to check what the errors are.
Yeah, I thought that was how it was supposed to work, and after I created the database, I got a message from the installer that it already existed and that all tables would be wiped out (fine, it was empty/new). But then it wouldnât proceed.
So I just deleted the existing database and started over. I made sure to use my database admin user ID and I told it to create a new user ID for SuiteCRM. No errors, but it returned to the Step 2 page. I checked in cpanel and the database was not created, nor was the SuiteCRM user. However, back on the Step 2 page, it now shows the database user and the drop-down menu defaults to âProvide existing userâ, as if it thinks the user was created.
Still canât proceed past this page. Iâve filled in all required (red asterisk) entries, so I donât think itâs that.
Excellent question. Hereâs the tail end of the log:
2018-02-07 22:56:32âŚDB not selected, will create suitecrm
2018-02-07 22:56:32âŚPassed DB install check
2018-02-07 22:56:32âŚSUCCESS:: no errors detected!
2018-02-07 22:56:32âŚEnd DB Check Process *************
2018-02-07 22:56:33âŚinstallerHook: Could not find custom/install/install_hooks.php
The custom directory exists, but thereâs no install subdirectory.
Hhmm that doesnât tell me much. You might have more interesting things in suitecrm.log
Anyway, youâre stumbling in what is normally a very easy thing to do. Something is wrong with your hosting. When I install on Ubuntu from the command-line, I use these modules (for PHP 7.0):
In your CPanel, youâll find a way to turn PHP modules on or off. Try to see if you can match some of these, especially the zip ones.
A final idea, if this doesnât work, is to check browser errors in your browserâs Developer console. Maybe something is breaking in the screen, causing a problem later in the install process.
pgr, thanks for your help.
"
I ended up deleting the installation several times and trying different combinations of user names and so on. I eventually was able to get it installed (with one caveat) by using my hostgator cpanel credentials and then âUse admin userâ for the drop-down. The caveat is that it threw a bunch of errors such as the following:
[color=#0000bb]Thu Feb 8 14:07:53 2018 [411585][-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 âgarlick_suitecrm.aow_workflowâ doesnât exist[/color]
Hostgatorâs database panel also doesnât show the new database, but I can connect to it from the command line with mysql. And I can login to to SuiteCRM with the administrative user that I created, so I guess Iâm in business and I can move on to learning how to use it.