Don't modify repositories.xml. You should only have to modify
magnolia.properties, setting magnolia.repositories.jackrabbit.config to
the webapp relative path to your jackrabbit-mysql-search.xml file. Ie:
magnolia.repositories.jackrabbit.config=WEB-INF/config/repo-config/jackrabbit-mysql-search.xml
As to the errors below, I would:
1. If you have data in any of the magnolia workspaces/repositories,
export it using the export tool.
2. Shutdown magnolia
3. Delete all files in the repositories directory
4. Drop all table in your database. MySQL doesn't alter it's user
accounts or access when databases are dropped, so I've done this by
dropping the database and then re-created it (eg drop mgnlAuthor; create
mgnlAuthor;).
5. Restart magnolia and watch for messages in
logs/magnolia-bootstrap.log and logs/magnolia-debug.log
--David
sthikkireddy wrote:
Hi list,
Thank u very much David Smith.Now its working. But now i am getting
the following messages and the tomcat was shutdown with the message
INFO: Error shutting down the channel 8009
java.lang.NullPointerException
ERROR info.magnolia.cms.beans.config.ContentRepository
ContentRepository.java(getInternalWorkspaceName:596) 15.05.2007
15:32:18 No Repository/Workspace name mapping defined for usergroups
ERROR info.magnolia.cms.beans.config.ContentRepository
ContentRepository.java(getInternalWorkspaceName:596) 15.05.2007
15:32:19 No Repository/Workspace name mapping defined for mgnlSystem
ERROR info.magnolia.cms.beans.config.ContentRepository
ContentRepository.java(getInternalWorkspaceName:596) 15.05.2007
15:32:21 No Repository/Workspace name mapping defined for mgnlVersion
ERROR info.magnolia.cms.beans.config.ContentRepository
ContentRepository.java(getInternalWorkspaceName:596) 15.05.2007
15:32:22 No Repository/Workspace name mapping defined for dms
ERROR info.magnolia.cms.beans.config.ContentRepository
ContentRepository.java(getInternalWorkspaceName:596) 15.05.2007
15:32:23 No Repository/Workspace name mapping defined for Store
ERROR info.magnolia.cms.beans.config.ContentRepository
ContentRepository.java(getInternalWorkspaceName:596) 15.05.2007
15:32:24 No Repository/Workspace name mapping defined for Expressions
what i had done wrong. could u plz tell me what shud i do to get rid
of this. i passed the value
WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml for configFile
attibute in repositories.xml file two times. Is it correct? what
should i do now?
regards,
sthikkireddy.
Quoting David Smith <[email protected]>:
The value of schema isn't passed to the database driver for config.
Jackrabbit uses the value to look up a sql script resource file. That
file has db specific commands for creating the required tables as
necessary. As a rule of thumb the value matches the database in use.
In this case, set the value to "postgresql" for a postgresql database.
--David
sthikkireddy wrote:
Hi list,
I am deploying the magnolia with the changes for database
configuration. I configured magnolia repository to postgreSQL. My
jackrabbit-pgsql-search.xml file is as follows
<param name="driver" value="org.postgresql.Driver"/>
<param name="url"
value="jdbc:postgresql://127.0.0.1:5432/magnolia_public?autoReconnect=true"/>
<param name="schema" value="public"/>
<param name="user" value="postgres"/>
<param name="password" value="postgres"/>
But it is throwing the error as follows
ERROR info.magnolia.jackrabbit.ProviderImpl
ProviderImpl.java(init:176) 15.05.2007 14:37:03 Unable to
initialize repository: Cannot instantiate persistence manager
org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager:
Configuration error: unknown schema 'public'
javax.jcr.RepositoryException: Cannot instantiate persistence
manager
org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager:
Configuration error: unknown schema 'public': Configuration error:
unknown schema 'public'
what should be the problem. I have created two databases as
magnolia_author and magnolia_public. What should be the schema
value in the above code. I have not specified any value for schema
in pgsql. we are using pgadmin as a tool for DB admin console.
regards
sthikkireddy
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
