Accessing sugarcrm database at remote host

[sagarladdha]

Hi,

I am trying to access the sugarcrm database stored on a remote host. But the application gives me some errors like "Authentication protocol not supported" or "access denied".

The overall scene is somewhat like this. We are a team of 3 and we are customizing sugarcrm as per our oganizations' needs. So we have to share a common database. initially, we had local copies of this DB and we were changing the [I]module{/I]_cstm tables as we wished. We used to add custom fields through studio and when we uploaded our codes on the server i.e., we "checked in" the tasks, these custom fields were not working there. They were visible in both Detail and Edit views but the database wouldnt get updated.

So we thought of having a common database on the server itself but this isnt working. We are not able to connect to it through sugarcrm. We have tested the connection to the host and its fine. Do we need to re-install sugarcrm?

Someone please help in this regard.

Thanks in advance,

Sagar Laddha
India

[searocket]

that sounds like a MySQL problem, check that the host with your Sugarcrm has the correct permissions to access the database.

[sagarladdha]

I have checked the connection with other utilities (MySQL Administrator & MySQL Command Line Client) and its working absolutely fine. The required permissins have been set.

It is obvious that we cant connect directly because while installation we dont ahve any option of specifying the database server. So some files must be modifed or the application has to be reinstalled. But I dont know if reinstalling will be of any use. All I want is when we start sugarcrm, the data fetched should be from sugarcrm database on a remote host and not local one. I hope my problem is clear now.

Thanks

[paikmoses]

I have checked the connection with other utilities (MySQL Administrator & MySQL Command Line Client) and its working absolutely fine. The required permissins have been set.

It is obvious that we cant connect directly because while installation we dont ahve any option of specifying the database server. So some files must be modifed or the application has to be reinstalled. But I dont know if reinstalling will be of any use. All I want is when we start sugarcrm, the data fetched should be from sugarcrm database on a remote host and not local one. I hope my problem is clear now.

Thanks

Hi Sagar,

I would prefer you to take the database dump/backup of the structure and data seperately(http://sugarcrm.openapp.org/?p=141). Then you can install a new instance of Sugar on the new server and then populate the dump on the database server(http://sugarcrm.openapp.org/?p=142). This would help you in getting the data at the new instance of Sugar.

Hope this helps.

Regards,

[sagarladdha]

Hi Sagar,

I would prefer you to take the database dump/backup of the structure and data seperately(http://sugarcrm.openapp.org/?p=141). Then you can install a new instance of Sugar on the new server and then populate the dump on the database server(http://sugarcrm.openapp.org/?p=142). This would help you in getting the data at the new instance of Sugar.

Hope this helps.

Regards,

I think you have not understood my problem well. All i want is to use sugarcrm database at remote server instead of the local database. The solution that you have given will just take my database on the server. I want to connect to that database i.e., I want my sugarcrm application to access that database. I hope its clear now

Thanks

[rickcrites]

I think you have not understood my problem well. All i want is to use sugarcrm database at remote server instead of the local database. The solution that you have given will just take my database on the server. I want to connect to that database i.e., I want my sugarcrm application to access that database. I hope its clear now

Thanks

The DB configuration information is located in ./config.php (your root Sugar directory). There you can set the name/address of the DB, the connection information, etc.

Hope this helps.

Best,

[sagarladdha]

The DB configuration information is located in ./config.php (your root Sugar directory). There you can set the name/address of the DB, the connection information, etc.

Hope this helps.

Best,

Thanks for your help but I have already tried this thing and it is not working. Is there some other solution.

Thanks

[paikmoses]

I think you have not understood my problem well. All i want is to use sugarcrm database at remote server instead of the local database. The solution that you have given will just take my database on the server. I want to connect to that database i.e., I want my sugarcrm application to access that database. I hope its clear now

Thanks

Hi Sagar,

Thanks for elaborating your query. To connect your application with remote database you need to make changes in the database server. Create a database for Sugar and then give the privileges mentioning the IP address or the hostname of the server where database is installed. Then make changes accordingly in the config.php file.

For more precise steps you can check this out: http://sugarcrm.openapp.org/?p=175

Hope this would help you either.

Regards,

[kpit]

Another consideration, do you have MySQL Bound to a IP address that is accessable from the remote machine? You may have to have a bind-address configured on the network IP address that is accessable from the other machines.

[nikhilb]

Hello,
I have sugarcrm installed on remote machine (not only database but whole sugarcrm). I want that, I should have one copy of it on my localhost and and I would be able to update the changes that make on my localhost to the remote machine. How can I do this if i am using studio to update the sugarcrm. Please reply as sson as possiple