[Geonetwork-devel] postgresql support

GeoNetwork GeoNetwork Developer
1

I installed JRE2 1.4.2.10, Apache Tomcat 5.5.15 and
Postgresql 8.1.3 on a server w/ IP 10.0.0.255.
I created the user "geonetwork" w/password "geonet"
and the schema "geonetwork" into the database "geodb";

I installed Geonetwork 2.0.0 on Mckoi database, then I
installed Geonetwork 2.0.1 on 2.0.0.
I think to have followed all Anderson's
instructions...

Lines inserted in config.xml file:
<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.DbmsPool</provider>
<config>c
<user>geonetwork</user>
<password>geonet</password>
<driver>org.postgresql.Driver</driver>
<url>jdbc:postgresql://10.0.0.255/geodb</url>
<poolSize>4</poolSize>
</config>
</resource>

Lines deleted in config.xml file:
<activator
class="org.fao.geonet.activators.McKoiActivator">
<configFile>WEB-INF/db/db.conf</configFile>
</activator>

I start geonetwork (http://10.0.0.255/geonetwork),
but:
- Templates and Sample Metadata are unavailable;
- the value of siteID is not visible in Help, About
and Link pages;
- login produces the message "The requested operation
could not be performed."

I modified the field Metadata.source by introducing
the value of siteID but these problems are still
presents.

Where I made errors?
Thanks in advance!

Roberto

___________________________________
Yahoo! Mail: gratis 1GB per i messaggi e allegati da
10MB
http://mail.yahoo.it

___________________________________
Yahoo! Mail: gratis 1GB per i messaggi e allegati da 10MB
http://mail.yahoo.it

2

Hi Roberto,

the steps you did seem ok. This is clearly a database access problem
(you can verify this enabling debug into che config file and looking at
the logs). Did you put the postgres jdbc driver into the WEB-INF/lib directory?

Cheers,
Andrea

I installed JRE2 1.4.2.10, Apache Tomcat 5.5.15 and
Postgresql 8.1.3 on a server w/ IP 10.0.0.255.
I created the user "geonetwork" w/password "geonet"
and the schema "geonetwork" into the database "geodb";

I installed Geonetwork 2.0.0 on Mckoi database, then I
installed Geonetwork 2.0.1 on 2.0.0.
I think to have followed all Anderson's
instructions...

Lines inserted in config.xml file:
<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.DbmsPool</provider>
<config>c
<user>geonetwork</user>
<password>geonet</password>
<driver>org.postgresql.Driver</driver>
<url>jdbc:postgresql://10.0.0.255/geodb</url>
<poolSize>4</poolSize>
</config>
</resource>

Lines deleted in config.xml file:
<activator
class="org.fao.geonet.activators.McKoiActivator">
<configFile>WEB-INF/db/db.conf</configFile>
</activator>

I start geonetwork (http://10.0.0.255/geonetwork),
but:
- Templates and Sample Metadata are unavailable;
- the value of siteID is not visible in Help, About
and Link pages;
- login produces the message "The requested operation
could not be performed."

I modified the field Metadata.source by introducing
the value of siteID but these problems are still
presents.

Where I made errors?
Thanks in advance!

Roberto

3

There are a couple of issues -
    there is a typo in the config.xml snippet
    only one database resource can be enabled at time (you don't mention turning the others off
    The IP address 10.0.0.255 is suspect, usually addresses with 255's are netmasks.
          It is uncommon, but legal and possible to have that as an IP address with lots of other issues.

roberto ledda wrote:

I installed JRE2 1.4.2.10, Apache Tomcat 5.5.15 and
Postgresql 8.1.3 on a server w/ IP 10.0.0.255.
I created the user "geonetwork" w/password "geonet"
and the schema "geonetwork" into the database "geodb";

I installed Geonetwork 2.0.0 on Mckoi database, then I
installed Geonetwork 2.0.1 on 2.0.0.
I think to have followed all Anderson's
instructions...

Lines inserted in config.xml file:
<resource enabled="true">
<name>main-db</name>
<provider>jeeves.resources.dbms.DbmsPool</provider>
<config>c

extra "c" here

<user>geonetwork</user>
<password>geonet</password>
<driver>org.postgresql.Driver</driver>
<url>jdbc:postgresql://10.0.0.255/geodb</url>
<poolSize>4</poolSize>
</config>
</resource>

Lines deleted in config.xml file:
<activator
class="org.fao.geonet.activators.McKoiActivator">
<configFile>WEB-INF/db/db.conf</configFile>
</activator>

I start geonetwork (http://10.0.0.255/geonetwork),
but: - Templates and Sample Metadata are unavailable;
- the value of siteID is not visible in Help, About
and Link pages;
- login produces the message "The requested operation
could not be performed."

I modified the field Metadata.source by introducing
the value of siteID but these problems are still
presents.

Where I made errors?
Thanks in advance!

Roberto

PostgreSQL does not allow network connections by default

login to the computer running

try
       psql -p 10.0.0.255 geodb geonetwork

if that fails try
    ping 10.0.0.255

lookup and try a different IP address
possibly
       psql -p 127.0.0.1 geodb geonetwork
if the database and geonetwork are on the same machine

look at editing postgresql.conf in your postgresql data directory
    uncomment and set
            listen_addresses = '127.0.0.1'
edit pg_hba.conf
UNDERSTAND what you are doing and don't set the postgresql to be "too" open.

C.