Re: Jahia access to remote postgresql failed

Mmmm, we havent done this change... but after making it and restarting
makes no change. Same error messages and also continues apearing info
about hsql at the begining of catalina.out.

Any other idea?

El Lun, 12 de Noviembre de 2007, 4:50 pm, Sergiy Shyrkov escribi=F3:
> You will also need to replace the following Hibernate dialect in the
> <JAHIA_WEB_APP>/WEB-INF/etc/spring/applicationcontext-hibernate.xml
>
>    <prop key=3D"hibernate.dialect">org.hibernate.dialect.HSQLDialect</pro=
p>
>
> with one for PostgreSQL:
>
>    <prop
> key=3D"hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
>
> Kind regards
> Sergiy Shyrkov
>
> Javier Tur=E9gano wrote:
>> Hi all,
>>
>> We are trying to migrate our actual instalation of Jahia 5 from HSQL to
>> Postgresql. After some difficulties we were able to load the hsqldb into
>> postgresql.
>>
>> Then actualized the jahia.properties file this way:
>>
>> db_script                                              =3D
>> postgresql.script
>> db_driver                                              =3D
>> org.postgresql.Driver
>> db_url                                                   =3D
>> jdbc\:postgresql\://192.168.1.5\:5432/jahia
>> db_username                                            =3D   jahia_user
>> db_password                                            =3D   jahia_pass
>> db_transactions                                        =3D   false
>> db_support_embedded_select_statement                    =3D  true
>> db_starthsqlserver                                     =3D   false
>>
>> And restarted jahia. Also tried the db_url withouth \ . But the jahia
>> host
>> is unable to connect to the postgres host. Looked in the lists for that
>> kind of problems and we only find one unresolved question about the same
>> problem. We have checked that there are no network issues: we were able
>> to
>> ask the postgresql server for data from the command line in the jahia
>> host.
>>
>> We found in the catalina.out log surprising things like this:
>>
>> - dbLocation=3D/WEB-INF/var/dbdata/hsqldbjahia
>> - realPath =3D
>> /var/jahia/tomcat/webapps/ROOT/WEB-INF/var/dbdata/hsqldbjahia
>> - jahia.config=3D/WEB-INF/etc/config/jahia.properties
>> - HSQL server will not be started.
>>
>> It looks like Jahia still has info about the old hsql database. Any
>> other
>> configuration file or parameter we should change?
>>
>> The errors we can find in the log:
>>
>> org.springframework.beans.factory.BeanCreationException: Error creating
>> bean with name 'PlatformConfigurator' defined in ServletContext resource
>> [/WEB-INF/etc/jetspeed/conf/assembly/boot/datasource.xml]:
>> Initialization
>> of bean failed; nested exception is
>> org.apache.ojb.broker.metadata.MetadataException: Could not get the
>> metadata from the given datasource
>> org.apache.ojb.broker.metadata.MetadataException: Could not get the
>> metadata from the given datasource
>>         at
>> org.apache.ojb.broker.metadata.JdbcMetadataUtils.fillJCDFromDataSource(J=
dbcMetadataUtils.java:277)
>>
>> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create
>> PoolableConnectionFactory (socket creation error)
>>
>> Caused by: java.sql.SQLException: socket creation error
>>
>>    491 [main] ERROR org.apache.jetspeed.engine.JetspeedEngine.start:130
>> -
>> org.springframework.beans.factory.BeanCreationException: Error creating
>> bean with name 'PlatformConfigurator' defined in ServletContext
>> resource [/WEB-INF/etc/jetspeed/conf/assembly/boot/datasource.xml]:
>> Initialization of bean failed; nested exception is
>> org.apache.ojb.broker.metadata.MetadataException: Could not get the
>> metadata from the given datasource
>>    491 [2007-11-12 13:30:49,081]
>> [org.apache.jetspeed.engine.JetspeedEngine] ERROR -
>> org.springframework.beans.factory.BeanCreationException: Error creating
>> bean with name 'PlatformConfigurator' defined in ServletContext
>> resource [/WEB-INF/etc/jetspeed/conf/assembly/boot/datasource.xml]:
>> Initialization of bean failed; nested exception is
>> org.apache.ojb.broker.metadata.MetadataException: Could not get the
>> metadata from the given datasource
>>    493 [2007-11-12 13:30:49,083] [org.jahia.bin.JahiaJetspeedServlet]
>> FATAL - Jetspeed: init() failed:
>> org.apache.jetspeed.exception.JetspeedException: Jetspeed Initialization
>> exception!
>>
>> Any idea or sugestion to find the problem? If you need more information
>> about the instalation just ask for it.
>>
>> Thank you.
>>
>> ---------------------------------
>> Javier Tur=E9gano Molina
>> Andago Ingenier=EDa
>> www.andago.com
>>
>>
>> _______________________________________________
>> install_list mailing list
>> [email protected]
>> http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
>>
>>
>
> _______________________________________________
> install_list mailing list
> [email protected]
> http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
>


-- =

---------------------------------
Javier Tur=E9gano Molina
Jefe de Proyecto

Andago Ingenier=EDa
www.andago.com
t: 916011373 Ext. 45
f: 916011372
--------------------------------
ADE7 A690 29BB C644 3021  3919 C702 E423 014A D1F6

_______________________________________________
install_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list