{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11553","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11553/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11553/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11553/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11553","id":110556754,"number":11553,"title":"SQL Error upon login","user":{"login":"y2kbadbug","id":6489750,"avatar_url":"https://avatars.githubusercontent.com/u/6489750?v=3","gravatar_id":"","url":"https://api.github.com/users/y2kbadbug","html_url":"https://github.com/y2kbadbug","followers_url":"https://api.github.com/users/y2kbadbug/followers","following_url":"https://api.github.com/users/y2kbadbug/following{/other_user}","gists_url":"https://api.github.com/users/y2kbadbug/gists{/gist_id}","starred_url":"https://api.github.com/users/y2kbadbug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/y2kbadbug/subscriptions","organizations_url":"https://api.github.com/users/y2kbadbug/orgs","repos_url":"https://api.github.com/users/y2kbadbug/repos","events_url":"https://api.github.com/users/y2kbadbug/events{/privacy}","received_events_url":"https://api.github.com/users/y2kbadbug/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-10-08T22:48:07Z","updated_at":"2015-10-11T01:50:46Z","closed_at":null,"body":"Hello,\r\n\r\nSo on the latest master I am now experiencing the following error when logging into some of my MySQL servers (not all):\r\n\r\nError\r\nSQL query: DocumentationEdit Edit\r\nSELECT * FROM information_schema.CHARACTER_SETS\r\nMySQL said: Documentation\r\n#2006 - \r\n\r\nIf I remove everything except the base url itself, it takes me to the main server on my list which is logged in and gives me a bunch of tracebacks:\r\n\r\nWarning in ./libraries/dbi/DBIMysqli.php#243\r\n mysqli_query(): SSL operation failed with code 1. OpenSSL Error messages: error:0607A082:digital envelope routines:EVP_CIPHER_CTX_set_key_length:invalid key length error:0607A082:digital envelope routines:EVP_CIPHER_CTX_set_key_length:invalid key length\r\n\r\nBacktrace\r\n\r\n./libraries/dbi/DBIMysqli.php#243: mysqli_query(\r\nobject,\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\ninteger 0,\r\n)\r\n./libraries/DatabaseInterface.php#240: PMA\\libraries\\dbi\\DBIMysqli->realQuery(\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\nobject,\r\ninteger 0,\r\n)\r\n./libraries/DatabaseInterface.php#88: PMA\\libraries\\DatabaseInterface->tryQuery(\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\nNULL,\r\ninteger 0,\r\nboolean true,\r\n)\r\n./libraries/mysql_charsets.inc.php#21: PMA\\libraries\\DatabaseInterface->query(string 'SELECT * FROM information_schema.CHARACTER_SETS')\r\n./libraries/common.inc.php#1023: include_once(./libraries/mysql_charsets.inc.php)\r\n./index.php#13: require_once(./libraries/common.inc.php)\r\nWarning in ./libraries/dbi/DBIMysqli.php#243\r\n mysqli_query(): MySQL server has gone away\r\n\r\nBacktrace\r\n\r\n./libraries/dbi/DBIMysqli.php#243: mysqli_query(\r\nobject,\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\ninteger 0,\r\n)\r\n./libraries/DatabaseInterface.php#240: PMA\\libraries\\dbi\\DBIMysqli->realQuery(\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\nobject,\r\ninteger 0,\r\n)\r\n./libraries/DatabaseInterface.php#88: PMA\\libraries\\DatabaseInterface->tryQuery(\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\nNULL,\r\ninteger 0,\r\nboolean true,\r\n)\r\n./libraries/mysql_charsets.inc.php#21: PMA\\libraries\\DatabaseInterface->query(string 'SELECT * FROM information_schema.CHARACTER_SETS')\r\n./libraries/common.inc.php#1023: include_once(./libraries/mysql_charsets.inc.php)\r\n./index.php#13: require_once(./libraries/common.inc.php)\r\nWarning in ./libraries/dbi/DBIMysqli.php#243\r\n mysqli_query(): Error reading result set's header\r\n\r\nBacktrace\r\n\r\n./libraries/dbi/DBIMysqli.php#243: mysqli_query(\r\nobject,\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\ninteger 0,\r\n)\r\n./libraries/DatabaseInterface.php#240: PMA\\libraries\\dbi\\DBIMysqli->realQuery(\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\nobject,\r\ninteger 0,\r\n)\r\n./libraries/DatabaseInterface.php#88: PMA\\libraries\\DatabaseInterface->tryQuery(\r\nstring 'SELECT * FROM information_schema.CHARACTER_SETS',\r\nNULL,\r\ninteger 0,\r\nboolean true,\r\n)\r\n./libraries/mysql_charsets.inc.php#21: PMA\\libraries\\DatabaseInterface->query(string 'SELECT * FROM information_schema.CHARACTER_SETS')\r\n./libraries/common.inc.php#1023: include_once(./libraries/mysql_charsets.inc.php)\r\n./index.php#13: require_once(./libraries/common.inc.php)\r\nNotice in ./libraries/charset_conversion.lib.php#106\r\n iconv(): Wrong charset, conversion from `CP1252' to `utf-8//TRANSLIT' is not allowed\r\n\r\nBacktrace\r\n\r\n./libraries/charset_conversion.lib.php#106: iconv(\r\nstring 'CP1252',\r\nstring 'utf-8//TRANSLIT',\r\nstring 'MySQL server has gone away',\r\n)\r\n./libraries/DatabaseInterface.php#342: PMA_convertString(\r\nstring 'CP1252',\r\nstring 'utf-8',\r\nstring 'MySQL server has gone away',\r\n)\r\n./libraries/DatabaseInterface.php#2173: PMA\\libraries\\DatabaseInterface->convertMessage(string 'MySQL server has gone away')\r\n./libraries/dbi/DBIMysqli.php#418: PMA\\libraries\\DatabaseInterface->formatError(\r\ninteger 2006,\r\nstring 'MySQL server has gone away',\r\n)\r\n./libraries/DatabaseInterface.php#2613: PMA\\libraries\\dbi\\DBIMysqli->getError(object)\r\n./libraries/DatabaseInterface.php#89: PMA\\libraries\\DatabaseInterface->getError(NULL)\r\n./libraries/mysql_charsets.inc.php#21: PMA\\libraries\\DatabaseInterface->query(string 'SELECT * FROM information_schema.CHARACTER_SETS')\r\n./libraries/common.inc.php#1023: include_once(./libraries/mysql_charsets.inc.php)\r\n./index.php#13: require_once(./libraries/common.inc.php)"},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/147144697","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11553#issuecomment-147144697","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11553","id":147144697,"user":{"login":"y2kbadbug","id":6489750,"avatar_url":"https://avatars.githubusercontent.com/u/6489750?v=3","gravatar_id":"","url":"https://api.github.com/users/y2kbadbug","html_url":"https://github.com/y2kbadbug","followers_url":"https://api.github.com/users/y2kbadbug/followers","following_url":"https://api.github.com/users/y2kbadbug/following{/other_user}","gists_url":"https://api.github.com/users/y2kbadbug/gists{/gist_id}","starred_url":"https://api.github.com/users/y2kbadbug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/y2kbadbug/subscriptions","organizations_url":"https://api.github.com/users/y2kbadbug/orgs","repos_url":"https://api.github.com/users/y2kbadbug/repos","events_url":"https://api.github.com/users/y2kbadbug/events{/privacy}","received_events_url":"https://api.github.com/users/y2kbadbug/received_events","type":"User","site_admin":false},"created_at":"2015-10-11T01:50:46Z","updated_at":"2015-10-11T01:50:46Z","body":"Yes there is, these are running on Amazon RDS.  Some versions may be off a little bit but only minor versions."}}