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/08/16 08:57:44 UTC
[GitHub] [shardingsphere] Bingai077 opened a new issue, #20217: How to set the Time Zone for ShardingSphere-Proxy？
Bingai077 opened a new issue, #20217:
URL: https://github.com/apache/shardingsphere/issues/20217
Which version of ShardingSphere did you use?
ghcr.io/apache/shardingsphere-proxy:c9cc117c8f4b42c220f89c92851bf945c40c71b0 （helm cluster）
Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
Expected behavior
After ShardingSphere-Proxy proxy, the time zone is Asia/Shanghai，same as a direct connection.
Actual behavior
This version of ShardingSphere-Proxy doesn't yet support this SQL.
After ShardingSphere-Proxy proxy, tthe time zone is eight hours apart.
My shard dataSources url configuration parameter is
`jdbc:mysql://192.168.1.1:3306/test_db1?useUnicode=true&serverTimezone=Asia/Shanghai`
--
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] Bingai077 commented on issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #20217:
URL: https://github.com/apache/shardingsphere/issues/20217#issuecomment-1217389887
@RaigorJiang When my client connects to the Proxy, I've set the time zone, too.But it's not in effect.
--
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] RaigorJiang commented on issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #20217:
URL: https://github.com/apache/shardingsphere/issues/20217#issuecomment-1219052570
> @RaigorJiang It has been resolved. The specific reason is that the container is in the wrong time zone.
OK, thanks for your feedback.
--
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] Bingai077 commented on issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
Posted by GitBox <gi...@apache.org>.
Bingai077 commented on issue #20217:
URL: https://github.com/apache/shardingsphere/issues/20217#issuecomment-1218995506
@RaigorJiang It has been resolved. The specific reason is that the container is in the wrong time zone.
--
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] RaigorJiang closed issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
Posted by GitBox <gi...@apache.org>.
RaigorJiang closed issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
URL: https://github.com/apache/shardingsphere/issues/20217
--
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] RaigorJiang commented on issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #20217:
URL: https://github.com/apache/shardingsphere/issues/20217#issuecomment-1216598071
Hi @Bingai077
When your client connects to the Proxy, you also need to set the time zone through the client URL.
--
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] RaigorJiang commented on issue #20217: How to set the Time Zone for ShardingSphere-Proxy？
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #20217:
URL: https://github.com/apache/shardingsphere/issues/20217#issuecomment-1217558441
Hi @TeslaCN , do you have some suggestions?
--
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