Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[DOCS] Failed to connect by service_name #401

Closed
andyli029 opened this issue Mar 9, 2022 · 1 comment · Fixed by #402
Closed

[DOCS] Failed to connect by service_name #401

andyli029 opened this issue Mar 9, 2022 · 1 comment · Fixed by #402
Assignees
Labels
bug Something isn't working documentation Improvements or additions to documentation
Milestone

Comments

@andyli029
Copy link
Contributor

andyli029 commented Mar 9, 2022

Describe the problem
From deploy_radondb-mysql_operator_on_k8s.md
Failed to connect by service_name

To Reproduce

root@worker-p001:~# kubectl get svc
NAME                     TYPE        CLUSTER-IP     EXTERNAL-IP   PORT(S)             AGE
kubernetes               ClusterIP   10.96.0.1      <none>        443/TCP             467d
mysql                    ClusterIP   None           <none>        3306/TCP,9125/TCP   355d
mysql-operator-metrics   ClusterIP   10.96.97.145   <none>        8443/TCP            31m
sample-follower          ClusterIP   10.96.197.2    <none>        3306/TCP,8082/TCP   31m
sample-leader            ClusterIP   10.96.70.172   <none>        3306/TCP,8082/TCP   31m
sample-mysql             ClusterIP   None           <none>        3306/TCP,8082/TCP   31m

root@worker-p001:~# mysql -h sample-leader.default -P 3306 -uradondb_usr -pxxxxx
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2005 (HY000): Unknown MySQL server host 'sample-leader.default' (2)

root@worker-p001:~# mysql -h 10.96.70.172 -P 3306 -uradondb_usr -pxxxxx
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 138
Server version: 5.7.34-37-log Percona Server (GPL), Release 37, Revision 7c516e9

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> quit;

Expected behavior

Environment:

  • RadonDB MySQL version:
    v2.1.2
@andyli029 andyli029 added the bug Something isn't working label Mar 9, 2022
@runkecheng
Copy link
Collaborator

Unable to resolve the service name on the host, user should use the service name in the container to access the database.

@runkecheng runkecheng added this to the v2.1.3 milestone Mar 9, 2022
@andyli029 andyli029 added the documentation Improvements or additions to documentation label Mar 9, 2022
andyli029 added a commit that referenced this issue Mar 10, 2022
docs:Add a description of `service_name` connection method #401
zhl003 pushed a commit to zhl003/radondb-mysql-kubernetes that referenced this issue Aug 17, 2022
docs:Add a description of `service_name` connection method radondb#401
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working documentation Improvements or additions to documentation
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants