Yes I did that command.
The database works fine on the first device.
The second device saw the database after I deleted all the sources and library info that was already on it plus I Copied these files over from the first device favourites.xml ", " sources.xml ", " mediasources.xml ", " passwords.xml "
The video files play (on nas) but the music files (on sdcard in first device) don’t play on the second device.
Get this error in the log.
DEBUG: CPlayerCoreFactory::GetPlayers: matched 0 rules with players
11:03:02.121 T:1925896704 DEBUG: CPlayerCoreFactory::GetPlayers: adding audiodefaultplayer (PAPlayer)
11:03:02.121 T:1925896704 DEBUG: CPlayerCoreFactory::GetPlayers: for video=0, audio=1
11:03:02.121 T:1925896704 DEBUG: CPlayerCoreFactory::GetPlayers: for video=1, audio=1
11:03:02.121 T:1925896704 DEBUG: CPlayerCoreFactory::GetPlayers: adding player: VideoPlayer
11:03:02.121 T:1925896704 DEBUG: CPlayerCoreFactory::GetPlayers: added 2 players
11:03:02.133 T:1718354688 DEBUG: Skin Helper Service --> Kodi_Monitor: sender xbmc - method: Playlist.OnAdd - data: {“item”:{“id”:918,“type”:“song”},“playlistid”:0,“position”:3}
11:03:02.154 T:1925896704 ERROR: Init: Error opening file musicdb://albums/406/918.mp3?albumid=406
11:03:02.154 T:1925896704 ERROR: CAudioDecoder: Unable to Init Codec while loading file musicdb://albums/406/918.mp3?albumid=406
11:03:02.154 T:1925896704 WARNING: PAPlayer::QueueNextFileEx - Failed to create the decoder
11:03:02.154 T:1925896704 DEBUG: OnQueueNextItem: play state was 1, starting 1
11:03:02.154 T:1925896704 DEBUG: OnPlayBackStopped: play state was 1, starting 0
11:03:02.155 T:1925882624 DEBUG: CAnnouncementManager - Announcement: OnStop from xbmc
11:03:02.155 T:1925896704 ERROR: Playlist Player: skipping unplayable item: 3, path [musicdb://albums/406/918.mp3?albumid=406]
11:03:02.155 T:1925896704 DEBUG: Playlist Player: no more playable items… aborting playback
11:03:02.155 T:1925882624 DEBUG: GOT ANNOUNCEMENT, type: 1, from xbmc, message OnStop
11:03:02.184 T:1659372288
Well for them to play you would first need to share them (e.g. via samba) and then either add them to the Library on both devices via the Network Share name or alternatively use path substitution on the second device
I’ve installed samba from the myosmc program addon but not sure if I need to change anything after that as adding the source on second device smb://(ip address of first device)/home/osmc/Music throws up error “file exits” I’ve tried it without a password, with the default osmc password and also the password I made for remote control via http.
When adding the network location i’ve got the shared folder set as home/osmc/Music
I’ve rebooted raspberry pi but still them same error
I think you might have mixed up things with copying your sources and password files. Also it might be best if you use fstab based mounts as you anyhow need to find a way to align both systems (either by using same mounted folder name or via the path substitution)
So here we are at the end of 2020. The command sudo apt-get install mysql-server
no longer seems to work. Any hints for a current command that might work today?
Thanks, that worked like a charm. The rest of the guide is still working as described by Kyblik previously.
In the documentation that I found it was recommended to secure your MariaDB installation after first install, like this:
sudo mysql_secure_installation
First prompt will ask you to enter the current database root password. Press Enter to indicate ‘none’. Next prompt will ask if you’d like to set up a database root password. Type N and Enter. From there, press Y + Enter to accept the defaults.
Hello all
My pi don’t want to boot. 4 green LED flashing.
I don’t know why (some electrical cut)
So It’s time to reinstall.
But nothing seem to work well with mysql.
sudo apt install mysql-server => don’t work anymore so I’ve try mariadb
=> ok
sudo mysql
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
sudo service mysql stop
Failed to stop mysql.service: Unit mysql.service not loaded.
ok, try to find my.cnf => nothing
sudo mysql_secure_installation
sudo: mysql_secure_installation: command not found
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
no file found
please can you update this how to ?
I don’t know how I can repair or reinstall my OSMC
EDIT : I’m a idiot : I have installed the mariadb client !! and loose 2 h… Sorry
Since I have 2 vero 4k’s in my house I have setup a mysql between the two. That way the status of everything is synced (to some extend. It doesn’t do live update since the vero’s are always on).
For some time now I have noticed the recently added is not updating at all. Is this a mysql/osmc issue? Or should I lokk elsewhere?
As a staring point just upload full logs via MyOSMC and share the URL. If we can not identify the issue from there we can advice in the new thread which debugging helps.
If you are setup such that both clients are pulling from the same database then there is no “syncing”, they are putting/pulling information to/from the same place. The GUI however does not go looking or receive information on when changes happened so when you switch from one client to the next you can be looking at libraries that have not been refreshed yet. If you switch what window your looking at this will sometimes update the screens. If you start playing something when you stop playback that always refreshes the screen. If you have an item that is partially watched and you start playback on a second client it will prompt for the resume correctly even if the client is not currently showing an icon for that. Additionally if your using an OSMC remote you can hold down the select button when your on the home screen and that will force the UI to reload (I programed that option for this specific situation).
I’m a bit confused here. Your saying your syncing watched status (just not “live”) but content is missing from one of the clients (which shouldn’t be possible)? Or are you just talking about just the recently added widget not showing items that were already watched on the other client, which may be expected as that list may actually be a ‘unwatched recently added’ list depending on the skin in use.
This cannot be done through Keymap Editor. You must edit the map manually and if you use Keymap Editor again after you manually edit the file it will remove it and you must manually tweak the file again.
<?xml version="1.0" encoding="UTF-8"?>
<!-- LG TV CEC KEY ID -->
<!-- up 166 -->
<!-- down 167 -->
<!-- left 169 -->
<!-- right 168 -->
<!-- select/ok 11 -->
<!-- back 216 -->
<!-- exit 216 -->
<!-- stop 224 -->
<!-- << 221 -->
<!-- >> 223 -->
<!-- play 234 -->
<!-- pause 230 -->
<!-- red 251 -->
<!-- green 252 -->
<!-- yellow 253 -->
<!-- blue 254 -->
<keymap>
<Home>
<keyboard>
<key id="252">ReloadSkin()</key>
<key id="253">UpdateLibrary(video)</key>
</keyboard>
</Home>
</keymap>