[GeoNetwork-users] Issues with the installer

Hi everybody,

I have discovered the cause of the problems related to the installation of
geonetwork. This comes out when a dbms other than McKoi is selected
during install. The installation phase goes well but geonetwork doesn't start.

Why?

Simple. The config.xml is correctly configured but the installer doesn't remove
the McKoi activator. When geonetwork starts, it tries to start the activator
(even if you choose a dbms different than mcKoi) but it fails because McKoi
doesn't find any data file (you created the db schema into another dbms, do
you remember?). So, the solution is to install geonetwork and remove the
activator from the config.xml file. Basically, you have to remove these lines:

<activator class="org.fao.geonet.activators.McKoiActivator">
     <configFile>WEB-INF/db/db.conf</configFile>
</activator>

Cheers,
Andrea

I just tried a clean reinstall of 2.0.1 on my Mac.

The fix below did not help. My installation was configured to use McKoi so I'm not sure that the rationale for the fix makes sense for my installation. I'll try Archie's suggestion of first installing 2.0.0 and then 2.0.1 as soon as I can.

  Allan

On Jan 19, 2006, at 19:42, Andrea Carboni wrote:

Hi everybody,

I have discovered the cause of the problems related to the installation of
geonetwork. This comes out when a dbms other than McKoi is selected
during install. The installation phase goes well but geonetwork doesn't start.

Why?

Simple. The config.xml is correctly configured but the installer doesn't remove
the McKoi activator. When geonetwork starts, it tries to start the activator
(even if you choose a dbms different than mcKoi) but it fails because McKoi
doesn't find any data file (you created the db schema into another dbms, do
you remember?). So, the solution is to install geonetwork and remove the
activator from the config.xml file. Basically, you have to remove these lines:

<activator class="org.fao.geonet.activators.McKoiActivator">
     <configFile>WEB-INF/db/db.conf</configFile>
</activator>

Cheers,
Andrea

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
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

--
Allan Doyle
+1.781.433.2695
adoyle@anonymised.com

Allan Doyle wrote:

I just tried a clean reinstall of 2.0.1 on my Mac.

The fix below did not help. My installation was configured to use McKoi so I'm not sure that the rationale for the fix makes sense for my installation. I'll try Archie's suggestion of first installing 2.0.0 and then 2.0.1 as soon as I can.

    Allan

from an email to [geonetwork-devel]
I have been able to get a 2.0.1 install running with jetty and McKoi by

install 2.0.0 with jetty and McKoi.
install 2.0.1 with jetty and McKoi onto the same directory (overwriting files).
2.0.0 gets McKoi setup properly, 2.0.1 will leave McKoi alone if it exists but installs the other things.

This method works on FC4 and on FC3

from another email to [geonetwork-devel]

I was able to get geonetwork-2.0.1 working against Postgresql 8.0.
the only real issue seems to be, don't use the longvarchar type and use the text type instead.
and add an type alias into Data Druid for the postgresql driver.

As a manual process

