[mythtv-users] mythconverg database maintenance and backup

[Jim Abernathy]

On 01/14/2018 08:00 AM, Stephen Worthington wrote:
> On Sun, 14 Jan 2018 12:26:48 +0000, you wrote:
>
>> I know I must be missing something simple.  Yesterday I worked to get the suggested optimize and backup scripts for mythconverg into the cron.daily directory.  I tested each of these scripts by running them as:
>>
>> sudo /etc/cron.daily/mythtv-backup
>>
>> sudo /etc/cron.daily/optimize_mythdb
>>
>> They both worked and I had the backup files where they should be and data in the syslog and /var/log/mythtv/optimize_mythdb.log files to indicate they ran okay.
>>
>> This morning anacron should have run at 6:25 my 2 daily scripts but it didn't and there is no indication in the syslog of it running. This is what I see at 6:25:
>>
>> Jan 14 06:25:01 mythbuntu CRON[11179]: (root) CMD (test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ))
>>
>> I again manually ran the scripts as before and they work.
>>
>> Any idea on why they may not be running automatically?
>>
>> My crontab is below.
>>
>> Jim A
>>
>>
>> SHELL=/bin/sh
>> PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
>>
>> # m h dom mon dow user    command
>> 17 *    * * *    root    cd / && run-parts --report /etc/cron.hourly
>> 25 6    * * *    root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
>> 47 6    * * 7    root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
>> 52 6    1 * *    root    test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
>> #
> Do the files in the /etc/cron.daily directory have root ownership and
> the correct permissions?  This is what mine look like:
>
> root at mypvr:/etc/cron.daily# ll
> total 116
> drwxr-xr-x   2 root root  4096 Dec 20 23:33 ./
> drwxr-xr-x 189 root root 12288 Jan  1 03:30 ../
> -rwxr-xr-x   1 root root   311 Jun 20  2010 0anacron*
> -rwxr-xr-x   1 root root   539 Apr  6  2016 apache2*
> -rwxr-xr-x   1 root root   376 Apr  5  2014 apport*
> -rwxr-xr-x   1 root root  1474 Nov  1  2016 apt-compat*
> -rwxr-xr-x   1 root root   314 Mar 31  2012 aptitude*
> -rwxr-xr-x   1 root root   355 Jun  5  2013 bsdmainutils*
> -rwxr-xr-x   1 root root   384 Mar 24  2014 cracklib-runtime*
> -rwxr-xr-x   1 root root   532 Mar  9  2012 debsums*
> -rwxr-xr-x   1 root root  1597 Nov 27  2015 dpkg*
> -rwxr-xr-x   1 root root    56 Oct 17  2015 jfs-filestructure-backup*
> -rwxr-xr-x   1 root root   372 Oct  5  2011 logrotate*
> -rwxr-xr-x   1 root root  1293 Nov  7  2015 man-db*
> -rwxr-xr-x   1 root root   435 Jun 21  2013 mlocate*
> -rwxr-xr-x   1 root root  2069 Apr 21  2016 mythexport*
> -rwxr-xr-x   1 root root   844 Oct  8 01:28 mythtv-database*
> -rwxr-xr-x   1 root root   242 Jun 11  2010 mythtv-status*
> -rwxr-xr-x   1 root root  1387 Oct  6  2016 ntp*
> -rwxr-xr-x   1 root root  1298 Dec 31  2015 optimize_mythdb*
> -rwxr-xr-x   1 root root   249 Apr  9  2012 passwd*
> -rw-r--r--   1 root root   102 Apr  2  2012 .placeholder
> -rwxr-xr-x   1 root root  3449 Feb 27  2016 popularity-contest*
> -rwxr-xr-x   1 root root   383 Apr 13  2012 samba*
> -rwxr-xr-x   1 root root   441 Nov 11  2013 sysstat*
> -rwxr-xr-x   1 root root   214 Apr 20  2012 update-notifier-common*
> -rwxr-xr-x   1 root root  1046 May 20  2016 upstart*
>
> If the write permissions are too permissive, I think cron will not run
> them.
jim at mythbuntu:~$ ls -l /etc/cron.daily/
total 68
-rwxr-xr-x 1 root root  311 Dec 28  2014 0anacron
-rwxr-xr-x 1 root root  539 Apr  5  2016 apache2
-rwxr-xr-x 1 root root  376 Mar 31  2016 apport
-rwxr-xr-x 1 root root 1474 Jun 19  2017 apt-compat
-rwxr-xr-x 1 root root  355 May 22  2012 bsdmainutils
-rwxr-xr-x 1 root root 1597 Nov 26  2015 dpkg
-rwxr-xr-x 1 root root  372 May  6  2015 logrotate
-rwxr-xr-x 1 root root 1293 Nov  6  2015 man-db
-rwxr-xr-x 1 root root  539 Jul 16  2014 mdadm
-rwxr-xr-x 1 root root  435 Nov 18  2014 mlocate
-rwxr-xr-x 1 root root  842 Jan 13 07:14 mythtv-backup
-rwxr-xr-x 1 root root 1387 Sep  5 11:24 ntp
-rwxr-xr-x 1 root root  286 Jan 13 10:04 optimize_mythdb
-rwxr-xr-x 1 root root  249 Nov 12  2015 passwd
-rwxr-xr-x 1 root root 3449 Feb 26  2016 popularity-contest
-rwxr-xr-x 1 root root  383 Mar  7  2016 samba
-rwxr-xr-x 1 root root  214 May 24  2016 update-notifier-common
jim at mythbuntu:~$

> If you have an email system installed locally, then cron will email
> root a copy of the cron logs each day.
I'm adding postfix and setting up to get root mail now.

Jim A

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org