Solved by the post marked as solved. Also see this comment for more detail.
Hi there,
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.
Background:
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.
Setup
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)
Problem
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.
Logs:
https://paste.osmc.tv/zofugayuqi
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)
Fred