topic Configure an alfresco instance with existing db in Alfresco Archive

Configure an alfresco instance with existing db

dkmorb — Tue, 28 Oct 2008 15:32:53 GMT

Hi all, i'm new here.I should configure a new Alfresco installation possibly on a existing SQL server 2005 database. I try to copy the original folder alf_data from "source" machine and change paths in custom-repository.properties, but at the end, i obtain this error:16:14:28,968 INFO [STDOUT] 16:1

Re: Configure an alfresco instance with existing db

krishna — Wed, 29 Oct 2008 06:40:25 GMT

hi,
we r also facing wit same prob..
any luck in this case…
do share with us…

thx…

Re: Configure an alfresco instance with existing db

dkmorb — Wed, 29 Oct 2008 08:09:01 GMT

Hi krishna,
ok, no problem for me, but my experience are limited to this particular case, so… I've not idea on how solve this issue. How can I preceede?

Bye,
dkmorb.

Re: Configure an alfresco instance with existing db

krishna — Thu, 30 Oct 2008 05:36:42 GMT

Hi,
my prob of configuring to existin ms sql server is solved.
We need to create a folder called org.repo.admin.dialect.AlfrescoSQLServerDialect in activities folder.
Copy the 3 files in them.
Change the custom-repository.properties file to enter ur db name, user name and password.
Also copy jaxb-api 2.1 jar in tomcat\common\endorsed folder.

suppose if you get error of "schema auto-update failed", then make change in shared\extension\custom-repository.properties as dbschema.update= false.

hope This works to u tooo….

Krishna..

Re: Configure an alfresco instance with existing db

dkmorb — Thu, 30 Oct 2008 08:38:24 GMT

Hi krishna,
my problem is just a little different from your, probably because i've success to connect my alfresco to alfresco db (MS SQL Server 2005) but i can't connect to already populated db on that server. :cry:

I don't know…
dkmorb

Re: Configure an alfresco instance with existing db

dkmorb — Thu, 30 Oct 2008 10:19:20 GMT

Men, i'm poor programmer so…
I've solved my problem deleting original hibernate lib (3 files) in jboss and adding them to alfresco.war file (WEB-INF/lib). Now all my 2 application works perfectly togheter with Alfresco.

Byez,
dkmorb.