Posts by vpeter

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

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

rar2fs is nice. Was using it around 2010. But who is using rars in 2019

One tip for VPN: Maybe it would be possible to "clone" VPN addon to different name and use second instance. One would be used for public VPN server and one for private at home.

Pooling gpio pin every second is probably very bad idea.

Look into build open-vm-tools config.log to see why it fails. It should not.

Quote from Naass

Using Firefox browser, I have an error saying that the site is untrusted due to self-signed certificate. I have no button to r choice on the page to tell Firefox to trust my site!

On page you need to click Advanced, Add Exception and then Confirm Security Exception. Any other server will do the same because it uses self-signed certificates. You would need to install real one (like from let's encrypt) to overcome that. Or add CA for self-signed certificate to Windows.

Regarding VPN: You would need to make some script to switch between two VPN profiles. I assume addon doesn't support that out of the box.