Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 327A11327A98 for ; Sun, 29 Jul 2012 19:26:29 -0300 (ADT) Received: from [89.150.129.84] (helo=smtp.fullrate.dk) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SvbwR-00039O-RK for pgsql-php@postgresql.org; Sun, 29 Jul 2012 22:26:28 +0000 Received: from naim-work (4304ds5-ynoe.0.fullrate.dk [90.185.143.98]) by smtp.fullrate.dk (Postfix) with ESMTP id D8D799D386 for ; Mon, 30 Jul 2012 00:26:14 +0200 (CEST) Date: Mon, 30 Jul 2012 00:26:13 +0200 From: Rico Secada To: pgsql-php@postgresql.org Subject: Re: Cannot login using phpPgAdmin Message-ID: <20120730002613.6dde343c@naim-work> In-Reply-To: References: X-Mailer: Claws Mail 3.7.6 (GTK+ 2.20.1; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Host-Lookup-Failed: Reverse DNS lookup failed for 89.150.129.84 (failed) X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201207/7 X-Sequence-Number: 4265 On Sat, 28 Jul 2012 16:45:55 +0530 Archana K N wrote: > Hello, >=20 > 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. >=20 > Is this a problem with the phppgadmin? I'm always having the same problem with phpPgAdmin anytime I install it!=20 Here's the solution I use on Debian: First create the file /etc/apache2/conf.d/phppgadmin: Alias /phppgadmin /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 php_flag magic_quotes_gpc Off php_flag track_vars On php_value include_path . Next, get the latest snapshot: $ git clone git://github.com/phppgadmin/phppgadmin.git Move the downloaded contens to /usr/share/phppgadmin By default the =E2=80=9Chost=E2=80=9D option is set for UNIX domain socket,= you need to change that for TCP/IP connections. In config.inc.php:=20 $conf['servers'][0]['desc'] =3D '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'] =3D 'localhost'; // Database port on server (5432 is the PostgreSQL default) $conf['servers'][0]['port'] =3D 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.=20 >=20 > regards