Hi,
I like to setup phpPgAdmin for PostgreSQL database (simular to phpmyadmin for mysql) for Gitlab-CE omnibus version.
I already successfully setup phpPgAdmin itself. Next, I added a new database user via:
su - gitlab-psql
Then joining the db:
/opt/gitlab/embedded/bin/psql gitlabhq_production
Add new user & rights:
CREATE USER blah WITH PASSWORD 'blah ';
GRANT ALL PRIVILEGES ON DATABASE gitlabhq_production to blah;
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO blah;
I changed the phpPgAdmin settings:
nano /usr/share/phpPgAdmin/conf/config.inc.php
To:
$conf['extra_login_security'] =false;
Now I’m trying to login with this new user in phpPgAdmin, however it still fails with “login failed”. How to continue? I think phpPgAdmin doesn’t have access to the PostgreSQL database. It seems the omnibus PostgreSQL process is kinda sandboxed…?
I don’t know which settings I need to change in order to view the gitlab database in phpPgAdmin.
Thanks in advance!
Kind regards,
Melroy van den Berg