Hi Hank,
that is the way we created our mysql database. We used the ddl script from command line, not the autogen.dd-config (we set the ddl.generation=false). And now we're wondering if that's indeed the right way to do it or if we should use the autogen.dll=true instead. That is to say: we're not sure if our mysql db schema is 100.00% what MH expects it to be and whether our problems are related to the db or not. You see, in our newly-installed MH 1.3 segmenting + OCR aren't working at all.
This is quite a problem for us because we wouldn't want to delete our production data in our mysql db but we still would like to have the segmenting and text analysis work. So my question to everybody is: is anyone else suffering from similar problems regarding segmenting / OCR with MH 1.3?
We did notice the discussion thread http://opencast.3480289.n2.nabble.com/Error-segmenting-removing-file-in-Matterhorn-1-3-td7389726.html and my colleague says he has tried the mvn options mentioned in the thread. As always, any piece of advice truly appreciated! Yours, Olli S On 26.4.2012 16:29, Hank Magnuski wrote:
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] <mailto:[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 <tel:%2B358%209%20%20191%2021782> Gsm: +358 50 407 5509 <tel:%2B358%2050%20407%205509> Email: [email protected] <mailto:[email protected]> _________________________________________________ Matterhorn-users mailing list Matterhorn-users@__opencastproject.org <mailto:[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 <http://www.ncast.com> _______________________________________________ Matterhorn-users mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
-- Olli Salo Tietotekniikkakeskus Helsingin yliopisto Tel: +358 9 191 21782 Gsm: +358 50 407 5509 Email: [email protected] _______________________________________________ Matterhorn-users mailing list [email protected] http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
