Doc #77886 [NEW]: using host in dsn string

From: Date: Sat, 13 Apr 2019 16:19:42 +0000
Subject: Doc #77886 [NEW]: using host in dsn string
Groups: php.doc.bugs 
Request: Send a blank email to doc-bugs+get-16568@lists.php.net to get a copy of this message
From: ch dot derenne at gmail dot com Operating system: fedora28 PHP version: 7.3.4 Package: PDO Firebird Bug Type: Documentation Problem Bug description:using host in dsn string 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 bug report at https://bugs.php.net/bug.php?id=77886&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=77886&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=77886&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=77886&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=77886&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=77886&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=77886&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=77886&r=needscript Try newer version: https://bugs.php.net/fix.php?id=77886&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=77886&r=support Expected behavior: https://bugs.php.net/fix.php?id=77886&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=77886&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=77886&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=77886&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=77886&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=77886&r=dst IIS Stability: https://bugs.php.net/fix.php?id=77886&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=77886&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=77886&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=77886&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=77886&r=mysqlcfg

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