RE: [cobalt-users] [RaQ4] phpPgAdmin goes *boink*

["J. Patrick Lanigan" <patl@xxxxxxxxxxx>]

For those who may be interested.

PostgreSQL on the RaQ3 is NOT listening on port 5432 by default so you need
to start the postmaster with -p 5432 so that phpPgAdmin can hit it. (Or
change the port phpPgAdmin hits, but that seemed like more work to figure
out to me.)

More importantly I found that I still couldn't get in. The reason: I always
use mixed case alphanumeric passwords. The passwords in PostgreSQL, at least
the stock version on the RaQ3, doesn't pay attention to case. So when I
entered the password to get in I was denied. But if I entered the password
in all lowercase, even though that is not what I set it to, I got in.

HTH,
Patrick

> J. Patrick Lanigan wrote:
>
> I am having a problem as well. I did compile php with PostgreSQL
> support and I have verified with phpinfo(). This is the error I
> get When I try to access psql through phpPgAdmin:
>
> Warning: Unable to connect to PostgreSQL server: connectDB() --
> connect() failed: Connection refused Is the postmaster running at
> 'localhost' and accepting connections on Unix socket '5432'? in
> /home/sites/site2/web/dbadmin/phpPgAdmin/lib.inc.php on line 196
> Error - /home/sites/site2/web/dbadmin/phpPgAdmin/lib.inc.php -- Line: 224
> PostgreSQL said: Unable to connect to server
>
> Any ideas?
>
> Thanks,
> J. Patrick Lanigan - Web Developer
> -------------------------------------
>  w: http://www.laniganonline.com/
> -------------------------------------
>
> > "The A-Team" <propylon@xxxxxxxxxxxxxxxxxxxx> wrote:
> > >  1. phpMyAdmin access WHAT in order to admin the seperate
> databases? The
> > > reason I ask this is because if you don't designate a DB via
> > config.inc.php
> > > for MyAdmin it will see all the DB's.
> >
> > If you specify the advanced auth info. you can limit access to
> > users in the
> > mysql user table and they will only be able to access DBs they have
> > privileges for.
> >
> > > Oh, one final thing, when I try and login with any user at
> phpPgAdmin it
> > > gives me the return:
> > >
> > > Fatal error: Call to undefined function: pg_connect() in
> > > /home/sites/home/users/opaque/web/phpPgAdmin/lib.inc.php on line 196
> >
> > This means that PHP is not compiled with PostgreSQL support.  To verify,
> > create a script containing <?php phpinfo(); ?>, view the output
> > and look at
> > the configuration section and PostgreSQL section if one exists.
>