mysql logging from servicemix/karaf

[Costi Sirb <co...@moredevs.ro>]

Hello,


I'm trying to add database logging to servicemix/karaf by editing the 
pax.logging config file as:

# Root logger
log4j.rootLogger=INFO, out, DB, osgi:VmLogAppender
...
# Database appender
log4j.appender.DB=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DB.URL=jdbc:mysql://localhost:3306/edigrid_logging
log4j.appender.DB.driver=com.mysql.jdbc.Driver
log4j.appender.DB.user=root
log4j.appender.DB.password=
log4j.appender.DB.sql=INSERT INTO logs VALUES('%x','%d','%C','%p','%m')
log4j.appender.DB.layout=org.apache.log4j.PatternLayout

I copied mysql-connector-java-5.1.35.jar file, with and without "karaf" 
prefix to <karaf-home>/lib directory.
I also tried to install mysql from inside karaf (osgi:install -s 
mvn:mysql/mysql-connector-java/5.1.35) but no difference.
Also tried to add mysql-connector-java-5.1.35.jar onto lib and lib/ext 
Java directories.
Also tried to add mysql driver into Import Package manifest field of 
pax-logging-service/pax-logging-api.

*I got the following error at servicemix/karaf startup:**
*
Please wait while Apache ServiceMix is starting...
   2% [=> ]log4j:ERROR Failed to load driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver not found by 
org.ops4j.pax.logging.pax-logging-service [3]
     at 
org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDelegation(BundleWiringImpl.java:1460)
     at 
org.apache.felix.framework.BundleWiringImpl.access$400(BundleWiringImpl.java:72)
     at 
org.apache.felix.framework.BundleWiringImpl$BundleClassLoader.loadClass(BundleWiringImpl.java:1843)
     at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
     at java.lang.Class.forName0(Native Method)
     at java.lang.Class.forName(Class.java:191)
     at org.apache.log4j.jdbc.JDBCAppender.setDriver(JDBCAppender.java:391)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     at java.lang.reflect.Method.invoke(Method.java:606)
     at 
org.apache.log4j.config.PaxPropertySetter.setProperty(PaxPropertySetter.java:310)
     at 
org.apache.log4j.config.PaxPropertySetter.setProperty(PaxPropertySetter.java:269)
     at 
org.apache.log4j.config.PaxPropertySetter.setProperties(PaxPropertySetter.java:196)
     at 
org.apache.log4j.config.PaxPropertySetter.setProperties(PaxPropertySetter.java:108)
     at 
org.apache.log4j.PaxLoggingConfigurator.parseAppender(PaxLoggingConfigurator.java:193)
     at 
org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:735)
     at 
org.apache.log4j.PropertyConfigurator.configureRootCategory(PropertyConfigurator.java:615)
     at 
org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:502)
     at 
org.apache.log4j.PaxLoggingConfigurator.doConfigure(PaxLoggingConfigurator.java:72)
     at 
org.ops4j.pax.logging.service.internal.PaxLoggingServiceImpl.updated(PaxLoggingServiceImpl.java:214)
     at 
org.ops4j.pax.logging.service.internal.PaxLoggingServiceImpl$1ManagedPaxLoggingService.updated(PaxLoggingServiceImpl.java:362)
     at 
org.apache.felix.cm.impl.helper.ManagedServiceTracker.updateService(ManagedServiceTracker.java:148)
     at 
org.apache.felix.cm.impl.helper.ManagedServiceTracker.provideConfiguration(ManagedServiceTracker.java:81)
     at 
org.apache.felix.cm.impl.ConfigurationManager$ManagedServiceUpdate.provide(ConfigurationManager.java:1436)
     at 
org.apache.felix.cm.impl.ConfigurationManager$ManagedServiceUpdate.run(ConfigurationManager.java:1392)
     at org.apache.felix.cm.impl.UpdateThread.run(UpdateThread.java:103)
     at java.lang.Thread.run(Thread.java:745)

***************************************

Can you please give me any advice as I'm kind of desperate.

Thank you,
Costi