Connecting to PGSQL over SSL via Red Bean PHP

16 views
Skip to first unread message

no name

unread,
Jul 31, 2021, 5:58:03 AM7/31/21
to redbeanphp
$dbh = new PDO('pgsql:localhost=host;port=26257;dbname=bank;sslmode=require;sslcert=[path]/client.maxroach.crt;sslkey=[path]/client.maxroach.key;sslrootcert=[path]/ca.crt;', 'maxroach', null, array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_EMULATE_PREPARES => true, ));

This a pdo method, i need configure red bean connection for ssl pgsql connection

R::setup( "pgsql:host=$ip;port=$port;dbname=$dbname",$user, $password, $frozen ); ?

gabor

unread,
Jul 31, 2021, 1:11:20 PM7/31/21
to redbeanphp
You can set a custom PDO instance like this:

gabor

unread,
Jul 31, 2021, 1:12:20 PM7/31/21
to redbeanphp
Also manual wiring:
Reply all
Reply to author
Forward
0 new messages