Posts by vpeter

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

1. 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.

start/stop/restart the mariadb service

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

I assume user [email protected] 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

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

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

Seems to be working with sample rar file I have.

Quote from CvH

For whatever reason more ppl then you would expect.

Seems true. And this program is still maintained.

And I remembered I know the author