You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/02/14 16:36:43 UTC
[GitHub] [superset] alan345 opened a new issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
alan345 opened a new issue #18719:
URL: https://github.com/apache/superset/issues/18719
cannot connect to Mysql Database when DATABASE NAME contains @
When you create a new database:
databaseview => + Database
### Expected results
Connect successfully to the databse
### Actual results
I got his error `Unknown MySQL server host "prod".` on the field HOST
If i remove the `@` just to check the behavior, the error is now legit on the DATABASE NAME as this database name doesn't exist.
The database is called `nacho@prod`
#### Screenshots
<img width="501" alt="image" src="https://user-images.githubusercontent.com/15246526/153905773-b0651860-423b-4190-8352-eac525367016.png">
<img width="501" alt="image" src="https://user-images.githubusercontent.com/15246526/153905829-c6c3f6cd-2bba-4fde-b057-50a2092385cc.png">
### Environment
(please complete the following information):
- browser type and version: Chrome
- superset version: 0.5.8
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [X ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ X] I have reproduced the issue with at least the latest released version of superset.
- [ X] I have checked the issue tracker for the same issue and I haven't found one similar.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] minho95 commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
minho95 commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039797989
Can I ask what is the version of the MySQL server? I am trying to reproduce it, but during the creation of the database with a name containing '@' I get the error:
`ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@name' at line 1`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] minho95 commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
minho95 commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039797989
Can I ask what is the version of the MySQL server? I am trying to reproduce it, but during the creation of the database with a name containing '@' I get the error:
`ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@name' at line 1`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] alan345 commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
alan345 commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039474733
FYI, Replacing `@` by `%40` is not working
<img width="498" alt="image" src="https://user-images.githubusercontent.com/15246526/153933499-69a7538b-b25f-4f0d-b7fb-c8f284cd47be.png">
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] minho95 edited a comment on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
minho95 edited a comment on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039797989
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] villebro commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1041201312
While in general I would not encourage using these types of characters in a database name, I believe this should be fairly easy to fix by making sure we urlencode the database name when constructing the SQLAlchemy URI.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] minho95 edited a comment on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
minho95 edited a comment on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039797989
Are you sure that you are entering the correct name? **nacho** should be username and **prod** name of the host.
When I try to reproduce during the creation with a name containing '@' I get the error:
`ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@name' at line 1`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] alan345 commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
alan345 commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039474733
FYI, Replacing `@` by `%40` is not working
<img width="498" alt="image" src="https://user-images.githubusercontent.com/15246526/153933499-69a7538b-b25f-4f0d-b7fb-c8f284cd47be.png">
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhaoyongjie commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1040107015
Hi @alan345 @minho95, I have validated on the master branch and MySQL 5.7.
1. login MySQL
2. create database from MySQL cli
```
mysql> create database `foo@bar`;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| foo@bar |
| infodumps |
| mysql |
| performance_schema |
| sample_data |
| sampling |
| sys |
+--------------------+
8 rows in set (0.00 sec)
mysql>
```
3. can't sent testing query for `foo@bar`
<img width="558" alt="image" src="https://user-images.githubusercontent.com/2016594/154043396-dca0e7a1-90d5-4b8a-bc59-09f3aac2a0f8.png">
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] zhaoyongjie commented on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
zhaoyongjie commented on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1040107015
Hi @alan345 @minho95, I have validated on the master branch and MySQL 5.7.
1. login MySQL
2. create database from MySQL cli
```
mysql> create database `foo@bar`;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| foo@bar |
| infodumps |
| mysql |
| performance_schema |
| sample_data |
| sampling |
| sys |
+--------------------+
8 rows in set (0.00 sec)
mysql>
```
3. can't sent testing query for `foo@bar`
<img width="558" alt="image" src="https://user-images.githubusercontent.com/2016594/154043396-dca0e7a1-90d5-4b8a-bc59-09f3aac2a0f8.png">
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] minho95 edited a comment on issue #18719: cannot connect to Mysql Database when DATABASE NAME contains @
Posted by GitBox <gi...@apache.org>.
minho95 edited a comment on issue #18719:
URL: https://github.com/apache/superset/issues/18719#issuecomment-1039797989
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org