{"action":"created","issue":{"url":"https://api.github.com/repos/EQEmu/Server/issues/567","repository_url":"https://api.github.com/repos/EQEmu/Server","labels_url":"https://api.github.com/repos/EQEmu/Server/issues/567/labels{/name}","comments_url":"https://api.github.com/repos/EQEmu/Server/issues/567/comments","events_url":"https://api.github.com/repos/EQEmu/Server/issues/567/events","html_url":"https://github.com/EQEmu/Server/issues/567","id":183761585,"number":567,"title":"eqemu_server.pl, problem with get_mysql_result ? ","user":{"login":"proxeeus","id":1784908,"avatar_url":"https://avatars.githubusercontent.com/u/1784908?v=3","gravatar_id":"","url":"https://api.github.com/users/proxeeus","html_url":"https://github.com/proxeeus","followers_url":"https://api.github.com/users/proxeeus/followers","following_url":"https://api.github.com/users/proxeeus/following{/other_user}","gists_url":"https://api.github.com/users/proxeeus/gists{/gist_id}","starred_url":"https://api.github.com/users/proxeeus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/proxeeus/subscriptions","organizations_url":"https://api.github.com/users/proxeeus/orgs","repos_url":"https://api.github.com/users/proxeeus/repos","events_url":"https://api.github.com/users/proxeeus/events{/privacy}","received_events_url":"https://api.github.com/users/proxeeus/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":13,"created_at":"2016-10-18T18:08:28Z","updated_at":"2016-10-18T20:36:05Z","closed_at":"2016-10-18T19:47:49Z","body":"Hi,\r\nI hope I'm not writing this @ the wrong spot.\r\n\r\nThis is after a fresh git pull, and a new version of the eqemu_server.pl script.\r\n\r\nBasically, world.exe sees that my database is out of date, and tries to update it. The problem I'm facing is, it looks like get_mysql_result (around line 930) has a formatting problem, some parameters are missing an \"=\" character (password does have it, though), thus leading some mysql commands to never be correctly executed by world.exe\r\n\r\nHere's the line I'm talking about (sorry about the formatting...):\r\n\r\n`if($OS eq \"Windows\")\r\n{ \r\nreturn `\"$path\" --host $host --user $user --password=\"$pass\" $db -N -B -e \"$run_query\"`;\r\n }\r\n`\r\nI can reproduce the issue by manually entering this kind of \"bogus\" command on a cmd prompt.\r\n\r\nI tried fixing the .pl script but it keeps on redownloading itself.\r\n\r\nHere's a picture of the issue:\r\n![image](https://cloud.githubusercontent.com/assets/1784908/19490197/8db22360-956e-11e6-8427-8c23db6481d7.png)\r\n"},"comment":{"url":"https://api.github.com/repos/EQEmu/Server/issues/comments/254631530","html_url":"https://github.com/EQEmu/Server/issues/567#issuecomment-254631530","issue_url":"https://api.github.com/repos/EQEmu/Server/issues/567","id":254631530,"user":{"login":"proxeeus","id":1784908,"avatar_url":"https://avatars.githubusercontent.com/u/1784908?v=3","gravatar_id":"","url":"https://api.github.com/users/proxeeus","html_url":"https://github.com/proxeeus","followers_url":"https://api.github.com/users/proxeeus/followers","following_url":"https://api.github.com/users/proxeeus/following{/other_user}","gists_url":"https://api.github.com/users/proxeeus/gists{/gist_id}","starred_url":"https://api.github.com/users/proxeeus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/proxeeus/subscriptions","organizations_url":"https://api.github.com/users/proxeeus/orgs","repos_url":"https://api.github.com/users/proxeeus/repos","events_url":"https://api.github.com/users/proxeeus/events{/privacy}","received_events_url":"https://api.github.com/users/proxeeus/received_events","type":"User","site_admin":false},"created_at":"2016-10-18T20:36:05Z","updated_at":"2016-10-18T20:36:05Z","body":"I think I may have figured it out... my db password was using a lot of special characters (>, ?, * and the like). By creating another user with the same root rights, but a simpler password, world.exe connected flawlessly to MySql!"}}
{"actor":{"display_login":"proxeeus"}}