Just tried it both ways and neither method works (rc4, MySQL 5, Centos):
Using auto-ddl false and rc4 file "mysql5.sql" I get errors:
13:53:31 INFO (SeriesServiceImpl:122) - Activating Series Service
13:53:31 ERROR (SeriesServiceDatabaseImpl:223) - Could not retrieve all
series:
Internal Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'ORG_ID' in 'field list'
Error Code: 1054
Call: SELECT ORG_ID, SERIES_ID, ACCESS_CONTROL, DUBLIN_CORE FROM SERIES
Query: ReadAllQuery(referenceClass=SeriesEntity sql="SELECT ORG_ID,
SERIES_ID, ACCESS_CONTROL, DUBLIN_CORE FROM SERIES")
13:53:31 WARN (SeriesServiceImpl:162) - Unable to index series instances:
{}
So I can confirm that "mysql5.sql" is not working.
With auto-ddl true and a totally empty, clean database I get errors also:
13:58:59 INFO (IngestServiceImpl:156) - Ingest Service started.
13:58:59 ERROR (?:?) - [org.apache.felix.fileinstall.ArtifactInstaller,
org.osgi.service.cm.ManagedService, id=197, bundle=271]: Unexpected problem
updating Configuration
PID=org.opencastproject.ingest.scanner.InboxScanner.f80ebf26-8e18-4455-8d3f-7b26053998df,
factoryPID=org.opencastproject.ingest.scanner.InboxScanner,
bundleLocation=file:/opt/matterhorn/felix-framework-3.2.1/load/matterhorn-ingest-service-impl-1.3-rc4.jar
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'matterhorn.MH_USER' doesn't exist
Error Code: 1146
Call: SELECT USERNAME, ORGANIZATION, PASSWORD FROM MH_USER WHERE ((USERNAME
= ?) AND (ORGANIZATION = ?))
bind => [admin, mh_default_org]
Query: ReadAllQuery(name="user" referenceClass=JpaUser sql="SELECT
USERNAME, ORGANIZATION, PASSWORD FROM MH_USER WHERE ((USERNAME = ?) AND
(ORGANIZATION = ?))")
at
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
and also
13:59:01 ERROR (?:?) -
[org.opencastproject.capture.admin.api.CaptureAgentStateService,
org.osgi.service.cm.ManagedServiceFactory, id=209, bundle=234]: Unexpected
problem updating Configuration
PID=org.opencastproject.capture.agent.40689e40-c5c1-4685-97cc-b02f7f9855d8,
factoryPID=org.opencastproject.capture.agent,
bundleLocation=file:/opt/matterhorn/felix-framework-3.2.1/load/matterhorn-capture-admin-service-impl-1.3-rc4.jar
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services -
2.0.2.v20100323-r6872): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'matterhorn.CAPTURE_AGENT_STATE' doesn't exist
Error Code: 1146
Call: SELECT ORG, ID, CONFIGURATION, STATE, LAST_HEARD_FROM, URL FROM
CAPTURE_AGENT_STATE WHERE ((ID = ?) AND (ORG = ?))
bind => [demo_capture_agent, mh_default_org]
Query: ReadAllQuery(referenceClass=AgentImpl sql="SELECT ORG, ID,
CONFIGURATION, STATE, LAST_HEARD_FROM, URL FROM CAPTURE_AGENT_STATE WHERE
((ID = ?) AND (ORG = ?))")
at
org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
So I've tried all three databases now with rc4 and none of them work.
Hank
On Sat, Dec 17, 2011 at 10:12 AM, Greg Logan <[email protected]> wrote:
> On 12/17/2011 11:28 AM, Christopher Brooks wrote:
> > Hey hank,
> >
> > The autogeneration of ddl does not work reliably. The mysql scripts are
> the most up to date, and there was a resolution on list to reduce our
> coverage just to one script (the mysql one) to help eliminate these issues,
> so the postgres scripts should be removed from future releases. Instead,
> we'll advertise in our release docs any community contributed scripts for
> non mysql dbs.
> >
> > So, I'd try with mysql right now, and autogen off (there were
> significant db naming convention changes in this last rc).
>
> Either something changed and no one told me, or you missed that the
> review is just a patch set :)
>
> Hank, autogen should work fine on an empty DB, but I imagine it might
> complain on a DB with existing tables since some things may have
> changed. The large refactoring Chris is talking about is *not* in rc4.
> For what it's worth, my day-to-day dev environment, as well as the test
> clusters we have available (testadmin.usask.ca and
> testallinone.usask.ca) are all running with ddl-autogen turned on
> against mysql and I haven't seen any issues related to that at all. THe
> ddl scripts are currently known to be broken, so please don't use them
> yet! This is what will be addressed with the DB refactoring (see
> MH-8335 for details).
>
> G
>
_______________________________________________
Matterhorn-users mailing list
[email protected]
http://lists.opencastproject.org/mailman/listinfo/matterhorn-users
