Masalah Konfigurasi MySQL di Pentaho dengan OS Windows XP

[ivan ibnualim]

Assalamu'alaikum,,

Saya sudah ikutin petunjuk untuk konfigurasi MySQL pada ebook "Pentaho
Solutions" yang ditulis oleh Roland Bouman dan Jos van Dongen.
Tapi yang ada malah Pentaho servernya ndak bisa jalan dan muncul
pesan2 error di console Tomcat-nya.

Berikut pesan errornya:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Jul 28, 2010 2:46:34 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jul 28, 2010 2:46:34 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.20
02:46:47,265 ERROR [Logger] misc-
org.pentaho.platform.scheduler.QuartzSystemList
ener: QuartzSystemListener.ERROR_0001 - Scheduler was not properly
initialized a
t startup
org.quartz.SchedulerConfigException: Failure occured during job
recovery. [See n
ested exception: org.quartz.JobPersistenceException: Failed to obtain
DB connect
ion from data source 'myDS': java.sql.SQLException: Could not retrieve
datasourc
e via JNDI url 'java:comp/env/jdbc/Quartz'
org.apache.commons.dbcp.SQLNestedExce
ption: Cannot create PoolableConnectionFactory (socket creation error)
[See nest
ed exception: java.sql.SQLException: Could not retrieve datasource via
JNDI url
'java:comp/env/jdbc/Quartz'
org.apache.commons.dbcp.SQLNestedException: Cannot c
reate PoolableConnectionFactory (socket creation error)]]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSuppo
rt.java:493)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68
)
at
org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j
ava:1010)
at
org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.
java:1152)
at
org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSys
temListener.java:112)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:341)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:323)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:291)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:202)
at
org.pentaho.platform.web.http.context.SolutionContextListener.context
Initialized(SolutionContextListener.java:135)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3934)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4
429)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:630)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:556)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491
)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:314)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at
org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
413)
* Nested Exception (Underlying Cause) ---------------
org.quartz.JobPersistenceException: Failed to obtain DB connection
from data sou
rce 'myDS': java.sql.SQLException: Could not retrieve datasource via
JNDI url 'j
ava:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException:
Cannot cre
ate PoolableConnectionFactory (socket creation error) [See nested
exception: jav
a.sql.SQLException: Could not retrieve datasource via JNDI url
'java:comp/env/jd
bc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableCon
nectionFactory (socket creation error)]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSu
pport.java:575)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(J
obStoreTX.java:109)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSuppo
rt.java:491)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68
)
at
org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j
ava:1010)
at
org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.
java:1152)
at
org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSys
temListener.java:112)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:341)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:323)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:291)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:202)
at
org.pentaho.platform.web.http.context.SolutionContextListener.context
Initialized(SolutionContextListener.java:135)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3934)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4
429)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:630)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:556)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491
)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:314)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at
org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
413)
* Nested Exception (Underlying Cause) ---------------
java.sql.SQLException: Could not retrieve datasource via JNDI url
'java:comp/env
/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot
create Poolable
ConnectionFactory (socket creation error)
at
org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionP
rovider.java:166)
at
org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManage
r.java:111)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSu
pport.java:553)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(J
obStoreTX.java:109)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSuppo
rt.java:491)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68
)
at
org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.j
ava:1010)
at
org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.
java:1152)
at
org.pentaho.platform.scheduler.QuartzSystemListener.startup(QuartzSys
temListener.java:112)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:341)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:323)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:291)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:202)
at
org.pentaho.platform.web.http.context.SolutionContextListener.context
Initialized(SolutionContextListener.java:135)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3934)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4
429)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:630)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:556)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491
)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:314)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at
org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
413)
02:46:47,281 ERROR [Logger] Error: Pentaho
02:46:47,281 ERROR [Logger] misc-
org.pentaho.platform.engine.core.system.Pentaho
System: PentahoSystem.ERROR_0014 - Error while trying to execute
startup sequenc
e for org.pentaho.platform.scheduler.QuartzSystemListener
org.pentaho.platform.api.engine.PentahoSystemException:
PentahoSystem.ERROR_0014
- Error while trying to execute startup sequence for
org.pentaho.platform.sched
uler.QuartzSystemListener
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:349)
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:323)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:291)
at
org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSys
tem.java:202)
at
org.pentaho.platform.web.http.context.SolutionContextListener.context
Initialized(SolutionContextListener.java:135)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContex
t.java:3934)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4
429)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:791)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:77
1)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)

at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:630)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.j
ava:556)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:491
)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java
:314)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(Lifecycl
eSupport.java:119)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)

at
org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)

at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443
)
at
org.apache.catalina.core.StandardService.start(StandardService.java:5
16)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:710
)
at org.apache.catalina.startup.Catalina.start(Catalina.java:
583)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:
288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:
413)
Caused by: org.pentaho.platform.api.engine.PentahoSystemException:
PentahoSystem
.ERROR_0014 - Error while trying to execute startup sequence for
org.pentaho.pla
tform.scheduler.QuartzSystemListener
at
org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemLis
tenersOfStartup(PentahoSystem.java:342)
... 28 more
02:46:47,281 ERROR [Logger] Error end:
Pentaho BI Platform server failed to properly initialize. The system
will not be
available for requests. (Pentaho Platform Engine Core TRUNK-
SNAPSHOT.developmen
t) Base Url = http://localhost:8080/pentaho/, Solution Path = C:
\Program Files\P
entaho\biserver-ce\pentaho-solutions
Jul 28, 2010 2:46:47 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
Jul 28, 2010 2:46:47 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
Jul 28, 2010 2:46:47 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/31 config=null
Jul 28, 2010 2:46:47 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 13425 ms
--------------------------------------------------------------------------------------------------------------------------------------------------------------------

Yang sudah saya lakukan:
1. Install JRE
2. Setting environment untuk JRE
3. Install Pentaho
4. Membuat MySQL schema : hibernate, quartz, data source, dan lain2
5. Mengkonfigurasi file /tomcat/webapss/pentaho/META-INF/context.xml
6. Mengkonfigurasi file pentaho-solutions/system/hibernate/hibernate-
setting.xml
7. Mengkonfigurasi file pentaho-solutions/system/hibernate/
mysql5.hibernate.cfg.xml
8. Mengkonfigurasi file pentaho-solutions/system/applicationContext-
spring-security-jdbc.xml
9. Mengkonfigurasi file pentaho-solutions/system/applicationContext-
spring-security-hibernate-properties



Mohon bantuannya,, ^_^
Sudah 2 hari ngutek2 ini terus,, tapi ndak bisa2. @.@

[Zulfikar Hakim]

Van, sebelumnya mau tanya dulu :

1. basis data quartznya udah jalan / udah ada belum?
2. terus di basis data tersebut minta tolong dicek ada user pentaho_user
ga? Kalo ga ada ditambahkan.

Kalo misalnya belum ada, coba download dump basis data quartz sama
hibernate dari :

biserver-ce/data/mysql

keterangan lebih lanjut ada di buku tersebut halaman 46 : setting up the
MySQL schema.

Thanks

--
Zulfikar Hakim
Dept. Of Informatics Engineering
School of Electrical Engineering and Informatics
Bandung Institute of Technology
----------------------------------------------------------------
Undergraduate Student (Student No. 13507085)

Yahoo! ID : zulfika...@ymail.com
Mobile : +628987 111 510