Database password can't contain dollar-sign $

SUMMARY

Database password cannot contain $ dollar-sign. It's unclear if the problem happens at MongoEngine or at Stackstorm level.

Testing PyMongo with a password containing $ worked just fine (could create indexes and perform queries).

STACKSTORM VERSION

Paste the output of st2 --version: st2 3.1.0, on Python 2.7.12

OS, environment, install method

Post what OS you are running this on, along with any other relevant information/

Running on Docker Swarm using https://github.com/StackStorm/st2-dockerfiles

Steps to reproduce the problem

Use a password with * in the [database] section. I've used on st2.docker.conf.

Expected Results

Services should start normally.

Actual Results

Authentication to Mongo is reported as successful but fails on ensuring indexes are created.

OperationFailure: not authorized on st2 to execute command { createIndexes: "user_d_b", indexes: [ { unique: true, background: false, sparse: false, key: { name: 1 }, name: "name_1" } ] }

If a password without $ is used, everything works just fine.

Start with the [database] section in st2.docker.conf and trace how StackStorm passes the configured password to MongoDB. Reproduce with the reported special-character password, compare with PyMongo behavior, and confirm the fix by verifying authentication and index creation succeed.