[GeoNetwork-users] PostgreSQL 8.4 on Geonetwork 2.4.2

theresia_freska · November 21, 2009, 11:58am

Hi all,

I'm trying to setup GN 2.4.2, Tomcat 6.0, and PostgreSQL 8.4. I have a problem with the configuration of PostgreSQL.

I did what is told in http://trac.osgeo.org/geonetwork/wiki/HowToMoveFromMySQLToPostgres, that is to add several lines in pg_hba.conf. But every time I restart PostgreSQL, the service couldn't start. There is no error log in the event viewer. So, for now I left out this step.

I added this in GN config.xml, and set <resource enabled="false"> for the other database configurations.

<resource enabled="true">
            <name>geonetwork</name> 
            <provider>jeeves.resources.dbms.DbmsPool</provider>
            <config>
                <user>postgres</user>
                <password>postgres</password>
                <driver>org.postgresql.Driver</driver>
                <url>jdbc:postgresql://localhost:5432/geonetwork</url>
                <poolSize>10</poolSize>
            </config>
        </resource>

I also did the database configuration in GAST.

They don't work. I can't fetch the "CATEGORIES" values. In the lib folder, I have these files, postgresql-8.4-701.jdbc3.jar; postgresql-8.4-701.jdbc4.jar. Do I have to enable these drivers in some other configuration files?

Thanks.

ajs6f · November 21, 2009, 1:02pm

If you leave out appropriate alterations to pg_hba.conf, your connection between GN and PostgreSQL will not work. pg_hba.conf controls who may connect to your db server and under what conditions. Please examine:

http://www.postgresql.org/docs/8.4/interactive/auth-pg-hba-conf.html

to understand this most important config. It should also be asked, did you make the appropriate alterations to postgresql.conf as detailed on the same page written by Mr. Doeleman?

If your server refuses to start after changing these files, it's not unlikely that you edited one of them in some way that isn't legal syntax for that file. That's a question for the PostgreSQL lists. Once you have a PostgreSQL server up and running, we can connect it to GN.

---
A. Soroka
Digital Research and Scholarship R & D
the University of Virginia Library

On Nov 21, 2009, at 6:58 AM, theresia freska wrote:

Hi all,

I'm trying to setup GN 2.4.2, Tomcat 6.0, and PostgreSQL 8.4. I have a problem with the configuration of PostgreSQL.

I did what is told in http://trac.osgeo.org/geonetwork/wiki/HowToMoveFromMySQLToPostgres, that is to add several lines in pg_hba.conf. But every time I restart PostgreSQL, the service couldn't start. There is no error log in the event viewer. So, for now I left out this step.

I added this in GN config.xml, and set <resource enabled="false"> for the other database configurations.

       <resource enabled="true">
           <name>geonetwork</name> 
           <provider>jeeves.resources.dbms.DbmsPool</provider>
           <config>
               <user>postgres</user>
               <password>postgres</password>
               <driver>org.postgresql.Driver</driver>
               <url>jdbc:postgresql://localhost:5432/geonetwork</url>
               <poolSize>10</poolSize>
           </config>
       </resource>

I also did the database configuration in GAST.

They don't work. I can't fetch the "CATEGORIES" values. In the lib folder, I have these files, postgresql-8.4-701.jdbc3.jar; postgresql-8.4-701.jdbc4.jar. Do I have to enable these drivers in some other configuration files?

Thanks.

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

Gustavo_Gonzalez · November 21, 2009, 4:43pm

Hi theresia

Your config.xml is wrong, this should be

<resource enabled="true">
            <name>main-db</name>  
            <provider>jeeves.resources.dbms.DbmsPool</provider>
            <config>
                <user>postgres</user>
                <password>postgres</password>
                <driver>org.postgresql.Driver</driver>
                <url>jdbc:postgresql://localhost:5432/geonetwork</url>
                <poolSize>10</poolSize>
            </config>
        </resource>

Sorry for my English.

Gustavo.

