mongodb / docs-bi-connector

17 stars 63 forks source link

Help setup the connector #374

Open pbu80 opened 2 years ago

pbu80 commented 2 years ago

I am an novice when comes to db help me, am using config file to bring up the mongosqld adn getting below error

 C:\Program Files\MongoDB\Connector for BI\2.14\bin>mongosqld.exe /config:config.yml
2022-07-14T03:50:52.699-0500 I CONTROL    [initandlisten] mongosqld starting: version=v2.14.4 pid=2744 host=XXXXXXXX
2022-07-14T03:50:52.699-0500 I CONTROL    [initandlisten] git version: df0cf0b57e9aac0ab6d545eee0d4451d11d0c6e9
2022-07-14T03:50:52.699-0500 I CONTROL    [initandlisten] OpenSSL version OpenSSL 1.0.2n-fips  7 Dec 2017 (built with OpenSSL 1.0.2s  28 May 2019)
2022-07-14T03:50:52.699-0500 I CONTROL    [initandlisten] options: {config: "config.yml", systemLog: {verbosity: 1}, schema: {stored: {mode: "custom", sour
ce: "mongosqld_data", name: "mySchema"}}, mongodb: {net: {uri: "mongodb://XXXX:XXXXX@10.221.70.23:27017/?authSource=admin", auth: {source:
"admin"}}}}
2022-07-14T03:50:52.699-0500 I CONTROL    [initandlisten] ** WARNING: Access control is not enabled for mongosqld.
2022-07-14T03:50:52.699-0500 I CONTROL    [initandlisten]
--mongo-uri may not contain any authentication information
wtrocki commented 1 year ago

Do you use username and password in connection string?

pbu80 commented 1 year ago

Yes, I solved it by configuring the credentials in the config file.

I have new question now, the password is stored as plaintext, how to encrypt/hide it?

wtrocki commented 1 year ago

General secret rules apply. Would consider using Vault