-
1. Re: Permission denied error using PostgresRDBMSAdapter for J
diondodgen Jul 7, 2005 9:58 AM (in response to diondodgen)Hi,
This has been run using Postgres8.0.3 and Postgres7.4 on Suse9.1 and Suse9.3
The scriptCreatePostgresSchema.sql has been used.
I should have included this as part of the stack trace above previous:-
15:43:06,450 INFO [Domain] Initializing namespace : slide
15:43:06,637 INFO [Namespace] Loading namespace slide parameters
15:43:06,715 INFO [Namespace] Loading namespace definition
15:43:06,859 INFO [Namespace] nodestore: org.apache.slide.store.impl.rdbms.J2EEStore
15:43:06,994 INFO [J2EEStore] Retrieving datasource 'PortalDS'
15:43:06,996 INFO [Namespace] securitystore references nodestore
15:43:06,997 INFO [Namespace] lockstore references nodestore
15:43:06,997 INFO [Namespace] revisiondescriptorsstore references nodestore
15:43:06,997 INFO [Namespace] revisiondescriptorstore references nodestore
15:43:06,997 INFO [Namespace] contentstore references nodestore
15:43:07,015 INFO [logger] Setting TLock timeout for store j2ee to 20 seconds
15:43:07,015 INFO [logger] Setting object cache size for store j2ee to 10000
15:43:07,016 INFO [ExtendedStore] Setting permission cache size for store j2ee to 10000
15:43:07,016 INFO [ExtendedStore] Setting lock cache size for store j2ee to 100
15:43:07,016 INFO [ExtendedStore] Setting descriptors cache size for store j2ee to 10000
15:43:07,016 INFO [ExtendedStore] Setting descriptor cache size for store j2ee to 10000
15:43:07,016 INFO [ExtendedStore] Setting content caching for store j2ee to false
15:43:07,016 INFO [ExtendedStore] Setting content cache size for store j2ee to 10000
15:43:07,017 INFO [ExtendedStore] Setting content cache byte size for store j2ee to 10000000
15:43:07,017 INFO [ExtendedStore] Setting transaction content cache size for store j2ee to 1000
15:43:07,017 INFO [ExtendedStore] Setting transaction content cache byte size for store j2ee to 1000000
15:43:07,017 INFO [ExtendedStore] Setting maximum byte size for content cache entry for store j2ee to 50000
15:43:07,017 INFO [ExtendedStore] Enabling full caching causing low isolation
15:43:07,164 INFO [Namespace] Registering Store j2ee (class org.apache.slide.store.ExtendedStore) with parameters {} on scope /
15:43:07,197 INFO [Namespace] Initializing Store j2ee(org.apache.slide.store.ExtendedStore)
15:43:07,619 INFO [Namespace] Loading namespace slide base data
15:43:08,067 ERROR [PostgresRDBMSAdapter] SQL error 0 on /: ERROR: permission denied for relation uri
15:43:08,071 INFO [STDOUT] org.apache.slide.common.ServiceAccessException: Service org.apache.slide.store.impl.rdbms.J2EEStore@1edc290 access error : ERROR: permission denied for relation uri
15:43:08,073 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter.createException(PostgresRDBMSAdapter.java:341)
Again any advice.....
Thanks
Dion