Apex Listener SSO problem - ORDS, SODA & JSON in the Database

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. 

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

Related

Connecting to Oracle 9i with Sun One Web Server 6.1 SP4

I have an application that connects to an Oracle 9i database. When I run iPlanet 4.1, I am able to login to the application and run it. Since I have migrated to Sun One Web Server 6.1 SP4, I have not been able to login. Through some built in error logging, I have been able to determine that my user validation routine is receiving a Null pointer when it trys to connect to the database. I have also determined that my login servlet is executing properly. When I receive the Null pointer error, I am redirected to a failed login page, which is what is supposed to happen in such a case. I believe that I do not have the web server configured properly to connect to the database and I am not sure how to do it! Below is an excerpt from my code where the database connection occurs and the exception is detected. Any help would be appreciated!
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
          oracleConnect = DriverManager.getConnection("jdbc:oracle:thin:#" + chost + ":" + cport + ":" + csid ,u,p);
     enable = true;
     
oracleConnect.close();
}catch(java.sql.SQLException e){processError.logError("validateUser Invalue user" + e.getMessage()); enable = false;}
catch(java.io.FileNotFoundException e){processError.logError("validate User error" + e.getMessage());}
catch(java.io.IOException e){processError.logError("evalidateUser rror File Error " + e.getMessage());}
catch(java.lang.NullPointerException e){processError.logError("validateUser error Null Pointer " + e.getMessage());} 
hi
sun web server does not have anything to do with oracle database connection. you might want to take a look at the following issues.
1. whether you are giving the correct oracle dsn [ confirm this with the database administrator
2. make sure that jdbc driver has the correct class path variables set.
hth
s 
You are not using the server's built in JDBC Connection pooling, so there is no special WebServer configuration needed to connect to a database.
If in the other hand, you want to use the built in connection pooling, then refer to this page to see how to create a connection pool
http://docs.sun.com/source/817-1831-10/agjava.html#wp1085593
Samples on how to configure and use JDBC connection pooling can be found in the sample apps
http://docs.sun.com/source/817-1833-10/pwawap.html#wp40108

Gateway error in sun ONE portal gateway when invoking a Lotus notes channel

Hi Friends,
I have configured a channel in the portal server for integrating it with the lotus notes server. I have to edit the following options in the channel.
servername: <name>
portnumber: 80
username: <username>
userpassword: <password>
This configuration is working fine when I login through http. But when I login through the gateway (https), it gives me error saying
"Unable to connect to host - icemail.
Contact administrator".
But when I use IP ADDRESS instead of server name it is able to open the lotus email normally.
I have pasted the log files below. Kindly help me in solving the issue.
2004-10-14 17:41:18" "ID:38,139, Source address:/10.205.47.72, Source port:53,968" srapGateway_test_1.ongcl.com_default.access null INFO uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com /172.16.5.21 uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com 172.16.5.21
"2004-10-14 17:41:27" "ID : 38,139 User ID : 62819 Client : /10.205.47.72 Request Type : https Destination Host icemail Type of Request POST Client Requested URL https://icemail/webauth.nsf?Login Client Post Data size null Response Result code 502 Complete Response size 380" srapGateway_test_1.ongcl.com_default.access null INFO uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com /172.16.5.21 uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com 172.16.5.21
"2004-10-14 17:45:38" "ID:38,269, Source address:/10.205.47.72, Source port:53,981" srapGateway_test_1.ongcl.com_default.access null INFO uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com /172.16.5.21 uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com 172.16.5.21
"2004-10-14 17:45:47" "ID : 38,269 User ID : 62819 Client : /10.205.47.72 Request Type : https Destination Host icemail Type of Request POST Client Requested URL https://icemail/webauth.nsf?Login Client Post Data size null Response Result code 502 Complete Response size 380" srapGateway_test_1.ongcl.com_default.access null INFO uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com /172.16.5.21 uid=amservice-srapgateway,ou=people,dc=ongcl,dc=com 172.16.5.21
Best Regards
Ramkumar Raghavan

derbyclient.jar-1

Hi,
Has anyone heard of or has the 'derbyclient.jar-1' file?
I need it to complete the Userbuild example from the fieldguide but I cannot
find this file.
Can somebody help!!!
Thanks 
There's a derbyclient.jar at $creator_install/SunAppServer8/derby/lib.
I think this should be the one you are looking for.
HTH,
Sakthi 
Hi,
My userbuild example project asks me for "derbyclient.jar" AND THE "derbyclient.jar-1" file.
My project does not run due this file not being present. 
Here's what i did:
+ right clicked on the Libraries node, chose Properties
+ Removed the broken library references
+ Ensured/Added the derbyclient.jar to this list
+ Chose Run File/Project on DerbyLoginDB.java
It gave me:
Error on url jdbc:derby://localhost:21527/sample
ERROR: SQLException: Connection authorization failure occurred. Reason: userid invalid.
org.apache.derby.client.am.SqlException: Connection authorization failure occurred. Reason: userid invalid.
I have then modified the line:
String url = "jdbc:derby://localhost:" + port + "/sample";
to:
String url = "jdbc:derby://localhost:" + port + "/sample;user=dbadmin;password=dbadmin";
Reran the project, it worked fine!
HTH,
Sakthi

Beginner needs help. Unable to trace the source of Error

Hello to all,
Can anyone please help me.
I'm using Oracle 10G and Glassfish Server.
NetBeans-->Services tab-->Databases-->Drivers-->Oracle Thin-->Connect Using-->New Connection Wizard-->Test Connection.
I get the following error whenever I click the "Test Connection" button in the New Connection Wizard :--
***Cannot establish a connection to jdbc:oracle:thin:#localhost:1521:XE using oracle.jdbc.OracleDriver (Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )***
Is this due to the port 8080 conflict between Glassfish and Oracle 10G?
I tried Google.I'm a new bee.Google wasn't of much help.
Error 12505 seems to be a large subset of errors.
Unable to figure the exact error in my case.
Awaiting for your kind suggestions.
Thanks in advance.
Are you using the correct URL format?
jdbc:oracle:thin:#//localhost:1521/XE
This error should not be anything to do with a clash in ports, at least on 8080, as the JDBC Driver will be attempting to connect on the 1521 port you specified.
Thanks for your kind response.
I think its URL Format is correct: "jdbc:oracle:thin:#localhost:1521:XE" .This is what the wizard shows as the JDBC URL.Please correct me if I'm wrong.
But I'm little confused with the default SID value i.e. XE.
When I login to the sqlplus and execute the command "show parameter instance_name" the value it returns is "orcl".
I tried doing the following,and either way the connection succeeded(I had to unlock both the scott and system account before doing it):
1).Changed SID to orcl --> username: scott --> password:***** --> Clicked "Test Connection".
!Connection Succeeded.
2).Changed SID to orcl --> username: system --> password:***** --> Clicked "Test Connection".
!Connection Succeeded.
After I clicked "Next" it showed SYSTEM as the selected schema(Though it showed a drop down list of several schemas,I didn't change it).
Clicked Next--> It said"Override the default name for the connection..... Input Connection name: jdbc:oracle:thin:#localhost:1521:orcl [system on Default schema] "
Same way,for scott it showed : "Input Connection name: jdbc:oracle:thin:#localhost:1521:orcl [scott on Default schema]"
Which schema should I select from the drop down menu ?? Will overriding the default schema cause any problem?

Vanity Url Problem

Hi Experts, Queries related to Vanity url Following are the steps we have done to create a vanity URL :-*Create a webroot  with hostname ="sitename"and  root url ="<context root>/sitename"*Create a url pattern for page asset  using Host ="<context root>/sitename" and pattern = ${name}*Configure the web.xml to give siteprefix value as sitename Prefix.*For any page  autogenerated URL is : <context root>/sitename/pagename Query 1When we hit Url with hostname and port no( hostname:portNo/<context root>/sitename./pagename-).in browser then 404 error is displayed.Same process when we done in our localhost then its works fine.we also used tag <render:gettemplateurl > to Generates a valid URL to an asset  by using [webrootname="webroot";] in the tag. But it also didn't work. Query 2*How we create a vanity Url without having  "<context root>/sitename" in Url. working url :- localhost:portno/<context root>/sitename./pagename- its working expected Url  :- localhost:portno./pagename- give 404 errorwhere we have to do changes so "<context root>/sitename" is removed in vanity url. Please Suggest Thanks in advance
For query1 --> Did you restart application server after configuring webroot in web.xml? If yes, what errors do you see in sites.log file when you hit vanity url in browser? For query2 --> You have to install webserver and write redirect rules. This is explained in Administration Guide - Configuring vanity URL Regards,Guddu

Categories

Resources