[mythtv-users] mysql filling up hard drive

[Scott Moncrieff]

I will certainly have a look at Find_orphans, I was not looking forward to
removing them manually although I had a plan of copying the log file into a
spreadsheet and using the file names to construction rows of mysql commands
to remove them. I did something similar when I renumbered all of my
channels and removed all of the junk ones I did not want.

I was fairly sure that there was an issue with my old system not deleting
files, I had a 2TB drive with 900Mb of recording but the drive was 99% full
and current recordings from my library were being expired and deleted,
nothing I had manually deleted after watching had actually been removed. My
time to retain deleted recording was set to 0. That system is gone now so
and I needed to do the upgrade anyway.

I suppose that some kind of security on my mythtv computers is something I
should look at urgently but I do have my router pretty well locked down. I
would like to password protect mythweb but that option does not seem to
work from the mythbuntu control center, it just returns an
org.freedesktop.DBus.Python.TypeError


On 10 May 2015 at 18:22, Michael T. Dean <mtdean at thirdcontact.com> wrote:

> On 05/08/2015 06:05 PM, Scott Moncrieff wrote:
>
>> I don't know why I didn't look before but I just looked in Manage
>> Recording Rules and it is full of 'Record All     Breakfast      News...'
>> rules. I don't know how many but was holding 'page down' for a good couple
>> of minutes and still did not get past them. Too many to delete manually I
>> suspect. Would this be a likely cause! How can I get rid of them without
>> setting aside a couple of day deleting them one at a time?
>>
>>
> Since I'm pretty sure that you didn't create 23.5k recording rules for
> that show, it sounds like you may have an open/unsecured MythWeb
> installation where a bot or miscreant or something got in there and created
> the rules for you.  If so, you need to fix that before something else does
> something really bad to your system.
>
> Mike
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150510/6e7a96d0/attachment.html>