hdbcli.dbapi.Error: (10, 'authentication failed') when password contains special character

[#1]

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

[agentry_src]

Are you able to change your password? $ might be a special character in your system somewhere. Also have you talked to your DBA regarding this issue? What did they have to say?

[Former Member]

Hi Mike,

I am using this setup for some internal testing and hence, I am the only one who has access to this system. To answer your question, yes, I am able to change the password. I am trying to query the database using hdbcli and am stuck because of this password issue. I can change the password to something else without '$' but then I need to understand the root cause of this issue because a similar password may be used in field.

Thanks,

Aditya