{"action":"created","issue":{"url":"https://api.github.com/repos/ether/etherpad-lite/issues/3107","repository_url":"https://api.github.com/repos/ether/etherpad-lite","labels_url":"https://api.github.com/repos/ether/etherpad-lite/issues/3107/labels{/name}","comments_url":"https://api.github.com/repos/ether/etherpad-lite/issues/3107/comments","events_url":"https://api.github.com/repos/ether/etherpad-lite/issues/3107/events","html_url":"https://github.com/ether/etherpad-lite/issues/3107","id":197992338,"number":3107,"title":"Changing port to connect to mysql don't work!","user":{"login":"flotho","id":1043935,"avatar_url":"https://avatars.githubusercontent.com/u/1043935?v=3","gravatar_id":"","url":"https://api.github.com/users/flotho","html_url":"https://github.com/flotho","followers_url":"https://api.github.com/users/flotho/followers","following_url":"https://api.github.com/users/flotho/following{/other_user}","gists_url":"https://api.github.com/users/flotho/gists{/gist_id}","starred_url":"https://api.github.com/users/flotho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/flotho/subscriptions","organizations_url":"https://api.github.com/users/flotho/orgs","repos_url":"https://api.github.com/users/flotho/repos","events_url":"https://api.github.com/users/flotho/events{/privacy}","received_events_url":"https://api.github.com/users/flotho/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-12-29T11:21:28Z","updated_at":"2016-12-29T11:55:57Z","closed_at":null,"body":"Hi,\r\n\r\nI'm working on the latest fresh install of etherpad on a server and a second server with mySQL 5.5.52 on centos6.6.\r\nThe mysql server is listening on a specific port and I would like to be able to specify it in the json. I tried many things like :\r\n```\r\n   \"dbType\" : \"mysql\",\r\n   \"dbSettings\" : {\r\n                    \"user\"    : \"etherpad\",\r\n                    \"host\"    : \"database\",\r\n                    \"password\": \"etherpad\",\r\n                    \"database\": \"etherpad\",\r\n                    \"port\": 5133\r\n                  },\r\n```\r\nBut when running ./run.sh I have the following message :\r\n```\r\nError: ER_ACCESS_DENIED_ERROR: Access denied for user 'etherpad'@'10.0.130.109' (using password: YES)\r\n    at Handshake.Sequence._packetToError (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/sequences/Sequence.js:48:14)\r\n    at Handshake.ErrorPacket (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/sequences/Handshake.js:101:18)\r\n    at Protocol._parsePacket (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/Protocol.js:271:23)\r\n    at Parser.write (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/Parser.js:77:12)\r\n    at Protocol.write (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/Protocol.js:39:16)\r\n    at Socket.<anonymous> (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/Connection.js:82:28)\r\n    at emitOne (events.js:96:13)\r\n    at Socket.emit (events.js:188:7)\r\n    at readableAddChunk (_stream_readable.js:176:18)\r\n    at Socket.Readable.push (_stream_readable.js:134:10)\r\n    --------------------\r\n    at Protocol._enqueue (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/Protocol.js:135:48)\r\n    at Protocol.handshake (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/protocol/Protocol.js:52:41)\r\n    at Connection.connect (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/Connection.js:109:18)\r\n    at Connection._implyConnect (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/Connection.js:387:10)\r\n    at Connection.query (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/node_modules/mysql/lib/Connection.js:174:8)\r\n    at exports.database.init (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/mysql_db.js:74:6)\r\n    at exports.database.init (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/CacheAndBufferLayer.js:110:18)\r\n    at exports.database.init (/opt/etherpad/etherpad-lite/src/node_modules/ueberdb2/CloneAndAtomicLayer.js:48:11)\r\n    at Object.exports.init (/opt/etherpad/etherpad-lite/src/node/db/DB.js:41:6)\r\n    at /opt/etherpad/etherpad-lite/src/node/server.js:62:8\r\n\r\n```\r\nYet when I'm trying to connect from the etherpad server to the mysql using the mysq command it succeed :\r\n```\r\n[etherpad@gestion etherpad-lite]$ mysql -P 5133 -h database -u etherpad -D etherpad\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\r\nYour MySQL connection id is 30\r\nServer version: 5.5.52 MySQL Community Server (GPL)\r\n\r\nCopyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nMySQL [etherpad]> \r\n\r\n```\r\n\r\nany help/advice would be appreciated,\r\n\r\nregards"},"comment":{"url":"https://api.github.com/repos/ether/etherpad-lite/issues/comments/269620176","html_url":"https://github.com/ether/etherpad-lite/issues/3107#issuecomment-269620176","issue_url":"https://api.github.com/repos/ether/etherpad-lite/issues/3107","id":269620176,"user":{"login":"lpagliari","id":836386,"avatar_url":"https://avatars.githubusercontent.com/u/836386?v=3","gravatar_id":"","url":"https://api.github.com/users/lpagliari","html_url":"https://github.com/lpagliari","followers_url":"https://api.github.com/users/lpagliari/followers","following_url":"https://api.github.com/users/lpagliari/following{/other_user}","gists_url":"https://api.github.com/users/lpagliari/gists{/gist_id}","starred_url":"https://api.github.com/users/lpagliari/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lpagliari/subscriptions","organizations_url":"https://api.github.com/users/lpagliari/orgs","repos_url":"https://api.github.com/users/lpagliari/repos","events_url":"https://api.github.com/users/lpagliari/events{/privacy}","received_events_url":"https://api.github.com/users/lpagliari/received_events","type":"User","site_admin":false},"created_at":"2016-12-29T11:55:57Z","updated_at":"2016-12-29T11:55:57Z","body":"@flotho this seems to be an issue with `ueberdb` lib. Can you try to run [this example](https://github.com/Pita/ueberDB#example) with your credentials to check if you're able to connect to your database?"}}
{"actor":{"display_login":"lpagliari"}}