pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Cannot login using phpPgAdmin
10+ messages / 7 participants
[nested] [flat]

* Cannot login using phpPgAdmin
@ 2012-07-28 11:15 Archana K N <archanakknn@gmail.com>
  2012-07-28 11:54 ` Re: Cannot login using phpPgAdmin Devrim GÜNDÜZ <devrim@gunduz.org>
  2012-07-28 11:57 ` Re: Cannot login using phpPgAdmin Raymond O'Donnell <rod@iol.ie>
  2012-07-29 22:26 ` Re: Cannot login using phpPgAdmin Rico Secada <coolzone@it.dk>
  0 siblings, 3 replies; 10+ messages in thread

From: Archana K N @ 2012-07-28 11:15 UTC (permalink / raw)
  To: pgsql-php

Hello,

      I am having a problem with login in phppgadmin. I can connect to
postgres using pgadmin 3 (from remote system also). But when am using
phppgadmin it always shows "*Login Failed*". I tried several ways like
changing php.ini file and pg_hba.conf nothing is working.

Is this a problem with the phppgadmin?


regards

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
@ 2012-07-28 11:54 ` Devrim GÜNDÜZ <devrim@gunduz.org>
  2 siblings, 0 replies; 10+ messages in thread

From: Devrim GÜNDÜZ @ 2012-07-28 11:54 UTC (permalink / raw)
  To: Archana K N <archanakknn@gmail.com>; +Cc: pgsql-php


Hi,

On Sat, 2012-07-28 at 16:45 +0530, Archana K N wrote:

>       I am having a problem with login in phppgadmin. I can connect to
> postgres using pgadmin 3 (from remote system also). But when am using
> phppgadmin it always shows "*Login Failed*". 

If you are trying to login with postgres user, then phpPgAdmin won't
allow you to login. Check config.php for details.

I also saw some login issues with recent PHP versions, but I did not
have time to track the issue.

Regards,
-- 
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Attachments:

  signature.asc (application/pgp-signature, 197B) download

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
@ 2012-07-28 11:57 ` Raymond O'Donnell <rod@iol.ie>
  2012-07-28 12:25   ` Re: Cannot login using phpPgAdmin Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
  2 siblings, 1 reply; 10+ messages in thread

From: Raymond O'Donnell @ 2012-07-28 11:57 UTC (permalink / raw)
  To: Archana K N <archanakknn@gmail.com>; +Cc: pgsql-php

On 28/07/2012 12:15, Archana K N wrote:
> 
> Hello,
> 
>       I am having a problem with login in phppgadmin. I can connect to
> postgres using pgadmin 3 (from remote system also). But when am using
> phppgadmin it always shows "/Login Failed/". I tried several ways like
> changing php.ini file and pg_hba.conf nothing is working.

When you logged in successfully from pgAdmin, were you using the same
username/password combination that failed in phpPgAdmin?

What do the PostgreSQL logs show?

What did you change in php.ini and pg_hba.conf?

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-28 11:57 ` Re: Cannot login using phpPgAdmin Raymond O'Donnell <rod@iol.ie>
@ 2012-07-28 12:25   ` Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Hartmut Holzgraefe @ 2012-07-28 12:25 UTC (permalink / raw)
  To: pgsql-php

On 28.07.2012 13:57, Raymond O'Donnell wrote:

> When you logged in successfully from pgAdmin, were you using the same
> username/password combination that failed in phpPgAdmin?

and originating from the same host/interface? ...

-- 
hartmut




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
@ 2012-07-29 22:26 ` Rico Secada <coolzone@it.dk>
  2012-07-30 04:51   ` Re: Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2 siblings, 1 reply; 10+ messages in thread

From: Rico Secada @ 2012-07-29 22:26 UTC (permalink / raw)
  To: pgsql-php

On Sat, 28 Jul 2012 16:45:55 +0530
Archana K N <archanakknn@gmail.com> wrote:

> Hello,
> 
>       I am having a problem with login in phppgadmin. I can connect to
> postgres using pgadmin 3 (from remote system also). But when am using
> phppgadmin it always shows "*Login Failed*". I tried several ways like
> changing php.ini file and pg_hba.conf nothing is working.
> 
> Is this a problem with the phppgadmin?

