topic alfresco portlet + postgreSQL in Alfresco Archive

alfresco portlet + postgreSQL

vincent — Fri, 23 Feb 2007 08:51:09 GMT

Hello,I have installed liferay portal (liferay-portal-tomcat-jdk5-4.2.1.zip) and the Alfresco portlet (liferay-portal-alfresco-4.2.1.war) both download on the liferay website. My OS is Windows XP and my application server is tomcat. The alfresco portlet works fine but it uses HSQL db and I would lik

Re: alfresco portlet + postgreSQL

jmliege — Fri, 23 Feb 2007 14:41:41 GMT

Hello,

Maybe the problem is that db tables are not created.

In order to deploy again with no problem (as you started first with HSQL),
you should delete all the alf_data folder.

Secondly, you modify one parameter of the db in your custom-db-connection.properties as follow:

db.schema.update=true

you can remove it later.

Re: alfresco portlet + postgreSQL

vincent — Mon, 26 Feb 2007 08:31:31 GMT

Hello,

Thank you very much for your reply JMLiege.

I will try your solution today, and I will post the result.

Re: alfresco portlet + postgreSQL

vincent — Mon, 26 Feb 2007 13:03:12 GMT

I found the solution to install the alfresco portlet on postgres.
We have to :

unpack the liferay-portal-alfresco-4.2.1.war:

delete the 3 files :

alfresco\WEB-INF\classes\alfresco\extension :

- custom-db-and-data-context.xml
- custom-db-connection.properties
- custom-hibernate-dialect.properties

and modify the file :

alfresco\WEB-INF\classes\alfresco\repository.properties

and put in the following values :

db.schema.update=true
db.driver=org.postgresql.Driver
db.name=alfresco
db.url=jdbcostgresql://localhost/alfresco
db.username=alfresco
db.password=alfresco
db.pool.initial=10
db.pool.max=20

Repack the all files in alfresco.war and deploy this archive with the autodeploy tool of liferay.

(if you installed the portlet before you have to remove the alf_data directory)

Re: alfresco portlet + postgreSQL

jmliege — Tue, 27 Feb 2007 08:11:19 GMT

In fact, you should keep those files and modify them in order to do the same, as it is recommended to avoid changes in the alfresco config files.
That's the main goal of such extension file.

Happy to see that the 'db.schema.update=true' helped you.

Best regards,
JM