Error during Oracle sql resolver configuration

Question
1

Hi all,

I try configure sql resolver for Oracle. My settings are:
driver: cx-oracle
server: 10.12.34.56
database: abc (sid)
user: USER
port: 1521
table: PRIVACYIDEA
mapping: { “userid” : “id”, “username”: “user”, “phone” : “telephoneNumber”, “mobile” : “mobile”, “email” : “mail”, “surname” : “sn”, “givenname” : “givenName” ,“password” : “password”}

I get an error: Could not parse rfc1738 URL from string ‘cx-oracle://USER:12345678_&@10.12.34.56:1521/abc’

I’ll be glad to know your opinion about this situation.

Regards,
Alexander

2

Hi Alexander,
In my opinion this is a great error message.
After reading RFC1738 it gets much clearer.
Kind regards
Cornelius

3

cx-oracle://USER:12345678@10.12.34.56:1521/abc (without &) not working too…
Maybe, I’ve lost something…

4

The problem was in drivers.
It’s necessary to install instant client from Oracle and cx_Oracle driver.

Now I’ve faced with new error)
failed to retrieve users: ‘twophase’ is an invalid keyword argument for this function

I’ve found this: https://qiita.com/tkprof/items/7d7b2d00df9c5f16fffe
In requirements file for privacyIDEA SQLAlchemy==1.0.5 but this bug was fixed in 1.1.11 version.
So, can I update SQLAlchemy to 1.1.11 without problems?)

Thank you!

Regards,
Alexander

5

Problem is solved.
It is necessary install cx_Oracle 5.3
I have privacyIDEA server version 2.19.1. I see it is possible to update to 2.20.1 now. This version has “Allow creating oracle DB (#752)”, it’s very usefull note.

Thank you very much!

Regards,
Alexander