Hi, and thanks! That seemed to fix that problem. Now I'll just have to figure out where Jahia is supposed to have stored user credentials, and I just might have Jahia running on PostgreSQL. (apparently another bug in their setup-wizard)
Thanks a bunch. BTW: Jahia 6 CE seems to be using Jackrabbit 1.5-679434. // JHB http://linkedin.com/janhelgebergesen On Tue, Feb 17, 2009 at 11:19 PM, Alexander Klimetschek <[email protected]>wrote: > On Tue, Feb 17, 2009 at 11:10 PM, Alexander Klimetschek > <[email protected]> wrote: > > On Tue, Feb 17, 2009 at 10:10 PM, Jan-Helge Bergesen <[email protected]> > wrote: > >> I'm trying to get Jahia 6 CE up and running with PostgreSQL 8.3 on > Ubuntu > >> 8.10. > >> > >> [org.apache.jackrabbit.core.fs.db.DatabaseFileSystem] - failed to > initialize > >> file system > >> org.postgresql.util.PSQLException: ERROR: type "varbinary" does not > exist > > > > Seems to be that Jahia includes an old version of Jackrabbit, because > > this issue was fixed in Jackrabbit 1.4 already. Here is the old issue: > > https://issues.apache.org/jira/browse/JCR-949 > > Upps, it's not the journal, but the DatabaseFileSystem. Then I suspect > that the repository.xml/workspace.xml configuration of your Jackrabbit > sets the wrong schema for the DbFileSystem [1]. The schema must be > "postgresql": > > <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"> > <param name="driver" value="...."/> > <param name="url" value="jdbc:....."/> > <param name="schema" value="postgresql"/> <!-- this is the > important config --> > ..... > </FileSystem> > > You'll have to change all occurences of the DbFileSystem in > repository.xml and all workspace.xml. > > [1] > http://jackrabbit.apache.org/api/1.5/org/apache/jackrabbit/core/fs/db/DbFileSystem.html > > Regards, > Alex > > -- > Alexander Klimetschek > [email protected] >
