[GeoNetwork-users] How to install the Database on an atherserver

GeoNetwork GeoNetwork User
1

Hi Benchekroun,

I posted some scripts a few weeks back about how to do this on MS-SQL, in case you are using this DBMS. You can check the archives, or mail me off line if you need more details. I have not checked these against the latest versions though, so the scripts may or may not work, but the procedure should be the same.

Good luck.

________________________________

From: geonetwork-users-bounces@lists.sourceforge.net on behalf of Andrea Carboni
Sent: Wed 5/30/2007 3:58 PM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] How to install the Database on an atherserver

Hi Benchekroun,

start GAST and:

- select a different dbms
- redo the setup into the new db

Make sure to copy the jdbc driver of your dbms into the web/WEB-INF/lib folder.

Cheers,
Andrea

Hi All,

Could any one help me on how to install the database (data, xml files, etc)
on an other server than the one where geonetwork is installed?.

The default installing process installs the database on the server wher
geonetwork is installed and don't allow to modify the location for the
database.

Thanks in advance,

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
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

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
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

2

Dear Benchekroun,

I think your question was to install the database at "another server" like in "another computer" rather than "another database system" at the same computer (localhost)...? If I am wrong, please disregard this reply.

What I did (for the geonetwork-2.0.2) was to edit the file config.xml in "web/WEB-INF/config.xml" inside the folder where you installed your geonetwork application. Some lines down in this file you find the xml node <resources> where the mckoi resource is enabled as default. If you for example want a MySQL database server located at another computer than the default localhost, (make sure all other resources than the MySQL is flagged as enabled="false") and modify the xml node <geonet><resources><resource><config><url>...

<url>jdbc:mysql://your_server_name/your_database_name</url>

To initiate the tables you need for your database, you may use one of the scripts in the folder "setup/sql/create-db-mysql" also inside the folder where you installed geonetwork. You will also need to load into your new tables the data from the .ddt files in "setup/db/*.ddt".

I do not know if there is another method where you will not need to get into the code. This is what I did. I hope my experience is of some help to you!

Best wishes
Dag Terje

Quoting "Pickering, Jason" <pickeringj@anonymised.com>:

Hi Benchekroun,

I posted some scripts a few weeks back about how to do this on MS-SQL, in case you are using this DBMS. You can check the archives, or mail me off line if you need more details. I have not checked these against the latest versions though, so the scripts may or may not work, but the procedure should be the same.

Good luck.

________________________________

From: geonetwork-users-bounces@lists.sourceforge.net on behalf of Andrea Carboni
Sent: Wed 5/30/2007 3:58 PM
To: geonetwork-users@lists.sourceforge.net
Subject: Re: [GeoNetwork-users] How to install the Database on an atherserver

Hi Benchekroun,

start GAST and:

- select a different dbms
- redo the setup into the new db

Make sure to copy the jdbc driver of your dbms into the web/WEB-INF/lib folder.

Cheers,
Andrea

Hi All,

Could any one help me on how to install the database (data, xml files, etc)
on an other server than the one where geonetwork is installed?.

The default installing process installs the database on the server wher
geonetwork is installed and don't allow to modify the location for the
database.

Thanks in advance,

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.