By nyx on

Hi.

I am trying to install drupal into postgresql. I am having some issues getting my db_url string correct.

The problem I have is that i HAVE to use unix sockets, my hosting partner does not allow the use of tcp.ip based connections. Thus life is getting difficult.

When i put in ie. $db_url = 'pgsql://user:pass@localhost/user_drupal'; ofcourse it tries to connect to localhost on port 5432.

"Unable to connect to PostgreSQL server: could not connect to server: Operation timed out Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? "

I have tried things like $db_url = 'pgsql://user:pass@unix(/tmp)/user_drupal'; and i get things like ....

Unable to connect to PostgreSQL server: could not translate host name "unix(" to address: No address associated with hostname

please help, im at the point of it doesnt look like I can run drupal :(

php version == 4.3.10
apache = apache2++
os == freebsd
postgresql = 7.4

ive tried 4.5.2 and no go.. im using the 4.6.0 RC at the moment...

someone please help :)

Comments

suzanne.aldrich’s picture

suzanne.aldrich commented

Hi nyx. I was having the same problem too, until I annoyed my hosting admin about it enough that he hacked up a version of drupal's includes/database.pgsql.inc for me. The bug is reported in this node (check out the attachment for an explanation of the problem). Here is the hacked db_connect function:

function db_connect($url) {
  //$url = parse_url($url);
  $b = Array();
  $conn_string = '';

  if (preg_match('/^pgsql:\/\/(\w+)@/',$url, &$b)) {
        $conn_string .= " user='$b[1]'";
  } else if (preg_match('/^pgsql:\/\/(\w+):(\w+)@/',$url, $b)) {
        $conn_string .= " user='$b[1]' password='$b[2]'";
  }
  if (preg_match('/^pgsql:\/\/(?:[^@]*@)?(\w+)\//', $url, $b)) {
        $conn_string .= ($b[1]) ?
                " host='$b[1]'" : 
                " host='/var/run/postgresql'" ;
  }
  if (preg_match('/^pgsql:\/\/[^\/]*\/(\w+)/', $url, $b)) {
        $conn_string .= " dbname='$b[1]'";
  }

  $connection = pg_connect($conn_string) or die(pg_last_error());

  return $connection;

}

Hope this helps! Once I got drupal up and going, all the torture and suffering seemed worth it. My main problems always seem to be with either Postgresql table and sequence permissions, and unix filesystem permissions. Once those were set up, the base install seemed to work very well. My main gripe right now is trying to get image.module to work, but that's a whole new ordeal...