Installing SugarCRM in Elastix 2 problem

Discussion in 'General' started by ferds, Aug 19, 2010.

  1. ferds

    Joined:
    Jun 16, 2010
    Messages:
    1
    Likes Received:
    0
    Hi

    I'm new here and this is my first post..

    I've just installed elastix 2 from scratch and also installed SugarCRM but i got this error when i tried to access it:

    Could not connect to server localhost as sugarcrm. port . Access denied for user 'sugarcrm'@'localhost' (using password: YES)

    I dont know what to do next.. any help would be very much appreciated.

    thanks very much.
     
  2. rafael

    Joined:
    May 14, 2007
    Messages:
    1,454
    Likes Received:
    1
    how did you installed SugarCRM?

    REgards,

    Rafael
     
  3. gregory14

    Joined:
    Jun 3, 2010
    Messages:
    7
    Likes Received:
    0
    Hi,

    I have the same problem. I don't remember exactly how I installed SugarCRM, but I think I just clicked the installation link in the Elastix 2.0 web interface.

    I edited /var/www/html/SugarCRM/config.php and I changed the db_user_name and the db_password with the right values.

    Now, I have the error message :

    Code:
    Unable to retrieve system settings Query Failed:SELECT category, name, value FROM config::MySQL error 1146: Table 'sugarcrm.config' doesn't exist
    I looked for the sugarcrm database but I didn't find it. It doesn't exist!

    So please, could someone give us a basic database for sugarcrm?
     
  4. gregory14

    Joined:
    Jun 3, 2010
    Messages:
    7
    Likes Received:
    0
    I fixed my problem.

    1) I found a .sql file with the missing database :
    Code:
    /usr/share/elastix/module_installer/elastix-sugarcrm-addon-5.2.0l-5/setup/db/install/02-createtables.sql
    2) I connected to mysql :
    Code:
    mysql -p -u root
    3) I loaded the database :
    Code:
    sql> source /usr/share/elastix/module_installer/elastix-sugarcrm-addon-5.2.0l-5/setup/db/install/02-createtables.sql
    Ferds, does this solution work with you?
     
  5. satsapo

    Joined:
    Aug 11, 2010
    Messages:
    1
    Likes Received:
    0
    Same problem here but resolved!

    I've done what you said gregory14 but I also had to:

    Code:
    mysql> source /usr/share/elastix/module_installer/elastix-sugarcrm-addon-5.2.0l-5/setup/db/install/02-createtables.sql
    
    mysql> source /usr/share/elastix/module_installer/elastix-sugarcrm-addon-5.2.0l-5/setup/db/install/01-createdb.sql
    
    mysql> source /usr/share/elastix/module_installer/elastix-sugarcrm-addon-5.2.0l-5/setup/db/install/03-createusersdb.sql
    
    Thank you for your help.
    Hope this helps others! It took me a entire afternoon to resolve (I'm a linux and mysql newbee)
    ST
     
  6. eiger3970

    Joined:
    Apr 29, 2009
    Messages:
    112
    Likes Received:
    0
    Hi, I've upgraded to Elastix 2.0 and Sugar CRM won't install.
    vTiger works.
    SugarCRM is installed in my Addons tab.
    Call Center is installed in my Addons tab.

    Under the System>Updates tab the status shows Installed (Package that install SugarCRM). Not quite sure if it needs to be loaded? Anyway, the option under tab Extras no longer shows the option to use vTiger or SugarCRM and automatically loads to vTiger.
     

Share This Page