Forum / Remote Desktop Manager - Feature Request

MySQL DataSource support

  • Create an Issue
  • Cancel

Is it possible to add MySQL DataSource support?

Clock9 yrs

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

David Hervieux

signaturesignature

Clock9 yrs

any update on this?

Clock9 yrs

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

David Hervieux

signaturesignature

Clock9 yrs

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

Clock9 yrs

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

Clock8 yrs

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

David Hervieux

signaturesignature

Clock8 yrs

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

Clock8 yrs

Can you verify if the table was created successfully?

David Hervieux

signaturesignature

Clock8 yrs

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?

Clock8 yrs

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?

David Hervieux

signaturesignature

Clock8 yrs

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.

Clock8 yrs

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

David Hervieux

signaturesignature

Clock8 yrs

André has fixed that, thank you

David Hervieux

signaturesignature

Clock8 yrs

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
<em>edited by pvollmann on 10/10/2011</em>

Clock8 yrs

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

David Hervieux

signaturesignature

Clock8 yrs

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

MySQL_DataSource_createSchema.PNG
MySQL_DataSource_testSch.PNG
Clock8 yrs

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

David Hervieux

signaturesignature

Clock8 yrs

ok thx that worked now
BR

Clock8 yrs