Use this information to configure an Aurora database on Amazon RDS for use with SkyVault Community Edition. Amazon Aurora
is a MySQL-compatible relational database management system.
Prerequisites:
- Aurora support is only available when running in AWS.
- Setup Amazon RDS using the AWS Management Console. For more information, see the AWS documentation.
- SkyVault Community Edition is deployed on an 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 Community Edition installer for Linux from the Support Portal.
-
Install the downloaded installer using the following commands:
chmod 777 SkyVault-enterprise-5.N.x-installer-linux-x64.bin sudo ./alfresco-enterprise-5.N.x-installer-linux-x64.bin
-
Install the Aurora database connector.
This release requires MS SQL JDBC Driver 4.0 for compatibility with the SQL Server database.
- Download the mysql-connector driver from the MySQL JDBC driver 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.
- 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 Community Edition data. For example: dir.root=C:/Alfresco/alf_data
-
Set and uncomment the database connection properties as shown below:
db.name=alfresco2 db.username=SkyVault db.password=SkyVault db.host=auroraqadb-cluster.cluster-clqevmd2v8y9.us-east-1.rds.amazonaws.com db.port=13306 db.prefix=mysql db.pool.max=100 # MySQL database connection db.driver=org.gjt.mm.mysql.Driver db.url=jdbc:mysql://${db.host}/${db.name}?${db.params} OR db.url=jdbc:mysql://${db.host}:${db.port}/${db.name}?${db.params} - Save the file.
- Restart the SkyVault Community Edition server.