PHP SSL connection to MongoDB

Michal_Giza · 2021-07-04T05:28:49.738Z

Hi, I use DigitalOcean MongoDB cluster. Here is my connection string that works:

mongodb+srv://doadmin:[password]@[app]-ad319710.mongo.ondigitalocean.com/aircraft?authSource=admin&replicaSet=[app]&tls=true&tlsCAFile=/usr/share/ca-certificates/app/ca-certificate.crt

Rafael_Green · 2021-07-04T09:13:25.796Z

try this:

$client = new MongoDB\Client(
‘mongodb+srv://doadmin:[password]@[app]-ad319710.mongo.ondigitalocean.com/aircraft?authSource=admin&replicaSet=[app]&tls=true&tlsCAFile=/usr/share/ca-certificates/app/ca-certificate.crt’
);

$db = $client->[database];

Michal_Giza · 2021-07-04T09:27:03.593Z

Now I’m getting: Parse error : syntax error, unexpected ‘:’, expecting ‘)’ in line with your code

Rafael_Green · 2021-07-04T09:28:12.754Z

try this:

$client = new MongoDB\Client('mongodb+srv://doadmin:[password]@[app]-ad319710.mongo.ondigitalocean.com/aircraft?authSource=admin&replicaSet=[app]&tls=true&tlsCAFile=/usr/share/ca-certificates/app/ca-certificate.crt');

Michal_Giza · 2021-07-04T09:29:25.746Z

PHP code is valid but again: Fatal error : Uncaught MongoDB\Driver\Exception\ConnectionTimeoutException: No suitable servers found

Rafael_Green · 2021-07-04T09:30:04.156Z

what are you getting if you run this?

ping [app]-ad319710.mongo.ondigitalocean.com

Michal_Giza · 2021-07-04T09:32:03.084Z

ping: [app]-ad319710.mongo.ondigitalocean.com: No address associated with hostname

When I use the certificate in the Mongo client, I connect normally and can work with the database

Rafael_Green · 2021-07-04T09:34:44.830Z

are you able to connect when ssl is disabled?

have you tried reading this PHP error: No suitable servers found?

Michal_Giza · 2021-07-04T09:41:59.393Z

I don’t use SELinux as they mentioned in PHP error: No suitable servers found

Without TLS:

{“t”:{“$date”:“2021-07-04T09:41:18.687Z”},“s”:“E”, “c”:“NETWORK”, “id”:23256, “ctx”:“ReplicaSetMonitor-TaskExecutor”,“msg”:“SSL peer certificate validation failed”,“attr”:{“error”:“SSL peer certificate validation failed: self signed certificate in certificate chain”}}

Rafael_Green · 2021-07-04T09:45:23.070Z

Michal_Giza:

Hi, I use DigitalOcean MongoDB cluster. Here is my connection string that works:

mongodb+srv://doadmin:[password]@[app]-ad319710.mongo.ondigitalocean.com/aircraft?authSource=admin&replicaSet=[app]&tls=true&tlsCAFile=/usr/share/ca-certificates/app/ca-certificate.crt