topic HSQL to MYSQL in Alfresco Archive

HSQL to MYSQL

arumugavel — Thu, 31 May 2007 05:06:54 GMT

Hi,I'd installed alfresco in windows 2000. It worked fine. Later i tried to change my DB to MYSQL. I'd changed the following files in the /classes/alfresco/extension directory:- custom-db-connection.properties- custom-hibernate-dialect.propertiesAfter starting the server I'm getting the errors(49 Ta

Re: HSQL to MYSQL

frederick — Thu, 31 May 2007 06:23:42 GMT

You say that at startup 49 tables were created, so I assume you were planning to start with a new, empty repository. If that is the case, you must also empty your alf_data folder.

This error is caused by your lucene indexes (by default located in your alf_data folder): two roots were found, one for your previous repo (hsql) and one for your new repo (mysql).

Re: HSQL to MYSQL

arumugavel — Thu, 31 May 2007 06:54:45 GMT

Hi Frederick,

I'd emptied alf_data folder adn restarted the server. This time that issue is resolved. But i'm unable to login to alfresco.

Which table is used for user authentication/creation?

How to populate the tables with sample data?

Thanks

Re: HSQL to MYSQL

arumugavel — Thu, 31 May 2007 06:57:43 GMT

Also i'm getting these errors:

12:25:42,148 INFO [DescriptorService] Alfresco started (Community Network): Current version 1.4.0 (build-105) schema 21 - Ins
talled version 1.4.0 (build-105) schema 21
12:25:51,695 ERROR [SocketOpenOfficeConnection] disconnected unexpectedly
12:26:01,195 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
12:26:26,414 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
12:26:26,430 INFO [JkMain] Jk running ID=0 time=0/234 config=null
12:26:56,149 INFO [STDOUT] ClientAbortException: java.net.SocketException: Connection reset by peer: socket write error
12:26:56,149 INFO [STDOUT]     at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:327)
12:26:56,149 INFO [STDOUT]     at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:293)
12:26:56,149 INFO [STDOUT]     at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:85)
12:26:56,149 INFO [STDOUT]     at org.jboss.portal.core.cms.command.StreamContentCommand.execute(StreamContentCommand.java:91
)
12:26:56,149 INFO [STDOUT]     at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:65)
12:26:56,149 INFO [STDOUT]     at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:127)
12:26:56,149 INFO [STDOUT]     at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcaste
rInterceptor.java:72)

============================================

12:26:56,258 ERROR [[PortalServletWithPathMapping]] Servlet.service() for servlet PortalServletWithPathMapping threw exception

java.lang.IllegalStateException
        at org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:395)
        at org.jboss.portal.core.cms.command.StreamContentCommand.execute(StreamContentCommand.java:101)
        at org.jboss.portal.core.command.ControllerCommand.dispatch(ControllerCommand.java:65)
        at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:127)
        at org.jboss.portal.core.aspects.controller.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:72)
        at org.jboss.portal.core.command.CommandInterceptor.invoke(CommandInterceptor.java:25)
        at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:117)
        at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:171)

Re: HSQL to MYSQL

frederick — Thu, 31 May 2007 07:45:10 GMT

Which table is used for user authentication/creation?

How to populate the tables with sample data?

You do not have to this. If alfresco finds an empty db schema it will bootstrap the repository automatically. So all you have to do is make sure you have an empty schema available, and an empty alf_data folder.

Regards,

Re: HSQL to MYSQL

arumugavel — Thu, 31 May 2007 09:32:06 GMT

Hi Frederick,

Everything is working fine.

Thanks,
Arumugavel