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.
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