Self Contained Web Server / Interface

[mmesh]

Originally Posted by Big_Kev

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.

[DarkFire]

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]

Originally Posted by DarkFire

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]

Originally Posted by Big_Kev

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]

Originally Posted by DarkFire

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]

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..

[DarkFire]

Originally Posted by Big_Kev

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]

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]

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.

[DarkFire]

The new version fixed my MySQL problem.