MONGO_OPTIONS stopped working

[geekgonecrazy]

With 0.72.0 it seems that MONGO_OPTIONS stopped working.

The file that loads this environment variable was last touched here: #12595

The environment variable is normally loaded here:
https://github.com/RocketChat/Rocket.Chat/blob/develop/packages/rocketchat-cors/server/cors.js#L18

Suspicion is change to module has effected the order this code is executed in. This needs to be executed very early in start up.

This seems very likely would effect other functionality in this file

[steerben]

I will test if this solves the issue.

Though I would challenge if the cors.js file is the correct place to set such a crucial database connection option. For me it seems that it worked kinda unintentionally all the time, given the file the function call is placed in.

This should be one of the first things when initialising meteor.

[micfung]

sorry guys, the error still exists on 0.74.1
On mongo side, the error is no SSL certificate provided by peer; connection rejected
On rocketchat side, the error is MongoNetworkError: connection x to xxx:27017 closed
I tried so many times to upgrade from 0.71.1 to 0.72 and 0.74.1, but still cannot connect to mongo
The MONGO_OPTIONS works well on 0.71.1

[geekgonecrazy]

@MarcosSpessatto @rodrigok ideas?

[MarcosSpessatto]

@micfung can you please provide the content of your env variable MONGO_OPTIONS? Investigating your error, I found this link that is from this topic, I don't know if the problem can be something like that, @geekgonecrazy what do you think?

[micfung]

@MarcosSpessatto My MONGO-OPTIONS in .bashrc

export PEM=$(cat /opt/mongodb/mongodb.pem | awk '{printf "%s\\n",$0} END {print ""}')
export CA=$(cat /opt/mongodb/ca.pem  | awk '{printf "%s\\n",$0} END {print ""}')
export MONGO_OPTIONS="{\"sslCA\":[\"${CA}\"], \"sslCert\":\"${PEM}\",\"sslKey\":\"${PEM}\"}"

i will take a look the link you give me. FYR. i can connect mongo from my rocketchat server using cli

[micfung]

the command i use to connect mongo from my rocketchat server

sudo mongo --ssl -sslCAFile /opt/mongodb/ca.pem --sslPEMKeyFile /opt/mongodb/mongodb.pem --host xxx.xxx.xx -u admin -p xxx --authenticationDatabase 'rocketchat'