I would suggest the following sequence: 1. Create your database 2. Create all the tables using the ddl script "mysql5.sql" and the mysql tool. 3. Edit the properties file make ddl.generation FALSE 4. Start Matterhorn
Hank On Thu, Apr 26, 2012 at 12:15 AM, Olli Salo <[email protected]> wrote: > > Hi, > > I decided to ask this question on this list because we're confused about > the correct way of generating the sql tables. So the question: should we > set the > > org.opencastproject.db.ddl.**generation=VALUE > > in > > /opt/matterhorn/felix/conf/**config.properties > > to TRUE or FALSE. > > We just recently installed our MH box again from scratch, and me + my > colleague have this tiny feeling that we still might have some fishy table > sets in our MySql tables. We used the FALSE-setting and created the tables > manually, based on the manual db generation script in > > /opt/matterhorn/matterhorn_1.**3.0/docs/scripts/ddl > > but we are facing some issues. We > > a) don't have statistics in our engage player videos > b) segmenting doesn't seem to work. > > We're running MH 1.3.0 on our distributed installation (Redhat). > > Using MySql we can see (select * from user_action;) that there is some > data of viewer statistics related tasks failing: we get the following > message written in the type-field in the user_action table: > > ANNOTATION_INIT_AJAX_FAILED > > Moreover, we got an sql-related error message in our engage-servers > /opt/matterhorn/felix/log/**opencast.log. The error message can be found > in: > > http://pastebin.com/E3yXUZZB > > Is anyone else suffering from similar symptoms? > > Any help will be greatly appreciated! > > > > Olli > > > > > -- > Olli Salo > Tietotekniikkakeskus > Helsingin yliopisto > Tel: +358 9 191 21782 > Gsm: +358 50 407 5509 > Email: [email protected] > ______________________________**_________________ > Matterhorn-users mailing list > Matterhorn-users@**opencastproject.org<[email protected]> > http://lists.opencastproject.**org/mailman/listinfo/**matterhorn-users<http://lists.opencastproject.org/mailman/listinfo/matterhorn-users> > -- Hank Magnuski Direct: +1-408-541-9230 x205 Cell: +1-650-714-2409 Skype: hank.magnuski www.ncast.com
_______________________________________________ Matterhorn-users mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
