Cannot get SugarCRM to install

Submitted by DenisCroombs on Sun, 05/27/2012 - 11:09 Pro Licensee

Hi, I have now tried SuganCRM on 2 centos (latest/fully updated centos & virtualmin) systems and am getting the same type of issues on both:-

I have checked the MYSQL password and made sure it is as the domain user PW and no change.

Configuring webserver PHP settings .. .. done

Applying web server configuration .. .. done

Now installing SugarCRM version 6.4.4 ..

Database connection failed : DBI connect failed : Access denied for user 'cermatco'@'localhost' (using password: YES) 1360.

.. failed! See the error message above for the reason why.

Re-loading Webmin .. .. done

Applying web server configuration .. .. done

Any clues, as it is doing my and my customers heads in.

Denis

Status: 
Active

Comments

Submitted by JamieCameron on Sun, 05/27/2012 - 20:37

Do you get a similar error if you try to install another script into the same domain, such as Drupal or Joomla?

Submitted by DenisCroombs on Tue, 05/29/2012 - 14:13 Pro Licensee

Hi Jamie

Same issue, I even tried setting a new password and no difference. Any other clues?

Denis

Submitted by DenisCroombs on Tue, 05/29/2012 - 14:15 Pro Licensee

I just noticed that it actually created the database, just cannot add and fields/data to it.

Denis

Submitted by DenisCroombs on Tue, 05/29/2012 - 14:35 Pro Licensee

And trying the same on other domains on the same server also causes the same issue/error with most packages.

Regards Denis

Submitted by JamieCameron on Tue, 05/29/2012 - 17:59

Can you connect to MySQL as the domain user from the command line on the system?

The command for this would be like :

mysql -u cermatco -pXXX YYY

replace XXX with the user's password, and YYY with the database name. If this fails, the issue may be that MySQL user/IP permissions aren't allowing connections from localhost.

Submitted by DenisCroombs on Wed, 05/30/2012 - 13:26 Pro Licensee

Hi Jamie

mysql -u cermatco -pxxxxxxxx cermatco_egroupware ERROR 1045 (28000): Access denied for user 'cermatco'@'localhost' (using password: YES)

Regards Denis

Submitted by JamieCameron on Wed, 05/30/2012 - 18:49

Perhaps that domain's MySQL password is out of sync with what Virtualmin expects.

Try selecting the domain from the left menu, then going to Edit Databases -> Passwords, and changing the password to something different. Then change it back again to the original password.

Submitted by DenisCroombs on Thu, 05/31/2012 - 12:27 Pro Licensee

Hi Jamie

That worked and was able to connect to the database from the command line, I was then able to do the basic install but when I use the link http://cermatco.co.uk/sugarcrm/ to do the final SugarCRM install/config I get the error:- Database failure. Please refer to sugarcrm.log for details.

Thu May 31 00:00:04 2012 [17469][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Thu May 31 00:00:04 2012 [17469][-none-][FATAL] Unable to retrieve system settin gs Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tab le 'cermatco_sugarcrm.config' doesn't exist Thu May 31 00:01:01 2012 [17471][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Thu May 31 00:01:01 2012 [17471][-none-][FATAL] Unable to retrieve system settin gs Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tab le 'cermatco_sugarcrm.config' doesn't exist Thu May 31 00:02:02 2012 [17470][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Thu May 31 00:02:02 2012 [17470][-none-][FATAL] Unable to retrieve system settin gs Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tab le 'cermatco_sugarcrm.config' doesn't exist

Is the contents of the log file.

I also tried to connect to the sugarcrm db and the results are below:-

[root@sue sugarcrm]# mysql -u cermatco -pxxxxxxxxxx cermatco_sugarcrm Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 126539 Server version: 5.0.95 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Also when I started this I noticed that the license for the 100 user virtualmin system had expired and purchased a new one, but as yet the server is not picking this new license up.

Regards Denis

Submitted by JamieCameron on Thu, 05/31/2012 - 19:04

You might be seeing the leftovers of a partial SugarCRM install. Try un-installing, deleting all tables from the cermatco_sugarcrm database, and then re-installing.

BTW, I have applied your licence extension.

Submitted by DenisCroombs on Fri, 06/01/2012 - 05:28 Pro Licensee

Thanks for doing the licence extension.

I have tried un-installing the old sugarcrm installs, checking that the database was actually deleted and trying the install again a few times.

But even when I do the uninstall, double check that the db has been deleted and do the install again I get Database failure. Please refer to sugarcrm.log for details. when I use the http://cermatco.co.uk/sugarcrm/ link, I can then check the DB is valid by:-

[root@sue ~]# mysql -u cermatco -pxxxxxxxxxx cermatco_sugarcrm Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 132477 Server version: 5.0.95 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Which all looks OK ?

and the sugarcrm.log shows:-

Fri Jun 1 03:27:01 2012 [2107][-none-][FATAL] Query Failed: SELECT id, name, s ymbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Fri Jun 1 03:27:01 2012 [2107][-none-][FATAL] Unable to retrieve system setting s Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tabl e 'cermatco_sugarcrm.config' doesn't exist Fri Jun 1 03:28:01 2012 [2108][-none-][FATAL] Query Failed: SELECT id, name, s ymbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Fri Jun 1 03:28:01 2012 [2108][-none-][FATAL] Unable to retrieve system setting s Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tabl e 'cermatco_sugarcrm.config' doesn't exist Fri Jun 1 03:29:01 2012 [2105][-none-][FATAL] Query Failed: SELECT id, name, s ymbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Fri Jun 1 03:29:01 2012 [2105][-none-][FATAL] Unable to retrieve system setting s Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tabl e 'cermatco_sugarcrm.config' doesn't exist Fri Jun 1 03:30:02 2012 [2106][-none-][FATAL] Query Failed: SELECT id, name, s ymbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0: MySQL error 1146: Table 'cermatco_sugarcrm.currencies' doesn't exist Fri Jun 1 03:30:02 2012 [2106][-none-][FATAL] Unable to retrieve system setting s Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Tabl e 'cermatco_sugarcrm.config' doesn't exist

Regards Denis

Submitted by JamieCameron on Sat, 06/02/2012 - 06:51

If you access that cermatco_sugarcrm database, what tables DO exist?

Submitted by DenisCroombs on Sat, 06/02/2012 - 07:18 Pro Licensee

When I go into the database section of the domain config, I get "This database has no tables"

Would it be easier for you to find the issue if I gave you access to the system ?

Denis

Submitted by JamieCameron on Sat, 06/02/2012 - 19:21

Sure, remote access would make this much easier to debug ..

Submitted by DenisCroombs on Sun, 06/03/2012 - 12:31 Pro Licensee

Hi Jamie

Can you please send me details on how best to do that.

Denis

Submitted by JamieCameron on Mon, 06/04/2012 - 08:01

You can email me your system's IP address and root password for SSH at jcameron@virtualmin.com .

Also let me know which domain and directory you want SugarCRM installed into..