MP2 - TVSERVER with mysql Database. Not working (1 Viewer)

masoxik_cz

New Member
November 30, 2015
3
0
42
Home Country
Czech Republic Czech Republic
Hi guys, please I need help.
I installed new MP2, but I need config tv database to another machine with mysql database. I need that because I need update iptv tokens every day.
I found config "C:\ProgramData\Team MediaPortal\MP2-Server\SlimTVCore\v3.0\Gentle.config" and I edited it into this:

<DefaultProvider name="MySQL" connectionString="Server=pupik;Database=mptvdb;User ID=mp;Password=Medi@Port@1;charset=utf8;Connection Timeout=300;" />
<!--<DefaultProvider name="SQLite" connectionString="Data Source=C:\ProgramData\Team MediaPortal\MP2-Server\Database\MP2TVE_3.s3db;Pooling=true;FailIfMissing=true;Version=3" />-->

Then I restarted MP service and after that I started MP2 TVConfiguration icon on the desktop. This creates an objects in this remote database, but then says this:

MPerror.jpg



Požadovaná služba nebyla nalezena = A requested service cannot be found.

Here is logs as attachments
--- Post updated ---
I dont know why inserted image is not working. In the preview I see image correctly. :/
URl of this image is: https://www.masoxik.cz/foto/public/MPerror.jpg
 

Lehmden

Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,329
    3,792
    Lehmden
    Home Country
    Germany Germany
    Country flag
    HI.
    In MP2 the TV engine is using MP2 Server Database, this means SQLite. To use MySQL you need to exchange the database plugin for the MP2 server. As MySQL is slower a lot (we're talking about ten times slower in real live) compared to SQLite and has not a single advantage (in normal circumstances) the MySQL plugin isn't maintained for a very long time. So you need to try if it works (I don't believe it) and if it don't work probably change back to a very old version of MP2.

    But I don't understand why you need MySQL to update iptv tokens. Do you access the TV Database directly for this? This is not recommended in general and really dangerous in MP2 environment as this often will lead to a corrupted database... But I have to admit that I've never used IPTV (slow internet connection on my location, bad picture quality of IPTV compared to DVB-S2,...), also my ISP offers IPTV for free to it's customers...
    By the way, the SQLite DB also can be modified from "outside", if you really want to do this.
     

    masoxik_cz

    New Member
    November 30, 2015
    3
    0
    42
    Home Country
    Czech Republic Czech Republic
    ok thanx. I need update these tokens because my iptv provider not supporting MP. But they provide m3u list for VLC. this list is usable with mp with some modifications. Every provided token is valid only 24hours. after that is not possible watch to iptv channel with old token. :(
    I have automated scripts on linux server for this. On that same server I have Mysql server. I dont need 10x faster database, because tvserver dont need data that fast. Why? it is irrelevant.

    " you need to exchange the database plugin for the MP2 server." Please can you give me information how to do this?
    thank you very much.
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,329
    3,792
    Lehmden
    Home Country
    Germany Germany
    Country flag
    I dont need 10x faster database, because tvserver dont need data that fast.
    It's not only the TV Server, it's all MP2. Every view in MP2 GUI is getting data from the database. So you will slow down MP2 a lot by using MySQL... If the MySQL server isn't on the same machine as the MP2 server this will be even more worse. A really, really bad idea. You better modify your scripts on the linux server for that purpose...

    I have realized that the MySQL plugin is removed from the Repo in meantime. As told, it's old, not maintained and most likely not compatible with recent versions of MP2. So there is a lot of searching in forum needed to find it, if ever it is still available. But maybe you can compile it yourself as the source code still should be available....

    The exchange itself is simple, once you have found the plugin... Stop MP2 server, move the SQLite plugin folder (normally "c:\Program Files (x86)\Team MediaPortal\MP2-Server\Plugins\SQLiteDatabase\") aside and copy the MySQL plugin folder into MP2 server plugin folder... Then start the server again and if you are really lucky and the server starts, you need to rebuild all your media sources and the whole TV configuration from scratch. You need to replace the MySQL plugin folder prior to every update of MP2, and replace it again after the update was successful as with every update the SQLite Plugin will be installed again and you can not have two database plugins at the same time.

    Edit:
    It would be easier to write a TV Server Plugin for updating the m3u lists directly in the TV engine. But for this you need some c# skills...
     

    Users who are viewing this thread

    Similar threads

    I'm wanting to temporarily open ports to enable MP Client to work remotely via the internet. I have my router forwarding TCP ports 31456, 554, and 3306 and firewall set to public for TV Server and MySQL. Also tried disabling the firewall. MP Config says it can connect on port 31456 but can't access the database on 3306. I think...
    I'm wanting to temporarily open ports to enable MP Client to work remotely via the internet. I have my router forwarding TCP ports...
    I'm wanting to temporarily open ports to enable MP Client to work remotely via the internet. I have my router forwarding TCP ports...
    Replies
    0
    Views
    868
    OK, this is specifically for people in Belgium (Vlaanderen) who are using Telenet Cable with MediaPortal 2. Next year (Edit: this year, in march 2020) the Telenet provider will stop broadcasting Analog TV and Radio signals on their cable, and make the switch to Digital (DVB-C). The radio signals will disappear completely, so you'll...
    OK, this is specifically for people in Belgium (Vlaanderen) who are using Telenet Cable with MediaPortal 2. Next year (Edit: this...
    OK, this is specifically for people in Belgium (Vlaanderen) who are using Telenet Cable with MediaPortal 2. Next year (Edit: this...
    Replies
    0
    Views
    746
    That's awesome news! I can't say how I'm happy to help fellow XP user :D
    That's awesome news! I can't say how I'm happy to help fellow XP user :D
    Ok, I’m back, MP1.14 has been working great for the last few years, up until last month when a recording overwrote the hard drive...
    Replies
    18
    Views
    2K
    UPDATE 3; RESOLVED - i haven't needed to do anything with MP2 for so long i skipped the setup after reinstalling MP2 (which probably wasn't needed after all) I believe the issue was zap2it did not download any data for whatever reason. switching to TV Guide got me data but in a different format. I needed to go into the setup for XMLTV...
    UPDATE 3; RESOLVED - i haven't needed to do anything with MP2 for so long i skipped the setup after reinstalling MP2 (which...
    i have been running this batch file for months with no issues using the Spring '16 version: time /t date /t cd...
    Replies
    2
    Views
    1K
    Thank you for your patience. I will try that then (y).
    Thank you for your patience. I will try that then (y).
    I'm glad that I wasn't imagining the problem! Added by HTPCSourcer for clarity: For future reference: To rename the ProgramData...
    Replies
    11
    Views
    2K
    Top Bottom