Conection to tv server lost (1 Viewer)

[alanhewitt]

I have been having this problem intermittently for some time. I have searched the forums and tried various suggestions without success. The latest was that it could be the internet connection at fault and to try the loop back device. This I installed at the weekend and all seemed OK until yesterday when it happened again. I had a program set to record at 4.55pm when the problem occurred.
The loop-back was was set to address 192.168.2.1 which doesn't conflict with the router 192.168.1.64.
I enclose logs collected as soon as I noticed the failure
Any help would be appreciated.

 

[georgius]

From logs it seems that your MP was resuming from hibernation and MySQL database didn't start or wasn't listening on 192.168.1.64.

 

[alanhewitt]

Thanks for the quick reply.
how do I solve this?
I setup the loop-back device as per https://forum.team-mediaportal.com/threads/msloopback-device-for-singleseat-users.51028/ then set several test recordings and they went Ok, as did all the other scheduled recordings up to this time yesterday.
All the scheduled recordings today have also gone OK. It seems just an odd one which fails in this way. I cant rely on MP to so have a tv card in my work machine to record those which I record for my wife for this I use Win tv but doesn't have the best of interfaces.
Why only an odd failure? I cant expect 'she who should be obeyed' to put up with this in the living room. It always seems to be hers which fail.
I have a 40 second delay for recognition of tv card and had 10 second delay for MePo starting. Have increased this to 15 seconds.

 

[georgius]

The problem is not in TV cards, but in connection to database. As I see the TV server IP address is 192.168.2.1 and MySQL server IP address is 192.168.1.64. Is your database server running on same computer as TV server?

 

[alanhewitt]

Hi again, please remember you are talking to a wood-turner my computer skills are limited.
You will see from my specs that I am a single seat user all on one machine for tv machine.

 

[georgius]

You will see from my specs that I am a single seat user all on one machine for tv machine.

That's information what I need. So change shouldn't be very complicated. You have to locate Gentle.config files in MediaPortal configuration folders (section Configuration files) - this file should be in 'MediaPortal' and also in 'MediaPortal TV Server' subfolders. In these files locate

<DefaultProvider name="MySQL"

and in 'connectionString' attribute change 'Server' property from

Server=192.168.1.64

to

Server=192.168.2.1

Restart TV Service and MP and try if it works.

 

[alanhewitt]

Many thanks again have done as you ask and am just rebooting pc.
That is done, can watch and record tv. Done a logs grab again and no error for tv server.
Many many thanks.
Can I just ask why, all the scheduled recordings apart from just the one failed when the settings for mysql were wrong?
As I said give me trees and wood and I can understand.

 

[georgius]

I assume that you installed loop back adapter after installing database and MediaPortal, so in connection string (connection string tells TV Service how to connect to database) are written parameters which are not valid when your regular connection is not ready.

 

[alanhewitt]

Yes you are correct about the order of installation. but why some times connect when resuming from Hibernate and some time not. but so long as it works in the future do I need to know!
Thanks again

 

[georgius]

It's hard to say why sometimes connect and why sometimes not. I assume that while resuming from hibernation is not ready your regular network connection (e.g. you don't have assigned IP address to network card). If your regular connection is not ready, than MySQL database cannot listen on this connection and TV Service cannot connect to MySQL database.