This repository was archived by the owner on Jan 6, 2018. It is now read-only.
This repository was archived by the owner on Jan 6, 2018. It is now read-only.
oozie 3.0.2 not creating mysql tables in db #833
Description
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
<property>
<name>oozie.service.StoreService.jdbc.url</name>
<description>
JDBC URL.
</description>
<value>jdbc:mysql:localhost:3306/ooziedb;create=true</value>
</property>
<property>
<name>oozie.service.StoreService.jdbc.username</name>
<description>
DB user name.
</description>
<value>oozieuser</value>
</property>
<property>
<name>oozie.service.StoreService.jdbc.password</name>
<description>
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.
</description>
<value>pass</value>
</property>
<property>
<name>oozie.service.StoreService.pool.max.active.conn</name>
<description>
Max number of connections.
</description>
<value>10</value>
</property>
<property>
<name>oozie.service.StoreService.jdbc.driver</name>
<description>
JDBC driver class.
</description>
<value>com.mysql.jdbc.Driver</value>
</property>
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