tag:blogger.com,1999:blog-5215551487816981140.post5037598438676354514..comments2024-01-23T06:10:31.184-08:00Comments on ORA-00001: Unique constraint violated: Windows NTLM SSO with ApexMorten Bratenhttp://www.blogger.com/profile/12300886042835631690noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5215551487816981140.post-55594333194364538232015-11-17T09:43:03.016-08:002015-11-17T09:43:03.016-08:00@Sam:
1) The setup for IIS8 is the same as IIS7 (...@Sam:<br /><br />1) The setup for IIS8 is the same as IIS7 (for setting up a folder with Integrated Windows Authentication), although the IIS admin console might look at bit different between versions.<br /><br />2) If you are using the latest version of the Thoth Gateway (version 1.4.1), you don't even need the Oracle Instant Client, because the ODP.NET Managed Driver is included with the gateway (it's just a single DLL that you put in the same "bin" folder as the gateway). See http://ora-00001.blogspot.no/2014/11/thoth-gateway-140-beta-release-1-available.html<br /><br />- MortenMorten Bratenhttps://www.blogger.com/profile/12300886042835631690noreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-12340129649414615182015-11-12T07:00:59.831-08:002015-11-12T07:00:59.831-08:00Hi,
Thank you so much for your wonderful utili...Hi,<br /> Thank you so much for your wonderful utility and I really appreciate you detail posting on how to use it.<br /> I've these two questions since we are on Windows Server 2012 R2 64bit with IIS 8.<br /><br /> 1) Are there any new setting/issues I should be aware of, since I see instructions for IIS6 and IIS7?<br /><br /> 2) I already have Oracle Instant client 12.1 on this server. Can you please advise which ODP.NET I should download?<br /><br />Thank you,<br />SamAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-61986260884127650332012-11-23T02:33:53.940-08:002012-11-23T02:33:53.940-08:00and the The thothgateway log:
2012-11-20 11:24:38,...and the The thothgateway log:<br />2012-11-20 11:24:38,011 [6] INFO PLSQLGatewayModule.PLSQLHttpModule Request: GET /pls/apex/f<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Parsed module = pls, dad = apex, proc = f<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Parameter 1: p = 4000:RUN_PAGE:5824724424201990:BRANCH_TO_PAGE_ACCEPT:NO::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW:100,1,100<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Cookies: ORA_WWV_REMEMBER_UN=USERNAME:WORKSPACE; ORA_WWV_USER_63415164076637=80EDA8E3CDBE8032FE8C7C1347FEA498; ORA_WWV_USER_63127273658882=3345BAC5E2AF6741; WWV_CUSTOM-F_1005905120909186_100=E1B1848A98582282; ORA_WWV_APP_103=434F7F9DAFB2FFF9E4506FAB4EB2D8A9<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Current Windows user name (LOGON_USER) = DOMAIN\USERNAME<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connecting with user APEX_PUBLIC_USER to //192.168.16.174:1521/dngvm...<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Connected to Oracle 10.2.0.4.0<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: alter session set nls_language='AMERICAN' nls_territory='AMERICA'<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin dbms_session.modify_package_state(dbms_session.reinitialize); end;<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: declare dummy_num_vals integer; begin owa.ip_address(1) := :p_ip1; owa.ip_address(2) := :p_ip2; owa.ip_address(3) := :p_ip3; owa.ip_address(4) := :p_ip4; owa.hostname := :p_hostname; owa.set_user_id (:p_user_id); owa.set_password (:p_password); dummy_num_vals := owa.initialize; owa.init_cgi_env(:ecount, :namarr, :valarr); htp.init; htp.htbuf_len := 63; end;<br />2012-11-20 11:24:38,011 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin if wwv_flow_epg_include_modules.authorize (:p_proc_name) then f (p => :b1); if wpg_docload.is_file_download then :p_is_download := 1; else :p_is_download := 0; end if; else raise_application_error (-20000, 'Procedure call forbidden by request validation function (wwv_flow_epg_include_modules.authorize)'); end if; end;<br />2012-11-20 11:24:38,042 [6] INFO PLSQLGatewayModule.PLSQLHttpModule Gateway procedure executed successfully.<br />2012-11-20 11:24:38,042 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Committing database transaction...<br />2012-11-20 11:24:38,042 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Commit completed.<br />2012-11-20 11:24:38,042 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Fetch buffer size = 200<br />2012-11-20 11:24:38,042 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Executing SQL: begin owa.get_page(:linearr, :nlines); end;<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header X-ORACLE-IGNORE: IGNORE<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Processing header Location: f?p=100:1:5824724424201990:::::<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Closing database connection...<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Database connection closed.<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Compression of dynamic content is enabled, client accepts gzip, deflate<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Converting relative path (f?p=100:1:5824724424201990:::::) to absolute path<br />2012-11-20 11:24:38,058 [6] DEBUG PLSQLGatewayModule.PLSQLHttpModule Redirecting to /pls/apex/f?p=100:1:5824724424201990:::::<br />...the same block<br /><br />thanks,<br /><br />BenjaminBenjaminnoreply@blogger.comtag:blogger.com,1999:blog-5215551487816981140.post-81080770253575267402012-11-23T02:32:26.589-08:002012-11-23T02:32:26.589-08:00Hello Morten,
I have configured this ntlm authent...Hello Morten,<br /><br />I have configured this ntlm authentication with the thoth-gateway for apex 4.2 and 11g database.<br />It works really good.<br /><br />But when I am trying to configure it for apex 4.1 and 10g database, I can't access the application with NTLM (but works with other authentication). <br /><br />The log files:<br />The iis log:<br />192.168.16.67 - DOMAIN\username [20/Nov/2012:11:24:38 +0100] "GET /pls/apex/f?p=4000:RUN_PAGE:5824724424201990:BRANCH_TO_PAGE_ACCEPT:NO::FB_FLOW_ID,FB_FLOW_PAGE_ID,F4000_P1_FLOW:100,1,100 HTTP/1.1" 302 500<br />192.168.16.67 - DOMAIN\username [20/Nov/2012:11:24:38 +0100] "GET /pls/apex/f?p=100:1:5824724424201990::::: HTTP/1.1" 302 685<br />192.168.16.67 - DOMAIN\username [20/Nov/2012:11:24:38 +0100] "GET /pls/apex/f?p=100:1:2776707887505852::::: HTTP/1.1" 302 683<br />...etc (same line with several session id)<br /><br /><br />Do you have any idea to resolve this problem?<br /><br />BenjaminBenjaminnoreply@blogger.com