-----Original Message-----
From: theresia freska [mailto:frezzz_54@anonymised.com]
Sent: sábado, 21 de noviembre de 2009 6:58
To: geonetwork-users@lists.sourceforge.net
Subject: [GeoNetwork-users] PostgreSQL 8.4 on Geonetwork 2.4.2

Hi all,

I'm trying to setup GN 2.4.2, Tomcat 6.0, and PostgreSQL 8.4. I have a
problem with the configuration of PostgreSQL.

I did what is told in
http://trac.osgeo.org/geonetwork/wiki/HowToMoveFromMySQLToPostgres, that is
to add several lines in pg_hba.conf. But every time I restart PostgreSQL,
the service couldn't start. There is no error log in the event viewer. So,
for now I left out this step.

I added this in GN config.xml, and set <resource enabled="false"> for the
other database configurations.

<resource enabled="true">
            <name>geonetwork</name> 
            <provider>jeeves.resources.dbms.DbmsPool</provider>
            <config>
                <user>postgres</user>
                <password>postgres</password>
                <driver>org.postgresql.Driver</driver>
                <url>jdbc:postgresql://localhost:5432/geonetwork</url>
                <poolSize>10</poolSize>
            </config>
        </resource>

I also did the database configuration in GAST.

They don't work. I can't fetch the "CATEGORIES" values. In the lib folder, I
have these files, postgresql-8.4-701.jdbc3.jar;
postgresql-8.4-701.jdbc4.jar. Do I have to enable these drivers in some
other configuration files?

Thanks.

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4615 (20091117) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Heikki_Doeleman · November 21, 2009, 7:13pm

hi Theresia,

I'd recommend also to look at the Posgres section on GeoNetwork TV, which
you can find at http://geonetwork.tv/postgres.

Kind regards
Heikki Doeleman

On Sat, Nov 21, 2009 at 5:43 PM, Gustavo Gonzalez
<aguardientico@anonymised.com>wrote:

Hi theresia

Your config.xml is wrong, this should be

       <resource enabled="true">
           <name>main-db</name>  
            <provider>jeeves.resources.dbms.DbmsPool</provider>
           <config>
               <user>postgres</user>
               <password>postgres</password>
               <driver>org.postgresql.Driver</driver>
               <url>jdbc:postgresql://localhost:5432/geonetwork</url>
               <poolSize>10</poolSize>
           </config>
       </resource>

Sorry for my English.

Gustavo.

-----Original Message-----
From: theresia freska [mailto:frezzz_54@anonymised.com]
Sent: sábado, 21 de noviembre de 2009 6:58
To: geonetwork-users@lists.sourceforge.net
Subject: [GeoNetwork-users] PostgreSQL 8.4 on Geonetwork 2.4.2

Hi all,

I'm trying to setup GN 2.4.2, Tomcat 6.0, and PostgreSQL 8.4. I have a
problem with the configuration of PostgreSQL.

I did what is told in
http://trac.osgeo.org/geonetwork/wiki/HowToMoveFromMySQLToPostgres, that
is
to add several lines in pg_hba.conf. But every time I restart PostgreSQL,
the service couldn't start. There is no error log in the event viewer. So,
for now I left out this step.

I added this in GN config.xml, and set <resource enabled="false"> for the
other database configurations.

       <resource enabled="true">
           <name>geonetwork</name> 
           <provider>jeeves.resources.dbms.DbmsPool</provider>
           <config>
               <user>postgres</user>
               <password>postgres</password>
               <driver>org.postgresql.Driver</driver>
               <url>jdbc:postgresql://localhost:5432/geonetwork</url>
               <poolSize>10</poolSize>
           </config>
       </resource>

I also did the database configuration in GAST.

They don't work. I can't fetch the "CATEGORIES" values. In the lib folder,
I
have these files, postgresql-8.4-701.jdbc3.jar;
postgresql-8.4-701.jdbc4.jar. Do I have to enable these drivers in some
other configuration files?

Thanks.

__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 4615 (20091117) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus
on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork