topic Community Edition 4.2 on MS SQL Server 2012 in Alfresco Archive

Community Edition 4.2 on MS SQL Server 2012

manifest0 — Tue, 02 Apr 2013 01:41:00 GMT

Hi all,For the past few weeks on and off I have been attempting to setup Alfresco against a MS SQL DB. I have succeeded in this thanks to <a herf = >this</a> amp file, patching a 4.0 WAR file. However, I'm looking at trying to get it working against v4.2 CE. The same amp file doesn't suf

Re: Community Edition 4.2 on MS SQL Server 2012

afaust — Tue, 02 Apr 2013 09:50:33 GMT

Hello,

in addition to create/upgrade scripts Alfresco uses ORM mapping XMLs (based on MyBatis) to access / modify DB data during runtime. These may also need to be adapted for MS SQL for specific cases - similar to the create / upgrade scripts, the MS SQL connection will inherit scripts from the base dialect if a more specific XML file has not been defined.

In terms of it being viable, my personal opinion would be: "not in the least". If you have found a community AMP as a standard solution for Alfresco 4.0, you might want to contact the developer of that module to discuss upgrade (collaboration) options to save you the effort for some of it.
Otherwise, there's always Enterprise…

Regards
Axel

Regards
Axel

Re: Community Edition 4.2 on MS SQL Server 2012

manifest0 — Wed, 03 Apr 2013 03:36:30 GMT

Thanks Axel, I think that's sufficient evidence for us to just stick with the default PostgreSQL - it doesn't quite seem worth the hassle!

Re: Community Edition 4.2 on MS SQL Server 2012

anavalente — Fri, 07 Mar 2014 12:09:49 GMT

Hello,

I know that this post is old but I am trying to install alfresco community 4.0 with SQL Server 2012 for the last couple of days I have not succeeded yet. I wonder if you could help me.

I did a first MySql installation on Tomcat7 that worked perfectly and now I was asked to change the database to SQL Server. I already tryed with SQL Server 2012 and 2005 and I found the same error with both versions. I already created a dialect for sql server, opened the firewall and enabled TCP/IP. The error I get is this:

19:17:33,515 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'encryptionKeysRegistry' defined in class path resource [alfresco/encryption-context.xml]: Cannot resolve reference to bean 'attributeService' while setting bean property 'attributeService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'attributeService' defined in class path resource [alfresco/attributes-service-context.xml]: Cannot resolve reference to bean 'propertyValueDAO' while setting bean property 'propertyValueDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'propertyValueSqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4973)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5467)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
   at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
   at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
   at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
   at java.util.concurrent.FutureTask.run(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
   at java.lang.Thread.run(Unknown Source)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'attributeService' defined in class path resource [alfresco/attributes-service-context.xml]: Cannot resolve reference to bean 'propertyValueDAO' while setting bean property 'propertyValueDAO'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'propertyValueSqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   … 29 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueDAO' defined in class path resource [alfresco/dao/dao-context.xml]: Cannot resolve reference to bean 'propertyValueSqlSessionTemplate' while setting bean property 'sqlSessionTemplate'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1325)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1086)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   … 39 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'propertyValueSqlSessionTemplate' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Cannot resolve reference to bean 'repoSqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
   at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)
   at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   … 49 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'repoSqlSessionFactory' defined in class path resource [alfresco/ibatis/ibatis-context.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
   … 61 more
Caused by: org.springframework.core.NestedIOException: Failed to parse config resource: class path resource [alfresco/ibatis/alfresco-SqlMapConfig.xml]; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.alfresco.ibatis.HierarchicalSqlSessionFactoryBean.buildSqlSessionFactory(HierarchicalSqlSessionFactoryBean.java:248)
   at org.alfresco.ibatis.HierarchicalSqlSessionFactoryBean.afterPropertiesSet(HierarchicalSqlSessionFactoryBean.java:98)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
   … 68 more
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.alfresco.ibatis.HierarchicalXMLConfigBuilder.parseConfiguration(HierarchicalXMLConfigBuilder.java:128)
   at org.alfresco.ibatis.HierarchicalXMLConfigBuilder.parse(HierarchicalXMLConfigBuilder.java:110)
   at org.alfresco.ibatis.HierarchicalSqlSessionFactoryBean.buildSqlSessionFactory(HierarchicalSqlSessionFactoryBean.java:246)
   … 71 more
Caused by: org.apache.ibatis.builder.BuilderException: Error creating document instance. Cause: java.net.ConnectException: Connection refused: connect
   at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:217)
   at org.apache.ibatis.parsing.XPathParser.<init>(XPathParser.java:86)
   at org.apache.ibatis.builder.xml.XMLMapperBuilder.<init>(XMLMapperBuilder.java:55)
   at org.alfresco.ibatis.HierarchicalXMLConfigBuilder.mapperElement(HierarchicalXMLConfigBuilder.java:309)
   at org.alfresco.ibatis.HierarchicalXMLConfigBuilder.parseConfiguration(HierarchicalXMLConfigBuilder.java:124)
   … 73 more