I'm always having the same problem with phpPgAdmin anytime I install
it! 

Here's the solution I use on Debian:

First create the file /etc/apache2/conf.d/phppgadmin:

Alias /phppgadmin /usr/share/phppgadmin/

<Directory /usr/share/phppgadmin/>
DirectoryIndex index.php

Options +FollowSymLinks
AllowOverride None

order deny,allow
deny from all
allow from 127.0.0.0/255.0.0.0 ::1/128
 allow from all

<IfModule mod_php5.c>
  php_flag magic_quotes_gpc Off
  php_flag track_vars On
  php_value include_path .
</IfModule>
</Directory>

Next, get the latest snapshot:

$ git clone git://github.com/phppgadmin/phppgadmin.git

Move the downloaded contens to /usr/share/phppgadmin

By default the “host” option is set for UNIX domain socket, you need to
change that for TCP/IP connections. In config.inc.php: 

$conf['servers'][0]['desc'] = 'PostgreSQL';

// Hostname or IP address for server.  Use '' for UNIX domain socket.
// use 'localhost' for TCP/IP connection on this computer
$conf['servers'][0]['host'] = 'localhost';

// Database port on server (5432 is the PostgreSQL default)
$conf['servers'][0]['port'] = 5432;

Restart Apache:

# /etc/init.d/apache2 restart

You can now access it using: http://whatever.com/phppgadmin/

You can login using whatever account has been setup on PostgreSQL. 
> 
> regards



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-29 22:26 ` Re: Cannot login using phpPgAdmin Rico Secada <coolzone@it.dk>
@ 2012-07-30 04:51   ` Archana K N <archanakknn@gmail.com>
  2012-07-30 09:30     ` Re: Cannot login using phpPgAdmin Raymond O'Donnell <rod@iol.ie>
  2012-08-02 01:18     ` Re: Cannot login using phpPgAdmin my extraidentity <myextraidentity@hotmail.com>
  0 siblings, 2 replies; 10+ messages in thread

From: Archana K N @ 2012-07-30 04:51 UTC (permalink / raw)
  To: Rico Secada <coolzone@it.dk>; +Cc: pgsql-php

Hi,

      I used the same password and username while using pgadmin3. Even in
the same machine the phppgadmin is not working.

 In pg_hba.conf I added the a client machine's ip address and all.


Regards

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-29 22:26 ` Re: Cannot login using phpPgAdmin Rico Secada <coolzone@it.dk>
  2012-07-30 04:51   ` Re: Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
@ 2012-07-30 09:30     ` Raymond O'Donnell <rod@iol.ie>
  2012-07-30 10:42       ` Re: Cannot login using phpPgAdmin Andy Anderson <aanderson@amherst.edu>
  1 sibling, 1 reply; 10+ messages in thread

From: Raymond O'Donnell @ 2012-07-30 09:30 UTC (permalink / raw)
  To: Archana K N <archanakknn@gmail.com>; +Cc: Rico Secada <coolzone@it.dk>; pgsql-php

On 30/07/2012 05:51, Archana K N wrote:
> 
> Hi,
> 
>       I used the same password and username while using pgadmin3. Even
> in the same machine the phppgadmin is not working.
> 
>  In pg_hba.conf I added the a client machine's ip address and all.

As Devrim pointed out, by default phpPgAdmin doesn't let you log in as a
superuser. Would this be your problem?

