{"action":"closed","number":11838,"pull_request":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/11838","id":55545026,"html_url":"https://github.com/phpmyadmin/phpmyadmin/pull/11838","diff_url":"https://github.com/phpmyadmin/phpmyadmin/pull/11838.diff","patch_url":"https://github.com/phpmyadmin/phpmyadmin/pull/11838.patch","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11838","number":11838,"state":"closed","locked":false,"title":"SSL validation flag","user":{"login":"machavity","id":1122563,"avatar_url":"https://avatars.githubusercontent.com/u/1122563?v=3","gravatar_id":"","url":"https://api.github.com/users/machavity","html_url":"https://github.com/machavity","followers_url":"https://api.github.com/users/machavity/followers","following_url":"https://api.github.com/users/machavity/following{/other_user}","gists_url":"https://api.github.com/users/machavity/gists{/gist_id}","starred_url":"https://api.github.com/users/machavity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/machavity/subscriptions","organizations_url":"https://api.github.com/users/machavity/orgs","repos_url":"https://api.github.com/users/machavity/repos","events_url":"https://api.github.com/users/machavity/events{/privacy}","received_events_url":"https://api.github.com/users/machavity/received_events","type":"User","site_admin":false},"body":"I installed the latest PMA and had to make it work with a remote server running 5.7. The connection had to be encrypted and it conveniently came with its own self-signed certificates so I used them in my PMA setup and I couldn't get it to work. It always returned a 2002 error. I could connect over CLI and Workbench so I dug into it. After some searching I ran across [this PHP bug](https://bugs.php.net/bug.php?id=68344) which described the problem as being due to the following combination\r\n\r\n- MySQL 5.6 or later\r\n- PHP using mysqlnd\r\n- A self-signed certificate (with the name not matching the server name)\r\n\r\nPHP 5.6.16 introduced a fix as a result of that bug report. They added an additional flag (still not documented yet) that disables the mysqlnd validation. By replacing **MYSQLI_CLIENT_SSL** with **MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT** in my local PMA install I got PMA to finally work over SSL.\r\n\r\nThis patch adds a new configuration `$cfg['Servers'][$i]['ssl_verify']` which, when set to `false`, will tell PMA to use this new flag (if present).\r\n\r\nSigned-off-by: Joel Hutchinson joel.hutchinson@onlinecommercegroup.com","created_at":"2016-01-09T16:01:16Z","updated_at":"2016-01-15T21:43:00Z","closed_at":"2016-01-15T21:42:59Z","merged_at":null,"merge_commit_sha":"1f648316da82fd6fa65229f716d466adf00e6550","assignee":{"login":"ibennetch","id":1443710,"avatar_url":"https://avatars.githubusercontent.com/u/1443710?v=3","gravatar_id":"","url":"https://api.github.com/users/ibennetch","html_url":"https://github.com/ibennetch","followers_url":"https://api.github.com/users/ibennetch/followers","following_url":"https://api.github.com/users/ibennetch/following{/other_user}","gists_url":"https://api.github.com/users/ibennetch/gists{/gist_id}","starred_url":"https://api.github.com/users/ibennetch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ibennetch/subscriptions","organizations_url":"https://api.github.com/users/ibennetch/orgs","repos_url":"https://api.github.com/users/ibennetch/repos","events_url":"https://api.github.com/users/ibennetch/events{/privacy}","received_events_url":"https://api.github.com/users/ibennetch/received_events","type":"User","site_admin":false},"milestone":null,"commits_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/11838/commits","review_comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/11838/comments","review_comment_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/comments{/number}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11838/comments","statuses_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/statuses/d85e24caa31ea1ba465494f30b408adf6290a1c3","head":{"label":"machavity:ssl-verify-patch","ref":"ssl-verify-patch","sha":"d85e24caa31ea1ba465494f30b408adf6290a1c3","user":{"login":"machavity","id":1122563,"avatar_url":"https://avatars.githubusercontent.com/u/1122563?v=3","gravatar_id":"","url":"https://api.github.com/users/machavity","html_url":"https://github.com/machavity","followers_url":"https://api.github.com/users/machavity/followers","following_url":"https://api.github.com/users/machavity/following{/other_user}","gists_url":"https://api.github.com/users/machavity/gists{/gist_id}","starred_url":"https://api.github.com/users/machavity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/machavity/subscriptions","organizations_url":"https://api.github.com/users/machavity/orgs","repos_url":"https://api.github.com/users/machavity/repos","events_url":"https://api.github.com/users/machavity/events{/privacy}","received_events_url":"https://api.github.com/users/machavity/received_events","type":"User","site_admin":false},"repo":{"id":49298381,"name":"phpmyadmin","full_name":"machavity/phpmyadmin","owner":{"login":"machavity","id":1122563,"avatar_url":"https://avatars.githubusercontent.com/u/1122563?v=3","gravatar_id":"","url":"https://api.github.com/users/machavity","html_url":"https://github.com/machavity","followers_url":"https://api.github.com/users/machavity/followers","following_url":"https://api.github.com/users/machavity/following{/other_user}","gists_url":"https://api.github.com/users/machavity/gists{/gist_id}","starred_url":"https://api.github.com/users/machavity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/machavity/subscriptions","organizations_url":"https://api.github.com/users/machavity/orgs","repos_url":"https://api.github.com/users/machavity/repos","events_url":"https://api.github.com/users/machavity/events{/privacy}","received_events_url":"https://api.github.com/users/machavity/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/machavity/phpmyadmin","description":"phpMyAdmin itself","fork":true,"url":"https://api.github.com/repos/machavity/phpmyadmin","forks_url":"https://api.github.com/repos/machavity/phpmyadmin/forks","keys_url":"https://api.github.com/repos/machavity/phpmyadmin/keys{/key_id}","collaborators_url":"https://api.github.com/repos/machavity/phpmyadmin/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/machavity/phpmyadmin/teams","hooks_url":"https://api.github.com/repos/machavity/phpmyadmin/hooks","issue_events_url":"https://api.github.com/repos/machavity/phpmyadmin/issues/events{/number}","events_url":"https://api.github.com/repos/machavity/phpmyadmin/events","assignees_url":"https://api.github.com/repos/machavity/phpmyadmin/assignees{/user}","branches_url":"https://api.github.com/repos/machavity/phpmyadmin/branches{/branch}","tags_url":"https://api.github.com/repos/machavity/phpmyadmin/tags","blobs_url":"https://api.github.com/repos/machavity/phpmyadmin/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/machavity/phpmyadmin/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/machavity/phpmyadmin/git/refs{/sha}","trees_url":"https://api.github.com/repos/machavity/phpmyadmin/git/trees{/sha}","statuses_url":"https://api.github.com/repos/machavity/phpmyadmin/statuses/{sha}","languages_url":"https://api.github.com/repos/machavity/phpmyadmin/languages","stargazers_url":"https://api.github.com/repos/machavity/phpmyadmin/stargazers","contributors_url":"https://api.github.com/repos/machavity/phpmyadmin/contributors","subscribers_url":"https://api.github.com/repos/machavity/phpmyadmin/subscribers","subscription_url":"https://api.github.com/repos/machavity/phpmyadmin/subscription","commits_url":"https://api.github.com/repos/machavity/phpmyadmin/commits{/sha}","git_commits_url":"https://api.github.com/repos/machavity/phpmyadmin/git/commits{/sha}","comments_url":"https://api.github.com/repos/machavity/phpmyadmin/comments{/number}","issue_comment_url":"https://api.github.com/repos/machavity/phpmyadmin/issues/comments{/number}","contents_url":"https://api.github.com/repos/machavity/phpmyadmin/contents/{+path}","compare_url":"https://api.github.com/repos/machavity/phpmyadmin/compare/{base}...{head}","merges_url":"https://api.github.com/repos/machavity/phpmyadmin/merges","archive_url":"https://api.github.com/repos/machavity/phpmyadmin/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/machavity/phpmyadmin/downloads","issues_url":"https://api.github.com/repos/machavity/phpmyadmin/issues{/number}","pulls_url":"https://api.github.com/repos/machavity/phpmyadmin/pulls{/number}","milestones_url":"https://api.github.com/repos/machavity/phpmyadmin/milestones{/number}","notifications_url":"https://api.github.com/repos/machavity/phpmyadmin/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/machavity/phpmyadmin/labels{/name}","releases_url":"https://api.github.com/repos/machavity/phpmyadmin/releases{/id}","created_at":"2016-01-08T21:43:03Z","updated_at":"2016-01-08T21:43:14Z","pushed_at":"2016-01-15T21:29:40Z","git_url":"git://github.com/machavity/phpmyadmin.git","ssh_url":"git@github.com:machavity/phpmyadmin.git","clone_url":"https://github.com/machavity/phpmyadmin.git","svn_url":"https://github.com/machavity/phpmyadmin","homepage":"http://www.phpmyadmin.net/","size":482027,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"phpmyadmin:master","ref":"master","sha":"169c6ce49bb84c3d4c407f6abde6839c99b3ab4b","user":{"login":"phpmyadmin","id":1351977,"avatar_url":"https://avatars.githubusercontent.com/u/1351977?v=3","gravatar_id":"","url":"https://api.github.com/users/phpmyadmin","html_url":"https://github.com/phpmyadmin","followers_url":"https://api.github.com/users/phpmyadmin/followers","following_url":"https://api.github.com/users/phpmyadmin/following{/other_user}","gists_url":"https://api.github.com/users/phpmyadmin/gists{/gist_id}","starred_url":"https://api.github.com/users/phpmyadmin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpmyadmin/subscriptions","organizations_url":"https://api.github.com/users/phpmyadmin/orgs","repos_url":"https://api.github.com/users/phpmyadmin/repos","events_url":"https://api.github.com/users/phpmyadmin/events{/privacy}","received_events_url":"https://api.github.com/users/phpmyadmin/received_events","type":"Organization","site_admin":false},"repo":{"id":3217621,"name":"phpmyadmin","full_name":"phpmyadmin/phpmyadmin","owner":{"login":"phpmyadmin","id":1351977,"avatar_url":"https://avatars.githubusercontent.com/u/1351977?v=3","gravatar_id":"","url":"https://api.github.com/users/phpmyadmin","html_url":"https://github.com/phpmyadmin","followers_url":"https://api.github.com/users/phpmyadmin/followers","following_url":"https://api.github.com/users/phpmyadmin/following{/other_user}","gists_url":"https://api.github.com/users/phpmyadmin/gists{/gist_id}","starred_url":"https://api.github.com/users/phpmyadmin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phpmyadmin/subscriptions","organizations_url":"https://api.github.com/users/phpmyadmin/orgs","repos_url":"https://api.github.com/users/phpmyadmin/repos","events_url":"https://api.github.com/users/phpmyadmin/events{/privacy}","received_events_url":"https://api.github.com/users/phpmyadmin/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/phpmyadmin/phpmyadmin","description":"phpMyAdmin itself","fork":false,"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin","forks_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/forks","keys_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/keys{/key_id}","collaborators_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/teams","hooks_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/hooks","issue_events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/events{/number}","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/events","assignees_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/assignees{/user}","branches_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/branches{/branch}","tags_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/tags","blobs_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/refs{/sha}","trees_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/trees{/sha}","statuses_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/statuses/{sha}","languages_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/languages","stargazers_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/stargazers","contributors_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/contributors","subscribers_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/subscribers","subscription_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/subscription","commits_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/commits{/sha}","git_commits_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/git/commits{/sha}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/comments{/number}","issue_comment_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments{/number}","contents_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/contents/{+path}","compare_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/compare/{base}...{head}","merges_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/merges","archive_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/downloads","issues_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues{/number}","pulls_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls{/number}","milestones_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/milestones{/number}","notifications_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/labels{/name}","releases_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/releases{/id}","created_at":"2012-01-19T13:21:52Z","updated_at":"2016-01-14T21:12:01Z","pushed_at":"2016-01-15T21:40:51Z","git_url":"git://github.com/phpmyadmin/phpmyadmin.git","ssh_url":"git@github.com:phpmyadmin/phpmyadmin.git","clone_url":"https://github.com/phpmyadmin/phpmyadmin.git","svn_url":"https://github.com/phpmyadmin/phpmyadmin","homepage":"http://www.phpmyadmin.net/","size":511581,"stargazers_count":1520,"watchers_count":1520,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":898,"mirror_url":null,"open_issues_count":85,"forks":898,"open_issues":85,"watchers":1520,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/11838"},"html":{"href":"https://github.com/phpmyadmin/phpmyadmin/pull/11838"},"issue":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11838"},"comments":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11838/comments"},"review_comments":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/11838/comments"},"review_comment":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/11838/commits"},"statuses":{"href":"https://api.github.com/repos/phpmyadmin/phpmyadmin/statuses/d85e24caa31ea1ba465494f30b408adf6290a1c3"}},"merged":false,"mergeable":false,"mergeable_state":"dirty","merged_by":null,"comments":6,"review_comments":5,"commits":1,"additions":35,"deletions":1,"changed_files":3}}