SOLVED: For other users out there, superuser, and every other user needs ROLE_USER to function. I didn't have a dbuser password so: Dropped into user postgres to find pg_hba.conf (for me it was in /var/lib/pgsql93/data/pg_hba.conf) Added this to the first line: local all all trustlocal all all trustlocal all all trustlocal all all trustlocal all all trust (security alert!! this needs to be reverted back right away when you are done - you might want to use whitelisted IPs only in your firewall config when doing this) psql -U postgres gave postgres a new password (and this caused me problems I'm still working on) connect jasperserver UPDATE jiuserrole SET roleid = 5 WHERE userid = 10; Now superuser is back to ROLE_USER
Now I have to figure out where to add the new password for postgres in the relevant configs because Jasper is now not working due to that changed password.
EDIT: Regarding #4, the original password for postgres is ... drumroll .... "postgres".