Client sees but doesn't connect to server (1 Viewer)

[gonzo90017]

This is something I run into a few times a week: The client doesn't connect to the server. When i'm done using the client I have the client go to sleep. But for some reason when I turn the client on in the morning it won't load the TV Guide or Recordings. It takes me to the TV-Setup Please specifiy the IP address or host name screen.

If I open MediaPortal - Configuration> TV/Radio> and click on Test Connection I get the Connection to TV Server Succesful window.

I can see all of the folders I share on my server from the client. So I don't why the client wont connect to the server.

 

[breese]

Where is the MySQL Database located?
Everyone of the start up errors has issues locating the MySQL Database

Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=INTEL-PC;Database=MpTvDb;User ID=root;Password=***;charset=utf8;Connection Timeout=30; ---> MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown.

 

[gonzo90017]

The database is located on the server named INTEL. IP address 192.168.1.81

 

[breese]

Thanks!
From the way the logs read, is it possible the server is not responding to the client request in time?
Does it go to sleep when not in use?
"Connection Timeout=30"

 

[gonzo90017]

From the way the logs read, is it possible the server is not responding to the client request in time?

I have no idea?

Does it go to sleep when not in use?

The server is on a schedule. From 7am to 11:30pm it does not go to sleep. From 11:31pm to 6:59am the server is set to go to sleep after 15 minutes of inactivity but wakes up for scheduled recordings. As you can see in the logs the client tried to connect at around 10am.

 

[breese]

The Server Application Event Viewer is showing issues
"12/22/2013 10:10:12 PM";"MySQL";"(0)";"Warning";"Host name 'INTEL-PC.gateway.2wire.net' could not be resolved: No such host is known. For more information, see Help and Support Center at http://www.mysql.com. ";"3221225572"
"12/22/2013 10:10:12 PM";"MySQL";"(0)";"Warning";"Host name 'INTEL-PC.gateway.2wire.net' could not be resolved: No such host is known. For more information, see Help and Support Center at http://www.mysql.com. ";"3221225572"

Even the Server is having issues with the MYSQL

TVService-Error.log
(right at the 10am time period your talking about)
[2013-12-22 09:57:42,713] [Log ] [Channel state thread] [ERROR] - ChannelState.DoSetChannelStates: An unknown error occured while setting channel states - The database backend (provider MySQL) could not be reached.
Check the connection string: Server=INTEL-PC;Database=MpTvDb;User ID=root;Password=MediaPortal;charset=utf8;Connection Timeout=30;
Error: DatabaseUnavailableUnclassified

 

[gonzo90017]

So it seems like the issue is with MySQL in the TV Server (INTEL-PC)?

What would be the cause of this issue and how do I fix it?

Why would TV Server not be able to reach the database if it's on the same machine?

 

[breese]

It is possible the database is corrupt.
While I do not know how to fix it, there are messages on the forum of how others have.
Maybe one of the others will help you....

 

[gonzo90017]

Thanks for your help. Hopefully somebody else chimes in. . . .

 

[HomeY]

Hi gonzo,

To see if your dB is broken, do the following:
1. Open a command line by clicking start, type "cmd", hit return/enter.
2. Type cd C:\Program Files\MySQL\MySQL Server 5.1\bin (this should be the path to the bin subdirectory within your MySQL install folder) and hit return/enter.
3. Type mysqlcheck mptvdb --auto-repair -e -u root -p, and hit return/enter.
4. A password prompt should appear. The default password is MediaPortal (case sensitive).

If the above test doesn't return any issues, you might want to disable the Wifi Remote plugin and try again (i've seen more issues with the 1.6 Pre Release version).

Other tips:
- Fixed IP adresses for every PC in the network and fill in the IP adress in MP Config instead of the hostname (screenshot shows IP entered, gentle.config file shows hostname in it)
- Enter the IP adresses of the machines in the 'hosts' file >> C:\Windows\System32\drivers\etc
like this:

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
192.168.1.81 INTEL-PC