Also, I think usernames and passwords may be case-sensitive; not sure
about this.

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-29 22:26 ` Re: Cannot login using phpPgAdmin Rico Secada <coolzone@it.dk>
  2012-07-30 04:51   ` Re: Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-30 09:30     ` Re: Cannot login using phpPgAdmin Raymond O'Donnell <rod@iol.ie>
@ 2012-07-30 10:42       ` Andy Anderson <aanderson@amherst.edu>
  2012-07-30 11:01         ` Re: Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  0 siblings, 1 reply; 10+ messages in thread

From: Andy Anderson @ 2012-07-30 10:42 UTC (permalink / raw)
  To: pgsql-php

Is there a % in your password? I’ve had trouble in the past with such passwords in Postgres, though I don’t recall the exact context.

-- Andy

On Jul 30, 2012, at 5:30 AM, Raymond O'Donnell wrote:

> On 30/07/2012 05:51, Archana K N wrote:
>> 
>> Hi,
>> 
>>      I used the same password and username while using pgadmin3. Even
>> in the same machine the phppgadmin is not working.
>> 
>> In pg_hba.conf I added the a client machine's ip address and all.
> 
> As Devrim pointed out, by default phpPgAdmin doesn't let you log in as a
> superuser. Would this be your problem?
> 
> Also, I think usernames and passwords may be case-sensitive; not sure
> about this.
> 
> Ray.
> 
> 
> -- 
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
> 
> -- 
> Sent via pgsql-php mailing list (pgsql-php@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-php




^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-29 22:26 ` Re: Cannot login using phpPgAdmin Rico Secada <coolzone@it.dk>
  2012-07-30 04:51   ` Re: Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-30 09:30     ` Re: Cannot login using phpPgAdmin Raymond O'Donnell <rod@iol.ie>
  2012-07-30 10:42       ` Re: Cannot login using phpPgAdmin Andy Anderson <aanderson@amherst.edu>
@ 2012-07-30 11:01         ` Archana K N <archanakknn@gmail.com>
  0 siblings, 0 replies; 10+ messages in thread

From: Archana K N @ 2012-07-30 11:01 UTC (permalink / raw)
  To: Andy Anderson <aanderson@amherst.edu>; +Cc: pgsql-php

Hi,

     No i dont have a '%' in the password. When i try to access postgres
using
"http://localhost/phppgadmin"; it goes to the main page to log in . But
whatever I did till now am not able to log into postgres successfully.


regards

^ permalink  raw  reply  [nested|flat] 10+ messages in thread

* Re: Cannot login using phpPgAdmin
  2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
  2012-07-29 22:26 ` Re: Cannot login using phpPgAdmin Rico Secada <coolzone@it.dk>
  2012-07-30 04:51   ` Re: Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
@ 2012-08-02 01:18     ` my extraidentity <myextraidentity@hotmail.com>
  1 sibling, 0 replies; 10+ messages in thread

From: my extraidentity @ 2012-08-02 01:18 UTC (permalink / raw)
  To: Archana K N <archanakknn@gmail.com>; +Cc: Rico Secada <coolzone@it.dk>; pgsql-php

Below you stated:
" In pg_hba.conf I added the a client machine's ip address and all. "

Have you tried logging into it from that specific PC that was added?

If that doesn't work, go back into pg_hba.conf and remove your edits and see if that fixes the issue.

Mark


On Jul 29, 2012, at 11:52 PM, "Archana K N" <archanakknn@gmail.com> wrote:

> 
> Hi,
> 
>       I used the same password and username while using pgadmin3. Even in the same machine the phppgadmin is not working.
> 
>  In pg_hba.conf I added the a client machine's ip address and all. 
> 
> 
> Regards



^ permalink  raw  reply  [nested|flat] 10+ messages in thread


end of thread, other threads:[~2012-08-02 01:18 UTC | newest]

Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-07-28 11:15 Cannot login using phpPgAdmin Archana K N <archanakknn@gmail.com>
2012-07-28 11:54 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2012-07-28 11:57 ` Raymond O'Donnell <rod@iol.ie>
2012-07-28 12:25   ` Hartmut Holzgraefe <hartmut.holzgraefe@gmail.com>
2012-07-29 22:26 ` Rico Secada <coolzone@it.dk>
2012-07-30 04:51   ` Archana K N <archanakknn@gmail.com>
2012-07-30 09:30     ` Raymond O'Donnell <rod@iol.ie>
2012-07-30 10:42       ` Andy Anderson <aanderson@amherst.edu>
2012-07-30 11:01         ` Archana K N <archanakknn@gmail.com>
2012-08-02 01:18     ` my extraidentity <myextraidentity@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox