Initial Sync Failing

[d90 11]

I'm getting an error in my initial sync. I see the following in the logs but I don't know what to do about it. 

 

22:39:33.804 T:648  NOTICE: EMBY.database -> ERROR:: type: <class 'sqlite3.OperationalError'> value: no such table: tvshow

22:39:37.229 T:648  NOTICE: Previous line repeats 1 times.

kodi.log

Edited December 6, 2018 by d90

[Angelblue05 4130]

Could you provide your complete kodi log? If it includes sensitive info, you can pm. Thanks.

[d90 11]

I didn't realize I had to chose a file then click another button to attach it. It's added now. Thank you. 

[Angelblue05 4130]

Use the beta version, Leia is not supported on stable yet.

[d90 11]

I am using beta [3.1.35a]. I used the beta zip from kodi.emby.media installer and the beta Emby repo. From there I installed "Kodi Emby Beta Addons" 

Edited December 7, 2018 by d90

[d90 11]

Ok so since I'm already using the beta and its not working what are my next steps? I'm willing to test and do whatever it takes to get it working. I've also moved on to test on 2 separate shield tvs and 1 more windows 10 install. Same version of Kodi [18 RC3] and same beta version of Emby for Kodi [3.1.35a]. neither of the shields work but the other windows 10 install does. I can't figure out what's different about that single install vs the rest that don't work.

 

I have already tried fresh Kodi installs on all 4 of my systems.

 

Sent from my SM-G955U using Tapatalk

Edited December 8, 2018 by d90

[Angelblue05 4130]

Is your shield connected to the internet? The issue is that it can't grab the necessary components to make it work for your Kodi version.

 

Let me know.

Edited December 10, 2018 by Angelblue05

[d90 11]

Is your shield connected to the internet? The issue is that it can't grab the necessary components to make it work for your Kodi version.

 

Let me know.

Yes it has internet access. Where are the files hosted that it's trying to download? I'd like to test connectivity from my location. 

[Angelblue05 4130]

@@d90

 

Is this the same issue related to the other thread you posted in?

[d90 11]

Yes sir it is. 

[Angelblue05 4130]

Have you tried installing as I said in the other post? Does it work?

[d90 11]

I have tried that, and I saw that a patch was installed afterwards. Unfortunately im still unable to do the initial scan.

 

Sent from my SM-G955U using Tapatalk

[Angelblue05 4130]

I have tried that, and I saw that a patch was installed afterwards. Unfortunately im still unable to do the initial scan.

 

Sent from my SM-G955U using Tapatalk

New log? Thank you.

 

Maybe try to do a database reset. Launch the addon > local database reset.

Edited December 10, 2018 by Angelblue05

[d90 11]

I was able to get the initial sync to work by turning off my next gen firewall. I need some assistance from you still, because for security reasons I have to turn it back on. I need to know though, what IPs or domains to whitelist to allow this addon to function. 

[sualfred 677]

Check the logs of your firewall what exactly has been blocked and whitelist it.

Noone of us will know your IPs, hardware/network setup, etc.

[d90 11]

Check the logs of your firewall what exactly has been blocked and whitelist it.

Noone of us will know your IPs, hardware/network setup, etc.

I have checked the logs, and the only connections I see outbound from my kodi boxes running emby for kodi are to github and dropbox. Neither are being blocked. 

 

I'm asking what domains this addon reaches out to and needs for functionality. I don't need any info on my internal network.  

 

Please and thank you. 

[sualfred 677]

This is a sync addon to your own Emby server. We don't know the domain, IP, port of it. It's the one you have entered during the addon setup.

Edited December 10, 2018 by sualfred

[d90 11]

My emby server is on my local network. It's the same subnet the nvidia shield is on. Connectivity internally is not effected. L2 communication doesn't hit the firewall. This is what's confusing me. Angelblue05 said it needed to reach out to dl components on the internet. This lead me to believe something on the firewall was blocking outbound communication to some source on the internet. I put my shield in the DMZ and suddenly the sync works. It doesn't make any sense to me. 

 

Further, if internal communication to the emby server was failing, wouldn't that effect the emby app for android as well? Currently I'm able to stream just fine if I'm using the emby app, but I want to use kodi obviously

Edited December 10, 2018 by d90

[sualfred 677]

The things that are going to be downloaded from the internet are hosted on github. It's required to get module patches of the addon for the running Kodi build version. Everything else is direct communication with your local server (including a websocket connection).

[Angelblue05 4130]

@@d90

 

It reaches out to github and one single file on our hosted http://kodi.emby.media

 

I will provide you with a test build for you to try, to see if we can get it to work without you taking down your firewall, which I must admit is the first time I hear of something like this.

 

I’ll ping you in when the build is ready for you to test.

[djhifi 55]

I have 3 Nvidia shields and my database is stored on Synology 1813+ with firewall up. I also have firewall on my router up. This is the first I'm seeing any thing like this as well.

I have opened the ports for emby server on my Synology and router and that's it. I have UpnP off. Didn't even mess with the NVidia Shields.

 

 

Where is your server installed on (OS)?

Do you have the correct read/write permissions on the Shields and credentials inside the addon specified?

Do you have any more libraries besides "tvshows" table that you can select from?

Do the shields have DHCP or static ips?

Have you "messed" with network configurations on KODI itself?

 

When you placed the Shield on DMZ (therefore making the sync work) you didn't do ANYTHING else besides that for sure?

 

DMZing something shouldnt be the workaround indeed. But wierd issue and first time I'm seeing it as well. Specially on NVidia Shields.

 

EDIT: I take it that despite you've been posting on the other thread (https://emby.media/community/index.php?/topic/66299-initial-sync-problem/) this shouldn't be related:

 

 

 

Just try to install again. It was my bad, I forgot to push the leia-beta branch, so it couldn’t find the build for emby for kodi to make it work with your Kodi.

However you should still consider updating to RC.

 

 

Correct?

Edited December 11, 2018 by djhifi

[d90 11]

Where is your server installed on (OS)?

• Official Docker image

Do you have the correct read/write permissions on the Shields and credentials inside the addon specified?

• Yes

Do you have any more libraries besides "tvshows" table that you can select from?

• Movies as well

Do the shields have DHCP or static ips?

• Yes, they do. 

Have you "messed" with network configurations on KODI itself?

• Kodi is stock except for the addon. 

 

So in the past few days I've moved all my devices into the DMZ and done the initial scan. Once that's done I can move them back and they work normally within the trusted part of my network.

 

This got me thinking that it's maybe just that my addon couldn't get the leia specific updates from git. I watched my ngfw logs and saw that something was being blocked in my dnsbl from the shield to Git,a nd whitelisted that. I think going forward I'm ok. I'm going to test to confirm but assume if I don't post back here that the issue is resolved. I think my dnsbl was the culprit AS WELL AS needing whatever that update was that was mentioned in the other post. 

Edited December 13, 2018 by d90

[d90 11]

I've confirmed that I no longer have to put my Kodi boxes in dmz to do initial sync. As I suspected, my dnsbl was preventing a patch from downloading from git. Now that git is whitelisted the patch downloads fine and the initial sync goes without a hitch.

 

Thanks for the support y'all!!

 

Sent from my SM-G955U using Tapatalk