PHP insert document mLab

Question

I'm new at mLab and trying to insert same simple documents to my mongodb on mLab. First of all I was able to insert some documents to the database using the shell (command line) anytime I run the code I get this error:

Fatal error: Uncaught MongoDB\Driver\Exception\ConnectionTimeoutException:
No suitable servers found (`serverSelectionTryOnce` set): [connection timeout calling ismaster on 'ds157390.mlab.com:57390'] in C:\xampp\htdocs\MongoDB\vendor\mongodb\mongodb\src\Collection.php:726 
Stack trace: #0 C:\xampp\htdocs\MongoDB\vendor\mongodb\mongodb\src\Collection.php(726): MongoDB\Driver\Manager->selectServer(Object(MongoDB\Driver\ReadPreference)) 
#1 C:\xampp\htdocs\MongoDB\azureConnect.php(46): MongoDB\Collection->insertMany(Array) #2 {main} thrown in C:\xampp\htdocs\MongoDB\vendor\mongodb\mongodb\src\Collection.php on line 726

PHP-Code:

<?php

ini_set('max_execution_time', 0);

require 'vendor/autoload.php';

$seedData = array(
  array(
    'decade' => '1970s',
    'artist' => 'Debby Boone',
    'song' => 'You Light Up My Life',
    'weeksAtOne' => 10
),
array(
    'decade' => '1980s',
    'artist' => 'Olivia Newton-John',
    'song' => 'Physical',
    'weeksAtOne' => 10
),
array(
    'decade' => '1990s',
    'artist' => 'Mariah Carey',
    'song' => 'One Sweet Day',
    'weeksAtOne' => 16
),
 );

 $uname = "test";
 $pword = "test";
 $uri = "mongodb://".$uname.":".$pword."@ds157390.mlab.com:57390/data4estate";

 $conn = new MongoDB\Client($uri);

 $songs = $conn->data4estate->songs;

 $songs->insertMany($seedData);

Community · Accepted Answer · 2017-05-23 12:25:33Z

0

Try to follow instruction for connection timout:

https://blog.mlab.com/2013/10/do-you-want-a-timeout/

Try to set timeout option to connection string https://docs.mongodb.com/manual/reference/connection-string/#uri.connectTimeoutMS

$uri = "mongodb://".$uname.":".$pword."@ds157390.mlab.com:57390/data4estate?connectTimeoutMS=300000";

You can set the socketTimeoutMS on php MongoClient as answered here: PHP MongoDb driver: How to set timeout for executing a code

edited May 23, 2017 at 12:25

CommunityBot

11 silver badge

answered Apr 10, 2017 at 8:52

mvladk

6281 gold badge19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP insert document mLab

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related