problem with login in postgresql
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Unix and Linux reviews > Free Debian support > Linux Debian support > problem with login in postgresql




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    problem with login in postgresql  
itom


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
11-12-05 01:46 AM

hi all, I've a problem during configuration of PostgreSQL with
phppgadmin, below you find the steps that I made to install it.

the problem is that when I login via phppgadmin with user "tommaso" and
password "pippo" tell me -> "Login Failed" but if in a shell I login
with the command: '$ psql -U tommaso template1' ask me for password and
I enter without problem.

Debian Testing, version: PostgreSQL   7.5.12   e  phppgadmin   3.5.6-1

...............................

My step for installation:

1. Modify the conf: /etc/postgresql/pg_hba.conf
local        all                                           trust
host         all         127.0.0.1     255.0.0.0           trust

2. Add a temp user
# su - postgres
# createuser tmpuser

3. Login and add a real user with password
# psql -U tmpuser template1
and
CREATE USER tommaso WITH PASSWORD 'pippo' CREATEDB CREATEUSER;

4. Modify again the conf: /etc/postgresql/pg_hba.conf
local        all                                           password
host         all         127.0.0.1     255.0.0.0           password

5. try login (with success in a shell)

......................................

my /etc/phppgadmin/apache.conf


Alias /phppgadmin /usr/share/phppgadmin/

<DirectoryMatch /usr/share/phppgadmin/>

Options +FollowSymLinks
AllowOverride None

order deny,allow
deny from all
allow from 127.0.0.0/255.0.0.0
allow from 192.168.77.0/255.255.255.0
# allow from all

<IfModule mod_php4.c>
php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals On
php_value include_path .
</IfModule>

</DirectoryMatch>


#<Directory /usr/share/phpmyadmin/>
#    AllowOverride All
#</Directory>
#
#<Directory /var/www/phpmyadmin/>
#    AllowOverride All
#</Directory>





[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 03:42 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register