Self Contained Web Server / Interface (2 Viewers)

mmesh

MP Donator
  • Premium Supporter
  • December 10, 2004
    65
    3
    Zagreb
    Home Country
    Croatia Croatia
    Let me know if you can still log on with the SQL Server Management Studio.

    Kev

    I tried to log on as "sa" user and that is working OK.
    I'll try to log on as "Web" user as soon as I come from work today and post results here.

    :D
     

    DarkFire

    Portal Member
    May 9, 2007
    6
    0
    39
    With the latest release, with the extended 500 error, I get the following message:
    [AnyDAC][Phys][MySQL][LIBMYSQL] MySQL server has gone away

    FYI I use a different server for the MySQL database and it's not gone for sure so it seems like it looses the connection with it.
     

    Big_Kev

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    With the latest release, with the extended 500 error, I get the following message:
    [AnyDAC][Phys][MySQL][LIBMYSQL] MySQL server has gone away

    FYI I use a different server for the MySQL database and it's not gone for sure so it seems like it looses the connection with it.
    I am only guessing here, but it could be a DLL problem.

    Could you check that the version of libmysql.dll that is in the application directory is the same as the one in the MySQL install directory.

    If not, then replace it with the MySQL one.


    Regards
    Kev.
     

    DarkFire

    Portal Member
    May 9, 2007
    6
    0
    39
    I am only guessing here, but it could be a DLL problem.

    Could you check that the version of libmysql.dll that is in the application directory is the same as the one in the MySQL install directory.

    If not, then replace it with the MySQL one.


    Regards
    Kev.

    The libmysql.dll in my MySQL directory did have a different size. Probably a different version so I replaced the one in the MP Web interface directory and restarted the interface. Lets see what it does after a few hours...

    Edit: I tried it again and the same error appears. Seems it doesn't fix my problem.
     

    Big_Kev

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    I am only guessing here, but it could be a DLL problem.

    Could you check that the version of libmysql.dll that is in the application directory is the same as the one in the MySQL install directory.

    If not, then replace it with the MySQL one.


    Regards
    Kev.

    The libmysql.dll in my MySQL directory did have a different size. Probably a different version so I replaced the one in the MP Web interface directory and restarted the interface. Lets see what it does after a few hours...

    Edit: I tried it again and the same error appears. Seems it doesn't fix my problem.
    The interface currently holds the same connection open all the time, and just checks for connectivity at the beginning of each request. This seems OK for MSSQL, as that is what I am using without getting these issues.

    I will implement a "timeout" on the connection - say 10 minutes of inactivity - and force a re-connect at the next request. It would appear that the MySQL server is "dropping" the open connection without disconnecting the socket (perhaps).
    This may be a work-around for the problem.

    I will post it as soon as I can, but I am a little busy for the next week...

    Regards
    Kev
     

    pnyberg

    Portal Pro
    August 21, 2006
    405
    36
    Stockholm
    Home Country
    Sweden Sweden
    Thank BIG_KEV for a great app!

    I noticed that you need to have SQL Native client installed in order to connect to a remote server with SQL 2005...
    Perhaps you could update your excellent setup document with that?
    Most of the people are running this on the same server as TV server - but not me.. So it took me a while to figure out..

    :D
     

    DarkFire

    Portal Member
    May 9, 2007
    6
    0
    39
    I am only guessing here, but it could be a DLL problem.

    Could you check that the version of libmysql.dll that is in the application directory is the same as the one in the MySQL install directory.

    If not, then replace it with the MySQL one.


    Regards
    Kev.

    The libmysql.dll in my MySQL directory did have a different size. Probably a different version so I replaced the one in the MP Web interface directory and restarted the interface. Lets see what it does after a few hours...

    Edit: I tried it again and the same error appears. Seems it doesn't fix my problem.
    The interface currently holds the same connection open all the time, and just checks for connectivity at the beginning of each request. This seems OK for MSSQL, as that is what I am using without getting these issues.

    I will implement a "timeout" on the connection - say 10 minutes of inactivity - and force a re-connect at the next request. It would appear that the MySQL server is "dropping" the open connection without disconnecting the socket (perhaps).
    This may be a work-around for the problem.

    I will post it as soon as I can, but I am a little busy for the next week...

    Regards
    Kev

    Ok, I'll look forward to the next version.
    Take it easy, I'm not in a hurry it's just a luxury problem :)
     

    Big_Kev

    Portal Pro
    June 8, 2007
    338
    186
    Home Country
    New Version 0.2.0.06

    Hi All,

    There is something new in this version.

    It now supports refreshing EPG data from xml downloads. There are some new pages in the setup instructions that describe how to set it up.

    Basically, you set up your URLs, reset the mapping grid, and map your MediaPortal channel/s to the xml channels.

    I have added a timeout function for the database connection. It will now disconnect after 10 minutes of inactivity. Then re-connect for the next request.

    Hopefully this will get around the MySQL problems described previously, with the interface giving errors after being active for long periods.

    Kev
     

    risu

    MP Donator
  • Premium Supporter
  • September 22, 2006
    279
    19
    Home Country
    Finland Finland
    I think version 0.1.2.9 is last one which is worked somehow well on my system. After that I can't connect to web int after about 24 hours of installation. When I open manager on 2.0.0.06 I get Socket Error #10061 Connection refused so it could be a firewall issue also, but previous versions (pre 2.0.0.00) worked..

    EDIT

    If I manually kill the process MPWebInt.exe and start it again, it works! It just doesn't seem to work automatically on computer restart.
     

    Users who are viewing this thread

    Top Bottom