Newznab delete category

My newnab+ install was running a little slow. Looking at the categories, it seems i had several hundred thousand releases in the "misc" and "PC 0-day" categories. As i dont use these, i figured a good start to speeding up the box was to empty both of these categories.

Heres is how i did it -

mysql> use newznab;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> delete from releases where categoryID like '8010';
Query OK, 78060 rows affected (2 min 1.46 sec)

mysql> delete from releases where categoryID like '4010';
Query OK, 131528 rows affected (15.50 sec)

mysql> exit;


I dumped this into a php script which is called by the screen_local script. For me, it would be ideal if this was run before NN had chance to process the misc files, just to save resource. This is something ill be looking at in the future though.

 

Figured someone else may find this handy!

Using FreeIPA to authenticate OpenVPN users on pfSense

I have been fiddling with multiple different authentication methods to centralise the authentication across all my devices and services. ...… Continue reading

Zen Internet, IPv6 and pfsense

Published on February 19, 2017

Basic Telegraf, InfluxDB and Grafana setup

Published on January 26, 2017