ClearFoundation Tracker - ClearCenter
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0001186ClearCenterapp-remote-backup - Remote Server Backuppublic2013-06-18 09:272014-08-10 18:51
Reporterbchambers 
Assigned Tobchambers 
PrioritynormalSeverityfeatureReproducibilityN/A
StatusclosedResolutionfixed 
PlatformOSOS Version
Product Version6.4.0 
Target Version6.4.0 UpdatesFixed in Version6.4.0 Updates 
Summary0001186: Remote backup configlets don't support system-mysql database
DescriptionZarafa, mail archive, reports and future apps use the System-MySQL sandboxed db engine. Would be nice (and pretty easy) to have a separate sub-class to identify the system database engine.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
related to 0001896confirmed  Remote backup: offer MySQL data & Zarafa emails (attachments are in file system and mails are in DB) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-06-18 09:27bchambersNew Issue
2013-06-18 09:27bchambersStatusnew => assigned
2013-06-18 09:27bchambersAssigned To => bchambers
2013-07-21 18:19bchambersNote Added: 0000948
2013-07-21 18:20bchambersStatusassigned => resolved
2013-07-21 18:20bchambersResolutionopen => fixed
2013-07-21 18:20bchambersFixed in Version => 6.4.0 Updates
2013-08-15 08:32bchambersNote Edited: 0000948bug_revision_view_page.php?bugnote_id=948#r86
2013-08-22 16:46user2Statusresolved => closed
2014-08-10 18:51bchambersRelationship addedrelated to 0001896

Notes
(0000948)
bchambers   
2013-07-21 18:19   
(edited on: 2013-08-15 08:32)
Support has been added for system MySQL database, however, configlets have to be added manually for either the backup or restore process.

For backing up a System MySQL database (eg. Zarafa, reports, mail archive etc.). The following example will be for Zarafa database, however, any database using the System MySQL sandbox could be used.

type = 102
sub-type = 203
username = "zarafa"
password = "PASSWORD"
db-name = "zarafa"
mode = 1

To a new file /etc/rbs/config.d/rbs_quickpick_system_mysql-backup.ini

To find your Zarafa database password, use:

cat /var/clearos/system_database/zarafa

With this configlet added, a database dump of the database defined in the configlet will be made on backups.

To restore, change the filename to '-restore' and change the mode to 2.