SQLiteDatabase Plugin for MP2 (3 Viewers)

[cibu]

I have a problem while replacing the database-plugin in Alpha3. What I have done is the following:

• Stop your MP2 server: DONE
• In your MP2 server's plugin directory delete the "SQLCEDatabase" directory : DONE
• Instead copy the content of the SQLiteDatabase_BIN_v0.x.zip file attached to this thread in the plugin directory of your MP2 server: DONE, looks like C:\Program Files (x86)\Team MediaPortal\MP2-Server\Plugins\SQLiteDatabase\
• To be on the save side also delete your [SystemDrive]:\ProgramData\Team MediaPortal\MP2-Server directory: DONE
• Start your MP2 server: Will not work. Message is something like "Service is started but halted...".

What can be wrong?

 

[MJGraf]

Hard to tell without logs
I need the Server.log and the Error.log in particular.
Thanks, Michael

 

[cibu]

Hi Michael,

I hope these are the files you are looking for.

Mark

 

[MJGraf]

Thanks!
That's interesting - I read this somewhere else in the forum last night, but unfortunately can't remember where...
It doesn't load the SQLiteDatabase because it thinks it is from a "remote source" and it doesn't "trust" SQLiteDatabase.dll
So either you have your MP2 Server binaries (including the SQLiteDatabase directory) on a network share - if so, please try on a local hard disk.
If not, then it has to so something with this stupid windows security measures for downloaded files. In that case try right clicking SQLIteDatabase.dll as an administrator and try to find something where you can say "trust this file" or something similar...
Hope that helps!

 

[MJGraf]

Oh, and to tease everyone:
With our own connection pool we are down to <25 minutes for the import test
But the code is stiil ugly and needs a lot more tweaking. Just to say that I was probably right and we can make it even faster...

 

[mrj]

Hi

but unfortunately can't remember where...

maybe it was my post here:
Fix for disabling the screen saver.
/mrj

 

[MJGraf]

Exactly that was it!
Does anyone know where exactly that comes from? The DLL is contained in a ZIP file. When I download the ZIP file and extract it - is the "I'm downloaded and maybe dangerous"-attribute somehow propagated to the files included in the ZIP?

 

[cibu]

Thanks!
If not, then it has to so something with this stupid windows security measures for downloaded files. In that case try right clicking SQLIteDatabase.dll as an administrator and try to find something where you can say "trust this file" or something similar...
Hope that helps!

Thanks a lot! That was the right way to find the problem. I had copied the files from on PC to another and there have been missing some rights.

I attached a screenshot where I had to click "Zulassen". Only in German available for me but perhaps it can help others with this problem.

 

[Lehmden]

Hi.

To be on the save side also delete your [SystemDrive]:\ProgramData\Team MediaPortal\MP2-Server directory: DONE

This deleted all config files also... So it's impossible the server can start... You need to install the MP2 Server again (or do a repair, if the installer gives you this option) and start at first step again:

Stop your MP2 server: DONE

This time don't delete the " [SystemDrive]:\ProgramData\Team MediaPortal\MP2-Server directory"!!! This is something that can be useful ONLY!!! when an upgrade from an earlier version of MP2!!! did not work properly...

Does anyone know where exactly that comes from?

not exactly, but as I don't get this error it must be something with used browser and/or the user running Windows. As my system is hidden behind a hardware firewall I don't give a damn on "security". I'm running it as admin, Defender disabled, security center disabled, UAE disabled, firewall disabled, without any Anti Virus software,... And I never got any security issues my whole life... But lots of others running tons of "security" software has an virus infection every second day...

 

[MJGraf]

This deleted all config files also... So it's impossible the server can start... You need to install the MP2 Server again (or do a repair, if the installer gives you this option) and start at first step again:

I dare to disagree That's the wonderful world of MP2 - even when you delete the whole data-folder and then start the MP2 Server again, it will automatically recreate all the necessary files and folders for you. Of course all your settings are gone, you have to re-attach all the clients and in particular you have to re-import your shares. But the MP2 server will work. No need to reinstall, etc.