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 2022/02/08 07:29:59 UTC

[GitHub] [shardingsphere] guoyzh opened a new issue #15289: start sharding-proxy error

guoyzh opened a new issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289


   ![image](https://user-images.githubusercontent.com/19571804/152938339-5eeccc16-fe31-42b1-af13-82db289c2e46.png)
   **server.yaml**
   `rules:
      users:
        - root@%:root`
   
   **config-sharding.yaml**
   `schemaName: hqzc_db
   
   dataSources:
     ds_0:
       url: jdbc:mysql://127.0.0.1:3306/jjcsq?serverTimezone=UTC&useSSL=false
       username: root
       password: root
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
   
   rules:
     tables:
       rpt_new:
         actualDataNodes: ds_0.rpt_new_${0..50}
         tableStrategy:
           standard:
             shardingColumn: rpt_id
             shardingAlgorithmName: t_rpt_inline
         keyGenerateStrategy:
           column: rpt_id
           keyGeneratorName: snowflake
     defaultDatabaseStrategy:
       none:
     defaultTableStrategy:
       none:
     
     shardingAlgorithms:
       t_rpt_inline:
         type: INLINE
         props:
           algorithm-expression: rpt_new_${rpt_id % 50}
     
     keyGenerators:
       snowflake:
         type: SNOWFLAKE
         props:
           worker-id: 123`
   


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] guoyzh closed issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
guoyzh closed issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289


   


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] TeslaCN commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033290272


   Your `server.yaml` is also malformed. Try the following
   ```yaml
   rules:
     - !AUTHORITY
       users:
         - root@%:root
         - postgres@%:postgres
       provider:
         type: ALL_PRIVILEGES_PERMITTED
   ```


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] guoyzh commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
guoyzh commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033298495


   ![image](https://user-images.githubusercontent.com/19571804/153114572-e9440017-05be-4fd4-bc50-9d9c357922a4.png)
   after change yml 


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] guoyzh commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
guoyzh commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033305935


   ```
   mode:
     type: Memory
     overwrite: false
   ```


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] menghaoranss commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1032359566


   which version did you use?


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] TeslaCN edited a comment on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
TeslaCN edited a comment on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033290272


   Your `server.yaml` is also malformed. Try the following
   ```yaml
   rules:
     - !AUTHORITY
       users:
         - root@%:root
       provider:
         type: ALL_PRIVILEGES_PERMITTED
   ```


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] TeslaCN edited a comment on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
TeslaCN edited a comment on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033266521


   @guoyzh Your `config-sharding.yaml` is malformed.
   
   ```yaml
   rules:
   - !SHARDING
     tables:
   ```


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] guoyzh commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
guoyzh commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1032365323


   > which version did you use?
   
   5.0.0


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] guoyzh commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
guoyzh commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033437328


   The final problem is: GZ the Lib folder jar package does not have a suffix after decompression on the windows platform


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] TeslaCN commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033266521


   @guoyzh Your `config-sharding.yaml` is malformed.
   
   ```
   rules:
   - !SHARDING
     tables:
   ```


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] guoyzh commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
guoyzh commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033287448


   After modification, it is still the same error. Can you provide a complete configuration file first


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



[GitHub] [shardingsphere] CrackerSuperior commented on issue #15289: start sharding-proxy error

Posted by GitBox <gi...@apache.org>.
CrackerSuperior commented on issue #15289:
URL: https://github.com/apache/shardingsphere/issues/15289#issuecomment-1033305312


   What is your ```mode``` configuration?


-- 
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@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org