Hi,
I am consistently getting the error hdbcli.dbapi.Error: (10, 'authentication failed') when I have $ in my password "Aditya$123". I am using standard hdbcli dbapi with the connection syntax as below:
self.dbConn = dbapi.connect(user=db_user, password="db_password", port=port, address=address)
self.cursor = self.dbConn.cursor()
I tried to escape the $ character but that did not help :
db_password = db_password.replace('$','\$')
I checked this note https://answers.sap.com/questions/518509/using-credentials-from-hdbuserstore-results-in-err.html but not sure what am I missing here. Any help is greatly appreciated. Please not that I am able to connect from the terminal using hdbsql:
/usr/sap/CLO/HDB96> hdbsql -i 96 -p Aditya$123 -u SYSTEM
Welcome to the SAP HANA Database interactive terminal.
Type: \h for help with commands
\q to quit
hdbsql CLO=> \s
host : localhost:39613
sid : CLO
dbname : CLO
user : SYSTEM
kernel version: 1.00.122.23.1548298510
SQLDBC version: libSQLDBCHDB 1.00.120.118.1548119815
autocommit : ON
locale : en_US.UTF-8
input encoding: UTF8