Hi all,
I've been successfully using Apache Jackrabbit 2.4.3 and now 2.6.0
(standalone server in both cases) using the default configuration, so the
repository is stored on the filesystem.
How can I make it connect to a MySQL back end instead? I don't need to
worry about migration, just set it up as a fresh install.
After trying the steps below, Jackrabbit fails to start correctly or
populate the DATASTORE table in the database, and I find this error in the
logs:
ERROR [main] RepositoryImpl.java:366
failed to start Repository: Cannot instantiate persistence
manager org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager
javax.jcr.RepositoryException: Cannot instantiate persistence manager
org.apache.jackrabbit.core.persistence.pool.MySqlPersistenceManager
[... oodles of backtrace cut ...]
What I've done so far:
I've created the Jackrabbit database/user, which I can connect to no
problem:
mysql -D jackrabbit -u jackrabbit -h localhost -pjackrabbit
I started with a clean slate (empty /var/jackrabbit directory), except the
configuration file comes from here:
https://raw.github.com/wiki/jackalope/jackalope/files/repository.xml
Here's the startup script I'm using:
https://github.com/sixty-nine/Jackrabbit-startup-script
And here's the java process that runs:
java -XX:MaxPermSize=128m -Xmx512M -Xms128M -Dcom.sun.management.jmxremote
-Dcom.sun.management.jmxremote.port=1111
-Dcom.sun.management.jmxremote.authenticate=true
-Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.password.file=/opt/jackrabbit/startup/jmx.user
-Dcom.sun.management.jmxremote.access.file=/opt/jackrabbit/startup/jmx.role
-jar /opt/jackrabbit/jackrabbit-standalone-2.6.0.jar -h 127.0.0.1 -p 8080
I don't think I get far enough for it to matter, but I'm using MySQL
5.5.28-1.
I'm having the above problem with both 2.4.3 and 2.6.0.
Also:
java version "1.6.0_24"
OpenJDK Runtime Environment (IcedTea6 1.11.5) (6b24-1.11.5-1)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)
Plus I subsequently installed the MySQL JDBC library on Debian:
apt-get install libmysql-java
Thanks,
Lars.