Caused by: java.net.ConnectException: Connection refused: connect
   at java.net.DualStackPlainSocketImpl.connect0(Native Method)
   at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
   at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
   at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
   at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
   at java.net.PlainSocketImpl.connect(Unknown Source)
   at java.net.SocksSocketImpl.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at java.net.Socket.connect(Unknown Source)
   at sun.net.NetworkClient.doConnect(Unknown Source)
   at sun.net.www.http.HttpClient.openServer(Unknown Source)
   at sun.net.www.http.HttpClient.openServer(Unknown Source)
   at sun.net.www.http.HttpClient.<init>(Unknown Source)
   at sun.net.www.http.HttpClient.New(Unknown Source)
   at sun.net.www.http.HttpClient.New(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
   at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.startEntity(Unknown Source)
   at org.apache.xerces.impl.XMLEntityManager.startDTDEntity(Unknown Source)
   at org.apache.xerces.impl.XMLDTDScannerImpl.setInputSource(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentScannerImpl$DTDDispatcher.dispatch(Unknown Source)
   at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
   at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
   at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
   at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
   at org.apache.ibatis.parsing.XPathParser.createDocument(XPathParser.java:215)
   … 77 more

Can you help me? I guess something is wrong with my database configuration but I can't figure what it is. I think alfresco recognizes the database because when I change database properties (sql server authentication to windows authentication), the error in alfresco is exactly the same as in sql server (I did this just to check if the error changed).

I have the jtdc file in the lib folder and my alfresco.properties has the following:
db.name=alfresco
db.username=alfresco
db.password=alfresco
db.host=127.0.0.1
db.port=1433
db.driver=net.sourceforge.jtds.jdbc.Driver
db.url=jdbc:jtds:sqlserver://${db.host}:${db.port}/${db.name}
db.txn.isolation=4096
hibernate.dialect=org.hibernate.dialect.SQLServerDialect

I would really appreciate your help.

Re: Community Edition 4.2 on MS SQL Server 2012

mrogers — Fri, 07 Mar 2014 17:06:53 GMT

have you created an empty database and account called alfresco with alfresco as a password? If you have next thing I'd check is that your database is listening on the local loopback.

Re: Community Edition 4.2 on MS SQL Server 2012

anavalente — Sun, 09 Mar 2014 19:19:38 GMT

Yes, I created an empty database called alfresco with a database owner called alfresco. Moreover, I was able to connect to that database with another application I am using that is installed in the same tomcat.

Re: Community Edition 4.2 on MS SQL Server 2012

anavalente — Thu, 13 Mar 2014 19:37:30 GMT

Hello,

I just want to say that I managed to install alfresco community 4.0 in a SQL Server 2012 database. I had to create my own dialect and scripts and afterwards I kept ajusting the scripts until I had no more errors. If you want my scripts, just send me a private message.

I was also forgetting to delete my folder alfdata/contentstore.

I am testing now and Alfresco Community seems to work perfectly with SQL Server.

Thank you all

Re: Community Edition 4.2 on MS SQL Server 2012

disasterguy — Fri, 04 Apr 2014 05:57:55 GMT

Hi Ana Valente. Can you please post the script and the changes you've made so that I can do it also? I have a problem configuring alfresco on a MS SQL Server 2012. Your help will be much appreciated.

Re: Community Edition 4.2 on MS SQL Server 2012

mariuszdawczyk — Wed, 28 May 2014 15:36:26 GMT

Does anyone have amp ms sql 2012 for alfresco 4.2 f?

Re: Community Edition 4.2 on MS SQL Server 2012

mariuszdawczyk — Wed, 28 May 2014 15:38:39 GMT

Can You send me a AMP for ms sql ? I have alfresco 4.2 f

Re: Community Edition 4.2 on MS SQL Server 2012

anavalente — Fri, 06 Jun 2014 16:23:58 GMT

Hello,

In order to have alfresco working with SQL Server 2012 I used the dbscripts of sql server included in a trial version of alfresco enterprise edition and just made some (no more than 5) alterations in a script file because one table was different but I think that was because I was using version 4.0 of alfresco CE.

Re: Community Edition 4.2 on MS SQL Server 2012

albertogarcía — Wed, 03 Jun 2015 07:50:54 GMT

Hello anavalente,

We are trying to adapta a current Enterprise 4.1.7 Enterprise Alfresco to run in a 4.2 Community version. We have already the database created (with the Enterprise edition) but can't manage to get our Community version to work with that SQL. It is connecting to the database, but then we find the communication problems. I guess that after you ran you scrpit file you also had to adapt several features.
For now we have changed the dialect to force it to be SQL dialect and copied the contents of the "org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect" folder from the enterprise, but don't know how to continue (now we are getting ibatis errors) Do you have any clue?

Thanks in advance

Re: Community Edition 4.2 on MS SQL Server 2012

georgesamichia — Wed, 04 Apr 2018 07:17:18 GMT

Hello, I know it's a little outdated. can you please send me your script ??? I've been trying Alfresco 4.0.d for a few days with SQL Server 2014 but I can not do it. need your help

Re: Community Edition 4.2 on MS SQL Server 2012

anavalente — Fri, 06 Apr 2018 10:39:09 GMT

Hello,

I am sorry for not answering all the questions asked.

I have a manual written in Portuguese written in 2014. I will translate the correct section and comment it here. However, I had the script files in my hard drive and it burned.

1. Create an empty folder (C:/Alfresco for example), and inside that folder, create another folder called "alf_data" and another one called "keystore". Copy what is inside the keystore folder of the alfresco.war to this new folder with the same name.

2. In order to install Alfresco with SQL Server, copy the dbscripts with SQL Server to the folder that has the SQL scripts. (try installing the trial of the entreprise version, copy that folder and correct the scripts, comparing it to the mySQL scripts, it is easier that doing them all by hand - WEB-INF\classes\alfresco\ibatis\ and WEB-INF\classes\alfresco\dbscripts\)

3. Add to the folder “<tomcat_home>/conf/server.xml the connector to port 8443:

<Connector port="8443" protocol="org.apache.coyote.http11.Http11Protocol" SSLEnabled="true"

maxThreads="150" scheme="https" keystoreFile="<ALFRESCO_HOME>/alf_data/keystore/ssl.keystore" keystorePass="kT9X6oe68t" keystoreType="JCEKS"

secure="true" connectionTimeout="240000" truststoreFile="<ALFRESCO_HOME>/alf_data/keystore/ssl.truststore" truststorePass="kT9X6oe68t" truststoreType="JCEKS"

clientAuth="false" sslProtocol="TLS" />

Alter the connector od port 8080:

Replace<ALFRESCO_HOME> by the correct one.

5. Add a valve in context.xml:

6. Edit the file catalina.properties, in the same folder, puting “${catalina.base}/shared/classes after “shared.loader”.

Edit the file catalina.bat, adding in lines 302, 305, 309 e 312, after “CATALINA_OPS” the following:

-Xms1536m -Xmx1536m -XXermSize=1024m -XX:MaxPermSize=1024m

Place the .war files in tomcat (webapps).

Edit the alfresco-global.properties file. (The database has to be empty with read and wirte permissions)

Run this in SQL Server:

ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;

db.name=alfresco

db.username=alfresco

db.password=xxxxxxx

db.host=localhost

db.port=1433

db.driver=net.sourceforge.jtds.jdbc.Driver

db.url=jdbc:jtds:sqlserver://${db.host}:${db.port}/${db.name}

db.txn.isolation=4096

Hibernate.dialect = org.alfresco.repo.domain.hibernate.dialect.AlfrescoSQLServerDialect

Place this file in <TOMCAT_HOME>/shared/classes.

7. Look for the files “contentModel.xml” and “share-form-config.xml” and correct the information.

Example in my case:

dir.root=C:/Alfresco/alf_data

alfresco.context=alfresco

alfresco.host=127.0.0.1

alfresco.port=8080

alfresco.protocol=http

share.context=share

share.host=127.0.0.1

share.port=8080

share.protocol=http

### FTP Server Configuration ###

ftp.enabled=true

ftp.port=21

ftp.ipv6.enabled=false

### Initial admin password ###

alfresco_user_store.adminpassword=xxxxxxxxxx

### E-mail site invitation setting ###

notification.email.siteinvite=false

### File Protocol Root ###

protocols.rootPath=/${spaces.company_home.childname}/${spaces.sites.childname}

### License location ###

dir.license.external=C:/Alfresco

### BPM Engine ###

system.workflow.engine.jbpm.enabled=false

Re: Community Edition 4.2 on MS SQL Server 2012

alonsodiego — Fri, 15 Jun 2018 19:19:24 GMT

Hello,
I need to use "Alfresco" with "SqlServer". Could I get in contact with you? I need the scripts for "SQL Server"

Re: Community Edition 4.2 on MS SQL Server 2012

anavalente — Mon, 18 Jun 2018 09:51:59 GMT

Hello,

I cannot find the scripts. I did this in 2014. However, from what I recall,

I installed the trial version and then I searched for the scripts in the

ibatis folder.

After that, every time there was a database error in tomcat, I was able to

correct it, comparing the specific script to the one in MySQL.

Thank you,

Ana Valente

2018-06-16 23:33 GMT+01:00 alonsodiego <community@alfresco.com>:

Alfresco Community
<https://community.alfresco.com/?et=watches.email.thread>
Re: Community Edition 4.2 on MS SQL Server 2012
reply from Alonso Alonso
<https://community.alfresco.com/people/alonsodiego?et=watches.email.thread>
in Alfresco Content Services (ECM) - View the full discussion
<https://community.alfresco.com/message/833856-re-community-edition-42-on-ms-sql-server-2012?commentID=833856&et=watches.email.thread#comment-833856>

Re: Community Edition 4.2 on MS SQL Server 2012

afaust — Mon, 18 Jun 2018 20:10:55 GMT

Using the scripts from the trial of the commercial version is almost guaranteed to constitute a breach of the license agreement / terms of conditions for the trial version. This should not be done or recommended unless you want to become liable to legal actions by Alfresco.