Posts by vpeter

Use cron?

You need rar2fs: Add rar2fs binary

I got system back and still long time for even simple select * from episode_view. No idea why. It should not be working like that.

Addon handles everything it needs.

Today is slow to me to. Strange.

Update: And now I can't even import db

Quote from Klojum

Code

12:11:59.127 T:140109139670784   DEBUG: RunQuery took 39317 ms for 6538 items query: select * from episode_view  WHERE ((episode_view.dateAdded > '2012-01-01')) AND ((episode_view.playCount IS NULL OR episode_view.playCount < 1))

Can you run this from mysql itself? mysql -u root -p

I don't have any database that's why I copy/paste entries on exported library to get more episodes. And from mysql I get

Quote

use MyVideos116;

select * from episode_view WHERE ((episode_view.dateAdded > '2012-01-01')) AND ((episode_view.playCount IS NULL OR episode_view.playCount < 1));

14816 rows in set (0.193 sec)

Listing them on terminal takes around 7 seconds. using LibreELEC (Milhouse): devel-20190118210257-#0118-ge23e672 (Generic.x86_64) and MariaDB addon 10.3.11.

Quote from Klojum

Is it possible to update the server MariaDB add-on to v10.3.12? Who knows it'll fix it. Right now, Team Kodi is not in the happiest of moods of keeping up SQL db support.

Will do with few extra small changes.

I doubt HDD/SSD is making much difference in this case.

Leave storage as is and configure tvheadend to use extra mounted folders from esxi.

I tried with this in /storage/.kodi/userdata/addon_data/service.mariadb/my.cnf and I got log file with bunch of lines from Kodi.

general_log_file        = /storage/.kodi/userdata/addon_data/service.mariadb/mysql.log
general_log             = 1

LibreELEC:~ # cat /storage/.kodi/userdata/addon_data/service.mariadb/mysql.log
/storage/.kodi/addons/service.mariadb/bin/mysqld, Version: 10.3.11-MariaDB-log (MariaDB Server). started with:
Tcp port: 3306  Unix socket: /var/run/mysqld/mysqld.sock
Time                Id Command  Argument
190110 13:07:30      8 Connect  kodi@<IP_REMOVED> as anonymous on
8 Query    SET NAMES utf8
8 Query    SET SESSION sql_mode = (SELECT REPLACE(@@SESSION.sql_mode,'ONLY_FULL_GROUP_BY',''))
8 Query    SELECT @@SESSION.optimizer_switch
8 Query    SET SESSION optimizer_switch = 'derived_merge=off'
8 Query    SHOW DATABASES LIKE 'MyVideos113'
8 Query    SHOW TABLES LIKE '%'
8 Init DB  MyVideos113
8 Query    SHOW DATABASES LIKE 'MyVideos113'
8 Query    SHOW TABLES LIKE '%'
8 Query    SELECT idVersion FROM version
8 Quit

start/stop/restart the mariadb service

systemctl stop service.mariadb
systemctl start service.mariadb
systemctl restart service.mariadb

Kodi user can't connect on localhost but only on real ip address. That's why you need to use -h parameter

mysql -u kodi -p -h <real ip address of the server>

I assume user kodi@localhost doesn't even exist according to what is created: LibreELEC.tv/mariadb.start at master · LibreELEC/LibreELEC.tv · GitHub

I'm not mysql user so something can also be wrongly implemented.

Whole dmesg would tell more (post url you get) by

dmesg | pastebinit

For IR you can use irexec.

For keyboard I was using actkbd to restart kodi when kodi become non-responsive. (Gladly it is not needed anymore for last few months.)

No idea for CEC (only tested few times).

Rebooting from cron job at 4am every day is still better than waiting for random crash

Well, if I will notice that package must be bumped I will do it. But if everything works fine why make a bump and get into trouble. It happened in multiple occasion at OE and LE.

If you change password in settings then password is automatically set in database. If you have any other suggestion regarding how to be handled let me know.

Well, I don't use mysql so will not even notice something is wrong. And bumping just because there is new version is useless anyway.

Maybe better way would be that some advanced users would notify us "it's time to update"

I was using

mkdir /media/rar2fs
rar2fs -o allow_other --seek-length=0 /<dir containing rar files> /media/rar2fs

Read here about about:config invalid security certificate add exception button missing | Firefox Support Forum | Mozilla Support