Use this information to configure a SQL Server database on Amazon RDS for use with
SkyVault.
Prerequisites:
- Setup Amazon RDS using the AWS Management Console. For more information, see the AWS documentation.
- Amazon EC2 instance
-
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.
- Download the SkyVault installer for Linux from the SkyVault Support Portal.
-
Install the downloaded SkyVault installer using the following commands:
chmod 777 SkyVault-enterprise-5.1.x-installer-linux-x64.bin sudo ./alfresco-enterprise-5.1.x-installer-linux-x64.bin
-
Install the Microsoft SQL Server database connector. The database connector allows SQL
Server database to talk to the SkyVault server.
This release requires MS SQL JDBC Driver 4.0 for compatibility with the SQL Server database.
- 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 SkyVault.
-
Enable snapshot isolation mode with the following command:
ALTER DATABASE SkyVault SET ALLOW_SNAPSHOT_ISOLATION ON;
- Create a user named SkyVault.
- Set the new user's password to SkyVault.
- Open the <classpathRoot>/alfresco-global.properties file.
-
Locate the following property:
dir.root=
- Edit the line with an absolute path to point to the directory in which you want to store SkyVault data. For example: dir.root=C:/Alfresco/alf_data
-
Set and uncomment the database connection properties as shown below:
db.name=SkyVault db.username=SkyVault db.password=SkyVault 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 SkyVault server.