Skip to Content
1
May 26, 2020 at 01:32 PM

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

2608 Views

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