[Oreka-devel] How to get oreka database autocreated after a manual install on linux

[Nils O. <po...@ho...>]

Hi,
 
Have now successfully  compiled orkaudio, orktrack and orkweb on Ubuntu Server 14.04 LTS. I have adjusted deploy.xml files for orktrack and orkweb respectively, so that they match the current system and the tomcat7 configuration. And then also built .the war files and installed the orktrack and orkweb applications into tomcat. Adjusted the .../WEB-INF/web.xml and .../WEB-INF/classes/database.hbm.xml for each of these applications. I have also adjusted the orkaudio config at /etc/orkaudio/database.hbm.xml with correct values for my setup.
 
I start orkaudio service, start tomcat and its webapplications orktrack and orkweb. And what I can see no initial errors. But the database is not autocreated as on Windows. 
 
Is there a way to initiate an autocreate of the oreka database on Linux, or must it be created manually?
 
 
The database.hbm.xml looks like this. On Linux, the default database is test in the template. But I've changed to oreka (jdbc:mysql://localhost/oreka). Currently I also have the root account on MySQL and the password mysql. Se config below...
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
  "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>    
 <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
 <property name="hibernate.connection.maxconnections">100</property>
 <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
 <property name="hibernate.connection.url">jdbc:mysql://localhost/oreka</property>
 <property name="hibernate.connection.password">mysql</property>
 <property name="hibernate.connection.username">root</property>
 
 <property name="hibernate.hbm2ddl.auto">update</property> <!-- update, create, create-drop -->
 <property name="hibernate.show_sql">false</property> 
 
 <property name="hibernate.jdbc.use_scrollable_resultset">true</property>
 <property name="hibernate.max_fetch_depth">1</property>
 <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
    </session-factory>
</hibernate-configuration>
 
Regards
 
Nils