El Lun, 12 de Noviembre de 2007, 5:13 pm, Sergiy Shyrkov escribió:
> Hi Javier,
>
> please, let me know, which version of Jahia you use and post the
> exception stack trace that you get after changes, I described
> (datasource in the jahia.xml and Hibernate dialect in the
> applicationcontext-hibernate.xml).
>
We are running Jahia Profesional 5.x, not sure about the revision... any
place to look for it in the filesystem?
Here are the changes we made to the files you suggested:
[tomcat/webapps/ROOT/WEB-INF/etc/spring/applicationcontext-hibernate.xml]
-------------------------------------------------------------------------
<!-- <prop
key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
-->
<prop
key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.show_sql">false</prop>
[tomcat/conf/Catalina/localhost/jahia.xml]
-----------------------------------------------------------
<Context path="" docBase="ROOT" crossContext="true">
<Manager pathname=""/>
<Resource name="jdbc/jetspeed" auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource" username="jahia_user"
password="jahia_pass"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://192.168.1.5:5432/jahia"
defaultAutoCommit="true"
maxActive="100" maxIdle="30" maxWait="10000"/>
<Resource name="jdbc/jetspeedNonTx" auth="Container"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource" username="jahia" password="..jahia"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://192.168.1.5:5432/jahia"
defaultAutoCommit="true"
maxActive="20" maxIdle="30" maxWait="10000"/>
<!-- Resource configuration for UserTransaction use JOTM -->
<!--
<ResourceLink name="UserTransaction"
global="UserTransaction"
type="javax.transaction.UserTransaction"/>
-->
</Context>
I mail directly to you the full catalina.out of a server startup, for not
to flooding the list.
> Could you also provide more details about the migration, you done from
> HSQL to PostgreSQL?
>
We have not found many documentation about this process, so our aprox was:
Adapting the HSQL sql script, some datatype needed to be adapted in order
to load into postgresql. Then loaded it intro a new jahia database in
postgres and updated rights to allow the jahia machine to ask that
database.
> Thank you!
> Sergiy
>
> Javier Turégano wrote:
>> Hi Sergiy,
>>
>> El Lun, 12 de Noviembre de 2007, 4:41 pm, Sergiy Shyrkov escribió:
>>
>>> Hi Javier,
>>>
>>>
>>
>> First of all thanks for your fast answer.
>>
>>
>>> in the default installation the database connection is configured using
>>> the JNDI datasource that is used in Jahia.
>>> Its name is configured as 'datasource.name' in the jahia.properties
>>> file. If it is specified, other settings have no influence in this
>>> case.
>>> The same datasource is used across all Jahia services.
>>> Its configuration is located in the
>>> <TOMCAT_HOME>/conf/Catalina/localhost/jahia.xml file (in the default
>>> installation).
>>>
>>> You need to change the datasource configuration in the jahia.xml file
>>> from HSQL to PostgreSQL, i.e.:
>>>
>>>
>>
>> We have done this change also, but it looks like that has no effect over
>> our instalation. After the change is enough a tomcat restart or there is
>> more work to do? Is necesary to change also the jahia.xml located in the
>> src tree?
>>
>>
>>> <Context path="/jahia" docBase="jahia" crossContext="true">
>>>
>>> <Manager pathname=""/>
>>>
>>> <Resource name="jdbc/jetspeed" auth="Container"
>>> factory="org.apache.commons.dbcp.BasicDataSourceFactory"
>>> type="javax.sql.DataSource" username="jahia_user"
>>> password="jahia_pass"
>>> driverClassName="org.postgresql.Driver"
>>> url="jdbc:postgresql://192.168.1.5:5432/jahia" defaultAutoCommit="true"
>>> maxActive="100" maxIdle="30" maxWait="10000"/>
>>>
>>> <Resource name="jdbc/jetspeedNonTx" auth="Container"
>>> factory="org.apache.commons.dbcp.BasicDataSourceFactory"
>>> type="javax.sql.DataSource" username="jahia_user"
>>> password="jahia_pass"
>>> driverClassName="org.postgresql.Driver"
>>> url="jdbc:postgresql://192.168.1.5:5432/jahia" defaultAutoCommit="true"
>>> maxActive="20" maxIdle="30" maxWait="10000"/>
>>>
>>> </Context>
>>>
>>>
>>> Kind regards
>>> Sergiy Shyrkov
>>>
>>>
>>
>> Any other idea or posibility about where the source of the problem is?
>>
>>
>
>
--
---------------------------------
Javier Turégano Molina
Jefe de Proyecto
Andago Ingeniería
www.andago.com
t: 916011373 Ext. 45
f: 916011372
--------------------------------
ADE7 A690 29BB C644 3021 3919 C702 E423 014A D1F6
_______________________________________________
install_list mailing list
install_list@jahia.org
http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
