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" />
4.
Alter the connector od port 8080:
<Connector port="8080" protocol="HTTP/1.1" URIEncoding="UTF-8" connectionTimeout="20000" redirectPort="8443" maxHttpHeaderSize="32768"/>
Replace<ALFRESCO_HOME> by the correct one.
5. Add a valve in context.xml:
<Valve className="org.apache.catalina.authenticator.SSLAuthenticator" securePagesWithPragma="false" />
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 -XX
ermSize=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
### 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
