Extract alfresco in the /opt/ directory. This means that in the /opt directory there should be an alfresco folder, in this folder there should be a number of files and directories including the alfresco.sh file (Which starts and stops Alfresco.)
Edit the alfresco.sh file (eg â€œvi alfresco.shâ€ will do it.) Ensure that the variable APPSERVER is set to /opt/alfresco/tomcat
Next step is to install Java Database Connector for MySQL. Download the MySQL Java Database Connector from http://dev.mysql.com/downloads/connector/j/ then copy the .JAR file into /opt/alfresco/tomcat/common/lib/mysql-connector-java-<version>-bin.jar
Edit 2 different files that tell Alfresco to use MySQL instead of HSQL.
Check the firewall! First try turning it off (In YaST, â€œSecurity and Usersâ€ - â€œFirewallâ€.....Turn the firewall off.....Restart Alfresco ./alfresco.sh restart. Then restart browser and check again.
Check if MySQL is running....as root user run command â€œrcmysql statusâ€. If not then start it with command â€œrcmysql startâ€. Then Restart Alfresco and your browser and check again.
Remember to restart firewall with port 8080 open.
The other option is for restoring a backed up database. In which case:
Simply reinstate the backed up alfresco database. (Shit will (probably) hit the fan if you try and start Alfresco now without having replaced the base content store with the backed up one... DO NOT START ALFRESCO NOW!)
To BACKUP a running version of Alfresco on openSUSE 10.3.
It is best, if you are doing a manual backup of Alfresco, to first stop the service. Go to the /opt/alfresco/ directory and type ./alfresco.sh stop .
Backup the complete MySQL Alfresco Database.
The easiest way to do this is to use MySQL Administrator. Open MySQL Administrator connect to your Alfresco server.
On the Left hand side click on backup.
On Right hand side click Alfresco then on the right arrow.
Ensure you give the Project a Name at the top and click on â€œStart Backupâ€.
Enter the file name and where to save it. (Obviously remember this!)
Back up the Content Store of the system.
The content store is simply the whole /opt/alfresco/alf_data directory.
The best way (In my opinion) to make a backup of this directory is to use TAR
Use the command â€œtar czf alfrescobackup.tgz /opt/alfresco/alf_dataâ€
This will tar the entire directory and call it alfrescobackup.tgz (it may take a minute or two)
The two files, the SQL file and the .tgz file are the backed up Alfresco. Save them some place safe! Remember to restart Alfresco!
To RESTORE Alfresco from a backup as described above on openSUSE 10.3.
Install Alfresco as per instructions at beginning of this document. Do Not Start Alfresco!
Extract the MySQL file to the database you have created.
Extract the .tgz file to the directory /opt/alfresco/
Use the command â€œtar xzf alfrescobackup.tgzâ€
NB. TAR will automatically overwrite files with the same name.