TV Server 1.0 problem: The database backend (provider MySQL) could not be reached (1 Viewer)

[Hotkey]

Hi all,

i've the problem that after the start of the computer im unable to watch tv. When i enter MyTV and select a channel i get the message "Timeshift could not be started, no free card available" (Translated from german).
An error.log is generated by the tvserver which states, that the database backend could not be reached. (see blow)
This entry exists 5 times, each with 3 seconds delay between. When i exit MP and restart the TVService everything works as it should.
It seems that the tvservice is starting prior the mysql service which are both set to automatic launch.
How can i solve this problem to make sure that the mysql Service starts first?

Hope someone can help me.

Thanks in advance and with best regards

Hotkey

2008-12-31 12:03:20.531250 [TVService]: Exception   :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=htpc;Database=MpTvDb;User ID=xxxx;Password=xxxx;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'xxxx'@'localhost' (using password: YES)
   bei MySql.Data.MySqlClient.PacketReader.CheckForError()
   bei MySql.Data.MySqlClient.PacketReader.ReadHeader()
   bei MySql.Data.MySqlClient.PacketReader.OpenPacket()
   bei MySql.Data.MySqlClient.NativeDriver.Authenticate411()
   bei MySql.Data.MySqlClient.NativeDriver.Authenticate()
   bei MySql.Data.MySqlClient.NativeDriver.Open()
   bei MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   bei MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   bei MySql.Data.MySqlClient.MySqlPool.GetConnection()
   bei MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
   bei MySql.Data.MySqlClient.MySqlConnection.Open()
   bei Gentle.Provider.MySQL.MySQLProvider.GetConnection()

short update after further investigation:

From the log above it seems, that the MySQL Server denied the connection to the user "htpc@localhost".
To clarify the current setting:
The MySQL User is configured as "htpc@%" (which should include "localhost")
MP and TS is installed on the same computer which is also named "htpc".
I used this hostname "htpc" during the configuration, since the setup didn't allowed me to use "localhost" or "127.0.0.1" (see https://forum.team-mediaportal.com/installation-configuration-support-53/how-use-localhost-tv-database-server-51202/).

From the logs it seems, that the TV Server tries to use the "htpc" as the servername, but the MySQL Error Message gives "localhost".

I'll do dome more investigation and report back..


Update 2, Problem solved
Ok, i fixed this problem. I've now added a second entry in the mysql users table, so i know have the user htpc with the host "%" and one with the host "localhost".
This solved the problem.

Nevertheless it seems, that TVServer uses different techniques when connecting to the database. Otherwhise one entry for one host should be enough to perform the connection.
This might also be the answer why a manual restard of the tvserver after the boot solved the problem also.

After booting: No TV, then exit MP, restart TV Service, start MP: TV working


Greets

Hotkey



TV-Server Version: 1.0.0.0
MediaPortal Version: 1.0.0.0
MediaPortal Skin: Blue3Wide/Indigo
Windows Version: XP SP2
CPU Type: AMD X2 4400+
HDD: Samsung SATA2 250GB
Memory: 2gig
Motherboard: P2-M2A690G
Video Card: ATI 1250X onboard
Video Card Driver: ATI Omega 4.8.442
Sound Card: Radeon HD Audio
Sound Card AC3: optical out
Sound Card Driver: latest
1. TV Card: AVermedia AVerTV DVB-S Pro
1. TV Card Type: DVB-S
1. TV Card Driver: latest bde
2. TV Card:
2. TV Card Type:
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec:
MPEG2 Audio Codec:
h.264 Video Codec:
Satelite/CableTV Provider:
HTPC Case: ASUS P-P2-M2A690G
Cooling: Boxed ASUS cooler
Power Supply:
Remote:
TV: Toshiba 32EL66Z
TV - HTPC Connection: VGA, HDMI - HDMI not working