Doc #77886 [NEW]: using host in dsn string
| From: | ch dot derenne at gmail dot com | 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