Okay, figured after a couple hours hammering my keyboard and abusing Google time to reach out for a lifeline.
Connecting to external MongoDb (Amazon VPC)
Setting up the service and roles.
In my service, I can create a role and connect no problem with:
But when I try to enter Lookup Keys in the role to replace the mymongousername:mymongopassword I can no longer connect.
I set up my service like this:
and in my user role I set up
KEY: m_username VALUE: mymongousername PRVATE
KEY: m_password VALUE: mymongopassword PRIVATE
I get a response:
Unexpected MongoDb Service Exception: Failed to connect to: 184.108.40.206:27017: SASL Authentication failed on database 'mymongodb': Authentication failed.
I tried variants of username/password curly brackets etc but no luck. I revert back to original service setup with
mongodb://mymongousername:email@example.com:27017/mymongodb and connect again no problem.