Issues with the installer

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Issues with the installer

acarboni
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


Reply | Threaded
Open this post in threaded view
|

Re: Issues with the installer

a.doyle
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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/ 
> projects/geonetwork
>

--
Allan Doyle
+1.781.433.2695
[hidden email]




Reply | Threaded
Open this post in threaded view
|

Re: Issues with the installer

Carl Anderson-2
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';)
   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.


Reply | Threaded
Open this post in threaded view
|

Re: Issues with the installer

a.doyle
In reply to this post by a.doyle
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
>> [hidden email]
>> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
>> GeoNetwork OpenSource is maintained at http://sourceforge.net/ 
>> projects/geonetwork
>>
>
> --
> Allan Doyle
> +1.781.433.2695
> [hidden email]
>
>
>
>
> -------------------------------------------------------
> 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
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/geonetwork-users
> GeoNetwork OpenSource is maintained at http://sourceforge.net/ 
> projects/geonetwork
>

--
Allan Doyle
+1.781.433.2695
[hidden email]




Reply | Threaded
Open this post in threaded view
|

Re: Issues with the installer

a.doyle
In reply to this post by Carl Anderson-2
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';)
>   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
[hidden email]