{"action":"created","issue":{"url":"https://api.github.com/repos/processone/ejabberd/issues/1136","repository_url":"https://api.github.com/repos/processone/ejabberd","labels_url":"https://api.github.com/repos/processone/ejabberd/issues/1136/labels{/name}","comments_url":"https://api.github.com/repos/processone/ejabberd/issues/1136/comments","events_url":"https://api.github.com/repos/processone/ejabberd/issues/1136/events","html_url":"https://github.com/processone/ejabberd/issues/1136","id":157235617,"number":1136,"title":"problems with postgres/odbc and special characters (- .) in database names","user":{"login":"dl8bh","id":10435353,"avatar_url":"https://avatars.githubusercontent.com/u/10435353?v=3","gravatar_id":"","url":"https://api.github.com/users/dl8bh","html_url":"https://github.com/dl8bh","followers_url":"https://api.github.com/users/dl8bh/followers","following_url":"https://api.github.com/users/dl8bh/following{/other_user}","gists_url":"https://api.github.com/users/dl8bh/gists{/gist_id}","starred_url":"https://api.github.com/users/dl8bh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dl8bh/subscriptions","organizations_url":"https://api.github.com/users/dl8bh/orgs","repos_url":"https://api.github.com/users/dl8bh/repos","events_url":"https://api.github.com/users/dl8bh/events{/privacy}","received_events_url":"https://api.github.com/users/dl8bh/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/processone/ejabberd/labels/Component:Databases","name":"Component:Databases","color":"fef2c0"}],"state":"closed","locked":false,"assignee":{"login":"jsautret","id":568898,"avatar_url":"https://avatars.githubusercontent.com/u/568898?v=3","gravatar_id":"","url":"https://api.github.com/users/jsautret","html_url":"https://github.com/jsautret","followers_url":"https://api.github.com/users/jsautret/followers","following_url":"https://api.github.com/users/jsautret/following{/other_user}","gists_url":"https://api.github.com/users/jsautret/gists{/gist_id}","starred_url":"https://api.github.com/users/jsautret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsautret/subscriptions","organizations_url":"https://api.github.com/users/jsautret/orgs","repos_url":"https://api.github.com/users/jsautret/repos","events_url":"https://api.github.com/users/jsautret/events{/privacy}","received_events_url":"https://api.github.com/users/jsautret/received_events","type":"User","site_admin":false},"assignees":[{"login":"jsautret","id":568898,"avatar_url":"https://avatars.githubusercontent.com/u/568898?v=3","gravatar_id":"","url":"https://api.github.com/users/jsautret","html_url":"https://github.com/jsautret","followers_url":"https://api.github.com/users/jsautret/followers","following_url":"https://api.github.com/users/jsautret/following{/other_user}","gists_url":"https://api.github.com/users/jsautret/gists{/gist_id}","starred_url":"https://api.github.com/users/jsautret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsautret/subscriptions","organizations_url":"https://api.github.com/users/jsautret/orgs","repos_url":"https://api.github.com/users/jsautret/repos","events_url":"https://api.github.com/users/jsautret/events{/privacy}","received_events_url":"https://api.github.com/users/jsautret/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/processone/ejabberd/milestones/17","html_url":"https://github.com/processone/ejabberd/milestones/ejabberd%2016.08","labels_url":"https://api.github.com/repos/processone/ejabberd/milestones/17/labels","id":1854520,"number":17,"title":"ejabberd 16.08","description":"","creator":{"login":"mremond","id":86736,"avatar_url":"https://avatars.githubusercontent.com/u/86736?v=3","gravatar_id":"","url":"https://api.github.com/users/mremond","html_url":"https://github.com/mremond","followers_url":"https://api.github.com/users/mremond/followers","following_url":"https://api.github.com/users/mremond/following{/other_user}","gists_url":"https://api.github.com/users/mremond/gists{/gist_id}","starred_url":"https://api.github.com/users/mremond/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mremond/subscriptions","organizations_url":"https://api.github.com/users/mremond/orgs","repos_url":"https://api.github.com/users/mremond/repos","events_url":"https://api.github.com/users/mremond/events{/privacy}","received_events_url":"https://api.github.com/users/mremond/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":7,"state":"open","created_at":"2016-06-29T07:40:13Z","updated_at":"2016-07-22T14:48:25Z","due_on":null,"closed_at":null},"comments":6,"created_at":"2016-05-27T15:45:10Z","updated_at":"2016-07-22T14:48:25Z","closed_at":"2016-07-22T14:48:25Z","body":"> What version of ejabberd are you using?\r\n\r\n16.03\r\n\r\n> What operating system (version) are you using?\r\n\r\nFreeBSD 10.3\r\n\r\n> How did you install ejabberd (source, package, distribution)?\r\n\r\nFreeBSD Ports\r\n\r\n> What did not work as expected? Are there error messages in the log? What\r\n> was the unexpected behavior? What was the expected result?\r\n\r\nOn our testsystem using postgres as database:\r\nI tried\r\n> ejabberdctl delete_old_users 365\r\n\r\nwhich lead to error messages from postgres:\r\n```\r\nMay 27 16:59:56 xmpp postgres[88092]: [4-1] ERROR:  syntax error at or near \"-\" at character 19\r\nMay 27 16:59:56 xmpp postgres[88092]: [4-2] STATEMENT:  alter database some-exmaple.de set standard_conforming_strings='off';\r\nMay 27 16:59:56 xmpp postgres[88092]: [6-1] WARNING:  there is no transaction in progress\r\n```\r\nand a whole bunch of missing prepared_statements \r\n\r\nafter renaming the db to \"someexamplede\", everything works fine.\r\n\r\nSuggested fix: mask the db name in the respective psql queries with \"\" signs\r\n"},"comment":{"url":"https://api.github.com/repos/processone/ejabberd/issues/comments/234564297","html_url":"https://github.com/processone/ejabberd/issues/1136#issuecomment-234564297","issue_url":"https://api.github.com/repos/processone/ejabberd/issues/1136","id":234564297,"user":{"login":"jsautret","id":568898,"avatar_url":"https://avatars.githubusercontent.com/u/568898?v=3","gravatar_id":"","url":"https://api.github.com/users/jsautret","html_url":"https://github.com/jsautret","followers_url":"https://api.github.com/users/jsautret/followers","following_url":"https://api.github.com/users/jsautret/following{/other_user}","gists_url":"https://api.github.com/users/jsautret/gists{/gist_id}","starred_url":"https://api.github.com/users/jsautret/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsautret/subscriptions","organizations_url":"https://api.github.com/users/jsautret/orgs","repos_url":"https://api.github.com/users/jsautret/repos","events_url":"https://api.github.com/users/jsautret/events{/privacy}","received_events_url":"https://api.github.com/users/jsautret/received_events","type":"User","site_admin":false},"created_at":"2016-07-22T14:48:25Z","updated_at":"2016-07-22T14:48:25Z","body":"Indeed, quoting the database name solves the problem. It is the only place where a database name is used in a SQL query."}}
{"actor":{"display_login":"jsautret"}}