Unable to login to a remote host running postgresql via phppgadmin

Поиск
Список
Период
Сортировка
От Tom Browder
Тема Unable to login to a remote host running postgresql via phppgadmin
Дата
Msg-id CAFMGiz9urDrdA_PLZmm+XW2TkqT8ifHmk=bc_2=O+FjGdgPY6Q@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
I have installed postgresql 9.0.4 from source on aUbuntu 10.04 LTS
64-bit remote host.

I have installed phppgadmin, Apache2, and other required programs and
libraries via the Ubuntu package manager.

I have successfully created the user posgtres, executed initdb
successfully, and can execute pqsql to connect to template1, all while
logged in via ssh onto the remote host

I have set postgresql to listen on all.

I have these lines in my pg_hba.conf file:

host  all             myuser         <a remote host IP>/32         md5
host  all             postgres       <a remote host IP>/32         md5


However, I cannot successfully login with phppgadmin on the remote host.

I always get "login failed".

I have made these changes in /etc/phppgadmin files:

   apache.conf:

  config.inc.php:
     $conf['servers'][0]['desc'] = 'mars-postgresql';
     $conf['servers'][0]['host'] = 'local host ip address...';
     //$conf['extra_login_security'] = true;
     $conf['extra_login_security'] = false;

Any help is appreciated.

Best regards,

-Tom

В списке pgsql-admin по дате отправления:

Предыдущее
От: Vítor Carvalho
Дата:
Сообщение: get old versions (8.3.8 or 8.4.1)
Следующее
От: Tom Browder
Дата:
Сообщение: Unable to login with phppgadmin on a remote host