ClearOS Bug Tracker


View Issue Details Jump to Notes ] Issue History ] Print ]
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.
TagsNo tags attached.
Attached Files

- Relationships
related to 0001896confirmed Remote backup: offer MySQL data & Zarafa emails (attachments are in file system and mails are in DB) 

-  Notes
(0000948)
bchambers (administrator)
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.


- Issue History
Date Modified Username Field Change
2013-06-18 09:27 bchambers New Issue
2013-06-18 09:27 bchambers Status new => assigned
2013-06-18 09:27 bchambers Assigned To => bchambers
2013-07-21 18:19 bchambers Note Added: 0000948
2013-07-21 18:20 bchambers Status assigned => resolved
2013-07-21 18:20 bchambers Resolution open => fixed
2013-07-21 18:20 bchambers Fixed in Version => 6.4.0 Updates
2013-08-15 08:32 bchambers Note Edited: 0000948 View Revisions
2013-08-22 16:46 user2 Status resolved => closed
2014-08-10 18:51 bchambers Relationship added related to 0001896