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/07/20 08:28:55 UTC
[GitHub] [shardingsphere] sandynz opened a new issue, #17409: gsql could not login to Proxy with default postgres database
sandynz opened a new issue, #17409:
URL: https://github.com/apache/shardingsphere/issues/17409
## Bug Report
### Which version of ShardingSphere did you use?
master branch, commit d7a8079e5141474e47e4aaa42221feda32047964
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
Proxy
### Expected behavior
gsql could login to Proxy with postgres.
### Actual behavior
Client log:
```
omm@b74ff82d07b4:~$ gsql --host=host.docker.internal --port=3307 postgres root
Password for user root:
Failed to get the server's version. resStatus=7
ERROR: ERROR: org.apache.shardingsphere.proxy.backend.exception.RuleNotExistedException
```
No log in Proxy.
### Reason analyze (If you can)
`postgres` exists in registry center `/metadata/postgres/`, though content is empty.
The error occur when executing `SELECT VERSION()`.
<img width="1377" alt="图片" src="https://user-images.githubusercontent.com/42492540/167236466-614d25dd-7d87-4f09-bad1-59c58bc53831.png">
Similar situation works on PostgreSQL backend.
```
% psql --host=localhost --port=3307 postgres root
Password for user root:
psql (13.4, server 12.3-ShardingSphere-Proxy 5.1.2-SNAPSHOT-371f15e)
Type "help" for help.
```
Seems after authentication, there's no more query SQL with psql.
No sure what's wrong with gsql.
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
1, Install MogDB v2.1, refer to https://docs.mogdb.io/zh/mogdb/v2.1/docker-installation . Or try openGauss
2, Update `server.yaml`:
Add
```
proxy-frontend-database-protocol-type: openGauss
```
in `props`.
3, Start Proxy.
4, Login with gsql
```
docker exec -it mogdb bash
su - omm
gsql --host=host.docker.internal --port=3307 postgres root
```
### Example codes for reproduce this issue (such as a github link).
--
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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] TeslaCN commented on issue #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17409:
URL: https://github.com/apache/shardingsphere/issues/17409#issuecomment-1120138853
`gsql` would query `pg_settings` when establishing connection.
--
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] terrymanu closed issue #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #17409: gsql could not login to Proxy with default postgres database
URL: https://github.com/apache/shardingsphere/issues/17409
--
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] sandynz commented on issue #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #17409:
URL: https://github.com/apache/shardingsphere/issues/17409#issuecomment-1120134997
Hi @TeslaCN , could you help to have a look at this issue?
--
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] jingshanglu commented on issue #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
jingshanglu commented on issue #17409:
URL: https://github.com/apache/shardingsphere/issues/17409#issuecomment-1189974525
@TeslaCN this sql will be execute too, and have error
```
SELECT intervaltonum(gs_password_deadline())
```
--
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 #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17409:
URL: https://github.com/apache/shardingsphere/issues/17409#issuecomment-1190012175
The following SQL is sent by gsql 2.1.0:
```sql
SELECT gs_password_notifytime()
```
--
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 #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17409:
URL: https://github.com/apache/shardingsphere/issues/17409#issuecomment-1187029020
Temporary solution is adding a logic database to ShardingSphere-Proxy.
--
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] tristaZero closed issue #17409: gsql could not login to Proxy with default postgres database
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #17409: gsql could not login to Proxy with default postgres database
URL: https://github.com/apache/shardingsphere/issues/17409
--
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