pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: kmh496 <kmh496@kornet.net>
To: pgsql-php@postgresql.org
Subject: can somebody show me a MDB2 dsn with port number?
Date: Sun, 21 May 2006 02:49:29 +0900
Message-ID: <1148147370.7568.30.camel@var.sirfsup.com> (raw)

hello pgsql-php,

i looked for a sample of MDB2 dsn array with port number, couldn't find
one.
my dsn without it is:
$dsn_postgresql=array(
    'phptype' => "pgsql",
    'username' => $pg_username,
    'password' => $pg_password,
    'hostspec' => "localhost",
    'database' => $pg_database
);
$options = array(
    'debug'       => 9,
    'portability' => DB_PORTABILITY_ALL,
);

the MDB2 docs have just


Most variations are allowed: 


1     phptype://username:password@protocol+hostspec:110//usr/db_file.db?mode=0644
2       phptype://username:password@hostspec/database_name
3       phptype://username:password@hostspec
4       phptype://username@hostspec
5       phptype://hostspec/database
6       phptype://hostspec
7       phptype(dbsyntax)
8       phptype

* I don't see PORTNUMBER in there anywhere*

"Additional keys can be added by appending a URI query string to the end
of the DSN."
what does that mean?


and my connect call is

    global $dsn_mysql,$dsn_postgresql,$DEBUG_DICT_CONNECT,$options;
    // default has always been mysql, if (!$dsn) $dsn = $dsn_mysql;
    // if (!$dsn) $dsn = $dsn_postgresql;
    if (!$dsn) $dsn = $dsn_mysql;
    // Retries connection to server 5 times.
    if ($DEBUG_DICT_CONNECT) echo "dsn = " . print_r($dsn) . "<br>";
    if ($DEBUG_DICT_CONNECT) echo "dsn = " . print_r($dsn) . "<br>";
    $db = MDB2::connect($dsn,$options);


I have tried   
$pg_options = array(
    'portnumber'       => 5534,
    'debug'       => 9,
    'portability' => DB_PORTABILITY_ALL,
);

but connection fails.



can somebody cut and paste me one please?
thanks everybody.
joseph.









view thread (3+ messages)  latest in thread

Message-ID: <1148147370.7568.30.camel@var.sirfsup.com>
Permalink:  ../1148147370.7568.30.camel@var.sirfsup.com/
Also on:    postgresql.org/message-id/1148147370.7568.30.camel@var.sirfsup.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: kmh496@kornet.net
  Subject: Re: can somebody show me a MDB2 dsn with port number?
  In-Reply-To: <1148147370.7568.30.camel@var.sirfsup.com>
  References: <1148147370.7568.30.camel@var.sirfsup.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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