yahoo/oozie — Issue #833: oozie 3.0.2 not creating mysql tables in db
Author: jabirahmed
Created: 2012-02-08 12:20:18+00:00
State: open

i have installed mysql connector and built the new war

jabira@oozie2001:~$ jar -tvf oozie-3.0.2/oozie-server/webapps/oozie.war |grep mysq
789885 Wed Feb 08 12:04:48 UTC 2012 WEB-INF/lib/mysql-connector-java-5.1.18-bin.jar

also set the correct parameters in the oozie-site.xml

oozie.service.StoreService.jdbc.url

JDBC URL.

jdbc:mysql:localhost:3306/ooziedb;create=true

oozie.service.StoreService.jdbc.username

DB user name.

oozieuser

oozie.service.StoreService.jdbc.password

DB user password.

IMPORTANT: if password is emtpy leave a 1 space string, the service trims the value,
if empty Configuration assumes it is NULL.

IMPORTANT: if the StoreServicePasswordService is active, it will reset this value with the value given in
the console.

pass

oozie.service.StoreService.pool.max.active.conn

Max number of connections.

10

oozie.service.StoreService.jdbc.driver

JDBC driver class.

com.mysql.jdbc.Driver

Oozie starts up fine too and i dont see any exceptions in logs other than

but when i check mysql i dont see any tables being created in the db

jabira@oozie2001:~$ mysql -uoozieuser --ppass ooziedb

mysql>
mysql> show tables;
Empty set (0.00 sec)

Not sure whats going wrong here