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/10/10 06:41:03 UTC
[GitHub] [shardingsphere] xxbcoder opened a new issue, #17596: Does sharding proxy support SSL? If so, how to configure it?
xxbcoder opened a new issue, #17596:
URL: https://github.com/apache/shardingsphere/issues/17596
Does sharding proxy support SSL? If so, how to configure it?
--
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 #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1128709262
> Mycat does not support ssl either. It has a setting called "dbDriver", which supports "navicat" or "jdbc". Only "dbDriver=jdbc" supports ssl; but selecting "jdbc" will cause a series of other problems. , It seems that the function of jdbc is not fully realized. So if I want to use ShardingSphere-Proxy to connect to mysql with ssl turned on, is there any configuration like dbDriver that needs to be modified, or directly use useSSL=false in jdbcUrl? Now we want to choose ShardingSphere-Proxy as the database middleware, but we are worried about encountering the same problem.
```
Client
|
| SSL not supported
V
ShardingSphere-Proxy
|
| SSL supported by configuring `useSSL=true` and other options in JDBC URL
V
MySQL
```
--
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 #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1191082671
> @TeslaCN What does it take to support SSL for the frontend channel communications? I'm new to the ShardingSphere project. If you can share some file references, I can try taking a stab at it.
Here is something about MySQL SSL handshake protocol.
https://dev.mysql.com/doc/dev/mysql-server/latest/page_protocol_connection_phase.html#sect_protocol_connection_phase_initial_handshake_ssl_handshake
Here is the frontend of ShardingSphere-Proxy.
https://github.com/apache/shardingsphere/blob/8f898cc6501afb985dc157b7d9bbe414bdfae247/shardingsphere-proxy/shardingsphere-proxy-frontend/shardingsphere-proxy-frontend-core/src/main/java/org/apache/shardingsphere/proxy/frontend/ShardingSphereProxy.java#L107-L119
--
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] github-actions[bot] closed issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #17596: Does sharding proxy support SSL? If so, how to configure it?
URL: https://github.com/apache/shardingsphere/issues/17596
--
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 #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1124498688
ShardingSphere-Proxy doesn't support SSL for now. But Proxy connects to MySQL via MySQL JDBC Connector, which means Proxy can use SSL communicate with MySQL Server.
--
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] xxbcoder commented on issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
xxbcoder commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1124469509
If MySQL enables SSL, I use sharding proxy. What should be configured on sharding proxy to connect?
--
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] xxbcoder commented on issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
xxbcoder commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1128613740
> ShardingSphere-Proxy doesn't support SSL for now. But Proxy connects to MySQL via MySQL JDBC Connector, which means Proxy can use SSL communicate with MySQL Server.
Mycat does not support ssl either. It has a setting called "dbDriver", which supports "navicat" or "jdbc". Only "dbDriver=jdbc" supports ssl; but selecting "jdbc" will cause a series of other problems. , It seems that the function of jdbc is not fully realized. So if I want to use ShardingSphere-Proxy to connect to mysql with ssl turned on, is there any configuration like dbDriver that needs to be modified, or directly use useSSL=false in jdbcUrl? Now we want to choose ShardingSphere-Proxy as the database middleware, but we are worried about encountering the same problem.
--
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] xxbcoder commented on issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
xxbcoder commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1128613361
Mycat does not support ssl either. It has a setting called "dbDriver", which supports "navicat" or "jdbc". Only "dbDriver=jdbc" supports ssl; but selecting "jdbc" will cause a series of other problems. , It seems that the function of jdbc is not fully realized. So if I want to use ShardingSphere-Proxy to connect to mysql with ssl turned on, is there any configuration like dbDriver that needs to be modified, or directly use useSSL=false in jdbcUrl? Now we want to choose ShardingSphere-Proxy as the database middleware, but we are worried about encountering the same problem.
--
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] vikiuvb commented on issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
vikiuvb commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1191035738
@TeslaCN What does it take to support SSL for the frontend channel communications? I'm new to the ShardingSphere project. If you can share some file references, I can try taking a stab at it.
--
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] github-actions[bot] commented on issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1272349804
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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] xxbcoder commented on issue #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by GitBox <gi...@apache.org>.
xxbcoder commented on issue #17596:
URL: https://github.com/apache/shardingsphere/issues/17596#issuecomment-1132432320
tks
--
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 #17596: Does sharding proxy support SSL? If so, how to configure it?
Posted by "tristaZero (via GitHub)" <gi...@apache.org>.
tristaZero closed issue #17596: Does sharding proxy support SSL? If so, how to configure it?
URL: https://github.com/apache/shardingsphere/issues/17596
--
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