wsm12138 removed a comment on issue #13425:
URL: 
https://github.com/apache/shardingsphere/issues/13425#issuecomment-1000978462


   Hi~ @RaigorJiang  
   ###  Which version of ShardingSphere did you use? & Which project did you 
use?
   I used 5.0.1 snapshot ShardingSphere-Proxy reproduce the problem(commit 
id:ec75ec41dfc70db6696b02282471ef0934a6f98c)
   ### Actual behavior 
   When I  use DistSQL to add RESOURCE for DATABASE,the following error 
occurred.
   
![image](https://user-images.githubusercontent.com/86462784/147378121-2742b932-12e5-45b2-9a71-662c977d354a.png)
   ### Try to solve the problem 
   I'm sure i have  `jdbc driver` because i can use `config-sharding.yaml` to 
startup Proxy successfuly
   But i also can't find answer from 
[FAQ](https://github.com/apache/shardingsphere/blob/master/docs/document/content/reference/faq/_index.cn.md)
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   ```yaml
   [root@localhost conf]# cat server.yaml | grep -v "#"
   rules:
     - !AUTHORITY
       users:
         - root@%:root
         - sharding@:sharding
       provider:
         type: ALL_PRIVILEGES_PERMITTED
   
   props:
   ```
   Proxy
   ```shell
   mysql -uroot -proot -h127.0.0.1 -P3307
   mysql> create  database sbtest_sharding;
   Query OK, 0 rows affected (0.99 sec)
   mysql> use sbtest_sharding;
   Database changed
   mysql> ADD RESOURCE ds_0 (
       ->     HOST=127.0.0.1,
       ->     PORT=3306,
       ->     DB=sbtest_sharding,
       ->     USER=root,
       ->     PASSWORD=passwd
       -> ), ds_1 (
       ->     HOST=127.0.0.2,
       ->     PORT=3306,
       ->     DB=sbtest_sharding,
       ->     USER=root,
       ->     PASSWORD=passwd
       -> );
   ERROR 1104 (C1104): Can not process invalid resources, error messages are: 
[Invalid data source configuration name `ds_0`, error message is: Failed to 
initialize pool: Communications link failure, Invalid data source configuration 
name `ds_1`, error message is: Failed to initialize pool: Communications link 
failure].
   mysql> ^DBye
   ```
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to