Ufdjrw

It's a yearly task, alright

How to deal with taxi scam when on vacation?

Connecting top and bottom SMD component pads using via

Bash: What does "masking return values" mean?

What is a good source for large tables on the properties of water?

Is it normal that my co-workers at a fitness company criticize my food choices?

How is the Swiss post e-voting system supposed to work, and how was it wrong?

Have researchers managed to "reverse time"? If so, what does that mean for physics?

Why did it take so long to abandon sail after steamships were demonstrated?

Official degrees of earth’s rotation per day

How to simplify this time periods definition interface?

Meaning of "SEVERA INDEOVI VAS" from 3rd Century slab

Provisioning profile doesn't include the application-identifier and keychain-access-groups entitlements

What does it mean to make a bootable LiveUSB?

Professor being mistaken for a grad student

Calculus II Professor will not accept my correct integral evaluation that uses a different method, should I bring this up further?

Why are there 40 737 Max planes in flight when they have been grounded as not airworthy?

Sword in the Stone story where the sword was held in place by electromagnets

SQL Server Primary Login Restrictions

2D counterpart of std::array in C++17

An Accountant Seeks the Help of a Mathematician

Schematic conventions for different supply rails

My adviser wants to be the first author

Ban on all campaign finance?

Compiled python executable access blocked to access Oracle database

4

1

I have a script (my_script.py) that accesses an Oracle database with the typical logon process via cx_Oracle.

def make_connect(**creds):
 dsn_str = cx_Oracle.makedsn(host, port, sid)
 return cx_Oracle.connect(un, pw, dsn_str)

There is no problem accessing the database through this method when the script is run from an IDE, but as soon as I package it into an executable (with PyInstaller, although I don't think this matters), I am getting the following error:

ORA-20045: LOGON BLOCKED

I believe this is because the executable that is accessing the database is not python.exe that is running the code but rather my_script.exe. The code works as expected if I change my_script.exe to python.exe, meaning I believe python.exe is whitelisted by the database for access.

I don't know enough about what particular system variable or environ variable declares itself to the Oracle database for access, but I have tried changing sys.executable to python.exe, or sys.argv[0] to python.exe, but I think there is something deeper that I might need to change (if I could change anything at all to get access).

Any suggestions would be more than helpful. The exe will be on systems with domain access to the database but because it's only python.exe that is whitelisted their access will be denied.

python python-3.x oracle oracle11g cx-oracle

share|improve this question

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  Oracle exceptions in the ORA-20000 to ORA-21299 range are generic user-defined exceptions raised by calling raise_application_error. You might have a LOGON trigger or something similar that's preventing you from connecting. Try running this query to look for the code that's generating this error: select * from all_source where text like '%-20045%'
  
  – kfinity
  Mar 6 at 19:04
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Ask your DBAs to change the trigger to check the driver name that initiated the connection instead of the program name. This will be (very) marginally more secure but much less annoying to users: SELECT UNIQUE sid, client_driver FROM v$session_connect_info ORDER BY sid; The de facto standard for the CLIENT_DRIVER column is 'name : version'. Note older versions of the DB will only show the first 9 or so characters that the driver actually sets, so you might not see the version when you use Oracle DB 11.
  
  – Christopher Jones
  Mar 6 at 21:27
  

  
  
  
  

add a comment | 

4

1

I have a script (my_script.py) that accesses an Oracle database with the typical logon process via cx_Oracle.

def make_connect(**creds):
 dsn_str = cx_Oracle.makedsn(host, port, sid)
 return cx_Oracle.connect(un, pw, dsn_str)

There is no problem accessing the database through this method when the script is run from an IDE, but as soon as I package it into an executable (with PyInstaller, although I don't think this matters), I am getting the following error:

ORA-20045: LOGON BLOCKED

I believe this is because the executable that is accessing the database is not python.exe that is running the code but rather my_script.exe. The code works as expected if I change my_script.exe to python.exe, meaning I believe python.exe is whitelisted by the database for access.

I don't know enough about what particular system variable or environ variable declares itself to the Oracle database for access, but I have tried changing sys.executable to python.exe, or sys.argv[0] to python.exe, but I think there is something deeper that I might need to change (if I could change anything at all to get access).

Any suggestions would be more than helpful. The exe will be on systems with domain access to the database but because it's only python.exe that is whitelisted their access will be denied.

python python-3.x oracle oracle11g cx-oracle

share|improve this question

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565

• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  Oracle exceptions in the ORA-20000 to ORA-21299 range are generic user-defined exceptions raised by calling raise_application_error. You might have a LOGON trigger or something similar that's preventing you from connecting. Try running this query to look for the code that's generating this error: select * from all_source where text like '%-20045%'
  
  – kfinity
  Mar 6 at 19:04
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Ask your DBAs to change the trigger to check the driver name that initiated the connection instead of the program name. This will be (very) marginally more secure but much less annoying to users: SELECT UNIQUE sid, client_driver FROM v$session_connect_info ORDER BY sid; The de facto standard for the CLIENT_DRIVER column is 'name : version'. Note older versions of the DB will only show the first 9 or so characters that the driver actually sets, so you might not see the version when you use Oracle DB 11.
  
  – Christopher Jones
  Mar 6 at 21:27
  

  
  
  
  

add a comment | 

I have a script (my_script.py) that accesses an Oracle database with the typical logon process via cx_Oracle.

def make_connect(**creds):
 dsn_str = cx_Oracle.makedsn(host, port, sid)
 return cx_Oracle.connect(un, pw, dsn_str)

There is no problem accessing the database through this method when the script is run from an IDE, but as soon as I package it into an executable (with PyInstaller, although I don't think this matters), I am getting the following error:

ORA-20045: LOGON BLOCKED

I believe this is because the executable that is accessing the database is not python.exe that is running the code but rather my_script.exe. The code works as expected if I change my_script.exe to python.exe, meaning I believe python.exe is whitelisted by the database for access.

I don't know enough about what particular system variable or environ variable declares itself to the Oracle database for access, but I have tried changing sys.executable to python.exe, or sys.argv[0] to python.exe, but I think there is something deeper that I might need to change (if I could change anything at all to get access).

Any suggestions would be more than helpful. The exe will be on systems with domain access to the database but because it's only python.exe that is whitelisted their access will be denied.

python python-3.x oracle oracle11g cx-oracle

share|improve this question

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565

def make_connect(**creds):
 dsn_str = cx_Oracle.makedsn(host, port, sid)
 return cx_Oracle.connect(un, pw, dsn_str)

share|improve this question

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565

share|improve this question

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565

asked Mar 6 at 18:37

Michael McIntyreMichael McIntyre

565