{"action":"created","issue":{"url":"https://api.github.com/repos/LiskHQ/lisk-build/issues/287","repository_url":"https://api.github.com/repos/LiskHQ/lisk-build","labels_url":"https://api.github.com/repos/LiskHQ/lisk-build/issues/287/labels{/name}","comments_url":"https://api.github.com/repos/LiskHQ/lisk-build/issues/287/comments","events_url":"https://api.github.com/repos/LiskHQ/lisk-build/issues/287/events","html_url":"https://github.com/LiskHQ/lisk-build/issues/287","id":331417411,"node_id":"MDU6SXNzdWUzMzE0MTc0MTE=","number":287,"title":"Failed to create Postgresql user","user":{"login":"LZLP","id":16204502,"node_id":"MDQ6VXNlcjE2MjA0NTAy","avatar_url":"https://avatars0.githubusercontent.com/u/16204502?v=4","gravatar_id":"","url":"https://api.github.com/users/LZLP","html_url":"https://github.com/LZLP","followers_url":"https://api.github.com/users/LZLP/followers","following_url":"https://api.github.com/users/LZLP/following{/other_user}","gists_url":"https://api.github.com/users/LZLP/gists{/gist_id}","starred_url":"https://api.github.com/users/LZLP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LZLP/subscriptions","organizations_url":"https://api.github.com/users/LZLP/orgs","repos_url":"https://api.github.com/users/LZLP/repos","events_url":"https://api.github.com/users/LZLP/events{/privacy}","received_events_url":"https://api.github.com/users/LZLP/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-06-12T02:44:52Z","updated_at":"2018-06-12T10:42:47Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI attempted to install the binary one for the test network on my ubuntu 17 (artful) but it failed to create postgres user. There is no other postgreSQL program installed. \r\n\r\n```\r\nlisk@ubuntuserver:~$ lsb_release -a\r\nNo LSB modules are available.\r\nDistributor ID:\tUbuntu\r\nDescription:\tUbuntu 17.10\r\nRelease:\t17.10\r\nCodename:\tartful\r\n```\r\n\r\n```\r\nlisk@ubuntuserver:~$ bash installLisk.sh install -r test\r\nChecking prerequisites:\r\ncurl is installed.\t\t\t\t\tPassed\r\nTar is installed.\t\t\t\t\tPassed\r\nWget is installed.\t\t\t\t\tPassed\r\nSudo is installed.\t\t\t\t\tPassed\r\nPlease provide sudo password for validation\r\n\r\nSudo authenticated.\t\t\t\t\tPassed\r\nAll preqrequisites passed!\r\nWhere do you want to install Lisk to? (Default /home/lisk): \r\nWould you like to synchronize from the Genesis Block? (Default no): \r\n√ NTP is running\r\n\r\nDownloading current Lisk binaries: lisk-Linux-x86_64.tar.gz\r\n######################################################################## 100.0%\r\n\r\nChecksum Passed!\r\n\r\nExtracting Lisk binaries to /home/lisk/lisk-test\r\n\r\nCleaning up downloaded files\r\n\r\nColdstarting Lisk for the first time\r\n√ Postgresql started successfully.\r\nX Failed to create Postgresql user.\r\nInstallation failed. Cleaning up...\r\n\r\nStopping Lisk components before cleanup\r\n√ Lisk stopped successfully.\r\n√ Postgresql stopped successfully.\r\n```\r\n\r\nI also tried the docker install on a different machine and noticed the following command did not work. Is this the root cause?\r\n\r\n```\r\nlisk@ubuntuserver:~$ echo \"*:*:*:*:$(shell grep POSTGRES_PASSWORD db.env |cut -d \"=\" -f 2 )\" >.pgpass\r\n-su: shell: command not found\r\n```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/LiskHQ/lisk-build/issues/comments/396546215","html_url":"https://github.com/LiskHQ/lisk-build/issues/287#issuecomment-396546215","issue_url":"https://api.github.com/repos/LiskHQ/lisk-build/issues/287","id":396546215,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NjU0NjIxNQ==","user":{"login":"LZLP","id":16204502,"node_id":"MDQ6VXNlcjE2MjA0NTAy","avatar_url":"https://avatars0.githubusercontent.com/u/16204502?v=4","gravatar_id":"","url":"https://api.github.com/users/LZLP","html_url":"https://github.com/LZLP","followers_url":"https://api.github.com/users/LZLP/followers","following_url":"https://api.github.com/users/LZLP/following{/other_user}","gists_url":"https://api.github.com/users/LZLP/gists{/gist_id}","starred_url":"https://api.github.com/users/LZLP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LZLP/subscriptions","organizations_url":"https://api.github.com/users/LZLP/orgs","repos_url":"https://api.github.com/users/LZLP/repos","events_url":"https://api.github.com/users/LZLP/events{/privacy}","received_events_url":"https://api.github.com/users/LZLP/received_events","type":"User","site_admin":false},"created_at":"2018-06-12T10:42:47Z","updated_at":"2018-06-12T10:42:47Z","author_association":"NONE","body":"Okay, thanks."}}
{"actor":{"display_login":"LZLP"}}