https://bugs.contribs.org/show_bug.cgi?id=10654

Terry Fage <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |VERIFIED

--- Comment #5 from Terry Fage <[email protected]> ---
VERIFICATION

= Environment: 
SME 9.2 x64 VM updates as at 27 Nov 18

= ORIGINAL PROBLEM:
Bug 10654 - automysqlbackup does not backup new database types correctly

= RESOLUTION:
Fixed in smeserver-automysqlbackup-3_0_RC6-10_el6_sme

* Mon Nov 26 2018 John Crisp <[email protected]> 3.0.RC6-10.sme
- fix runmysqlbackup to allow for new databases [SME:10654]

= CURRENT VERSION INSTALLED:
[root@sme9264 ~]# cat /etc/e-smith-release
SME Server release 9.2

[root@sme9264 ~]# uname -r
2.6.32-754.6.3.el6.x86_64

[root@sme9264 ~]# rpm -q smeserver-automysqlbackup
package smeserver-automysqlbackup is not installed

[root@sme9264 ~]# rpm -q automysqlbackup
package automysqlbackup is not installed

Install and configure current smecontrib 

[root@sme9264 ~]# yum install --enablerepo=smecontribs
smeserver-automysqlbackup

[root@sme9264 ~]# rpm -q smeserver-automysqlbackup
smeserver-automysqlbackup-3.0.RC6-9.el6.sme.noarch

[root@sme9264 ~]# rpm -q automysqlbackup
automysqlbackup-3.0.RC6-5.el6.sme.noarch

[root@sme92x64 ~]# signal-event post-upgrade; signal-event reboot

[root@sme92x64 ~]# yum --enablerepo=smecontribs,centos-sclo-rh install
smeserver-mysql55

[root@sme92x64 ~]# signal-event post-upgrade; signal-event reboot

[root@sme9264 ~]# rpm -q smeserver-mysql55
smeserver-mysql55-2.0.0-8.el6.sme.noarch

[root@sme9264 ~]# config show mysql55-mysqld
mysql55-mysqld=service
    LocalNetworkingOnly=yes
    status=enabled

= TESTING:
[root@sme9264 ~]# automysqlbackup
Invoking backup method.

Parsed config file "/etc/automysqlbackup/myserver.conf"

# Checking for permissions to write to folders:
base folder /root/backup ... exists ... ok.
backup folder /root/backup/db ... exists ... writable? yes. Proceeding.

[root@sme9264 ~]# ls backup/db
daily  fullschema  latest  monthly  status  tmp  weekly

= UPDATED VERSION INSTALLED:
[root@sme9264 ~]# yum update --enablerepo=smetest smeserver-tftp-server

[root@sme92x64 ~]# signal-event post-upgrade; signal-event reboot

[root@sme9264 ~]# rpm -q smeserver-automysqlbackup
smeserver-automysqlbackup-3.0.RC6-10.el6.sme.noarch

[root@sme9264 ~]# automysqlbackup
Invoking backup method.

Parsed config file "/etc/automysqlbackup/myserver.conf"

# Checking for permissions to write to folders:
base folder /root/backup ... exists ... ok.
backup folder /root/backup/db ... exists ... writable? yes. Proceeding.

[root@sme9264 ~]# ls backup/db
daily  fullschema  latest  monthly  status  tmp  weekly

[root@sme9264 backup]# /sbin/e-smith/runmysqlbackup
/etc/automysqlbackup/myserver.conf
[root@sme9264 backup]# ls
db  db_mysql55

[root@sme9264 ~]# /sbin/e-smith/runmysqlbackup
/etc/automysqlbackup/mysql55.conf
[root@sme9264 ~]# cd backup
[root@sme9264 backup]# ls
db  db_mysql55

Cron runs the above as and when set

No errors evident

= PROBLEM FIXED:
automysqlbackup was failing to back up new databases following the recent
updates.

= VERIFIED OR REOPEN:
Verified

= DOCUMENTATION IMPACT:
N/A

= SUGGESTED RELEASE NOTES:
%Changelog
* Mon Nov 26 2018 John Crisp <[email protected]> 3.0.RC6-10.sme
- fix runmysqlbackup to allow for new databases [SME:10654]

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
_______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/

Reply via email to