Walter,
here is the config I use for 1.1.x distributed QA server on
opencast01.usask.ca. I've been using the mysql ddl script with no
problems:
http://opencast.jira.com/svn/MH/branches/1.1.x/docs/scripts/ddl/mysql5.sql
. Oddly enough I just noticed that my ddl generation was set to true,
but when running the ddl manually it should be set to false. I don't
think this matters though since I run this script before I start my
felix instance and I think the existence of tables overrides auto-ddl
anyway. If you decide to run auto-ddl and no tables currently exist on
a distributed instance, there is a known bug where some of the tables
are not generated for mysql. auto-ddl only for mysql works in an all in
one instance. From what I've experienced the embedded ootb h2 db
auto-ddl works for both distributed and all in one instances.
If for some reason mysql5.sql does not work for you (it should), you can
run an all in one instance and do a data dmp which should then be used
for a distributed instance. This shouldn't be necessary since a ddl
script will be avail for each release. If all else fails, you could have
problems with grant privileges or closed ports.
org.opencastproject.db.ddl.generation=true
org.opencastproject.db.vendor=MySQL
org.opencastproject.db.jdbc.driver=com.mysql.jdbc.Driver
org.opencastproject.db.jdbc.url=jdbc:mysql://opencast01.usask.ca/matterhorn?useUnicode=true&characterEncoding=UTF8
org.opencastproject.db.jdbc.user=foo
org.opencastproject.db.jdbc.pass=bar
On 7/25/11 2:00 PM, Walter Schwarz wrote:
Version 1.1.x
This was an error in a distributed install but the error exists when
deployed as an all-in-one as well.
When using a MySQL server jobs fail to start, the upload in the
matterhorn web UI doesn't complete. When removing the MySQL lines
from the config file and using a local solr (?) database jobs complete
successfully.
Sanity checks passed:
DDL generation is set to true.
Matterhorn does create the tables and their structure correctly.
The matterhorn user is able to add rows to these tables.
The failure is the same (below) when using a local MySQL or a remote
MySQL server.
Jobs ingest correctly when removing MySQL config (local jdbc server).
The directory and file creation attempts below are successful, they
exist.
What else could I look at to hunt down this failure?
Debug log:
2011-07-22 16:17:48 DEBUG (WorkingFileRepositoryImpl:243) - Attempting
to create a new directory at
/opt/matterhorn/content/files/mediapackage/ee6cfd50-c8b8-4179-82ef-95f9d4082340/871e7cd7-5ff8-40c1-8547-81f72c5d23cf
2011-07-22 16:17:48 DEBUG (WorkingFileRepositoryImpl:250) - Attempting
to write a file to
/opt/matterhorn/content/files/mediapackage/ee6cfd50-c8b8-4179-82ef-95f9d4082340/871e7cd7-5ff8-40c1-8547-81f72c5d23cf/dublincore.xml
2011-07-22 16:17:48 INFO (IngestServiceImpl:801) - Adding element of
type Catalog to mediapackage ee6cfd50-c8b8-4179-82ef-95f9d4082340
2011-07-22 16:17:48 DEBUG (MimeTypes:214) - Discovered previously
unknown mime type 'application/json'
2011-07-22 16:17:48 DEBUG (MimeTypes:214) - Discovered previously
unknown mime type 'video/x-motion-jpeg'
2011-07-22 16:17:48 DEBUG (JobJpaImpl:425) - processor service
registration is null
2011-07-22 16:17:48 DEBUG (JsonpFilter:102) - No json padding
requested from
org.apache.felix.http.base.internal.dispatch.FilterPipeline$RequestWrapper@46147bef
2011-07-22 16:17:48 DEBUG (OAuthProviderProcessingFilter:171) -
Supplied OAuth parameters are inadequate. Ignoring.
2011-07-22 16:17:48 DEBUG (WorkspaceImpl:205) -
/opt/matterhorn/content/workspace/mediapackage/ee6cfd50-c8b8-4179-82ef-95f9d4082340/871e7cd7-5ff8-40c1-8547-81f72c5d23cf/dublincore.xml
is up to date
2011-07-22 16:17:48 DEBUG (WorkspaceImpl:207) - Getting
http://mhadmin.at.northwestern.edu:8080/files/mediapackage/ee6cfd50-c8b8-4179-82ef-95f9d4082340/871e7cd7-5ff8-40c1-8547-81f72c5d23cf/dublincore.xmldirectly
from working file repository root at
/opt/matterhorn/content/workspace/mediapackage/ee6cfd50-c8b8-4179-82ef-95f9d4082340/871e7cd7-5ff8-40c1-8547-81f72c5d23cf/dublincore.xml
2011-07-22 16:17:48 WARN (WorkflowServiceImpl:496) - Unable to update
workflow to failed state
org.opencastproject.workflow.api.WorkflowDatabaseException:
org.opencastproject.util.NotFoundException: Job -1 not found
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
