You can configure a SQL Server database on Amazon RDS for use with Content Services, with the following prerequisites:
- Setup Amazon RDS using the AWS Management Console
- Amazon EC2 instance
To configure the database:
-
Use the ssh command to connect to the Amazon EC2 instance
using a provided .ppk key.
- For Amazon Linux, the user name is ec2-user.
- For RHEL5, the user name is either root or ec2-user.
- For Ubuntu, the user name is ubuntu. For SUSE Linux, the user name is root.
- Execute sudo su to change to root.
- Install Content Services.
-
Install the Microsoft SQL Server database connector to allow the database to
talk to the server.
Check the Supported Platforms page for the correct driver version.
- Download sqljdbc4.jar from the Microsoft SQL Server download site.
- Copy the JDBC driver into the <TOMCAT_HOME>/lib directory.
- Install and use a database tool to connect to the Amazon RDS.
- Create a database named alfresco.
-
Enable snapshot isolation mode with the following
command:
ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;
- Create a user named alfresco.
- Set the new user’s password to alfresco.
- Open the <classpathRoot>/alfresco-global.properties file.
- Locate the property: dir.root=
- Edit this to set an absolute path to point to the directory in which you want to store Content Services data. For example: dir.root=C:/Alfresco/alf_data
-
Set and uncomment the database connection properties as shown
below:
db.name=alfresco db.username=alfresco db.password=alfresco db.host=sql-alfresco.cw4mo3qj8qdu.us-east-1.rds.amazonaws.com db.port=1433 db.pool.max=275 db.txn.isolation=4096 # SQL Server connection db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://${db.host}:${db.port};databaseName=${db.name} - Save the file.
- Restart the Content Services server.