I was able to get this working on Tomcat, thank for your help. Now that I have gotten my feet wet, I want to try to get this working on JBoss.
I checked the mailing list and could not find what you are referring to. I have a couple questions concerning Anthony's response. By "Another syntax is used for JDBC paths" are you referring to changing the syntax in the jackrabbit-mysql-search.xml file or in the JBoss datasource definition itself, or something else entirely? Is this "jdbc not bound" error due to the DataSourcePersistenceManager, or is it a problem with magnolia regardless or persistence manager. In other words, if I tried to use a JNDI datasource bound to Derby instead of MySQL would I still be getting this same error. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 2:44 AM To: [email protected] Subject: Re: [magnolia-user] Derby to MySQL: Problems with DataSourcePersistenceManager wiki I remember that for JBoss, it's another syntax which is used for JDBC paths. It has already been pointed out on the mailing list. For your problem Narinder, have you deleted the "repositories" directory, and clean all MySQL tables in order to force Magnolia to bootstrap ? Because the community edition is shipped with already bootstrapped instances which use the jackrabbit derby driver. Anthony Narinder Kumar a écrit : > Hi James, > > I won't be able to tell you about JBoss, but while integrating with > Tomcat, I also went through similar errors. The problem was perhaps, > you copied just the contents mentioned in wiki page in the config file > : jackrabbit-dspm-search-author.xml. We must put the definition part > as well in the file. My complete file looks like : > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE Repository [ > <!-- > the Repository element configures a repository instance; > individual workspaces of the repository are configured through > separate configuration files called workspace.xml which are > located in a subfolder of the workspaces root directory > (see Workspaces element). > it consists of > a FileSystem element (the virtual file system > used by the repository to persist global state such as > registered namespaces, custom node types, etc.. > a Security element that specifies the name of the app-entry > in the JAAS config and the access manager > a Workspaces element that specifies to the location of > workspaces root directory and the name of default workspace > a Workspace element that is used as a workspace configuration > template; it is used to create the initial workspace if > there's > no workspace yet and for creating additional workspaces > through > the api > a SearchIndex element that is used for configuring per > workspace > Indexing-related settings > a Versioning element that is used for configuring > versioning-related settings > --> > <!ELEMENT Repository > (FileSystem,Security,Workspaces,Workspace,Versioning)> > <!-- > a virtual file system > --> > <!ELEMENT FileSystem (param*)> > <!ATTLIST FileSystem > class CDATA #REQUIRED> > <!-- > the Security element specifies the name (appName attribute) > of the JAAS configuration app-entry for this repository. > it also specifies the access manager to be used (AccessManager > element). > --> > <!ELEMENT Security (AccessManager, LoginModule?)> > <!ATTLIST Security > appName CDATA #REQUIRED> > <!-- > the AccessManager element configures the access manager to be > used by > this repository instance; the class attribute specifies the FQN > of the > class implementing the AccessManager interface > --> > <!ELEMENT AccessManager (param*)> > <!ATTLIST AccessManager > class CDATA #REQUIRED> > <!-- > generic parameter (name/value pair) > --> > <!ELEMENT param EMPTY> > <!ATTLIST param > name CDATA #REQUIRED > value CDATA #REQUIRED> > <!-- > the LoginModule element optionally specifies a JAAS login > module to > authenticate users. This feature allows the use of Jackrabbit in a > non-JAAS environment. > --> > <!ELEMENT LoginModule (param*)> > <!ATTLIST LoginModule > class CDATA #REQUIRED> > <!-- > the Workspaces element specifies the workspaces root directory > (rootPath attribute) and the name of the default workspace > (defaultWorkspace attribute). > individual workspaces are configured through individual > workspace.xml > files located in a subfolder each of the workspaces root > directory. > --> > <!ELEMENT Workspaces EMPTY> > <!ATTLIST Workspaces > rootPath CDATA #REQUIRED > defaultWorkspace CDATA #REQUIRED> > <!-- > the Workspace element serves as a workspace configuration > template; > it is used to create the initial workspace if there's no > workspace yet > and for creating additional workspaces through the api > --> > <!ELEMENT Workspace (FileSystem,PersistenceManager,SearchIndex?)> > <!ATTLIST Workspace > name CDATA #REQUIRED> > <!-- > the PersistenceManager element configures the persistence manager > to be used for the workspace; the class attribute specifies the > FQN of the class implementing the PersistenceManager interface > --> > <!ELEMENT PersistenceManager (param*)> > <!ATTLIST PersistenceManager > class CDATA #REQUIRED> > <!-- > the SearchIndex element specifies the locaction of the search > index > (used by the QueryHandler); the class attribute specifies the > FQN of the class implementing the QueryHandler interface. > --> > <!ELEMENT SearchIndex (param*,FileSystem?)> > <!ATTLIST SearchIndex > class CDATA #REQUIRED> > <!-- > the Versioning element configures the persistence manager > to be used for persisting version state > --> > <!ELEMENT Versioning (FileSystem, PersistenceManager)> > <!ATTLIST Versioning > rootPath CDATA #REQUIRED > > > ]> > <Repository> > <FileSystem > class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> > <param name="path" value="${rep.home}/repository"/> > </FileSystem> > <Security appName="Jackrabbit"> > <AccessManager > class="org.apache.jackrabbit.core.security.SimpleAccessManager"></AccessManager> > > > <LoginModule > class="org.apache.jackrabbit.core.security.SimpleLoginModule"> > <param name="anonymousId" value="anonymous"/> > </LoginModule> > </Security> > <Workspaces rootPath="${rep.home}/workspaces" > defaultWorkspace="default"/> > <Workspace name="default"> > <FileSystem > class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> > <param name="path" value="${wsp.home}/default" /> > </FileSystem> > <PersistenceManager > class="com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager"> > > <param name="dataSourceLocation" > value="java:comp/env/jdbc/magnolia"/> > <param name="schemaObjectPrefix" value="author_${wsp.name}_"/> > <param name="externalBLOBs" value="false"/> > </PersistenceManager> > <SearchIndex > class="org.apache.jackrabbit.core.query.lucene.SearchIndex"> > <param name="textFilterClasses" > > value="org.apache.jackrabbit.core.query.MsExcelTextFilter,org.apache.jackrabbit.core.query.MsPowerPointTextFilter,org.apache.jackrabbit.core.query.MsWordTextFilter,org.apache.jackrabbit.core.query.PdfTextFilter,org.apache.jackrabbit.core.query.HTMLTextFilter,org.apache.jackrabbit.core.query.XMLTextFilter,org.apache.jackrabbit.core.query.RTFTextFilter"/> > > > <param name="path" value="${wsp.home}/index"/> > <param name="useCompoundFile" value="true"/> > <param name="minMergeDocs" value="100"/> > <param name="volatileIdleTime" value="3"/> > <param name="maxMergeDocs" value="100000"/> > <param name="mergeFactor" value="10"/> > <param name="bufferSize" value="10"/> > </SearchIndex> > </Workspace> > <Versioning rootPath="${rep.home}/version"> > <FileSystem > class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> > <param name="path" value="${rep.home}/workspaces/version"/> > </FileSystem> > <PersistenceManager > class="com.iorgagroup.jackrabbit.core.state.db.DataSourcePersistenceManager"> > > <param name="dataSourceLocation" > value="java:comp/env/jdbc/magnolia"/> > <param name="schemaObjectPrefix" value="author_version_"/> > <param name="externalBLOBs" value="false"/> > </PersistenceManager> > </Versioning> > </Repository> > > After making the change in Author and Public instances, I am getting > no errors during starting up. > > But that leads me to other problems while trying to publish new > content from Author instance : > > ERROR info.magnolia.module.admininterface.commands.ActivationCommand > Activation > Command.java(execute:86) 26.03.2007 12:46:55 can't activate > info.magnolia.cms.exchange.ExchangeException: Message received from > subscriber: > Activation failed | failed to build path of > 0bffc839-1382-4499-990c-281968b66291 > : 271e4431-ac45-4dd6-9e23-3778566c88a1 has no child entry for > 0bffc839-1382-4499 > -990c-281968b66291: Message received from subscriber: Activation > failed | failed > to build path of 0bffc839-1382-4499-990c-281968b66291: > 271e4431-ac45-4dd6-9e23- > 3778566c88a1 has no child entry for 0bffc839-1382-4499-990c-281968b66291 > at > info.magnolia.cms.exchange.simple.BaseSyndicatorImpl.activate(BaseSyn > dicatorImpl.java:255) > at > info.magnolia.module.admininterface.commands.ActivationCommand.execut > e(ActivationCommand.java:82) > at > info.magnolia.commands.MgnlCommand.executePooledOrSynchronized(MgnlCo > mmand.java:141) > at > info.magnolia.commands.MgnlCommand.execute(MgnlCommand.java:128) > at > info.magnolia.module.workflow.MgnlParticipant.consume(MgnlParticipant > .java:116) > at > openwfe.org.embed.impl.engine.AbstractEmbeddedParticipant.dispatch(Ab > stractEmbeddedParticipant.java:154) > at > openwfe.org.engine.expressions.ParticipantExpression.dispatch(Partici > pantExpression.java:456) > at > openwfe.org.engine.expressions.ParticipantExpression.regularDispatch( > ParticipantExpression.java:471) > at > openwfe.org.engine.expressions.ParticipantExpression.apply(Participan > tExpression.java:414) > at > openwfe.org.engine.expressions.raw.RawExpression.apply(RawExpression. > java:370) > > Any pointers, tips.. > > Regards > Narinder > > From: James Frankman [mailto:[EMAIL PROTECTED] > Sent: Sun 3/25/2007 7:55 AM > To: [email protected] > Subject: [magnolia-user] Derby to MySQL: Problems with > DataSourcePersistenceManager wiki > > > I tried to follow this wiki in an attempt to switch to MySQL but had > problems with JBoss and Tomcat. With JBoss, the solution provided > could never find the JNDI data source I set up for MySQL. I kept > getting "jdbc not bound" errors. > > I tried to follow the wiki more exactly by trying to do it with > Tomcat, but I get the following error: > > Has anybody successfully implmented the instructions on the Wiki? > Perhaps there is a mistake, or can someone give me any ideas what is > going wrong? > > INFO info.magnolia.jackrabbit.ProviderImpl > ProviderImpl.java(init:143) 25.03.2 > 007 00:54:34 Loading repository at > C:\jameswork\magnolia-3.0.2\tomcat\webapps\m > agnoliaAuthor\repositories\magnolia (config file: > C:\jameswork\magnolia-3.0.2\to > mcat\webapps\magnoliaAuthor\WEB-INF\config\repo-conf\jackrabbit-dspm-search-auth > > > or.xml) > [Fatal Error] :-1:-1: Premature end of file. > ERROR info.magnolia.jackrabbit.ProviderImpl > ProviderImpl.java(init:176) 25.03.2 > 007 00:54:35 Unable to initialize repository: Configuration file > syntax error.: > Premature end of file. > org.apache.jackrabbit.core.config.ConfigurationException: > Configuration file syn > tax error.: Premature end of file.: Premature end of file. > at > org.apache.jackrabbit.core.config.ConfigurationParser.parseXML(Config > urationParser.java:548) > at > org.apache.jackrabbit.core.config.ConfigurationParser.parseWorkspaceC > onfig(ConfigurationParser.java:296) > at > org.apache.jackrabbit.core.config.RepositoryConfig.loadWorkspaceConfi > g(RepositoryConfig.java:366) > at > org.apache.jackrabbit.core.config.RepositoryConfig.init(RepositoryCon > fig.java:320) > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/developer.html > ---------------------------------------------------------------- > > ---------------------------------------------------------------- > for list details see > http://www.magnolia.info/en/developer.html > ---------------------------------------------------------------- > ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/developer.html ---------------------------------------------------------------- ---------------------------------------------------------------- for list details see http://www.magnolia.info/en/developer.html ----------------------------------------------------------------
