{"action":"created","issue":{"url":"https://api.github.com/repos/mevdschee/php-crud-api/issues/142","repository_url":"https://api.github.com/repos/mevdschee/php-crud-api","labels_url":"https://api.github.com/repos/mevdschee/php-crud-api/issues/142/labels{/name}","comments_url":"https://api.github.com/repos/mevdschee/php-crud-api/issues/142/comments","events_url":"https://api.github.com/repos/mevdschee/php-crud-api/issues/142/events","html_url":"https://github.com/mevdschee/php-crud-api/issues/142","id":192073023,"number":142,"title":"Using postgres maintenance database","user":{"login":"beakman","id":215902,"avatar_url":"https://avatars.githubusercontent.com/u/215902?v=3","gravatar_id":"","url":"https://api.github.com/users/beakman","html_url":"https://github.com/beakman","followers_url":"https://api.github.com/users/beakman/followers","following_url":"https://api.github.com/users/beakman/following{/other_user}","gists_url":"https://api.github.com/users/beakman/gists{/gist_id}","starred_url":"https://api.github.com/users/beakman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/beakman/subscriptions","organizations_url":"https://api.github.com/users/beakman/orgs","repos_url":"https://api.github.com/users/beakman/repos","events_url":"https://api.github.com/users/beakman/events{/privacy}","received_events_url":"https://api.github.com/users/beakman/received_events","type":"User","site_admin":false},"labels":[{"id":175489583,"url":"https://api.github.com/repos/mevdschee/php-crud-api/labels/help%20wanted","name":"help wanted","color":"159818","default":true}],"state":"closed","locked":false,"assignee":{"login":"mevdschee","id":1288217,"avatar_url":"https://avatars.githubusercontent.com/u/1288217?v=3","gravatar_id":"","url":"https://api.github.com/users/mevdschee","html_url":"https://github.com/mevdschee","followers_url":"https://api.github.com/users/mevdschee/followers","following_url":"https://api.github.com/users/mevdschee/following{/other_user}","gists_url":"https://api.github.com/users/mevdschee/gists{/gist_id}","starred_url":"https://api.github.com/users/mevdschee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mevdschee/subscriptions","organizations_url":"https://api.github.com/users/mevdschee/orgs","repos_url":"https://api.github.com/users/mevdschee/repos","events_url":"https://api.github.com/users/mevdschee/events{/privacy}","received_events_url":"https://api.github.com/users/mevdschee/received_events","type":"User","site_admin":false},"assignees":[{"login":"mevdschee","id":1288217,"avatar_url":"https://avatars.githubusercontent.com/u/1288217?v=3","gravatar_id":"","url":"https://api.github.com/users/mevdschee","html_url":"https://github.com/mevdschee","followers_url":"https://api.github.com/users/mevdschee/followers","following_url":"https://api.github.com/users/mevdschee/following{/other_user}","gists_url":"https://api.github.com/users/mevdschee/gists{/gist_id}","starred_url":"https://api.github.com/users/mevdschee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mevdschee/subscriptions","organizations_url":"https://api.github.com/users/mevdschee/orgs","repos_url":"https://api.github.com/users/mevdschee/repos","events_url":"https://api.github.com/users/mevdschee/events{/privacy}","received_events_url":"https://api.github.com/users/mevdschee/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2016-11-28T17:53:33Z","updated_at":"2016-11-30T18:49:52Z","closed_at":"2016-11-30T18:49:52Z","body":"I'm trying to query the maintenance database \"postgres\" to obtain the database list from \"pg_database\" table.\r\n\r\nWhen I use the php built-in web server: `php -S localhost:8000` it works fine:\r\n\r\n`GET http://localhost:8000/api.php/postgres/pg_database`\r\n\r\nRESULT:\r\n\r\n> {\"pg_database\":{\"columns\":[\"datname\",\"datdba\",\"encoding\",\"datcollate\",\"datctype\",\"datistemplate\",\"datallowconn\",\"datconnlimit\",\"datlastsysoid\",\"datfrozenxid\",\"datminmxid\",\"dattablespace\",\"datacl\"],\"records\":[[\"template1\",\"10\",\"6\",\"en_US.UTF-8\",\"en_US.UTF-8\",\"t\",\"t\",\"-1\",\"12030\",\"673\",\"1\",\"1663\",\"{=c\\/postgres,postgres=CTc\\/postgres}\"],[\"template0\",\"10\",\"6\",\"en_US.UTF-8\",\"en_US.UTF-8\",\"t\",\"f\",\"-1\",\"12030\",\"673\",\"1\",\"1663\",\"{=c\\/postgres,postgres=CTc\\/postgres}\"],[\"postgres\",\"10\",\"6\",\"en_US.UTF-8\",\"en_US.UTF-8\",\"f\",\"t\",\"-1\",\"12030\",\"673\",\"1\",\"1663\",null],[\"omldb\",\"10\",\"6\",\"en_US.UTF-8\",\"en_US.UTF-8\",\"f\",\"t\",\"-1\",\"12030\",\"673\",\"1\",\"1663\",null],[\"experiments_registry\",\"16385\",\"6\",\"en_US.UTF-8\",\"en_US.UTF-8\",\"f\",\"t\",\"-1\",\"12030\",\"673\",\"1\",\"1663\",null],[\"nc_18.11.201616.35.57.204\",\"16385\",\"6\",\"en_US.UTF-8\",\"en_US.UTF-8\",\"f\",\"t\",\"-1\",\"12030\",\"673\",\"1\",\"1663\",null]]}}\r\n\r\nBut when I upload the 'api.php' to production server I always get an 404 Not found (entity) error.\r\n\r\nI found that the query: `$result = $this->db->query($this->db->getSql('reflect_table'),array($table,$database))` returns nothing in production server.\r\n\r\nAny clues on why this is happening?\r\n\r\nThank you all."},"comment":{"url":"https://api.github.com/repos/mevdschee/php-crud-api/issues/comments/263959577","html_url":"https://github.com/mevdschee/php-crud-api/issues/142#issuecomment-263959577","issue_url":"https://api.github.com/repos/mevdschee/php-crud-api/issues/142","id":263959577,"user":{"login":"mevdschee","id":1288217,"avatar_url":"https://avatars.githubusercontent.com/u/1288217?v=3","gravatar_id":"","url":"https://api.github.com/users/mevdschee","html_url":"https://github.com/mevdschee","followers_url":"https://api.github.com/users/mevdschee/followers","following_url":"https://api.github.com/users/mevdschee/following{/other_user}","gists_url":"https://api.github.com/users/mevdschee/gists{/gist_id}","starred_url":"https://api.github.com/users/mevdschee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mevdschee/subscriptions","organizations_url":"https://api.github.com/users/mevdschee/orgs","repos_url":"https://api.github.com/users/mevdschee/repos","events_url":"https://api.github.com/users/mevdschee/events{/privacy}","received_events_url":"https://api.github.com/users/mevdschee/received_events","type":"User","site_admin":false},"created_at":"2016-11-30T18:49:52Z","updated_at":"2016-11-30T18:49:52Z","body":"Closed due to inactivity."}}
{"actor":{"display_login":"mevdschee"}}