Bug#908618: jameica: MySQL not usable; class not found: com.mysql.jdbc.Driver

[Christian Weiske]

Package: jameica
Version: 2.8.1+dfsg-1
Severity: normal

Dear Maintainer,

I am running a hibiscus server in my network that stores its data in a MySQL
database. Several clients access this very database.

When trying to configure the jameica+hibiscus versions shipped with Debian to
do just this, it crashes because it cannot load the MySQL driver.

I manually installed libmysql-java for this and also added both
 /usr/share/java/mysql.jar
and
 /usr/share/java/mysql-connector-java.jar
to the class path (by running
 $ CLASSPATH=".:/usr/share/java/mysql.jar..." jameica
)
This did not help.

The exception message is:

[Tue Sep 11 22:27:13 CEST 2018][ERROR][main][de.willuhn.jameica.hbci.HBCI.call] unable to init db service
java.rmi.RemoteException: unable to load jdbc driver; nested exception is: 
	java.lang.ClassNotFoundException: loader.jameica: class not found: com.mysql.jdbc.Driver
	at de.willuhn.datasource.db.DBServiceImpl.start(DBServiceImpl.java:287)
	at de.willuhn.jameica.hbci.HBCI.call(HBCI.java:331)
	at de.willuhn.jameica.hbci.HBCI.init(HBCI.java:104)
	at de.willuhn.jameica.plugin.PluginLoader.initPlugin(PluginLoader.java:395)
	at de.willuhn.jameica.plugin.PluginLoader.init(PluginLoader.java:240)
	at de.willuhn.jameica.services.PluginService.init(PluginService.java:39)
	at de.willuhn.boot.BootLoader.resolve(BootLoader.java:139)
	at de.willuhn.boot.BootLoader.resolve(BootLoader.java:119)
	at de.willuhn.boot.BootLoader.getBootable(BootLoader.java:72)
	at de.willuhn.jameica.system.Application.init(Application.java:103)
	at de.willuhn.jameica.system.Application.newInstance(Application.java:87)
	at de.willuhn.jameica.Main.main(Main.java:75)
Caused by: java.lang.ClassNotFoundException: loader.jameica: class not found: com.mysql.jdbc.Driver
	at de.willuhn.util.MultipleClassLoader.load(MultipleClassLoader.java:300)
	at de.willuhn.util.MultipleClassLoader.loadClass(MultipleClassLoader.java:227)
	at de.willuhn.datasource.db.MyDriver.<init>(MyDriver.java:47)
	at de.willuhn.datasource.db.DBServiceImpl.start(DBServiceImpl.java:283)
	... 11 more

Instructions how to switch jameica/hibiscus to MySQL are at:
https://www.willuhn.de/wiki/doku.php?id=support:mysql&s[]=server#hibiscus_konfigurieren

-- System Information:
Debian Release: buster/sid
  APT prefers unstable-debug
  APT policy: (500, 'unstable-debug'), (500, 'unstable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.18.0-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages jameica depends on:
ii  eclipse-platform-data         3.8.1-11
ii  eclipse-rcp                   3.8.1-11
ii  libbcpkix-java                1.60-1
ii  libbcprov-java                1.60-1
ii  libcommons-cli-java           1.4-1
ii  libcommons-collections3-java  3.2.2-1
ii  libcommons-lang-java          2.6-8
ii  libcommons-logging-java       1.2-2
ii  libequinox-osgi-java          3.9.1-1
ii  libh2-java                    1.4.197-2
ii  libicu4j-49-java              49.1-3
ii  libjameica-datasource-java    2.8.1+dfsg-3
ii  libjameica-util-java          2.8-2
ii  libnanoxml2-java              2.2.3.dfsg-6
ii  libpaperclips-java            1.0.4-2
ii  libswt-cairo-gtk-4-jni        4.6.3-2
ii  libswt-gtk2-4-jni             4.6.3-2
ii  libswtcalendar-java           0.5-2
ii  velocity                      1.7-5

jameica recommends no packages.

Versions of packages jameica suggests:
ii  libmckoisqldb-java  1.0.6-2

-- no debconf information