using the configuration file within the connector for BI server to connect to Mongo DB
Cognos → ConnectorforBI → MongoDB
it has been working fine for quite some time.
recently, it is not working. seeing this error on the log file within the BIconnector server:
“[manager] error initializing schema: unable to execute command: connection() error occured during connection handshake: auth error: unable to authenticate using mechanism “SCRAM-SHA-256”: (AuthenticationFailed) Authentication failed.”
I have tried to manually connect to the mongoDB using command line from the BIconnector server but still failed with this error.
./mongosqld --mongo-uri=“mongodb://hostname:port/?connect=direct” --auth -u “username” -p “password” --mongo-authenticationSource=“admin” --mongo-authenticationMechanism=“SCRAM-SHA-256” --mongo-ssl --mongo-sslPEMKeyFile=“<pathto.pemfilecontatingprivatekeyandcert>” --mongo-sslPEMKeyPassword=“password” --mongo-sslCAFile=“pathto.pemfilecontainingthecacerts”
2024-10-18T13:34:37.176-0400 I CONTROL [initandlisten] mongosqld starting: version=v2.14.4 pid= host=
2024-10-18T13:34:37.177-0400 I CONTROL [initandlisten] git version: df0cf0b57e9aac0ab6d545eee0d4451d11d0c6e9
2024-10-18T13:34:37.177-0400 I CONTROL [initandlisten] OpenSSL version OpenSSL 1.0.1e-fips 11 Feb 2013 (built with OpenSSL 1.0.1e 11 Feb 2013)
2024-10-18T13:34:37.177-0400 I CONTROL [initandlisten] options: {security: {enabled: true}, mongodb: {net: {uri: “mongodb://hostname:port/?connect=direct”, ssl: {enabled: true, minimumTLSVersion: “TLS1_1”, PEMKeyFile: “/opt/mongo/certs/mongobi.pem”, PEMKeyPassword: “”, CAFile: “/opt/mongo/certs/CAChain.pem”}, auth: {username: “username”, password: “”, source: “admin”, mechanism: “SCRAM-SHA-256”}}}}
2024-10-18T13:34:37.192-0400 I NETWORK [initandlisten] waiting for connections at 127.0.0.1:3307
2024-10-18T13:34:37.192-0400 I NETWORK [initandlisten] waiting for connections at /tmp/mysql.sock
2024-10-18T13:34:37.625-0400 E NETWORK [initandlisten] unable to load MongoDB information: failed to create admin session for loading server cluster information: unable to execute command: connection() error occured during connection handshake: auth error: unable to authenticate using mechanism “SCRAM-SHA-256”: (AuthenticationFailed) Authentication failed.