OS X + Alfresco 2.0 + Postgres 8.2.3

scott_anderson — Tue, 06 Mar 2007 08:06:40 GMT

I am trying to get Alfresco 2.0 to work with PostgreSQL 8.2.3 on OS X. Extrapolating from the available docs and forum commentary I have gotten to this place with my configuration …1) Created an 'alfresco' user and 'alfresco' database for PostgreSQL2) Downloaded and extracted alfresco-community-tomc

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

derek — Tue, 06 Mar 2007 08:58:52 GMT

Hi,

custom-db-connection.properties

dir.root

custom-repository.properties

But the real problem might be that the dialect is not a property value, but just a dangling string in the file. It needs to be hibernate.dialect=….

Regards

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

scott_anderson — Thu, 08 Mar 2007 11:56:52 GMT

> It needs to be hibernate.dialect=….

Duh…a result of my boss feeding me beers late at night to keep me working. Your instructions solved my problem of getting the server started w/o any errors. I did encounter a little bit of trouble getting the server started a second time. If I comment out the db.schema.update property in the custom-repository.properties file (the state I found it before I set it to true), I am seeing some errors related to the app re-attempting to 'auto-update' the schema …

02:59:54,277 ERROR [web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:659)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
   at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:809)
   at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:698)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
   at org.apache.catalina.core.StandardService.start(StandardService.java:450)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
Caused by: org.hibernate.exception.SQLGrammarException: could not get table metadata: JBPM_ACTION
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:100)
   at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:838)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:376)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:643)
   … 32 more
Caused by: java.sql.SQLException: ERROR: function information_schema._pg_keypositions() does not exist
   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1501)
   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1283)
   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:186)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:314)
   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:221)
   at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedExportedKeys(AbstractJdbc2DatabaseMetaData.java:3240)
   at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getImportedKeys(AbstractJdbc2DatabaseMetaData.java:3536)
   at org.hibernate.tool.hbm2ddl.TableMetadata.initForeignKeys(TableMetadata.java:119)
   at org.hibernate.tool.hbm2ddl.TableMetadata.<init>(TableMetadata.java:35)
   at org.hibernate.tool.hbm2ddl.DatabaseMetadata.getTableMetadata(DatabaseMetadata.java:85)
   … 35 more

This appears to be the same result I get when I try to access the foreign keys of the JBPM_ACTION table using NetBeans' db access tools. Is this something I should concern myself with? If I set the db.schema.update to false after the initial startup and shutdown, this auto-update process appears to be skipped on subsequent starts and I believe I am good to go. However, on the initial startup I am seeing this line in the catalina.out log which looks a little suspicious …

03:31:30,867 INFO [domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/2.0/${db.script.dialect}/AlfrescoPostCreate-2.0-FKIndexes.sql

I can't find anywhere where db.script.dialect would get set.

Thanks again,
Scott

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

derek — Thu, 08 Mar 2007 12:13:05 GMT

Hi,

You should only have to set the dialect and the database connection details. Messing about with the auto-update is not really recommended before searching for a solution to the issue. Type this (information_schema._pg_keypositions) into a JIRA search.

Give the workaround a try and let me know if it fixed your issue. It worked for me, but there might be other issues as a result.

Regards

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

scott_anderson — Fri, 09 Mar 2007 02:09:13 GMT

That sql patch seems to be working for me. I can leave the db.schema.update untouched for my installation. Thanks.

topic OS X + Alfresco 2.0 + Postgres 8.2.3 in Alfresco Archive

OS X + Alfresco 2.0 + Postgres 8.2.3

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

Re: OS X + Alfresco 2.0 + Postgres 8.2.3

Re: OS X + Alfresco 2.0 + Postgres 8.2.3