Problem with installation on Dreamhost hosting

📦 Install & Upgrade Help
1

Hi, im trying to install the SuiteCRM on Dreamhost hosting, but im receiving a error.

Fatal error: Uncaught exception ‘Exception’ with message ‘Database failure. Please refer to suitecrm.log for details.’ in /home/demo/crm3/include/utils.php:1623 Stack trace: #0 /home/demo/crm3/include/database/DBManager.php(345): sugar_die(‘Database failur…’) #1 /home/demo/crm3/include/database/DBManager.php(321): DBManager->registerError(’ Query Failed: …’, ‘MySQL error 114…’, true) #2 /home/demo/crm3/include/database/MysqliManager.php(160): DBManager->checkError(’ Query Failed: …’, true) #3 /home/demo/crm3/include/OutboundEmail/OutboundEmail.php(495): MysqliManager->query(‘INSERT INTO out…’, true) #4 /home/demo/crm3/include/OutboundEmail/OutboundEmail.php(396): OutboundEmail->save() #5 /home/demo/crm3/modules/Administration/Administration.php(135): OutboundEmail->getSystemMailerSettings() #6 /home/demo/crm3/include/entryPoint.php(192): Administration->retrieveSettings() #7 /home/demo/crm3/index.php(47): require_once(’/home/demo/c…’) #8 {main} thrown in /home/demo/crm3/include/utils.php on line 1623

I dont know how to fixed, and the Error log dont say too much:

Tue Mar 14 12:53:51 2017 [10211][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 12:53:51 2017 [10211][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘b9a79f74-ae35-6b71-52e8-58c84a5c416d’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 13:46:19 2017 [27684][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 13:46:19 2017 [27684][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘6e42be84-60f6-0e79-dfca-58c856ed6624’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 13:46:21 2017 [27684][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 13:46:21 2017 [27684][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘a5953170-f41a-f0f1-7609-58c856fa5fcb’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 14:29:49 2017 [16677][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 14:29:49 2017 [16677][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘aad8649a-a6c7-6d5d-63dc-58c86078f175’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 14:30:15 2017 [16842][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 14:30:15 2017 [16842][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘1041ff1b-01d8-6364-247f-58c860de4d60’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 14:53:39 2017 [21169][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 14:53:39 2017 [21169][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘653c4063-1121-b74c-92b6-58c866ed30b8’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:13:23 2017 [30343][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:13:23 2017 [30343][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘3b666e68-3364-83ed-9efe-58c86b95e332’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:13:29 2017 [30343][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:13:29 2017 [30343][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘e29f0769-ae0e-43ae-f684-58c86bf8fb3a’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:37:54 2017 [21583][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:37:54 2017 [21583][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘7727ca82-ed7c-847a-0992-58c87067b60d’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:37:57 2017 [21583][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’: MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist
Tue Mar 14 15:37:57 2017 [21583][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘1e741428-6ac1-8c5f-2542-58c870d26f25’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,’’,25,’’,’’,1,0): MySQL error 1146: Table ‘crm3.outbound_email’ doesn’t exist

2

Any help please?

3

Have you followed PRECISELY the installation guide? ( suitecrm.com/wiki/index.php/Installation ).(pay particular attention to permissions)

Are you sure that you entered the correct database credentials and address?

4

Yes, but, my hostname is a URL, i want to change to IP, how can i edit the hostname?

Thanks

5

I change the hostname, but still not working, Dreamhost the permissions of my folders are set to 777, but still not working, the Dreamhost support said looks like the database data is wrong (password, databasename or hostname) but everything works fine.

What can i do?

6

Are you sure that you are entering the correct credentials?

Try the attached script to test the database connection: just place it in same folder as SuiteCRM then, with the browser call it like this:

http://<path_to_suite_crm>/db_test.php

(You must replace <path_to_suite_crm> with the actual value so, for example, if it is www.example.com/crm, you should enter: http://www.example.com/db_test.php)

7

Evrerything is OK:

Successfully connected to host: ‘208.97.162.xx’
Successfully to Database: ‘crm2xxx’
There are 36 tables in database 'crm2xxx

8

It’s not OK. SuiteCRM has more than 200 tables

You probably have to increase system resources before you install. Eg:
max_execution_time = xx <-- try putting 3000
max_input_time = xx <-- 3000
max_input_vars = xx <— 10000
memory_limit = xx <— 500M
upload_max_filesize = xx <-- 256M

9

Im install SuiteCRM on my localhost, and everything is fine, the database are 37 tablets. not 200, why?

Here is a screenshot of my tablets

10

I was checking the file utils.php the line 1623 and say:

throw new \Exception($error_message, $exit_code);

What is that?

11

I don’t know what it is but please post the values for your systems variables.

If you don’t know how to get them you can just create a file called phpinfo.php and inside write the following

<?php
phpinfo();
?>

then put it in the SuiteCRM folder and execute it from the browser as I showed you before with the other script.

12

Ok, here is my site: http://crm2.eximperu.com/phpinfo.php

13

The values seem to be OK.

Maybe you could increase max_input_vars to 10000 and max_execution_time to 3000, but I don’t think it’s the problem.

Have you put the .user.ini file in your root folder? If yes: have you modified the values?

Have you tried to re-install SuiteCRM?

14

No, i didnt create a user.ini, i didnt modified any values, just use the auto install.

Yes, this is my third time i reinstall the SuiteCRM, i did the installation on my computer (localhost) and works fine.

15

You can try a different strategy:

  1. delete everything (Files and DB) from your server
  2. copy all files from your PC to your server
  3. export database from your PC
  4. import database in your server
  5. edit in your server the file config.php and modify accordingly the following values:
    . site_url
    . host_name
    . db_host_name
    . db_user_name
    . db_password
    . db_name
    . db_type
  6. edit .htaccess in the root folder of SuiteCRM and make sure that the new server folders are referred instead of those in yur PC
  7. Reset permissions correctly
  8. log into SuiteCRM as an administrator
  9. Run Quick Repair and Rebuild (Admin->Repair->Quick Repair & Rebuild)
  10. Clear the system cache
16

I assume your installation is breaking halfway, you should have a look at your upgradeWizard.log and see what’s in there (look for ERROR and FATAL).

17

I did that, and is not working, im guess is something about Dreamhost, but i dont know why.