Database connection TV server setup

[fatt_fill]

Hi all,

Having some issues setting up TV-Server Media Portal 1.0 RC2 (Windows XP SP3). Installed TV server using all in one installer. Installed as dedicated server using pre-installed MySQL database. Connection to database fine. Injection of new tables and data into database went well. TV Card tuned find and new channels in database (used MySQL admin tool to verify). Hostname of TV server is "server" and IP address 192.168.0.2.

Client (Win XP SP2/SP3 - tried two diff clients) is running Media Portal 1.0 RC2. IP addresses 192.168.0.8 and .9. No firewalls. Client loads fine but when I go to TV it comes up with the error "Connected to TV Server, Cannot connect to database" and prompts me to change the server name (for which I have tried "server" and 192.168.0.2 - the IP to host correlation is also in .../etc/hosts). If I use the MySQL admin tool I can see the connection coming in from the client despite the client showing this error. I've tried uninstalling everything and starting from scratch (even using the other database which had exactly the same problem, whether preinstalled or allowing the installer to do all that for me).

I'm now running out of ideas - any ideas?

Thanks in advance for any help you can give me.

Cheers
Phil

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

TV-Server Version : 1.0 RC2
MediaPortal Version: 1.0 RC2
MediaPortal Skin: Default
Windows Version: WinXP SP3 (32 bit)
CPU Type: AMD 64 3000+
HDD: 250GB
Memory: 1.25GB
Motherboard: NVidia NForce 3 based
Video Card: 6600GT
Video Card Driver: 7.1.8.9
Sound Card: Onboard
Sound Card AC3: NA
Sound Card Driver: NA
1. TV Card: Hauppage Nova T 500
1. TV Card Type:
1. TV Card Driver: 4.3.26168.0
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:
Cooling:
Power Supply:
Remote:
TV:
TV - HTPC Connection:

[Paranoid Delusion]

hi Phil

If you configured everything with the firewal supposedly turned off, its still active, unbelievable we know.

So turn them on and allow TVServer, mediaportal and mysql as exceptions and hopefully you will connect.

Then you may turn the flipping thing back off, if you wish.

ps. Welcome to MP

[fatt_fill]

Hi - thanks for you help. Read something about this a while back so tried the install with the firewall turned off. I've just tried turning the firewalls off on both the client and the server - the server did have the firewall turned on but as I'd installed it with it turned on the exceptions you mentioned were present. Simiarly on the client side the exceptions were present - doesn't work with both firewalls on (with the exceptions) or both firewalls off.

Is there any way I can test connectivity (ping works but I know that means basically nothing) or up the logging levels so I can see exactly what is going on?

Cheers
Phil

[Con]

Sorry for my English
I installed MediaPortal_Setup_1.0_RC2, MySQL has already been installed on machine.
Run "TV-Server Configuration" and fill settings db, test was passed.
In the base had been create tables and create row in table "card" (with my tv-tuner).

When I run "TV-Server Configuration" show message "Failed to open database".

The problem was in a password MySQL - "Mn9)Ju&"
Compare with error.log - Password=Mn9)Ju&amp

When I change password everything worked.
I hope this information will be helpful somebody.

"c:\Users\All Users\Team MediaPortal\MediaPortal TV Server\log\error.log"

