X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6031C9FA3A6 for ; Sat, 20 May 2006 15:12:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 24291-05 for ; Sat, 20 May 2006 15:12:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2B75E9FA279 for ; Sat, 20 May 2006 15:12:18 -0300 (ADT) Received: from mxsf36.cluster1.charter.net (mxsf36.cluster1.charter.net [209.225.28.161]) by svr4.postgresql.org (Postfix) with ESMTP id 382745B1EA0 for ; Sat, 20 May 2006 18:09:42 +0000 (GMT) Received: from mxip19a.cluster1.charter.net (mxip19a.cluster1.charter.net [209.225.28.149]) by mxsf36.cluster1.charter.net (8.12.11/8.12.11) with ESMTP id k4KI9bOv006501 for ; Sat, 20 May 2006 14:09:39 -0400 Received: from 24-197-119-161.dhcp.spbg.sc.charter.com (HELO toast.zoidtechnologies.com) ([24.197.119.161]) by mxip19a.cluster1.charter.net with ESMTP; 20 May 2006 14:09:37 -0400 X-IronPort-AV: i="4.05,150,1146456000"; d="scan'208"; a="343557354:sNHT57777448" Received: from dionysus.zoidtechnologies.com (dionysus.zoidtechnologies.com [192.168.2.9]) by toast.zoidtechnologies.com (Postfix) with ESMTP id C55F62070C0; Sat, 20 May 2006 14:09:36 -0400 (EDT) Subject: Re: can somebody show me a MDB2 dsn with port number? From: Jeff MacDonald To: kmh496 Cc: pgsql-php@postgresql.org In-Reply-To: <1148147370.7568.30.camel@var.sirfsup.com> References: <1148147370.7568.30.camel@var.sirfsup.com> Content-Type: text/plain Date: Sat, 20 May 2006 14:09:36 -0400 Message-Id: <1148148576.12905.13.camel@dionysus.zoidtechnologies.com> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-4.fc4) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/18 X-Sequence-Number: 3518 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_file.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-dsn.php specifically, look at the line that describes the "hostspec" ("Host Specification"). regards, J -- Jeff MacDonald Zoid Technologies, http://zoidtechnologies.com/