Let a standard geonetwork install against McKoi run.
As a Postgresql DB Admin
   create user geonetwork (create user geonetwork password 'mypass':wink:
   create schema geonetwork (create schema geonetwork authorization geonetwork;)
Create objects using the MySQL script in setup/sql/create-db-mysql.sql
      (the create-db-postgresql.sql script is broken. Druid needs to have a type alias for longvarchar to text added for postgresql)
Download Database-Druid version 3.7 (http://druid.sf.net) version 3.2 does not work
   add the postgresql driver to Druid
   connect to the postgresql database
   navigate to the tables in the geonet schema
   select a table and use the "data" tab
      import from the setup/db/<tab>.ddf file in the geonetwork installation
   import tables in the order
   Categories, Users, User Groups, Groups, Metadata, Metadataategories, Operations, OperationsAllowed
      (foreign keys will fail otherwise. Commit after each import)
copy a postgresql JDBC jar into web/WEB-INF/lib (http://jdbc.postgresql.org)
edit web/WEB-INF/config.xml
   add

                <resource enabled="true">
                        <name>main-db</name>
                        <provider>jeeves.resources.dbms.DbmsPool</provider>
                        <config>
                                <user>geonetwork</user>
                                <password>[PASS]</password>
                                <driver>org.postgresql.Driver</driver>
                                <url>jdbc:postgresql://[HOST]/[DB]</url>
                                <poolSize>4</poolSize>
                        </config>
                </resource>

change [HOST] to be your postgresql host name
change [DB] to be your postgresql database name
change [PASS] to be your geonet login password
set all other main-db resources to be enabled="false"

start geonetwork

C.

On Jan 20, 2006, at 06:49, Allan Doyle wrote:

I just tried a clean reinstall of 2.0.1 on my Mac.

The fix below did not help. My installation was configured to use McKoi so I'm not sure that the rationale for the fix makes sense for my installation. I'll try Archie's suggestion of first installing 2.0.0 and then 2.0.1 as soon as I can.

OK, a clean install of 2.0.0 followed by an install of 2.0.1 worked.

By the way, the installer welcome screen says "Welcome to the installation of geonetwork 2.0.0" and the "about" page also talks about 2.0.0

  Allan

  Allan

On Jan 19, 2006, at 19:42, Andrea Carboni wrote:

Hi everybody,

I have discovered the cause of the problems related to the installation of
geonetwork. This comes out when a dbms other than McKoi is selected
during install. The installation phase goes well but geonetwork doesn't start.

Why?

Simple. The config.xml is correctly configured but the installer doesn't remove
the McKoi activator. When geonetwork starts, it tries to start the activator
(even if you choose a dbms different than mcKoi) but it fails because McKoi
doesn't find any data file (you created the db schema into another dbms, do
you remember?). So, the solution is to install geonetwork and remove the
activator from the config.xml file. Basically, you have to remove these lines:

<activator class="org.fao.geonet.activators.McKoiActivator">
     <configFile>WEB-INF/db/db.conf</configFile>
</activator>

Cheers,
Andrea

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
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

--
Allan Doyle
+1.781.433.2695
adoyle@anonymised.com

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
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

--
Allan Doyle
+1.781.433.2695
adoyle@anonymised.com

Thanks Carl. I just sent mail, the 2.0.0 followed by 2.0.1 trick worked. And one of my next questions was going to be about PostgreSQL since I want to also put PostGIS on the machine. So your additional info about that is going to be helpful.

  Allan

On Jan 20, 2006, at 10:12, Carl Anderson wrote:

Allan Doyle wrote:

I just tried a clean reinstall of 2.0.1 on my Mac.

The fix below did not help. My installation was configured to use McKoi so I'm not sure that the rationale for the fix makes sense for my installation. I'll try Archie's suggestion of first installing 2.0.0 and then 2.0.1 as soon as I can.

    Allan

from an email to [geonetwork-devel]
I have been able to get a 2.0.1 install running with jetty and McKoi by

install 2.0.0 with jetty and McKoi.
install 2.0.1 with jetty and McKoi onto the same directory (overwriting files).
2.0.0 gets McKoi setup properly, 2.0.1 will leave McKoi alone if it exists but installs the other things.

This method works on FC4 and on FC3

from another email to [geonetwork-devel]

I was able to get geonetwork-2.0.1 working against Postgresql 8.0.
the only real issue seems to be, don't use the longvarchar type and use the text type instead.
and add an type alias into Data Druid for the postgresql driver.

As a manual process

Let a standard geonetwork install against McKoi run.
As a Postgresql DB Admin
  create user geonetwork (create user geonetwork password 'mypass':wink:
  create schema geonetwork (create schema geonetwork authorization geonetwork;)
Create objects using the MySQL script in setup/sql/create-db-mysql.sql
     (the create-db-postgresql.sql script is broken. Druid needs to have a type alias for longvarchar to text added for postgresql)
Download Database-Druid version 3.7 (http://druid.sf.net) version 3.2 does not work
  add the postgresql driver to Druid
  connect to the postgresql database
  navigate to the tables in the geonet schema
  select a table and use the "data" tab
     import from the setup/db/<tab>.ddf file in the geonetwork installation
  import tables in the order
  Categories, Users, User Groups, Groups, Metadata, Metadataategories, Operations, OperationsAllowed
     (foreign keys will fail otherwise. Commit after each import)
copy a postgresql JDBC jar into web/WEB-INF/lib (http://jdbc.postgresql.org)
edit web/WEB-INF/config.xml
  add

                <resource enabled="true">
                        <name>main-db</name>
                        <provider>jeeves.resources.dbms.DbmsPool</provider>
                        <config>
                                <user>geonetwork</user>
                                <password>[PASS]</password>
                                <driver>org.postgresql.Driver</driver>
                                <url>jdbc:postgresql://[HOST]/[DB]</url>
                                <poolSize>4</poolSize>
                        </config>
                </resource>

change [HOST] to be your postgresql host name
change [DB] to be your postgresql database name
change [PASS] to be your geonet login password
set all other main-db resources to be enabled="false"

start geonetwork

C.

--
Allan Doyle
+1.781.433.2695
adoyle@anonymised.com