Re: [Geoportal-support] geoportal - problems when using oracledb

[Grøtan B. O. <Bjo...@NG...>]

Ok - I'll try that tomorrow.
If this is the case, then the installation documentation must be updated.
Only thing it mentions when using Oracle is adding 2 lines of configuration.
And yes, we're using ojdbc6.jar. I don't like to much to put it into <TOMCAT>/lib 
as per installation guidelines - I usually prefer to let each war-file supply the
jars it needs outside those supplied by tomcat and other appservers.

Regards 
 
Bjørn Ove


-----Original Message-----
From: Min Seong Kang [mailto:mk...@es...]
Sent: Thu 2/16/2012 11:17 PM
To: Grøtan Bjørn Ove; geo...@li...
Subject: RE: geoportal - problems when using oracledb
 
OK. I think I understand your issue now. 
In the context xml (geoportal.xml), change parameter name "username" to "user" if you are using Oracle ojdbc6.jar.
That is the way you configure context xml for the specific jar file.

If it works, it is just a matter of configuration, not a bug.

Min Seong Kang

-----Original Message-----
From: Grøtan Bjørn Ove [mailto:Bjo...@ng...] 
Sent: Thursday, February 16, 2012 1:55 PM
To: Min Seong Kang; geo...@li...
Subject: RE: geoportal - problems when using oracledb

No LDAP - just simple authentication with user in xml-file.

Also - I found a workaround. Seems the jndi-lookup doesn't fetch username/password from geoportal.xml (Catalina/localhost).
When I put username/password as part of the jdbc-url (in geoportal.xml) it worked fine.
I'm ok for now - but might be a bug somewhere? How is geoportal built from source? ant? maven?

Regards
 
Bjørn Ove Grøtan

-----Original Message-----
From: Min Seong Kang [mailto:mk...@es...]
Sent: Thu 2/16/2012 8:19 PM
To: Grøtan Bjørn Ove; geo...@li...
Subject: RE: geoportal - problems when using oracledb
 
Bjorn,

To understand your issue better...
Do you have any LDAP to handle users or you set it up with a single admin account option in gpt.xml?
If you can share your gpt.xml, it would be better to look at the issue.

Regards,

Min Seong Kang



From: Grøtan Bjørn Ove [mailto:Bjo...@NG...]
Sent: Wednesday, February 15, 2012 6:16 AM
To: geo...@li...
Subject: [Geoportal-support] geoportal - problems when using oracledb

I'm experiencing same problems as described here: http://sourceforge.net/projects/geoportal/forums/forum/1096643/topic/4580689?message=10332588

My difference is - I did not use user 'geoportal' but 'geoportal10'.
It seems geoportal doesn't use my password from geoportal.xml  (<CATALINA_HOME>\conf\Catalina\localhost) since I very well can connect to same url with user/pwd in geoportal.xml using Oracle SQLDeveloper from same host.

I'm running geoportal 1.2 on Tomcat 6.0.35 at localhost:8080 (for testing purposes of course, not production).
I can login just fine using simple auth, but when I click Administration-tab, I get same ORA-error as described in link above.

Please advice.

Best regards

Bjørn Ove Grøtan