Re: DB Error: connect failed [SOLVED]

On Thu, 2005-02-03 at 01:42 -0500, Tom Lane wrote:
> Dunno about phpPgAdmin, but psql defaults to connecting through a Unix
> socket, which doesn't have either of the above risks.
>

I *thought* I was connecting to the Unix socket, so of course such a
thing should not have been a problem. I went back to the DSN array I had
written after your message and (after a little trial and error) figured
out to add "'protocol' => 'unix'" as one of the values in the array. The
final (working) DSN array and connect process was:

          $dsn = array('phptype'  => 'pgsql',
                       'username' => 'simpatic_www',
                       'password' => 'gottago',
                       'protocol' => 'unix',
                       'hostspec' => 'localhost',
                       'database' => 'simpatic_logbook'
          );
          $options = array('debug'       => 2,
                           'portability' => DB_PORTABILITY_ALL
          );
          $db =& DB::connect($dsn, $options);
          if (DB::isError($db)) { die($db->getMessage()); }

The connect *appears* to have worked fine, since I then get a page with
no database output (I've made no queries) but also no errors. So I'm
guessing the connect is done... thanks!

Of course, everything immediately broke again when I tried a query.  But
after a little time with the PEAR manual, and googling for bizarre
errors I would never have expected, the thing works. I have a simple
query that returns one value, but it's working! I now have only two
small details that pique my curiosity:

  1. What is "debug=2" and do I need it? Happy to RTFM... URL to FM?

  2. What is the significance of "=&" instead of "="? I can't find an
     explanation anywhere.

My thanks to everyone who has helped me get over this first hump in my
PostgreSQL usage.

--
Rodolfo J. Paiz <rpaiz@simpaticus.com>