Posts by goldenpipes

goldenpipes

Quote from JimmySmith
Did you mean for Kodi? If yes, I using
Code
query_cache_type        = 1
query_cache_size        = 5M
skip-name-resolve
default-storage-engine  = innodb
And it works pretty well for me (not big Library, two Pi's clients). Make sure that your Videos DB are innodb also (you can create it with default-storage-engine, or you can alter existing one).

I modified also a few of other parameters (not sure which one, some of them are setuped already from vpeters template), not sure if it havinf much influence, but innodb and query cache are confirmed along Kodi forums..
Code
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K


# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 10M
innodb_additional_mem_pool_size = 2M


# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 2M
innodb_log_buffer_size = 8M


#innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
Display More

I have a pretty big library.

my mysql server is running on an i5-3210m with 8gb ddr3-1600 ram with an SSD with ~500 MBps read and ~350 MBps write.

Would changing mysqld.conf to what you have above speed things up at all or should i just leave it as is?

would i just have to uncomment the innodb tags to convert the db's or would I need to rebuild my db's?

Thank You!

goldenpipes

it seems to be working fine the way i have it set

thanks for your work on this!

goldenpipes

Quote from Klojum

MySQL allows no outside access by default.

That's not a bug, but a security measure.

Adjust the MySQL settings for the appropriate user(s) for network access.

is this the my.conf? i have no idea where this file is or what to change. It just needs local network access. not web access..

Thank you!

Also i should mention my "advancedsettings.xml" on my "client" LE device works with the IP address. but on the "server" LE device it has to be "127.0.0.1" which i just thought was strange.

goldenpipes · Plex Media Server on LibreELEC goldenpipes June 17, 2017 at 3:23 AM

how does one do this?

the CentOS rpm or Redhat?

what do i do? id rather use the plex RPM instead of the addon stuff just so i can auto update pms.

goldenpipes

okay so i just changed my advanced settings from 192.168.1.111 which is the server IP to 127.0.0.1 and now it is working.

is that a bug or is the mysql server not open to the network? only localhost?

i have another LE box that i want to connect to the network and share the mysql.

thanks!

goldenpipes

hello there,

I am setting up a new server that I want to run mysql and kodi on. I have LE 8.0.2 installed and installed the LAMP addon

disabled the httpd since i wont be using it and have set up mysql with the all the steps:

Code

create user 'kodi' identified by 'kodi';
grant all on *.* to 'kodi';
drop user ''@'localhost';
drop user ''@'MEDIASERVER';
flush privileges;

here is my advancedsettings.xml

Code

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.111</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.111</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </musicdatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

Display More

this is the first time i am setting this server up on LE i have used Windows only before to set up mysql.

i am getting this error:

Display Spoiler

16:15:24.392 T:140572585203456 ERROR: Unable to open database: MyMusic60 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.393 T:140572585203456 ERROR: Unable to open database: MyMusic59 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.393 T:140572585203456 ERROR: Unable to open database: MyMusic58 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.393 T:140572585203456 ERROR: Unable to open database: MyMusic57 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.393 T:140572585203456 ERROR: Unable to open database: MyMusic56 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.393 T:140572585203456 ERROR: Unable to open database: MyMusic55 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.394 T:140572585203456 ERROR: Unable to open database: MyMusic54 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.394 T:140572585203456 ERROR: Unable to open database: MyMusic53 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.394 T:140572585203456 ERROR: Unable to open database: MyMusic52 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.394 T:140572585203456 ERROR: Unable to open database: MyMusic51 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.394 T:140572585203456 ERROR: Unable to open database: MyMusic50 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.394 T:140572585203456 ERROR: Unable to open database: MyMusic49 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic48 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic47 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic46 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic45 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic44 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic43 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.395 T:140572585203456 ERROR: Unable to open database: MyMusic42 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.396 T:140572585203456 ERROR: Unable to open database: MyMusic41 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.396 T:140572585203456 ERROR: Unable to open database: MyMusic40 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.396 T:140572585203456 ERROR: Unable to open database: MyMusic39 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.396 T:140572585203456 ERROR: Unable to open database: MyMusic38 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.396 T:140572585203456 ERROR: Unable to open database: MyMusic37 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to open database: MyMusic36 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to open database: MyMusic35 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to open database: MyMusic34 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to open database: MyMusic33 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to open database: MyMusic32 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to open database: MyMusic60 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.397 T:140572585203456 ERROR: Unable to create new database

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos107 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos106 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos105 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos104 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos103 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos102 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.398 T:140572585203456 ERROR: Unable to open database: MyVideos101 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.399 T:140572585203456 ERROR: Unable to open database: MyVideos100 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.399 T:140572585203456 ERROR: Unable to open database: MyVideos99 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.399 T:140572585203456 ERROR: Unable to open database: MyVideos98 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.399 T:140572585203456 ERROR: Unable to open database: MyVideos97 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.399 T:140572585203456 ERROR: Unable to open database: MyVideos96 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.399 T:140572585203456 ERROR: Unable to open database: MyVideos95 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos94 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos93 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos92 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos91 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos90 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos89 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.400 T:140572585203456 ERROR: Unable to open database: MyVideos88 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.401 T:140572585203456 ERROR: Unable to open database: MyVideos87 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.401 T:140572585203456 ERROR: Unable to open database: MyVideos86 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.401 T:140572585203456 ERROR: Unable to open database: MyVideos85 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.401 T:140572585203456 ERROR: Unable to open database: MyVideos84 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.401 T:140572585203456 ERROR: Unable to open database: MyVideos83 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.401 T:140572585203456 ERROR: Unable to open database: MyVideos82 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.402 T:140572585203456 ERROR: Unable to open database: MyVideos81 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.402 T:140572585203456 ERROR: Unable to open database: MyVideos80 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.402 T:140572585203456 ERROR: Unable to open database: MyVideos79 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.403 T:140572585203456 ERROR: Unable to open database: MyVideos78 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.403 T:140572585203456 ERROR: Unable to open database: MyVideos77 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.403 T:140572585203456 ERROR: Unable to open database: MyVideos76 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.403 T:140572585203456 ERROR: Unable to open database: MyVideos75 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.403 T:140572585203456 ERROR: Unable to open database: MyVideos107 [1045](Access denied for user 'kodi'@'MEDIASERVER' (using password: YES))

16:15:24.403 T:140572585203456 ERROR: Unable to create new database

16:15:24.404 T:140572585203456 NOTICE: Running database version TV29

16:15:24.404 T:140572585203456 NOTICE: Running database version Epg11

16:15:24.406 T:140572604146944 NOTICE: start dvd mediatype detection

16:15:24.486 T:140572604146944 WARNING: JSONRPC: Could not parse type "Setting.Details.SettingList"

16:15:24.545 T:140572604146944 NOTICE: initialize done

16:15:24.545 T:140572604146944 NOTICE: Running the application...

16:15:24.548 T:140572604146944 NOTICE: starting zeroconf publishing

16:15:24.549 T:140572604146944 NOTICE: CWebServer[8080]: Started

16:15:24.549 T:140572604146944 NOTICE: starting upnp client

16:15:24.571 T:140571427452672 NOTICE: ES: Starting UDP Event server on port 9777

16:15:24.571 T:140571427452672 NOTICE: UDP: Listening on port 9777 (ipv6 : false)

16:15:24.581 T:140572604146944 WARNING: CXRandR::Query - output LVDS1 has no current mode, assuming disconnected

16:15:24.630 T:140571845580544 WARNING: CSkinInfo: failed to load skin settings

16:15:31.511 T:140572585203456 ERROR: GetDirectory - Error getting

16:15:33.694 T:140572604146944 ERROR: Previous line repeats 6 times.

16:15:33.694 T:140572604146944 ERROR: GetResumeItemOffset - Cannot open VideoDatabase

i have no idea why kodi (LE) isn't connecting to the mysql server. Obviously mysql is running and i can putty into it from my windows PC.

goldenpipes

Quote from glenrunciter

I have a long shot you might try. Is yours a scenario with an AVR involved ? You might want to confirm your audio settings are defaulted to 2.0 speaker settings. Kodi is counter intuitive when it comes to surround settings, if you run a 5.1 rig you're bound to select 5.1 settings..but you shouldnt. This results in the "appearently bandwidth related" issues.

Is this true about the AVR settings? my pioneer htp 073 seems to work perfectly with my kodi audio system settings at 5.1.

goldenpipes · Cannot execute .sh script goldenpipes December 17, 2016 at 10:17 PM

Quote from lrusak

syntax matters

Bash

#!/bin/sh 
case "$1" in 
  pre) 
    ;; 
  post) 
    systemctl restart kodi 
    ;; 
esac

Thanks m8. i feel like such a noob!

goldenpipes · Cannot execute .sh script goldenpipes December 11, 2016 at 4:46 AM

Quote from sakos

Thank you Peter!

so i have the following file:
~/.config/sleep.d/01-restart.power

i chmod 755 and also dos2unix.

it still wont restart kodi on wake from sleep.

file contents:

Code

#!/Bin/sh! 
Case "$ 1" in 
pre) 
;; 
post) 
systemctl restart kodi 
;; 
Esac

am i doing something wrong? thanks!

Posts by goldenpipes

[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle

[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle

[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle

Plex Media Server on LibreELEC

[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle

[ABANDONED] LAMP addon - Linux, Apache, MySQL PHP bundle

Support for USB Gigabit LAN/802.11ac adapter?

Cannot execute .sh script

Cannot execute .sh script