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

[Min S. K. <mk...@es...>]

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