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

**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

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