Solved by the post marked as solved. Also see this comment for more detail.
I’m at a loss in getting this resolved and read through tons of different forum posts, but I can’t seem to get my issue resolved. The OSMC forum seems to have the friendliest and most helpful community, so I thought that I would post it here in the hopes of finding the hopefully small issue that I am missing.
I have had my Raspberry Pi devices for about 5 years now and started using OSMC about a year ago and everything has been working perfectly. I decided to move from Sickrage to Medusa, but I saw that it is recommended to start with a fresh library and along with all the additions and removals from my library I decided to start completely fresh and do a clean install of OSMC and setting the rest (MySQL, NZBGet & Medusa) from scratch.
Raspberry Pi 3 running as my primary device in the lounge connected via WiFi. This has all the applications installed and does all the work.
Raspberry Pi 2 in the bedroom with just OSMC installed and connecting to MySQL on the primary device
External Hard Drive mounted on the Asus router with guest login (No username or password required)
I installed OSMC from scratch with the installer and updating to the latest version I installed MySQL, NZBGet & Medusa.
I then created folders for the network drive and configured fstab.
I setup MySQL following the guide on the Kodi wiki keeping with kodi as the name and password for the MySQL User.
I gave the Raspberry Pi a static IP address through the MyOSMC interface and ticked Wait for Network
I configured MySQL’s connection through the MyOSMC interface.
I then added the network drive as a library using the IP address and the import starts off OK and the TV Shows section is visible.
After some time the TV Shows section is no longer visible and I am unable to update the library or clean the library.
This makes me feel that the issue is definitely with MySQL’s setup / configuration and I am certain that I am missing something somewhere although I can’t figure out where I made a mistake.
I have also tried stopping and starting the MySQL service to see if it may be network related even though I found that OSMC waits for MySQL I thought I’d try it as the shares may not have been visible yet.
Before taking logs I have dropped the MyVideos database and restarted the Raspberry Pi, but I was still not able to update or clean the library.
The logs has Debugging enabled and the following was done:
- Restart the Raspberry Pi
- Navigate to Media and perform Clean library
- Navigate to Videos opening up the folder in the SMB share and selecting Update Library on the left
Some useful info:
Advancedsettings.xml (Automatically created by MyOSMC)
<advancedsettings> <videolibrary> <importwatchedstate>true</importwatchedstate> <importresumepoint>true</importresumepoint> </videolibrary> <videodatabase> <name>MyVideos</name> <host>192.168.0.42</host> <user>kodi</user> <pass>kodi</pass> <type>mysql</type> <port>3306</port> </videodatabase> </advancedsettings>
/etc/fstab (Is the issue possibly here?)
/dev/mmcblk0p1 /boot vfat defaults,noatime,noauto,x-systemd.automount 0 0 //192.168.0.254/sda2/Series /mnt/External/Series cifs guest,uid=1000,gid=1000,noauto,x-systemd.automount,rw,iocharset=utf8 0 0 //192.168.0.254/sda2/Movies /mnt/External/Movies cifs guest,uid=1000,gid=1000,noauto,x-systemd.automount,rw,iocharset=utf8 0 0 //192.168.0.254/sda2/Downloads /mnt/External/Downloads cifs guest,uid=1000,gid=1000,noauto,x-systemd.automount,rw,iocharset=utf8 0 0 # rootfs is not mounted in fstab as we do it via initramfs. Uncomment for remount (slower boot) #/dev/mmcblk0p2 / ext4 defaults,noatime 0 0
I have also tried making use of another SD card and doing everything from scratch on there, but the issue remains.
As mentioned above I believe there is a mistake on my side with something that I missed compared to roughly a year ago when I set everything up previously and would appreciate it if somebody could take a look and either point me in the right direction or tell me what to do to resolve the issue.
I am not advanced in Linux, but I feel that I understand it, but I just need to be pointed in the right direction, so if you require something to be provided or uploaded, just point me at where I can get it or excuse me for asking for some more information.
Thanks in advance (hopefully)