can somebody show me a MDB2 dsn with port number?

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_fi le.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) . "
";
if ($DEBUG_DICT_CONNECT) echo "dsn = " . print_r($dsn) . "
";
$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.







---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: can somebody show me a MDB2 dsn with port number?

greetings,

your question would be more appropriate to one of the PEAR lists, but I
will answer it anyway.

On Sun, 2006-05-21 at 02:49 +0900, kmh496 wrote:
> 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_fi le.db?mode=0644
[..snipped..]
> can somebody cut and paste me one please?
> thanks everybody.
> joseph.

http://pear.php.net/manual/en/package.database.mdb2.intro-ds n.php

specifically, look at the line that describes the "hostspec" ("Host
Specification").

regards,
J
--
Jeff MacDonald
Zoid Technologies, http://zoidtechnologies.com/


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: can somebody show me a MDB2 dsn with port number?

On Sun, 2006-05-21 at 02:49 +0900, kmh496 wrote:
> hello pgsql-php,
>
> i looked for a sample of MDB2 dsn array with port number, couldn't find
> one.
[..snipped..]
> can somebody cut and paste me one please?
> thanks everybody.
> joseph.

see http://pear.php.net/manual/en/package.database.mdb2.intro-ds n.php
example 33-2 towards the bottom of the page.

regards,
J
--
Jeff MacDonald
Zoid Technologies, http://zoidtechnologies.com/


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org