Doc #77886 [Opn->Nab]: using host in dsn string

From: Date: Sat, 13 Apr 2019 16:45:39 +0000
Subject: Doc #77886 [Opn->Nab]: using host in dsn string
References: 1  Groups: php.doc.bugs 
Request: Send a blank email to doc-bugs+get-16569@lists.php.net to get a copy of this message
Edit report at https://bugs.php.net/bug.php?id=77886&edit=1 ID: 77886 Updated by: salathe@php.net Reported by: ch dot derenne at gmail dot com Summary: using host in dsn string -Status: Open +Status: Not a bug Type: Documentation Problem Package: PDO Firebird Operating System: fedora28 PHP Version: 7.3.4 Block user comment: N Private report: N New Comment: Details on the DSN for the Firebird PDO driver is available at https://www.php.net/manual/en/ref.pdo-firebird.connection.php Previous Comments: ------------------------------------------------------------------------ [2019-04-13 16:19:42] ch dot derenne at gmail dot com Description: ------------ --- From manual page: https://php.net/index --- In all documentation of PDO we see that host is the database host and path is the local database path relative to the host But using this with firebird issues that database file is not found (of course, if host is not localhost) In fact, searching in firebirdsql.org website, we see that we don't care about host, we have to use a database patch like hostname:databasepath So why not using same syntaxe whatever firebird, mysql or other database ? Or best : detecting if we ar eusing the host variable or not ? We've spent one hour to find what was wrong Test script: --------------- $host="10.1.15.2" $databasepath="/var/lib/firebird/data/db.fdb"; $usn="SYSDBA"; $psw="masterke"; $str_conn="firebird:host=".$host.";dbname=".$host.":".$databasepath.";charset=ISO8859_1;role=".$role; try { $db = new PDO($str_conn, $usn, $psw); } catch(PDOException $e) { die ('ERREUR PDO dans ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage()); } echo "connexion ok" Expected result: ---------------- connexion ok Actual result: -------------- PDO Error (file not found) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=77886&edit=1

« previous php.doc.bugs (#16569) next »