Unable to create Tables with MySQL

[amancevice]

Unable to create Tables with MySQL

[amancevice]

This is probably an issue you should open with Superset. Can you give me any more information about your configuration?

[ofostier]

Yes i can give you any information you need but i'm not a expert from this tool.
What do you need exactly and how can i find them.

My SUPERSET docker container run on docker4mac

Docker version 17.03.1-ce, build c6d412e

and then ...

When I try to create a table (with or without specified the schema i get this return

Table [MYTABLE] could not be found, please double check your database connection, schema, and table name. (working like a charm with the "main" source)

SUPERSET version info :

{"version": "0.17.4", "GIT_SHA": ""}

[amancevice]

Are you sure the user you are using to connect to this DB has the correct permissions to view this table?

[ofostier]

Yes this user have the read/write permissions to all tables in the schema

[amancevice]

And you're sure you're attempting to create the table with the right database selected? There should be a dropdown in the create table dialog.

[ofostier]

Yes the database i was previously created appear in the dropdown in the create table dialog.

[amancevice]

Hm. I must admit I'm stumped. I am able to add a DB and table using the demo example:

cd ./examples
./demo.sh mysql
# ... follow prompts
# ... navigate to localhost:8088
# ... Add DB
# ... Add table

[ofostier]

I restart install directly from cloning this project from github
and then do the demo.sh mysql
Everything is working from this example.

Then i create a new DB connection to a a MySQL in my network. (I can connect to from mysql workbench and make some queries, SELECT and UPDATE etc)
But take the same error when i try to create a table.

When i use the "SQL Lab" and select my DB, system can not retrieve the list of schemas.
So i try this in mysql workbench :
SELECT SCHEMA_NAME AS Database FROM INFORMATION_SCHEMA.SCHEMATA;
and then i retrieve all my schemas.
Mysql version :
5.5.28-log on a dedicated server

is there a special configuration to use mysql from Superset ?

[amancevice]

5.5 is a pretty old version of MySQL -- that may be your problem. I'm going to close this issue because I don't think it's a problem with the Docker image. I suggest you file an issue with Superset.