No suitable servers found (`serverselectiontryonce` set): [connection timeout calling ismaster on '127.0.0.1:3306']

[51yourdream]

No suitable servers found (serverselectiontryonce set): [connection timeout calling ismaster on '127.0.0.1:3306']

use Jenssegers\Mongodb\Eloquent\HybridRelations;
use Jenssegers\Mongodb\Eloquent\Model as Eloquent;

class Goods extends Eloquent
{
use HybridRelations;
protected $connection = 'mongodb';
// protected $connection = 'mysql';
protected $collection = 'tbke_goods';
// zk_final_price 价格
// volume 销量
// tk_rate //佣金比例
/**
* 批量往mongo中存入数据
* @param $datas
* @return bool
*/

[jaimeescano]

Hi lipengyihao,

I had the same issue, at the end ... I found that the issue was coming from the database.php file.
I suppose, you are using a MySQL server as default connection, so most likely, you have your .env file pointing to the mysql settings.

As you can see from the database.php, it will try to load the following settings for the mongodb connection:

    'mongodb' => [
        'driver'   => 'mongodb',
        'host'     => env('DB_HOST', 'localhost'),
        'port'     => env('DB_PORT', 27017),

So, it will try to check if there is a DB_PORT defined at the .env file (so ... laravel will find the port 3306) and load it from there, that's way you are getting the MySQL port.

So you can modify your database.php and set it as:

    'mongodb' => [
        'driver'   => 'mongodb',
        'host'     => env('DB_HOST', 'localhost'),
        'port'     => 27017,

Or define a new parameter at the .env file like:
DB_PORT_MONGO=27017
And then modify the database.php to load that parameter from your .env file.

Hope that helps.
Regards,
Jaime

[neroze]

Worked for me.
Thank you @jaimeescano

Cheers

[ayelen117]

Thanks @jaimeescano.

[yoedusvany]

Perfect, is that correct!!!!

[oaigudmundsson]

Hello
Not sure why but the solution above is not working.

database.php

'mongodb' => [
'driver' => 'mongodb',
'host' => env('MONGO_HOST'),
'port' => env('MONGO_PORT'),
'database' => env('MONGO_DATABASE'),
'username' => env('MONGO_USERNAME'),
'password' => env('MONGO_PASSWORD'),
],

.env file
MONGO_HOST="ds121212.mlab.com/abc"
MONGO_PORT="21212"
MONGO_DATABASE=abc
MONGO_USERNAME=abc_user
MONGO_PASSWORD=secret

Here is the error msg:
No suitable servers found (serverselectiontryonce set): [Failed connecting to 'ds121212.mlab.com:27017': Connection refused]

The port doesn't parse right as you can see. I can however make it connect by change the adding the port to HOST:
ds121212.mlab.com/abc => ds121212.mlab.com:21212/abc

So, why did it ignore the port?

Cheers

[jaimeescano]

Hi oaigudmundsson,

Try defining the port as integer value. Don't use double quotes. Probably mongo require a number and no a string.

Regards
Jaime

[oaigudmundsson]

Hello I did use as string and stilö same issue. Den 12 juni 2017 17:33 skrev "jaimeescano" <notifications@github.com>:

…

Hi oaigudmundsson, Try defining the port as integer value. Don't use double quotes. Probably mongo require a number and no a string. Regards Jaime — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#911 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAmzt9nunUkW2YK6yue7lU53gk6FNMZaks5sDVpIgaJpZM4JejBZ> .

[jaimeescano]

You mean, that you used as INTEGER? I suggested the opposite, to use INTEGER

.env file
MONGO_HOST="ds121212.mlab.com/abc"
MONGO_PORT=21212
MONGO_DATABASE=abc
MONGO_USERNAME=abc_user
MONGO_PASSWORD=secret

or for testing purposes, you could directly do the following:

database.php

'mongodb' => [
'driver' => 'mongodb',
'host' => env('MONGO_HOST'),
'port' => 21212,
'database' => env('MONGO_DATABASE'),
'username' => env('MONGO_USERNAME'),
'password' => env('MONGO_PASSWORD'),
],

[oaigudmundsson]

Sorry, i meant as int ans str. I did test both cases and it still didn't connect. Let me send some screenshot tomorrow. And yes, i did even type direct to database.php. Weird! Den 12 juni 2017 22:05 skrev "jaimeescano" <notifications@github.com>:

…

You mean, that you used as INTEGER? I suggested the opposite, to use INTEGER *.env file* MONGO_HOST="ds121212.mlab.com/abc" MONGO_PORT=21212 MONGO_DATABASE=abc MONGO_USERNAME=abc_user MONGO_PASSWORD=secret or for testing purposes, you could directly do the following: database.php 'mongodb' => [ 'driver' => 'mongodb', 'host' => env('MONGO_HOST'), 'port' => 21212, 'database' => env('MONGO_DATABASE'), 'username' => env('MONGO_USERNAME'), 'password' => env('MONGO_PASSWORD'), ], — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#911 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAmzt_2QAqAF0sUTMcAfI0wsHy5R_g51ks5sDZCtgaJpZM4JejBZ> .

[jaimeescano]

Have you tried to specify the port at the host parameter??

MONGO_HOST="ds121212.mlab.com:21212/abc"

Not sure, but if that works .. then the "abc" will need to be defined as replica set attribute

[oaigudmundsson]

yes, i did write on my first comment, that i got it work by ADDING the port on host string. Mongolabs host free sandbox and they don't have replica. Cheers Den 13 juni 2017 02:50 skrev "jaimeescano" <notifications@github.com>: Have you tried to specify the port at the host parameter?? MONGO_HOST="ds121212.mlab.com:21212/abc" Not sure, but if that works .. then the "abc" will need to be defined as replica set attribute — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#911 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAmzt_nHzFJEUh4sR6RHmcFH5TIO0aQtks5sDbyKgaJpZM4JejBZ> .

[oaigudmundsson]

Not working
MONGO_HOST="ds121212.mlab.com/ABC"
MONGO_PORT=21212 // this is useless?

Error message:
No suitable servers found (serverselectiontryonce set): [Failed connecting to 'ds121212.mlab.com:27017': Connection refused]

Working
MONGO_HOST="ds121212.mlab.com:21212/ABC"
MONGO_PORT=21212 // this is useless?

[jaimeescano]

So ... if the second one is working, your configuration to use the port should be:

database.php
'mongodb' => [
'driver' => 'mongodb',
'host' => env('MONGO_HOST'),
'port' => env('MONGO_PORT', 27017),
'database' => env('MONGO_DATABASE'),
'username' => env('MONGO_USERNAME'),
'password' => env('MONGO_PASSWORD'),
]

.env file
MONGO_HOST="ds121212.mlab.com"
MONGO_PORT=21212
MONGO_DATABASE=abc
MONGO_USERNAME=abc_user
MONGO_PASSWORD=secret

[oaigudmundsson]

I don't see where 27017 is and it must be set default mongodb port i guess?

Notice:
MONGO_HOST="ds121212.mlab.com:21212/abc"
abc must be there, otherwise

(1/1) AuthenticationException
Authentication failed.

Connection string must be like this:
mongodb://:@ds121212.mlab.com:21212/abc

Here is the files which are working:

My database.php
'mongodb' => [
'driver' => 'mongodb',
'host' => env('MONGO_HOST'),
'port' => env('MONGO_PORT'),
'database' => env('MONGO_DATABASE'),
'username' => env('MONGO_USERNAME'),
'password' => env('MONGO_PASSWORD'),
],

.env
MONGO_HOST="ds121212.mlab.com:21212/abc"
MONGO_PORT=21212
MONGO_DATABASE=abc
MONGO_USERNAME=abc_user
MONGO_PASSWORD=secret

[ianrussel]

This one works for me

       `DB_CONNECTION=mongodb
        DB_HOST=ianruhjkssel:riberrmayhjkjhka1@ds115kjhk01.mlab.com:15hjk701/express-tutorial-sandbox
        DB_DATABASE=express-tutorial-sandbox
        DB_USERNAME=ianruhjkssel
        DB_PASSWORD=riberrmayhjkjhka1`