nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Geoportal: A database communication error has occur

Mirza_MuhammadWaqar

HI

Whenever I try to login with admin, publisher or registereduser in geoportal the following error displays:
"A database communication error has occur."

What am I missing?

Thanks

Mirza Waqar

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

AndrzejBieniek

Below is working geoportal.xml file (using Oracle Service name)

server_name must be replaced by your real server name
service_name must be replaced with your real service name like ORCL

<!-- Context configuration file for the Geoportal Web App -->
<Context docBase="geoportal" path="/geoportal" debug="0" reloadable="true" crossContext="true">
  <Resource name="jdbc/gpt" auth="Container"
            type="oracle.jdbc.pool.OracleDataSource"
            driverClassName="oracle.jdbc.driver.OracleDriver"
            factory="oracle.jdbc.pool.OracleDataSourceFactory"
            url="jdbc:oracle:thin:@//server_name:1521/service_name"
            user="geoportal"
            password="geoportalpwd"
            maxActive="20"
            maxIdle="10"
            maxWait="-1" />
</Context>

Depending if u are using SID or ServiceName URL is different:

 jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID
 jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE

Sample connect string:

url = "jdbc:oracle:thin:@//myhost:1521/orcl"
url = "jdbc:oracle:thin:@myhost:1521:orcl"

I hope it helps.

regards

ErosSy

hello
with same problem I've solved:
replacing the username="geoportal" property by user="geoportal" in geoportal.xml

helped me a lot.

the root cause was specifying the "type" & "factory" value from geoportal.xml (context.xml)
the specified api uses the "user" not "username" property.

Which is not documented.

Thanks a lot. sbruscoli

CliveReece

sorry, there is no way that i can know your database machine name, port, or SID.

If you want to check if your jdbc connection settings work (outside of the log file messages), try using a third party tool like dbVisualizer.

Mirza_MuhammadWaqar

thanks dear for your reply, now i am using oracle 10 g enterprise edition,
i just stop apache tomcat, and delete all log files, after starting apache tomcat, when i just open "gpt.2011-05-27.log", i notice the following warrning, "WARNING: [SYNCHRONIZER] Error fetching next task, java.sql.SQLException: Invalid Oracle URL specified"...

In my geoportal.xml file i provide the following url, url="jdbc:oracle://localhost:1158/em"

can you tell me, is it correct or not?
waiting for your reply
thanks in advance

CliveReece

Well for one thing, you are deviating from the documented pre-installation requirements (https://sourceforge.net/apps/mediawiki/geoportal/index.php?title=Preinstallation) by attempting to use Tomcat 7.0 and Oracle Express Edition.

To troubleshoot your issue with the database and/or jdbc, I would NOT rely on web app messages, but scrutinize your log file messages.

To begin with that: stop Tomcat, clean out the log files, start Tomcat but do nothing (i.e. do not connect to the web app), wait until the gpt.log stabilizes in size, then inspect the log file. If you see an error, try to understand what it is telling you is wrong. If you do not see an error, then open a browser and start interacting with the geoportal until you generate an error in the log file. Then go back and troubleshoot the error from the log file.

Mirza_MuhammadWaqar

thanks for reply now i setup geoportal with simple athentication, and sucessfully login... When i click on administrator tab, new page open and following error occur, "A database communication error has occur", my geoportal.xml file is as follows...

I am using Oracle 10 g Express Edition...
----------------------------------------------------------------------------------------------



<Context docBase="Geoportal" path="C:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\geoportal" debug="0" reloadable="true" crossContext="true">


<Resource name="jdbc/gpt" auth="Container" type="oracle.jdbc.pool.OracleDataSource" factory="oracle.jdbc.pool.OracleDataSourceFactory"
driverClassName="oracle.jdbc.driver.OracleDriver"


              url="jdbc:oracle://localhost:1158:XEl"
              user="geoportal"
              password="geoportalpwd"
              maxActive="20"
              maxIdle="10"
              maxWait="-1" />
</Context>

CliveReece

hard to say. I provided one suggestion above that you might try to help isolate the issue.

I suspect a problem with your database and/or jdbc setup, since you are getting a "database communication" error. If it was a problem with LDAP, I would expect to see errors like "cannot connect to LDAP" or "cannot authenticate user", etc.

Mirza_MuhammadWaqar

yes i am using LDAP accounts... but it giving the same error... What could be reason for this error.. I check my gpt.xml file and geoportal.xml file both are apparently seems to be OK... I dont know where is the problem...

CliveReece

The 'geoportal' user that one uses in the jdbc configuration in geoportal.xml is ONLY for giving the geoportal web app communication with the database (via jdbc). The 'geoportal' user is a database account, not an LDAP account.

When logging into the geoportal through the web browser interface, you must use an LDAP account.

To separate out LDAP problems from JDBC or database problems in your environment, you might want to try configuring geoportal to simple authentication (see page 2 and page 24-25 of http://sourceforge.net/projects/geoportal/files/Documents/Geoportal/1.0/GeoportalServer_InstallationGuide.pdf/download).

The purpose of using simple authentication (even if temporarily) is to bypass the LDAP, thus trying to isolate whether the problems you are seeing are related to the database/jdbc side of things, or the LDAP side of things.

Mirza_MuhammadWaqar

Well i changed it... But still error is same...
When i try to login through administrator or publisher account i got the following error, " Your username or password was not valid, please try again... " and when i try to login through user account i got "A database communication error has occur", initially i see geoportal user in oracle don't have DBA rights in database now i update it, but still getting same error, its my term project, and tomorrow i have show fully functional geoportal, I am worried, it will not complete till tomorrow, kindly reply fast.

Stefanobruscoli

hello
with same problem I've solved:
replacing the username="geoportal" property by user="geoportal" in geoportal.xml

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.