#1 Open
dagwieers dagwieers
anthony_tuininga anthony_tuininga

Add support for setting the client_identifier during connection

Bitbucket cannot automatically merge this request due to conflicts.

Review the conflicts on the Overview tab. You can then either decline the request or merge it manually on your local system using the following commands:

hg update default
hg pull -r default https://bitbucket.org/dagwieers/cx_oracle
hg merge 27ec955e76e0
hg commit -m 'Merged in dagwieers/cx_oracle (pull request #1)'
  1. Dag Wieers avatarDag Wieers

Add support for setting the client_identifier during connection so that logon triggers will see this value, as requested and implemented by Dag Wieers.

Comments (2)

  1. Dag Wieers author

    I have not tested it, lacking Oracle libraries to build against. But it conforms to a previous (similar) commit (wrt. module, action and clientinfo) and should therefor be correct (give or take a typo ;-))

    Thanks in advance !

  2. Dag Wieers author

    In the meantime I have tested it using oracle-instantclient- and oracle-instantclient-, and in both cases the ACL still blocks me. I use it like this:

    con = oracle.connect(username, password, dns, client_identifier="perl")

    I have no means of verifying what is actually logged inside the database for this request, but I can confirm this does not work whereas symlinking python to ./perl and using ./perl in the shebang does work and is not blocked by the ACL. So I wonder if it is even using OCI_ATTR_CLIENT_IDENTIFIER during the connect in the instantclient library. For all we know the library is providing its own client_identifier during connect by using its own technique of getting the program name (in this case the interpreter from the shebang).

Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.