Can't connect to a neo4j aura instance with pdo_bolt

[Division70]

Hello !

I'm trying to work with pdo_bolt connection with an neo4j aura instance.

Here's my code :

$pdo = new \pdo_bolt\PDO('bolt:host=1c27354c.databases.neo4j.io;port=7687;appname=pdo-bolt', 'neo4j', ''); $stmt = $pdo->prepare('MATCH (m:Movie) RETURN m.title AS title ORDER BY m.title ASC LIMIT $n'); $stmt->bindValue('n', 123, \PDO::PARAM_INT); $stmt->execute(); $stmt->setFetchMode(\PDO::FETCH_ASSOC); foreach ($stmt AS $row) { print_r($row); }

Connection is refused, if have an error from

[app/src/Bolt/Bolt.php:52] Bolt\connection\Socket->connect() [app/src/pdo_bolt/drivers/bolt/Driver.php:107] Bolt\Bolt->build() [app/src/pdo_bolt/PDO.php:68] pdo_bolt\drivers\bolt\Driver->__construct() [app/controllers/MainController.php:16] pdo_bolt\PDO->__construct() [lib/base.php:1955] MainController->render()

Thanks for your help.

Best.

C

[stefanak-michal]

Hi.

When you want to connect to aura you require SSL. You can enable it with $options in PDO constructor. You can read about it in readme https://github.com/stefanak-michal/pdo-bolt#pdo-constructor-available-options

So your line will look like this:

$pdo = new \pdo_bolt\PDO('bolt:host=1c27354c.databases.neo4j.io;port=7687;appname=pdo-bolt', 'neo4j', 'password', ['ssl' => ['verify_peer' => true]]);

[Division70]

Hello !

Thanks for your reply. I still have an error to connect but, now, it runs StreamSocket->connect().

[app/src/Bolt/Bolt.php:52] Bolt\connection\StreamSocket->connect() [app/src/pdo_bolt/drivers/bolt/Driver.php:107] Bolt\Bolt->build() [app/src/pdo_bolt/PDO.php:68] pdo_bolt\drivers\bolt\Driver->__construct() [app/controllers/MainController.php:16] pdo_bolt\PDO->__construct()

I checked my php config (PHP 8.0). Sockets and open ssl are enabled as well as Registered Stream Socket Transports | tcp, udp, unix, udg, ssl, sslv3, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3

Maybe i've make a mistake on the format ?

Thanks for your help.

Best.

Christophe

[stefanak-michal]

Do you still get timeout error? More info will be nice.

You don't need ext-sockets if you use SSL, because StreamSocket use native php stream functions. Only openssl is required. Your list of available transports is okay, it should use TLS (i think).