SQL configuration for radio plugin (1 Viewer)

[flixxx]

MediaPortal Version: 1.0
MediaPortal Skin: Xface
Windows Version: Windows XP SP2
CPU Type: Intel Q6600 2.4 GHZ
HDD: Seagate 250GB
Memory: OCZ 3GB
Motherboard: Asus p5k-e
Video Card: Asus Nvidia 8600GS
Video Card Driver: 1.5.24
Sound Card: Asus Xonar DX
Sound Card AC3: Optical out
Sound Card Driver: 5.12.8
1. TV Card: Twinhan 1020a
1. TV Card Type: DVB-s
1. TV Card Driver: BDA Driver
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: MPV
MPEG2 Audio Codec: AC3filter
h.264 Video Codec: CoreAVC
Satelite/CableTV Provider: Echostar 110W/119W
HTPC Case: Standard
Cooling: Scythe Zipang
Power Supply: Enermax 400W
Remote: Harmony 880
TV: Samsung PN50A550
TV - HTPC Connection: DVI-HDMI


Hello,

i'd like to know where the SQL parameters are and how I can update them.

Currently the "Radio" plugin is giving me errors that it is unable to connect to the sql.

On the other hand, the TV server configuration is able to properly add the ip radio stations i add. I check the SQL and they all get added properly.

Here is the error log;

2010-10-03 18:48:12.109375 [ERROR][MPMain(1)]: TVHome: Error in Reload
2010-10-03 18:48:12.125000 [ERROR][MPMain(1)]: Exception   :Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string:  ---> System.InvalidOperationException: The ConnectionString property has not been initialized.
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
   --- End of inner exception stack trace ---
   at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
   at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
   at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
   at TvPlugin.ChannelNavigator.ReLoad()System.InvalidOperationException: The ConnectionString property has not been initialized.
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
2010-10-03 18:48:12.140625 [ERROR][MPMain(1)]: Exception   :The database backend (provider SQLServer) could not be reached.
Check the connection string: 
2010-10-03 18:48:12.140625 [ERROR][MPMain(1)]:   site      :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
2010-10-03 18:48:12.140625 [ERROR][MPMain(1)]:   source    :Gentle.Common
2010-10-03 18:48:12.140625 [ERROR][MPMain(1)]:   stacktrace:   at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
   at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
   at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
   at TvPlugin.ChannelNavigator.ReLoad()
2010-10-03 18:48:43.015625 [ERROR][MPMain(1)]: OnMessage exception:Error: DatabaseUnavailableUnclassified
Gentle.Common.GentleException: The database backend (provider SQLServer) could not be reached.
Check the connection string:  ---> System.InvalidOperationException: The ConnectionString property has not been initialized.
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
   --- End of inner exception stack trace ---
   at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
   at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
   at Gentle.Provider.SQLServer.SQL92Analyzer.Analyze(String tableName)
   at Gentle.Provider.SQLServer.SQLServerAnalyzer.Analyze(String tableName)
   at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
   at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
   at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
   at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
   at TvDatabase.RadioChannelGroup.ListAll()
   at TvPlugin.Radio.LoadDirectory(String strNewDirectory)
   at TvPlugin.Radio.OnPageLoad()
   at MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)System.InvalidOperationException: The ConnectionString property has not been initialized.
   at System.Data.SqlClient.SqlConnection.PermissionDemand()
   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Gentle.Provider.SQLServer.SQLServerProvider.GetConnection()
2010-10-03 18:48:45.781250 [ERROR][MPMain(1)]: OnMessage exception:System.NullReferenceException: Object reference not set to an instance of an object.
   at TvPlugin.Radio.SaveSettings()
   at TvPlugin.Radio.OnPageDestroy(Int32 newWindowId)
   at MediaPortal.GUI.Library.GUIWindow.OnMessage(GUIMessage message)

I'd like to know where i can reconfigure the SQL information for the radio plugin

 

[flixxx]

Can anyone help me with this please?

 

[flixxx]

So is this the right forum to post this? can anyone help me out?

As I mentioned in my previous post the SQL server is operational and running. During installation it succesfully passed the test. In fact, in the server configuration i can add/remove channels and i see the SQL database with the changes.

The radio plugin though can't connect to the sql server... i need to find a way to configure the plugin or to see where it's pointing.

 

[matejdro]

Did you found anything? I have the same error. On my desktop, just restarting mysql service helped. But on HTPC, error is still here.

 

[flixxx]

Nah no one has been helping.

You kinda of get used to it after a while and work with a half working product. In my 6 years using mediaportal not once has everything been working at the same time.

 

[matejdro]

Worst thing is that nobody is helping. There are a lot of open threads without any answers (some even opened by me). Are developers too busy with MP2?

Offtopic: is there any plugin that will allow me to use web radio standalone in MP since TV server solution is not working?

 

[flixxx]

From what i've been reading on the boards, developpers and coders have been jumping to XBMC.

 

[Deda]

I investigated your problem and result is that connection string to SQL server is missing in Gentle.config file (file is located in Mp settings folder). I don't know why connection string is not updated but you can repair it, as first aid, yourself.

Look for :

[COLOR=Red]  <DefaultProvider name="SQLServer" connectionString="Password=MediaPortal;Persist Security Info=True;User ID=sa;Initial Catalog=MpTvDb;Data Source=MyServer;Connection Timeout=300;" />[/COLOR]

  <!--
            <DefaultProvider name="Firebird" connectionString="User=SYSDBA;Password=masterkey;Data Source=TvLibrary.fdb;ServerType=1;Charset=UNICODE_FSS;" />
            <DefaultProvider name="Jet" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Code\Gentle.NET\Source\Gentle.Framework.Tests\Database Files\Gentle_MSAccess.mdb;OLE DB Services=-1;" />
            <DefaultProvider name="MySQL" connectionString="Server=10.0.0.2;Database=test;User ID=xxx;Password=xxx" />
            <DefaultProvider name="PostgreSQL" connectionString="Server=10.0.0.2;Database=Test;User ID=xxx;Password=xxx" />
            <DefaultProvider name="Oracle" connectionString="Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx" />
            <DefaultProvider name="OracleODP" connectionString="Data Source=kermit.symbiote.sporadicism.com,1521;User ID=gentle;password=xxx" />
            <DefaultProvider name="SQLite" connectionString="URI=file:c:/Code/Gentle.NET/Source/Gentle.Framework.Tests/Database Files/Gentle_SQLite.db" />
            <DefaultProvider name="SQLServer" connectionString="data source=127.0.0.1;initial catalog=Test;user id=xxx;password=xxx;packet size=4096" />
            -->

Pay attention for red block (I use MSSql server connection string), you can try all as it is except data source=MyServer, MyServer should be named to yours server name.

This is valid if MS SQL server is used. If you changed user and password they should be also named to yours.


Please, backup original file before you change something there.


Also, this string will be updated if in GUI - TV, use Guide (safer solution)

 

[Spragleknas]

From what i've been reading on the boards, developpers and coders have been jumping to XBMC.

Now where did you get that from?

I understand not getting the help you want is a PITA, but please stop disrespecting team members that invest an enormous amount of hours in this project that you all can use - for free.