ODBC connection problem to MySql with Bitnami

[johnprogers]

Hello
Can anyone assist me to setup an ODBC connection between Access and SugarCRM. All the posts I have viewed seem to have something missing.
I have setup and am using Sugar 5.5.1 on a virtual appliance provided by Bitnami. I have opened the mysql port in the ubantu firewall so that a connection can be made.
On my XP pro machine I have installed the MySQL ODBC Driver. When I configure the driver i specify the IP address of the virtual machine.
I then need the username and password for the odbc connection, I believe this is root and bitnami, but the bitnami documentation is not to clear on the username.
The database dropdown does not show the availiable databases and after a while I get an error message saying ' Connection failed: [HY000] [MySQL] [ODBC 5.1 Driver] Cannot connect to MySQL server xxx.xxx.xxx.xxx'

Where can I find out why the connection fails. Has anyone got a similar setup?

Thanks

john

[johnprogers]

OK, I have got a bit further, after playing with the firewall rules and restarting the vm, I now get the message that my 'host xxx.xxx.xxx.xxx is not allowed to connect to this SQL server.
Any further input gratefully accepted.

[logicasrl]

Hi John,

take a look to this thread:
http://www.sugarcrm.com/forums/showthread.php?t=60169

At the end you will find the solution to your problem

In any case you should execute something similar to the following instructions (from a console terminal of your Linux system):
# /opt/sugarcrm-5.2.0k/mysql/bin/mysql --socket=/opt/sugarcrm-5.2.0k/mysql/tmp/mysql.sock –u root –p
mysql> use mysql;
mysql> GRANT ALL ON sugarcrm.* TO 'root'@'%' IDENTIFIED BY '<root password>';
mysql> FLUSH PRIVILEGES;
mysql> quit

Hope this could help you...

Bye
Luca

[johnprogers]

Thanks for your reply. I am sure that if I could find the actual location of the mysql installation on the VM that this would work. I have navigated into every directory I can find and cannot find the location of MySQL. Is there a command that will tell me where it is?

John

[johnprogers]

I think I have found the correct location, indeed I ahve been able to run the commands given by using /opt/bitnami/mysql etc. I have got a working connection in the ODBC driver setup, but in the database drop down I only see two entries. The first is Information_Shema and the second is TEST. The TEST entry contains no tables at all and the Information_Schema contains the database description but no actual data tables.
I was expecting to find a database called 'sugarcrm', but this does not seem to be visible. Is it hidden or have I misunderstood?

John

[logicasrl]

Unfortunately I do not know Bitnami... I think of having no more ideas about how to solve the "disappeared" "sugarcrm" DB problem...
Good luck,
Luca

I think I have found the correct location, indeed I ahve been able to run the commands given by using /opt/bitnami/mysql etc. I have got a working connection in the ODBC driver setup, but in the database drop down I only see two entries. The first is Information_Shema and the second is TEST. The TEST entry contains no tables at all and the Information_Schema contains the database description but no actual data tables.
I was expecting to find a database called 'sugarcrm', but this does not seem to be visible. Is it hidden or have I misunderstood?

John