topic Re: 'Schema auto-update failed' after installation (OS X/MySQL) in Alfresco Archive

'Schema auto-update failed' after installation (OS X/MySQL)

bcm — Wed, 23 Jul 2008 22:27:39 GMT

I installed the Tomcat-bundled version of Alfresco Community 2.9.0B on a MacBook Pro running Leopard and configured it to use a MySQL database. Like many others apparently, I get that "Schema auto-update failed" exception when I start the server. The nested exception message is "A previous schema up

Re: 'Schema auto-update failed' after installation (OS X/MySQL)

steve — Thu, 24 Jul 2008 11:02:18 GMT

Hi,
You can get this error if the user you are connecting alfresco to in the DB does not have the correct permissions to access the database tables.
I logged this as ETWOTWO-522 (for Oracle, but I suspect this is the same for most/all dbs) but it has yet to be resolved.

Steve

Re: 'Schema auto-update failed' after installation (OS X/MySQL)

bcm — Thu, 24 Jul 2008 15:53:03 GMT

Thanks for the heads up.

I found a few hours after posting this that my MySQLinstallation was broken. I was installing another application, and when it tried to connect to the database server, it spit out an error from MySQL telling me that the server couldn't create a database file. That was handy information that helped me fix the database server problem :shock: Once that was fixed, I tried Alfresco again, and it worked.

So, let this thread be a bump for the bug you logged!