You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/02/20 03:16:47 UTC
[GitHub] [incubator-shardingsphere] ICanFlyFaraway opened a new issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
ICanFlyFaraway opened a new issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377
sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat.And i have been checked my configure for many times.Any advice for me ? I can not put the picture , becasuse my company has security demands.And my English is so bad :)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] ICanFlyFaraway commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
ICanFlyFaraway commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588668973
and there is no any error in the log
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588704220
with master version:
![image](https://user-images.githubusercontent.com/807508/74911956-ab59b800-53f8-11ea-942f-552c70b0909b.png)
```
schemaName: testproxy
dataSources:
test:
url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&useSSL=false
username: root
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] dongzl commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588620086
Hi @ICanFlyFaraway , Is there any exception? can you provide your config, remove your company's sensitive data?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] manbo1987 commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
manbo1987 commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588979708
![image](https://user-images.githubusercontent.com/45955973/74930746-364aaa80-5419-11ea-8cb6-c3bb37a1109c.png)
navicat 11.1.13 is ok, maybe the diff connector ?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] manbo1987 commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
manbo1987 commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588974948
navicat (12.1.21) can not connect the Proxy db
navicat (11.1.13) is ok .
so could ShardingProxy fix this issue in new version , if not Please check this and inform navicat to fix it
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] dongzl commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-589453665
I use mac Navicat Premium 12.0.24, It's OK.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588710952
Navicat for mysql 11.1.13 windows version.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu closed issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] ICanFlyFaraway commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
ICanFlyFaraway commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588666983
i just use the example config like follow
#3697 config-sharding.yaml
schemaName: sharding_db
dataSources:
ds0:
url: jdbc:mysql://localhost:3306/ds0
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
ds1:
url: jdbc:postgresql://localhost:3306/ds1
username: root
password: root
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 65
shardingRule:
tables:
t_order:
actualDataNodes: ds${0..1}.t_order${0..1}
databaseStrategy:
inline:
shardingColumn: user_id
algorithmExpression: ds${user_id % 2}
tableStrategy:
inline:
shardingColumn: order_id
algorithmExpression: t_order${order_id % 2}
keyGenerator:
type: SNOWFLAKE
column: order_id
t_order_item:
actualDataNodes: ds${0..1}.t_order_item${0..1}
databaseStrategy:
inline:
shardingColumn: user_id
algorithmExpression: ds${user_id % 2}
tableStrategy:
inline:
shardingColumn: order_id
algorithmExpression: t_order_item${order_id % 2}
keyGenerator:
type: SNOWFLAKE
column: order_item_id
bindingTables:
- t_order,t_order_item
defaultTableStrategy:
none:
#server.yaml
authentication:
users:
root:
password: root
sharding:
password: sharding
authorizedSchemas: sharding_db
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] ICanFlyFaraway commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
ICanFlyFaraway commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-589561777
@dongzl my navicat (12.1.21) can not show the prxoy schema,but navicat (11.1.13) is ok .
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-590788184
@ICanFlyFaraway @manbo1987
Can you show some logs when it can't work here. thx.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588709692
4.0.0 is also ok as master 5.x.
![image](https://user-images.githubusercontent.com/807508/74912226-35098580-53f9-11ea-88af-2e5ed6f9bfa9.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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-600046429
We will close this issue soon.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] dongzl commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-589932760
Hi @ICanFlyFaraway , you can use navicat (11.1.13).
Because SharingProxy support some mysql protocol packet imperfectly, so cause this problem.
We will support it in the future.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] manbo1987 commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
manbo1987 commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588975395
> Hi @ICanFlyFaraway , Is there any exception? can you provide your config, remove your company's sensitive data?
navicat (12.1.21) can not connect the Proxy db
navicat (11.1.13) is ok .
so could ShardingProxy fix this issue in new version , if not Please check this and inform navicat to fix it
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-592961896
Hello, @ICanFlyFaraway
Could you show the proxy log when navicat can't work?
Or we close this issue later.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4377:
sharding-proxy have been started,
but the schema 'sharding_db' can not be seen in the navicat
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588713668
@ICanFlyFaraway can you show some log/error info in your proxy command line?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services