2008-08-06 10:40:01.306010 [SetupTv]: Unable to get list of servers
2008-08-06 10:40:01.321635 [SetupTv]: Exception   :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=quartz;Database=MpTvDbRC2;User ID=root;Password=Mn9)Ju&;charset=utf8;Connection Timeout=300; ---> MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'root'@'quartz' (using password: YES)
   РІ MySql.Data.MySqlClient.PacketReader.CheckForError()
   РІ MySql.Data.MySqlClient.PacketReader.ReadHeader()
   РІ MySql.Data.MySqlClient.PacketReader.OpenPacket()
   РІ MySql.Data.MySqlClient.NativeDriver.Authenticate411()
   РІ MySql.Data.MySqlClient.NativeDriver.Authenticate()
   РІ MySql.Data.MySqlClient.NativeDriver.Open()
   РІ MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   РІ MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   РІ MySql.Data.MySqlClient.MySqlPool.GetConnection()
   РІ MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
   РІ MySql.Data.MySqlClient.MySqlConnection.Open()
   РІ Gentle.Provider.MySQL.MySQLProvider.GetConnection()
   --- Конец трассировки внутреннего стека исключений ---
   РІ Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   РІ Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   РІ Gentle.Provider.MySQL.MySQLAnalyzer.Analyze(String tableName)
   РІ Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   РІ Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   РІ Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   РІ Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   РІ Gentle.Framework.SqlBuilder..ctor(PersistenceBroker broker, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   РІ Gentle.Framework.PersistenceBroker.GetRetrieveListStatement(Type type, Key key)
   РІ Gentle.Framework.PersistenceBroker.RetrieveList(Type type, Key key, IList result, IDbConnection conn, IDbTransaction tr)
   РІ Gentle.Framework.Broker.RetrieveList(Type type)
   РІ TvDatabase.Server.ListAll()
   РІ SetupTv.SetupTvSettingsForm..ctor()MySql.Data.MySqlClient.MySqlException: #28000Access denied for user 'root'@'quartz' (using password: YES)

MySQL Version: mysql-5.0.51b-win32 or mysql-5.0.41-win32
TV-Server Version: 1.0_RC2 or svn-08-01-2008--19-31-Rev19843
MediaPortal Version: 1.0_RC2
MediaPortal Skin: BlueTwo
Windows Version: Vista Ultimate SP1 32
CPU Type: AMD Athlon 64, 2200 MHz
HDD: 213Gb
Memory: 2Gb
Motherboard: Asus A8N-E
Video Card: ATI RADEON X800GT

[Con]

More example with ampersand.

I manually configure my TVtuner Beholder 407.
In Windows XP DevID ven_1131&dev_7134&subsys_40710000&rev_ 01

In Vista GraphEdit show DevID ven_1131&dev_7134&subsys_00000000&rev_01
Mediaportal finds no tuner with this DevID.
Work this ven_1131&dev_7134&subsys_00000000&rev_ 01

I think this bug.

[Paranoid Delusion]

Hi Con

"amp"

The magical letters, yes this needed to be added for a lot of device id's, otherwise incorrectly recognised.

Thanks for reminding us yet again.

[fatt_fill]

Hi guys - yeah unfortunately this is not the source of my problems - I can connect to the DB locally using MySQL admin tools, TV server can connect to the DB as it has put the tables in place and my scanned channels have populated the relevant tables etc.. and even when the client connects I can see the connection come in from that laptop (viewable using the MySQL admin tool) and yet the client comes back with "Can't connect to database" - very strange. Tried reinstalling and using the default MediaPortal password as well but same problem and same problem if I use MSSQLExpress and install DB before hand or let the installer do it - very confusing.

Going to try a single seat and looking through some log files - where are these located - is there a way of increasing the logging level?

With thanks,
Phil

[reumann]

Hi,

Same problem goes here too.

I'm a new user of MediaPortal but I couldn't get TV Server to run. I have installed several times with defferent DB options but I could get to the entry of log:

2008-10-12 21:21:26.202609 [TVService]: TVService v0.9.3.20432 is starting up on Windows Vista (Service Pack 1)
2008-10-12 21:21:26.202609 [TVService]: Controller: Initilizing TVServer
2008-10-12 21:21:26.202609 [TVService]: Controller: 1 init attempt
2008-10-12 21:21:26.202609 [PowerEventThread]: TV service PowerEventThread message loop is running
2008-10-12 21:21:26.233809 [TVService]: C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
2008-10-12 21:21:26.233809 [TVService]: Controller: using MySQL database connection: Server=pylo;Database=MDPRTL;User ID=root;Password
2008-10-12 21:21:26.233809 [TVService]: ----------------------------
2008-10-12 21:21:26.249409 [TVService]: Controller: DeInit.
2008-10-12 21:21:29.260209 [TVService]: Controller: 2 init attempt
2008-10-12 21:21:29.260209 [TVService]: C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
2008-10-12 21:21:29.260209 [TVService]: Controller: using MySQL database connection: Server=pylo;Database=MDPRTL;User ID=root;Password
2008-10-12 21:21:29.260209 [TVService]: ----------------------------
2008-10-12 21:21:29.275809 [TVService]: Controller: DeInit.
2008-10-12 21:21:32.286609 [TVService]: Controller: 3 init attempt
2008-10-12 21:21:32.286609 [TVService]: C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
2008-10-12 21:21:32.286609 [TVService]: Controller: using MySQL database connection: Server=pylo;Database=MDPRTL;User ID=root;Password
2008-10-12 21:21:32.286609 [TVService]: ----------------------------
2008-10-12 21:21:32.302209 [TVService]: Controller: DeInit.
2008-10-12 21:21:35.313009 [TVService]: Controller: 4 init attempt
2008-10-12 21:21:35.313009 [TVService]: C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
2008-10-12 21:21:35.313009 [TVService]: Controller: using MySQL database connection: Server=pylo;Database=MDPRTL;User ID=root;Password
2008-10-12 21:21:35.313009 [TVService]: ----------------------------
2008-10-12 21:21:35.328609 [TVService]: Controller: DeInit.
2008-10-12 21:21:38.339409 [TVService]: Controller: 5 init attempt
2008-10-12 21:21:38.339409 [TVService]: C:\ProgramData\Team MediaPortal\MediaPortal TV Server\gentle.config
2008-10-12 21:21:38.339409 [TVService]: Controller: using MySQL database connection: Server=pylo;Database=MDPRTL;User ID=root;Password
2008-10-12 21:21:38.339409 [TVService]: ----------------------------
2008-10-12 21:21:38.355009 [TVService]: Controller: Failed to initialize TVServer
2008-10-12 21:21:38.573409 [TVService]: TV service started

I didn't crop line endings of connection strings, they exactly as is. error log has the following entry:

2008-10-12 21:21:38.355009 [TVService]: Exception :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
Check the connection string: Server=pylo;Database=MDPRTL;User ID=root;Password=MDPRTL;charset=utf8;Connection Timeout=300; ---> System.ArgumentException: Keyword not supported.
Parameter name: user ıd

This may be the issue of internalization. The letter "ı" is the lower case of "I" in Turkish ("i" is the lower case of "İ"). My locale is Turkish so if a function like lower("I") is used this will end up with "ı". Could you fix it?

I have made sure that problem is due to locale.

I selected "English (United States)" locale as my "Local System" account and now I'm able to start TV Server. I'm now moving my issue to a new bug report thread to be fixed in a new release.