United States of America
After having failed to create a plugin for MP1; rather than dive into it to figure out why I decided why not bring up mediaportal 2 and start plugin development there.
so to that end, on my HomeW computer (almost identitical to HOMET my mp1 client/server) I installed MP2-Setup-spring16.
the default installation went fine but had some trouble with my ceton eth6.. fixed that by setting up the cam (to 1) and using ATSC.
Acid test was the channel scan...and I was amazed when it mostly worked. ATSC finds 637 channels on the second ATSC channel it tries and then keeps trying on a bunch move never finding anything else. I cancelled the scan (637 channels is close enough for now) and took a look at what I got. None of the channels had their names from the channel map all appeared as "Unknown Station" with their program and service id. It was when I went to fix that, that I noticed MP2 was using sqllite3 for it's database.
Next order of business was changing from sqllite3 to sqlserverexpress which I have running for MP1 and other projects so I changed the gentile.config parameters to use sqlserver as the default with the correct connection parameters for my server. Stopped the mp2 services using the "stop services" context menu and started them. When I tried to start the MP2 tv config program I received a nasty remoting error.
.
I can see where the empty database was created and created with all the tables. but there appears no way past this error.
switching the gentle.config back to sqllite3 and MP2 tv config works, switch to sqlserver and it doesn't.
For me using either sqllite3 or oracles MySQL is not an option. Neither are robust enough for other projects I work on, neither have a management environment suitable for setup and forget. I use mssqlserver and/or mssqlserver express have for over 20 years and in the last 4 years of running it with MP1 it has proven to be a much better environment. Both sqllite3 and MySQL suffer from memory management issues and sql language implementation issues. sqllite3 further is just plain buggy... returning the integer 42 instead of the string "42" when a movie title by that name was selected. by the way, even running mssql 2016 in windows 10 virtual machine on windows 10 I get better query response than MySQL (when MySQL is running alongside MP1 not virtual) and I've never had to reboot to fix memory issues (in the case of running sqllite3 a reboot every 3 or 4 days is required)
I guess my question at this point is... Has support been dropped for sqlserver or have I just hit a bug in MP2 tv config?
btw... the sqlbrowser isn't really required for MP1. I've never used it so I removed the dependency from the tvservice definition and haven't had any issues over the last two years.
so to that end, on my HomeW computer (almost identitical to HOMET my mp1 client/server) I installed MP2-Setup-spring16.
the default installation went fine but had some trouble with my ceton eth6.. fixed that by setting up the cam (to 1) and using ATSC.
Acid test was the channel scan...and I was amazed when it mostly worked. ATSC finds 637 channels on the second ATSC channel it tries and then keeps trying on a bunch move never finding anything else. I cancelled the scan (637 channels is close enough for now) and took a look at what I got. None of the channels had their names from the channel map all appeared as "Unknown Station" with their program and service id. It was when I went to fix that, that I noticed MP2 was using sqllite3 for it's database.
Next order of business was changing from sqllite3 to sqlserverexpress which I have running for MP1 and other projects so I changed the gentile.config parameters to use sqlserver as the default with the correct connection parameters for my server. Stopped the mp2 services using the "stop services" context menu and started them. When I tried to start the MP2 tv config program I received a nasty remoting error.
.
I can see where the empty database was created and created with all the tables. but there appears no way past this error.
switching the gentle.config back to sqllite3 and MP2 tv config works, switch to sqlserver and it doesn't.
For me using either sqllite3 or oracles MySQL is not an option. Neither are robust enough for other projects I work on, neither have a management environment suitable for setup and forget. I use mssqlserver and/or mssqlserver express have for over 20 years and in the last 4 years of running it with MP1 it has proven to be a much better environment. Both sqllite3 and MySQL suffer from memory management issues and sql language implementation issues. sqllite3 further is just plain buggy... returning the integer 42 instead of the string "42" when a movie title by that name was selected. by the way, even running mssql 2016 in windows 10 virtual machine on windows 10 I get better query response than MySQL (when MySQL is running alongside MP1 not virtual) and I've never had to reboot to fix memory issues (in the case of running sqllite3 a reboot every 3 or 4 days is required)
I guess my question at this point is... Has support been dropped for sqlserver or have I just hit a bug in MP2 tv config?
btw... the sqlbrowser isn't really required for MP1. I've never used it so I removed the dependency from the tvservice definition and haven't had any issues over the last two years.
Last edited:
