MySQL DataSource support

Hi,
It's not possible in the current version, but we might do an universal DataSource (Oracle, MySQL) by the end of the year.

any update on this?

Hi,
Yes and no. There been no direct development but we have a database structure that might fit well with MySQL. Again, I can give you a timeframe, but maybe at the beginning of 2011

Thanks for the update I can't wait to test it!

I am too extremely eager to use this feature. Do you have any updates as to how you are progressing?

Hi,
We already have a MySQL data source available, have you tried it?

Thank you I found the add-on, but it doesn't work for me.
If I go to Data sources and select my MySQL DB it appears to work as I can "test Host" "Create Schema" and "Test Schema" all successfully.
However from the app I get the message:
The current datasource is unavailable
Table 'Desktops.connections' doesn't exist

Can you verify if the table was created successfully?

I do not see it on the MySQL Database:
mysql> use Desktops
Database changed
mysql> show tables;
Empty set (0.00 sec)

I should mention that i created the Database and User outside of RDM. I don't want to use my Root User for this DB.
Is that a problem?

I don't know if this is a problem, but it seems that the table connection does not exists, can you retry to execute the script?

I don't know what you mean, but I clicked al your buttons multiple times.

However I logged into my MySQL server CLI. Your gui has a hyperlink for "View Script" From there I copied: CREATE TABLE `Connections` (`ID` varchar(45) NOT NULL,`Data` longtext NOT NULL); and pasted it in the CLI. Now everything works great.

I suspect that the "Create Schema" button on your site doesn't create the table if the Database is already created.

Maybe, I will ask André, mu colleague, he did this part.

André has fixed that, thank you

I tried to use the MySQL Data Source AddOn but i get an error on connecting to the Database;

I created the Database Desktops;
create database Desktops;
give the User the appropriate permission to the DB, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv

| <Host> | Desktops | <Username> | Y | Y | Y | Y | Y | Y

But when i try to test the Schema i still get an error either i also get an error Message on create Schema.

Settings for the AddON
Name: Desktops
Hostname: <Hostname>
Schema: CREATE TABLE `Connections` (`ID` varchar(45) NOT NULL,`Data` longtext NOT NULL);
Username: <User>
Password: <Password>

when i try to run the Schema command in the MySQL cli logged on with the User i created, it works aslo i can drop the created table Connections.

BR
Peter
edited by pvollmann on 10/10/2011

Hi,
Could you send me a print screen of the error?

here are the requested Screens
edited by pvollmann on 10/10/2011

Hi,
In the schema field, you have to enter the database name not the SQL

ok thx that worked now
BR