{"action":"created","issue":{"url":"https://api.github.com/repos/rancher/rancher/issues/6576","repository_url":"https://api.github.com/repos/rancher/rancher","labels_url":"https://api.github.com/repos/rancher/rancher/issues/6576/labels{/name}","comments_url":"https://api.github.com/repos/rancher/rancher/issues/6576/comments","events_url":"https://api.github.com/repos/rancher/rancher/issues/6576/events","html_url":"https://github.com/rancher/rancher/issues/6576","id":188542106,"number":6576,"title":"Failed to get connect to database when connecting to Azure MySQL due to MariaDB connector bug","user":{"login":"kvaes","id":10435278,"avatar_url":"https://avatars3.githubusercontent.com/u/10435278?v=3","gravatar_id":"","url":"https://api.github.com/users/kvaes","html_url":"https://github.com/kvaes","followers_url":"https://api.github.com/users/kvaes/followers","following_url":"https://api.github.com/users/kvaes/following{/other_user}","gists_url":"https://api.github.com/users/kvaes/gists{/gist_id}","starred_url":"https://api.github.com/users/kvaes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kvaes/subscriptions","organizations_url":"https://api.github.com/users/kvaes/orgs","repos_url":"https://api.github.com/users/kvaes/repos","events_url":"https://api.github.com/users/kvaes/events{/privacy}","received_events_url":"https://api.github.com/users/kvaes/received_events","type":"User","site_admin":false},"labels":[{"id":203022029,"url":"https://api.github.com/repos/rancher/rancher/labels/area/packaging","name":"area/packaging","color":"FBCA04","default":false},{"id":145695744,"url":"https://api.github.com/repos/rancher/rancher/labels/kind/bug","name":"kind/bug","color":"fc2929","default":false}],"state":"open","locked":false,"assignee":{"login":"ibuildthecloud","id":1754002,"avatar_url":"https://avatars0.githubusercontent.com/u/1754002?v=3","gravatar_id":"","url":"https://api.github.com/users/ibuildthecloud","html_url":"https://github.com/ibuildthecloud","followers_url":"https://api.github.com/users/ibuildthecloud/followers","following_url":"https://api.github.com/users/ibuildthecloud/following{/other_user}","gists_url":"https://api.github.com/users/ibuildthecloud/gists{/gist_id}","starred_url":"https://api.github.com/users/ibuildthecloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ibuildthecloud/subscriptions","organizations_url":"https://api.github.com/users/ibuildthecloud/orgs","repos_url":"https://api.github.com/users/ibuildthecloud/repos","events_url":"https://api.github.com/users/ibuildthecloud/events{/privacy}","received_events_url":"https://api.github.com/users/ibuildthecloud/received_events","type":"User","site_admin":false},"assignees":[{"login":"ibuildthecloud","id":1754002,"avatar_url":"https://avatars0.githubusercontent.com/u/1754002?v=3","gravatar_id":"","url":"https://api.github.com/users/ibuildthecloud","html_url":"https://github.com/ibuildthecloud","followers_url":"https://api.github.com/users/ibuildthecloud/followers","following_url":"https://api.github.com/users/ibuildthecloud/following{/other_user}","gists_url":"https://api.github.com/users/ibuildthecloud/gists{/gist_id}","starred_url":"https://api.github.com/users/ibuildthecloud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ibuildthecloud/subscriptions","organizations_url":"https://api.github.com/users/ibuildthecloud/orgs","repos_url":"https://api.github.com/users/ibuildthecloud/repos","events_url":"https://api.github.com/users/ibuildthecloud/events{/privacy}","received_events_url":"https://api.github.com/users/ibuildthecloud/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/rancher/rancher/milestones/71","html_url":"https://github.com/rancher/rancher/milestone/71","labels_url":"https://api.github.com/repos/rancher/rancher/milestones/71/labels","id":1853807,"number":71,"title":"Unscheduled","description":"This milestone includes bugs we have looked into but have not scheduled into an upcoming release.","creator":{"login":"deniseschannon","id":11410997,"avatar_url":"https://avatars2.githubusercontent.com/u/11410997?v=3","gravatar_id":"","url":"https://api.github.com/users/deniseschannon","html_url":"https://github.com/deniseschannon","followers_url":"https://api.github.com/users/deniseschannon/followers","following_url":"https://api.github.com/users/deniseschannon/following{/other_user}","gists_url":"https://api.github.com/users/deniseschannon/gists{/gist_id}","starred_url":"https://api.github.com/users/deniseschannon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/deniseschannon/subscriptions","organizations_url":"https://api.github.com/users/deniseschannon/orgs","repos_url":"https://api.github.com/users/deniseschannon/repos","events_url":"https://api.github.com/users/deniseschannon/events{/privacy}","received_events_url":"https://api.github.com/users/deniseschannon/received_events","type":"User","site_admin":false},"open_issues":593,"closed_issues":693,"state":"open","created_at":"2016-06-28T21:41:11Z","updated_at":"2017-06-07T08:26:28Z","due_on":null,"closed_at":null},"comments":15,"created_at":"2016-11-10T15:43:43Z","updated_at":"2017-06-08T08:54:41Z","closed_at":null,"body":"**Rancher Version:** v1.1.4\r\n\r\n**Cattle Version:** 0.165.8.4\r\n\r\n**Docker Version:** 1.12.3, build 6b644ec\r\n\r\n**OS and where are the hosts located? (cloud, bare metal, etc):** Ubunt 16.04 TLS on Azure\r\n\r\n**Setup Details: (single node rancher vs. HA rancher, internal DB vs. external DB)** External MySQL Database (hosted on Azure)\r\n\r\n**Environment Type: (Cattle/Kubernetes/Swarm/Mesos)** not relevant\r\n\r\n**Steps to Reproduce:**\r\n\r\nCATTLE_DB_CATTLE_DATABASE=mysql\r\nCATTLE_DB_CATTLE_MYSQL_HOST=ranchermysql.mydomain.tld\r\nCATTLE_DB_CATTLE_MYSQL_NAME=cattle\r\nCATTLE_DB_CATTLE_MYSQL_PORT=3306\r\nCATTLE_DB_CATTLE_USERNAME=kvaes@ranchermysql\r\n\r\n**Results:** \r\n\r\n15:34:52.047 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n15:34:53.057 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n15:34:54.067 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n15:34:55.081 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n15:34:56.092 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n15:34:57.105 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n15:34:58.117 [main] ERROR i.c.p.a.sources.LazyJDBCSource - Failed to get connection to database, will retry for 5 minutes\r\n\r\n**Expected:**\r\n\r\nConnects...\r\n\r\n\r\n**Debugging:**\r\nConnection works with the same information from my laptop, directly from the docker host & from the rancher container.\r\n\r\nFrom the host ; \r\nkvaes@ranchermgmt01:~$ sudo mysql -h ranchermysql.mydomain.tld -P 3306 -u kvaes@ranchermysql -p\r\nEnter password:\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 65533\r\nServer version: 5.6.26.0 MySQL Community Server (GPL)\r\n\r\nCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| cattle             |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n4 rows in set (0.08 sec)\r\n\r\nmysql>\r\n\r\n\r\nFrom the rancher container ;\r\n\r\nkvaes@ranchermgmt01:~$ sudo docker ps -a\r\nCONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                              NAMES\r\nd333f361b122        rancher/server      \"/usr/bin/s6-svscan /\"   6 minutes ago       Up 35 seconds       3306/tcp, 0.0.0.0:8080->8080/tcp   cranky_austin\r\nkvaes@ranchermgmt01:~$ sudo docker exec -it d333f361b122 /bin/bash\r\nroot@d333f361b122:/# mysql -h ranchermysql.mydomain.tld -P 3306 -u kvaes@ranchermysql -p\r\nEnter password:\r\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 65533\r\nServer version: 5.6.26.0 MySQL Community Server (GPL)\r\n\r\nCopyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql> show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| cattle             |\r\n| mysql              |\r\n| performance_schema |\r\n+--------------------+\r\n4 rows in set (0.05 sec)\r\n\r\nmysql>"},"comment":{"url":"https://api.github.com/repos/rancher/rancher/issues/comments/307042072","html_url":"https://github.com/rancher/rancher/issues/6576#issuecomment-307042072","issue_url":"https://api.github.com/repos/rancher/rancher/issues/6576","id":307042072,"user":{"login":"fkollmann","id":106287,"avatar_url":"https://avatars1.githubusercontent.com/u/106287?v=3","gravatar_id":"","url":"https://api.github.com/users/fkollmann","html_url":"https://github.com/fkollmann","followers_url":"https://api.github.com/users/fkollmann/followers","following_url":"https://api.github.com/users/fkollmann/following{/other_user}","gists_url":"https://api.github.com/users/fkollmann/gists{/gist_id}","starred_url":"https://api.github.com/users/fkollmann/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fkollmann/subscriptions","organizations_url":"https://api.github.com/users/fkollmann/orgs","repos_url":"https://api.github.com/users/fkollmann/repos","events_url":"https://api.github.com/users/fkollmann/events{/privacy}","received_events_url":"https://api.github.com/users/fkollmann/received_events","type":"User","site_admin":false},"created_at":"2017-06-08T08:54:41Z","updated_at":"2017-06-08T08:54:41Z","body":"Issue still exists with 1.6.2-rc1:\r\n\r\n`level=fatal msg=\"this user requires mysql native password authentication.\"`\r\n"}}
{"actor":{"display_login":"fkollmann"}}