On 28/9/21 6:59 pm, Mathias Zarick wrote:
Hi there, I am wondering how it would be possible to use authentication using a secure external password store aka wallet with PDO OCI. See Oracle external authentication and OCI_CRED_EXT in the underground php oracle manual. and https://docs.oracle.com/en/database/oracle/oracle-database/19/dbseg/configuring-authentication.html#GUID-803496D2-19C7-4F02-94EC-C13EDD8FB17B (jump to chapter 3.2.9) Following works fine with oci8: $conn = oci_connect('/', '', $db, 'UTF8',OCI_CRED_EXT); note the OCI_CRED_EXT! But how can pass that option to a PDO OCI connection? Following might be close, but does not work: $opt = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_NUM, 'session_mode' => OCI_CRED_EXT, ]; try{ $conn = new PDO("oci:dbname=".$db.';charset=UTF8', "/","", $opt); } catch(PDOException $e){ echo ($e->getMessage()); } Is it possible at all?
You can see in the PDO_OCI source code there is no reference to the OCI_CRED_EXT constant which is needed to tell the Oracle client libraries to use external authentication.
PR's are welcome. For the moment stick with OCI8. In general, native drivers (e.g OCI8) will be better than any of the PDO abstractions. Chris
Thanks in Advance Mathias Zarick
-- https://twitter.com/ghrd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
