{"action":"created","issue":{"url":"https://api.github.com/repos/xtuple/xtuple-server/issues/281","labels_url":"https://api.github.com/repos/xtuple/xtuple-server/issues/281/labels{/name}","comments_url":"https://api.github.com/repos/xtuple/xtuple-server/issues/281/comments","events_url":"https://api.github.com/repos/xtuple/xtuple-server/issues/281/events","html_url":"https://github.com/xtuple/xtuple-server/issues/281","id":60133058,"number":281,"title":"Login error from Mac Client 4.8.0 on Live 4.8.0 Db / Ubuntu 14.04 LTS","user":{"login":"mperreault1980","id":11321317,"avatar_url":"https://avatars.githubusercontent.com/u/11321317?v=3","gravatar_id":"","url":"https://api.github.com/users/mperreault1980","html_url":"https://github.com/mperreault1980","followers_url":"https://api.github.com/users/mperreault1980/followers","following_url":"https://api.github.com/users/mperreault1980/following{/other_user}","gists_url":"https://api.github.com/users/mperreault1980/gists{/gist_id}","starred_url":"https://api.github.com/users/mperreault1980/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mperreault1980/subscriptions","organizations_url":"https://api.github.com/users/mperreault1980/orgs","repos_url":"https://api.github.com/users/mperreault1980/repos","events_url":"https://api.github.com/users/mperreault1980/events{/privacy}","received_events_url":"https://api.github.com/users/mperreault1980/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-03-06T17:33:28Z","updated_at":"2015-03-13T15:15:24Z","closed_at":null,"body":"I'm getting the following error when I try to login via remote: \r\n\r\nA System Error occurred at login2.cpp::429:\r\nERROR:  function login(boolean) does not exist\r\nLINE 1: SELECT login(true) AS result, CURRENT_USER AS user;\r\n\r\nAnyone know what could be causing this error?\r\n\r\nlog output: \r\n2015-03-06 17:32:55 UTC ERROR:  function login(boolean) does not exist at character 8\r\n2015-03-06 17:32:55 UTC HINT:  No function matches the given name and argument types. You might need to add explicit type casts.\r\n2015-03-06 17:32:55 UTC STATEMENT:  SELECT login(true) AS result, CURRENT_USER AS user;"},"comment":{"url":"https://api.github.com/repos/xtuple/xtuple-server/issues/comments/79034205","html_url":"https://github.com/xtuple/xtuple-server/issues/281#issuecomment-79034205","issue_url":"https://api.github.com/repos/xtuple/xtuple-server/issues/281","id":79034205,"user":{"login":"gilmoskowitz","id":704111,"avatar_url":"https://avatars.githubusercontent.com/u/704111?v=3","gravatar_id":"","url":"https://api.github.com/users/gilmoskowitz","html_url":"https://github.com/gilmoskowitz","followers_url":"https://api.github.com/users/gilmoskowitz/followers","following_url":"https://api.github.com/users/gilmoskowitz/following{/other_user}","gists_url":"https://api.github.com/users/gilmoskowitz/gists{/gist_id}","starred_url":"https://api.github.com/users/gilmoskowitz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gilmoskowitz/subscriptions","organizations_url":"https://api.github.com/users/gilmoskowitz/orgs","repos_url":"https://api.github.com/users/gilmoskowitz/repos","events_url":"https://api.github.com/users/gilmoskowitz/events{/privacy}","received_events_url":"https://api.github.com/users/gilmoskowitz/received_events","type":"User","site_admin":false},"created_at":"2015-03-13T15:15:24Z","updated_at":"2015-03-13T15:15:24Z","body":"There's obviously something wrong with either the contents of the database that xtuple-server is starting with or the way that database is being installed. Let's try to figure out what's missing or strange or incorrect.\r\n\r\nCreate a plain text file (not a word processing document) with the following:\r\n\r\n```SQL\r\nselect fetchMetricText('ServerVersion'), version();\r\nshow search_path;\r\nselect nspname from pg_namespace order by 1;\r\nselect nspname, proname\r\n  from pg_namespace n join pg_proc p on n.oid=pronamespace\r\n where proname ~* 'login';\r\nselect public.login();\r\nshow search_path;\r\nselect pkghead_name, pkghead_version from public.pkghead order by 1;\r\nselect nspname, count(*) as NumberOfProcedures\r\n  from pg_namespace n join pg_proc p on n.oid=pronamespace\r\n group by nspname order by nspname;\r\nselect nspname, count(distinct proname) as NumberOfProcedures\r\n  from pg_namespace n join pg_proc p on n.oid=pronamespace\r\n group by nspname order by nspname;\r\nselect nspname, relkind, count(*) as NumberOfRelations\r\n  from pg_namespace n join pg_class on n.oid=relnamespace\r\n group by nspname, relkind order by nspname, relkind;\r\n```\r\nThen run the following from a Terminal window on the Linux host and send us the output:\r\n\r\n```\r\npsql -e -U admin -p 5435 -d name-of-your-database -f name-of-your-file\r\n```\r\nIf you paste the output into a comment on this issue please wrap it in a code block."}}