bar top left
bar top right
left curve
right curve
Welcome, Guest

Installing SugarCRM in Elastix 2 problem
(1 viewing) (1) Guest
Go to bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Installing SugarCRM in Elastix 2 problem
#58051
Installing SugarCRM in Elastix 2 problem 1 Year, 5 Months ago Karma: 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.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
ferds
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#58073
Re: Installing SugarCRM in Elastix 2 problem 1 Year, 5 Months ago Karma: 39
how did you installed SugarCRM?

REgards,

Rafael
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
rafael
Free Software is all about freedom
Administrator
Posts: 1459
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Elastix Location: Ecuador Birthday: 10/11
Reply Quote
 
#58821
Re:Installing SugarCRM in Elastix 2 problem 1 Year, 5 Months ago Karma: 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?
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
gregory14
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#58834
Re:Installing SugarCRM in Elastix 2 problem 1 Year, 5 Months ago Karma: 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?
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
gregory14
Fresh Boarder
Posts: 7
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#59325
Re:Installing SugarCRM in Elastix 2 problem 1 Year, 5 Months ago Karma: 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
satsapo
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/09/05 15:51 By satsapo.
Reply Quote
 
#59985
Re:Installing SugarCRM in Elastix 2 problem 1 Year, 4 Months ago Karma: 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.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
eiger3970
Junior Boarder
Posts: 76
graphgraph
User Offline Click here to see the profile of this user
I use:
Elastix 2.0 32bit (MOBO blew up with a SATA to IDE data converter). Now Elastix 2.0.2 64bit.
CPU Info: GenuineIntel(R) Pentium(R) 4 CPU 2.40GHz
CPU usage: 0.73% used of 2,405.67 MHz
Memory usage: 22.37% used of 979.13 Mb
Hard Drive: 14% used of 16.44GB
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Moderators: Bob, jgutierrez