1 Reply Latest reply on Jul 16, 2010 5:10 PM by rwendel

    Apex Listener SSO problem

    Igor_Bursin
      Hi all!
      I have some problems with Apex Listener SSO configuration.....
      Currently situation:
      Apex 4.0, Oracle Database 11.2 + last CPU using Embedded Gateway configured with SSO (Application Express as Partner Application). All working successfully without any problems.
      I installed and configured Apex Listener with Oracle Glassfish Server. Added new host in portal application page, run regapp.sql.
      When i running application after redirection to sso login page i can see next errors:
      HTTP Status 404 - Requested url http://site.com:8888/apex/wwv_flow_custom_auth_sso.process_success is not allowed.
      On the Apex Listener error tracking page i see: HTTP Status Code: 404 Requested url http://site.com:8888/apex/wwv_flow_custom_auth_sso.process_success is not allowed.
      select msg from apex_sso.wwsec_sso_log$:

      "entry: papp_show_config "
      "IN papp_show_config: after the select."
      "site name is 2P8F3K05A7F387EF"
      "exit: papp_show_config"
      "entry: urlencode"
      "encoded URL is %2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095"
      "exit: urlencode"
      "entry: urlencode"
      "encoded URL is %2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095"
      "exit: urlencode"
      "entry: encrypt_url_cookie "
      "Before bake_site2pstore_token: listener token: HTML_DB:site.com:8888urlcookie_version: v1.2papp_url_cookie: %2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095~0enabler_config.site_token: 2P8F3K05A7F387EFkey: 83D0644796C39F8D"
      "entry: bake_site2pstore_token"
      "entry get_enabler_config"
      "site token is 2P8F3K05A7F387EF"
      "exit: get_enabler_config"
      "In hash string. Input is 30107-13-2010 14:11:53"
      "In hash string. Input is <CJuDJ;az ~ 2P8F3K05A7F387EF~20100713141153~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095~0"
      "temp site2pstoretoken is :<CJuDJ;az ~ 2P8F3K05A7F387EF~20100713141153~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A3996791311665095~0~8AAEB55F8BC0BC7CFB95E231A4FE6AF6"
      "exit: bake_site2pstore_token"
      "After bake_site2_pstore_token. Value is: A331C1B31329DF026379EDD72764E7A5E7BEB93F0303F9EFD5FF40D4926C2DC36F9A2F299D37DF452EA2D597BAFCADF238F6A8D3AAE3E5075ABAD1BA6D1EF032C0FD8FE546F1398BCBBE83941C6D02127A8CD13CDA708003C54B78BC2CAD8BD4A87345DAEBA410D5E565809F09A9C00FF894F425135149DD8AEC92CCFBDA2D0F0D53C7440152B0E5D12287CF2731E6ECA988171270151DA62D35C559BDEAC8B782D55C121432562ECE0B394D17678BC78B9C8AD3D67DE6FEA865E871CA4E95EC1B9610A7F04DAD323A9FEDB5036922420C8D6D49E4844535844AC352BFFADD999A7A991E8BD69707"
      "Redirect URL generated is : https://login.petrsu.ru/pls/orasso/orasso.wwsso_app_admin.ls_login?site2pstoretoken=v1.2~A7F387EF~A331C1B31329DF026379EDD72764E7A5E7BEB93F0303F9EFD5FF40D4926C2DC36F9A2F299D37DF452EA2D597BAFCADF238F6A8D3AAE3E5075ABAD1BA6D1EF032C0FD8FE546F1398BCBBE83941C6D02127A8CD13CDA708003C54B78BC2CAD8BD4A87345DAEBA410D5E565809F09A9C00FF894F425135149DD8AEC92CCFBDA2D0F0D53C7440152B0E5D12287CF2731E6ECA988171270151DA62D35C559BDEAC8B782D55C121432562ECE0B394D17678BC78B9C8AD3D67DE6FEA865E871CA4E95EC1B9610A7F04DAD323A9FEDB5036922420C8D6D49E4844535844AC352BFFADD999A7A991E8BD69707"
      "entry: papp_show_config "
      "IN papp_show_config: after the select."
      "site name is 2P8F3K05A7F387EF"
      "exit: papp_show_config"
      "entry: urlencode"
      "encoded URL is %2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866"
      "exit: urlencode"
      "entry: urlencode"
      "encoded URL is %2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866"
      "exit: urlencode"
      "entry: encrypt_url_cookie "
      "Before bake_site2pstore_token: listener token: HTML_DB:site.com:8888urlcookie_version: v1.2papp_url_cookie: %2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866~0enabler_config.site_token: 2P8F3K05A7F387EFkey: 83D0644796C39F8D"
      "entry: bake_site2pstore_token"
      "entry get_enabler_config"
      "site token is 2P8F3K05A7F387EF"
      "exit: get_enabler_config"
      "In hash string. Input is 30207-13-2010 14:18:37"
      "In hash string. Input is D|F>YVN<,x}S7~ 2P8F3K05A7F387EF~20100713141837~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866~0"
      "temp site2pstoretoken is :D|F>YVN<,x}S7~ 2P8F3K05A7F387EF~20100713141837~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866~%2F1.1%3A%2F%2Fsite.com%3A8888%2F%2Ff%3Fp%3D204%3A34%3A7839477128223866~0~67EF7818D5C5508149CBE100AD791ADA"
      "exit: bake_site2pstore_token"
      "After bake_site2_pstore_token. Value is: 75D0A68EEF409C82F9863BAFD41559CCD6DAC1495D4B960C412C6652E0C13F897C1015B0FE766E59FA82D2E199B86C670C2D5C83471A3C3FE1DE0F9019D6C6AD71DF4714FB37D529A20E8D961206DF92D51D531EEB644196BE0EDF6EB27CF19D311CFE5DFC9B58E1937D84581977F09DD3A73EB28492F0F3127F903B71EAA621DB3C4663FDD0BB1D266A368788F02E3019E791C81795EE4FD5A63BBF73AF514E8CA8D67876FC385A3F1215DA7F6772F4DDC1949B62400C4B025B6F95E74C72A5555F8C47AB47DADF6846D89D7570860C81ED939B4528437703FF96EEB3B05CF3698886BCE7220B878D70AA5CDCDB955B"
      "Redirect URL generated is : https://login.site.com/pls/orasso/orasso.wwsso_app_admin.ls_login?site2pstoretoken=v1.2~A7F387EF~75D0A68EEF409C82F9863BAFD41559CCD6DAC1495D4B960C412C6652E0C13F897C1015B0FE766E59FA82D2E199B86C670C2D5C83471A3C3FE1DE0F9019D6C6AD71DF4714FB37D529A20E8D961206DF92D51D531EEB644196BE0EDF6EB27CF19D311CFE5DFC9B58E1937D84581977F09DD3A73EB28492F0F3127F903B71EAA621DB3C4663FDD0BB1D266A368788F02E3019E791C81795EE4FD5A63BBF73AF514E8CA8D67876FC385A3F1215DA7F6772F4DDC1949B62400C4B025B6F95E74C72A5555F8C47AB47DADF6846D89D7570860C81ED939B4528437703FF96EEB3B05CF3698886BCE7220B878D70AA5CDCDB955B"
      If i running application via embedded gateway - all successfully. if i running application via apex listener i have a problem...Any idea?

      Best regards, Igor Bursin.
        • 1. Re: Apex Listener SSO problem
          rwendel
          In the install guide for the listener it talks about configuration of the "Allowed Procedures".

          This is under the security tab. Have you added the "wwv_flow*" to that list? It shows this option under the example configuration. It would appear from your error that it is not allowing you to the page.

          -Richard