topic 4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...? in Alfresco Archive

4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...?

oofdachile — Thu, 20 Jun 2013 20:37:13 GMT

Hi, folks –We need to prove that we could run Alfresco in a production environment if we wish to move away from a current, commercial ECM solution.I set up & tested a Tomcat-7 server on Windows Server 2008r2 (ssl, LDAP authentication from AD, etc) and then created a database in a SQL Server 2005

Re: 4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...?

abarisone — Thu, 01 Aug 2013 14:36:46 GMT

HI,
maybe you're experiencing some issues because Alfresco is not supported with Tomcat 7.
According to the Alfresco Compatibility matrix http://www.alfresco.com/services/subscription/supported-platforms you should have:
- Windows Server 2008 R2 X64
- MS SQL Server 2008 R2
- Tomcat 6.0.35

Regards,
Andrea

Re: 4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...?

kaynezhang — Thu, 01 Aug 2013 15:00:03 GMT

That is not tomcat 7 's problem,alfresco can be run on tomcat 7,It seems that alfresco didn't use hibernate dialiect to load ibatis mapping file correctly.
sqlserver is only supported by enterprise edition,make sure under alfresco\WEB-INF\classes\alfresco\ibatis you'll see a folder named "org.hibernate.dialect.SQLServerDialect"

Then edit file alfresco-global.properties and add hibernate.dialect=org.hibernate.dialect.SQLServerDialect to the end and restart.

Re: 4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...?

oofdachile — Wed, 14 Aug 2013 21:04:36 GMT

Hi, folks –

A statement like Alfresco Community 4.x "does not support Micosoft SQL Server" leaves me wondering what exactly is meant: was I on my own to create the right properties in alfresco-global.properties? More times than not, problems like these have to do with injecting my local pizza shop order information into a product's config file, rather than actual issues with the product itself, and so I wondered if I was just doing something wrong when trying to figure this out.

So, ok, the scoop is that in the 4.x Community releases of Alfresco, the SQL Server versions of the database scripts which create database tables (and probably do a bunch of other SQL-Server-y stuff) are just not included. You can check this for yourself by looking here:

%CATALINA_BASE%\webapps\alfresco\WEB-INF\classes\alfresco\dbscripts\create

Here (and other places, too, no doubt) there is support for only MySQL and Postgres. Addons like these …

https://addons.alfresco.com/addons/oracle-and-sql-server-support-alfresco-community
https://addons.alfresco.com/addons/sqlserver-community

… appear to add these needed pieces, though the first doesn't seem to have SQL Server hooks in it (though, hey, what do I know?) and the second entry appears to be a null pointer these days. Perhaps a lot could be learned from studying the Oracle portion of the first file, though.

So the big quesitons seem to be these:

<ul>
<li> Does ANYONE have an actual copy of that second addon?
<li> If the Oracle/SQLServer addon can indeed be used outright for SQL Server, does anyone know how?
</ul>

Thanks for taking the time to reply, Andrea and Kaynezhang!

Don

Re: 4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...?

kaynezhang — Thu, 15 Aug 2013 01:44:00 GMT

Only Alfresco Enterprise endition support Micosoft SQL Server,Oracle addon can't be used for SQL Server.
It seems someone had develop an amp for sqlserver2008 called ""alfresco community support for microsoft sqlserver2008".

Re: 4.2.c on WS2k8, Tomcat-7 & SQL Server 2005: db config issues...?

oofdachile — Wed, 11 Sep 2013 21:28:20 GMT

Thanks, kaynezhang. The AMP that you found for us is for Alfresco 3.4, but comparing that to the Oracle AMP should make it possible to create a complete package that works with 4.2.d. Hooray!