pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedCannot 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