TV Server DB Connection String problem (1 Viewer)

[reumann]

Hi,

I have installed several times with different DB options but I only 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 were exactly as is. "error" log had 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 "ı" (I believe that all connection string is converted to lower).

I converted my system's locale to "English (United States" I was able to run TV Server Configuration applet successfully.

Could you fix it?

 

[infinite.loop]

more informations are required.

"what" did you install exactly?
did you choose a one click installation? or advanced?

do you use MySQl or MS-SQL as server?
is the server installed on the same PC?
is the OS on the PC where you have the SQL-Server installed linux or windows?

 

[ronilse]

Hi,
It's the famous i without the dot above, which it's not converted correct. We had this in MP awhile ago & a workaround was done, but the real fix would be M$ fixing it so i means the same with & without the dot.......

Regards
Roy

 

[donjuan]

Problem about Turkish Windows !!

more informations are required.

"what" did you install exactly?
did you choose a one click installation? or advanced?

do you use MySQl or MS-SQL as server?
is the server installed on the same PC?
is the OS on the PC where you have the SQL-Server installed linux or windows?

Dear Infinitiloop,

The same problem was addressed by me in the following post already.

https://forum.team-mediaportal.com/...3-ss2-not-recognized-35738/?highlight=turkish

and here

https://forum.team-mediaportal.com/...zed-within-tvserver3-35224/?highlight=turkish

I have recently tried all with MYSQL and MS SQl2005 with TVe3 but even the mediaportal itself does not startup succesfully without editing some filenames of jpg files such as newmailicon.png etc.


For I am not a programmer, I can not really suggest a solution to this problem but this is a VERY BIG issue for the people who want to use this software in their Turkish regional code windows, both XP or Vista.

So I hope you developers will take a response in this issue and try your best to solve this issue.I am willing to help you in any aspect, especially by testing any betas or new developments suggested by you.

Thank you in advance.

 

[rtv]

Like it has been said a thousand times before:
If you ask M$ to fix the operating system then MP will be changed accordingly.

 

[donjuan]

About TVSERVER3 and Turkish Windows

Like it has been said a thousand times before:
If you ask M$ to fix the operating system then MP will be changed accordingly.

What can we do to temporarily fix the situation? Please someone help, because I want to try this annoying TVSERVER3 and I dont want to make concessions of my Turkish regional settings.

Thank you