![]() ![]() You should now be able to create an encrypted table by adding the ENCRYPTED=‘Y’ clause to any CREATE TABLE command. Restart the MySQL server: $ sudo /opt/bitnami/ctlscript.sh restart mysqlĬonfirm that the keyring_file plugin is active by running the query below in the MySQL client: SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'keyring%' Alfresco’s open source software is widely adopted for community-driven development and contributions as well as for. Keep a backup of this file as the data stored in the encrypted tables cannot be recovered without it. If you are a tech enthusiast with the ability to self-support, our Community Edition products are freely available and offer powerful capabilities for non-critical business process or content needs. NOTE: The keyring file will be automatically created in the above location when the first table is encrypted. Keyring_file_data=/opt/bitnami/mysql/data/keyring NOTE: Table encryption support is only available for InnoDB tables stored as individual files (the innodb_file_per_table option, enabled by default).įollow the steps below to configure table encryption support:Įdit the /opt/bitnami/mysql/conf/my.cnf configuration file.Īdd the following lines to the configuration file, within the section, to activate the keyring_file plugin: early-plugin-load=keyring_file.so The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations. To identify which database server is used in your stack, run the command below: $ test -d /opt/bitnami/mariadb & echo "MariaDB" || echo "MySQL" On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB. ![]() You should now be able to access the content repository from the older version in the new Alfresco instance.įor more information, refer to the official Alfresco upgrade documentation.NOTE: We are in the process of modifying the configuration for many Bitnami stacks. Restart the servers: $ sudo /opt/bitnami/ctlscript.sh restart Restore the database from the database backup file: $ mysql -u root -p bitnami_alfresco < /tmp/backup/alfresco.sql Mysql> GRANT ALL PRIVILEGES ON bitnami_alfresco.* TO IDENTIFIED BY 'DATABASE_PASSWORD' Replace the DATABASE_PASSWORD placeholder in the final command with the database password obtained in the previous step. ![]() Remove the existing Alfresco database and create a new one, then grant access to the bitnami database user. ĭb.url=jdbc:mysql://localhost:3306/bitnami_alfresco?useUnicode=yes&characterEncoding=UTF-8 If you don’t remember your MySQL root password, you can follow the steps below to reset it to a new value: Create a file in /tmp/mysql-init with the content shown below (replace NEWPASSWORD with the password you wish to use). Obtain the current database password by viewing the contents of the Alfresco configuration file at /opt/bitnami/alfresco/tomcat/shared/classes/alfresco-global.properties and noting the value of the db.password field. $ sudo chown -R tomcat:tomcat /opt/bitnami/alfresco/data Remove the existing content repository and replace it with the backup from the older version: $ sudo rm /opt/bitnami/alfresco/data $ sudo /opt/bitnami/ctlscript.sh start mysql Stop all services and start only MySQL: $ sudo /opt/bitnami/ctlscript.sh stop Transfer the content repository, indexes and database backup file to the new Alfresco instance, using SFTP, SSH or any other file transfer mechanism. ![]() $ sudo cp -R /opt/bitnami/alfresco/data /tmp/backupīack up the database to an SQL file, entering the database password when prompted: $ mysqldump -u root -p bitnami_alfresco > /tmp/backup/alfresco.sql Stop all servers: $ sudo /opt/bitnami/ctlscript.sh stopĬopy the content repository and indexes to a backup location: $ mkdir /tmp/backup NOTE: The steps below assume that you have already installed a new version of the stack and have access to both the older version (which contains data to be migrated) and the newer version (which contains no data). Instead, the correct procedure is to install a new version of the stack and then transfer the existing content repository to it. If you have important data, it is advisable that you create and try to restore a backup to ensure that everything works properly.Īn in-place upgrade of the Bitnami Alfresco Stack is not recommended. It is strongly recommended that you create a backup before starting the update process. ![]()
0 Comments
Leave a Reply. |