Can't connect to database (1 Viewer)

vecnar

Portal Pro
April 21, 2008
129
10
Home Country
Ireland Ireland
Hi All,
I am having problem connecting to database too. I use mysql 5.0.51. I disabled firewalls on both computers so they can ping each other. Added a user Grant all priveleges on *.* to 'root'@'%' identified by 'somePassword'; but still no luck. Any ideas?:confused:
 

sixgun

MP Donator
  • Premium Supporter
  • March 31, 2008
    80
    12
    Home Country
    United Kingdom United Kingdom
    I am also having this problem with MySQL.

    I have looked in the log files on my client and it seems to be getting the database connect string from the servers gentle.config file. So, I changed the file, but everytime I load up the config app it gets changed again!

    When I set up my server I left the server name blank, as I've done in previous installs. I found that if I put anything in there the connection test failed. So, the database server hostname is obviously stored somewhere else and the gentle.config file is being generated. If I could change that value I think the problem would be solved.

    Where in the registry/file system is that value held?

    Regards.
     

    rtv

    Retired Team Member
  • Premium Supporter
  • April 7, 2005
    3,622
    301
    Osnabruck
    Home Country
    Germany Germany
    Just enter the correct details until "Test" is successful...
     

    sixgun

    MP Donator
  • Premium Supporter
  • March 31, 2008
    80
    12
    Home Country
    United Kingdom United Kingdom
    When i enter the correct server name in the media portal client, i get

    Connected to TvServer
    Cannot connect to database.

    and in the logs it says to check the connect string, which doesn't have the hostname for the database server, which is exactly how i set it up on the server!

    So, will repeatedly entering the same hostname (which I know is correct) eventually work?

    Thanks.
     

    vecnar

    Portal Pro
    April 21, 2008
    129
    10
    Home Country
    Ireland Ireland
    I sorted my problem by granting access to all databases from any ip to the user on mysql server (grant all on *.* to 'root'@'%' identified by 'password'). Also for testing i disabled firewalls on both computers.

    On Client side i uninstalled and reinstalled media portal client. I am not sure where login details are stored as well. Every time i change gentle.config file everything changes back to previous settings after i run configuration app.

    Hope it helps.
     

    sixgun

    MP Donator
  • Premium Supporter
  • March 31, 2008
    80
    12
    Home Country
    United Kingdom United Kingdom
    I've tried changing privileges on the database but to no avail.

    I know the hostname is correct as I can access it via ping and windows explorer. I'm convinced it's the connect string being used by the client to connect to the database.

    I've attached my log files, if you look in the MediaPortal.log file @ 2008-05-07 14:12:47.739000 you'll see the error. It also happens in a few other places in the log file.

    When I type in my hostname for the TV Server from within MediaPortal, it comes up with

    Connected to TvServer
    Cannot connected to database

    So, the hostname is resolving, but the database cannot connect because of the blank hostname i entered. Is it possible to change this without re-installing the server? If not then I will just reinstall the server again and put the correct hostname in during the setup. But, I'm sure that it wouldn't pass the connection test when I did that last time I installed. But, that was with 0.2.3.0, so maybe something has changed in the installer.

    Many Thanks.

    MediaPortal.log
    2008-05-07 14:12:43.759000 [Info.][MPMain]: Main: Starting MPTestTool as exception watchdog
    2008-05-07 14:12:43.802000 [Info.][MPMain]: Main: MediaPortal is starting up
    2008-05-07 14:12:43.803000 [Info.][MPMain]: Main: Using Directories:
    2008-05-07 14:12:43.803000 [Info.][MPMain]: Base - C:\Program Files (x86)\Team MediaPortal\MediaPortal
    2008-05-07 14:12:43.804000 [Info.][MPMain]: Log - C:\ProgramData\Team MediaPortal\MediaPortal\Log
    2008-05-07 14:12:43.805000 [Info.][MPMain]: Skin - C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin
    2008-05-07 14:12:43.805000 [Info.][MPMain]: Language - C:\Program Files (x86)\Team MediaPortal\MediaPortal\Language
    2008-05-07 14:12:43.805000 [Info.][MPMain]: Database - C:\ProgramData\Team MediaPortal\MediaPortal\Database
    2008-05-07 14:12:43.806000 [Info.][MPMain]: Plugins - C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins
    2008-05-07 14:12:43.806000 [Info.][MPMain]: Thumbs - C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs
    2008-05-07 14:12:43.806000 [Info.][MPMain]: Cache - C:\ProgramData\Team MediaPortal\MediaPortal\Cache
    2008-05-07 14:12:43.806000 [Info.][MPMain]: Weather - C:\Program Files (x86)\Team MediaPortal\MediaPortal\Weather
    2008-05-07 14:12:43.807000 [Info.][MPMain]: CustomInputDevice - C:\ProgramData\Team MediaPortal\MediaPortal\InputDeviceMappings
    2008-05-07 14:12:43.807000 [Info.][MPMain]: Config - C:\ProgramData\Team MediaPortal\MediaPortal
    2008-05-07 14:12:43.807000 [Info.][MPMain]: CustomInputDefault - C:\Program Files (x86)\Team MediaPortal\MediaPortal\InputDeviceMappings\defaults
    2008-05-07 14:12:43.807000 [Info.][MPMain]: BurnerSupport - C:\Program Files (x86)\Team MediaPortal\MediaPortal\Burner
    2008-05-07 14:12:43.807000 [Info.][MPMain]: Main: Assembly creation time: 18/04/2008 16:15:24 (UTC)
    2008-05-07 14:12:43.810000 [Info.][MPMain]: Main: Set current directory to: C:\Program Files (x86)\Team MediaPortal\MediaPortal
    2008-05-07 14:12:43.836000 [Info.][MPMain]: Main: Verifying DirectX 9
    2008-05-07 14:12:43.836000 [Info.][MPMain]: Main: Verifying Windows Media Player
    2008-05-07 14:12:43.837000 [Info.][MPMain]: Main: Windows Media Player version 11,0,6000,6344 installed
    2008-05-07 14:12:43.899000 [Info.][MPMain]: Main: Checking for running MediaPortal instance
    2008-05-07 14:12:43.899000 [Info.][MPMain]: Main: Deleting old log\capture.log
    2008-05-07 14:12:43.904000 [Info.][MPMain]: Main: Checking skin version
    2008-05-07 14:12:43.913000 [Info.][3]: Version: Application 1.0.0.0 RC1
    2008-05-07 14:12:44.158000 [Info.][MPMain]: Load key mapping from C:\ProgramData\Team MediaPortal\MediaPortal\keymap.xml
    2008-05-07 14:12:44.165000 [Info.][MPMain]: Main: Init playlist player
    2008-05-07 14:12:44.167000 [Info.][MPMain]: Main: Init players
    2008-05-07 14:12:44.189000 [Info.][MPMain]: Thumbs: MediaPortal is using average thumbnails
    2008-05-07 14:12:44.195000 [Info.][MPMain]: Main: Initializing DirectX
    2008-05-07 14:12:44.305000 [Info.][MPMain]: D3D: Starting fullscreen
    2008-05-07 14:12:44.307000 [Info.][MPMain]: D3D: Client size: 1920x1080 - Screen: 1920x1080
    2008-05-07 14:12:44.926000 [Info.][MPMain]: TextureManager: Dispose()
    2008-05-07 14:12:44.929000 [Info.][MPMain]: TexturePacker:Dispose()
    2008-05-07 14:12:44.929000 [Info.][MPMain]: Load key mapping from C:\ProgramData\Team MediaPortal\MediaPortal\keymap.xml
    2008-05-07 14:12:44.976000 [Info.][MPMain]: Loading localised Strings - Path: C:\Program Files (x86)\Team MediaPortal\MediaPortal\Language Culture: en Language: English Prefix: False
    2008-05-07 14:12:44.986000 [Info.][MPMain]: Loading strings file: strings_en.xml
    2008-05-07 14:12:45.196000 [Info.][MPMain]: fonts.Dispose()
    2008-05-07 14:12:45.198000 [Info.][MPMain]: Load fonts from C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\fonts.xml
    2008-05-07 14:12:45.212000 [Info.][MPMain]: fonts.InitializeDeviceObjects()
    2008-05-07 14:12:45.359000 [Info.][MPMain]: Main: Loading BlueTwo wide skin
    2008-05-07 14:12:45.361000 [Info.][MPMain]: LoadWindowPlugins()
    2008-05-07 14:12:45.366000 [Info.][MPMain]: Load plugins from : C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins\windows\WindowPlugins.dll
    2008-05-07 14:12:45.371000 [Info.][MPMain]: Assembly Version : 0.9.1.31056
    2008-05-07 14:12:45.474000 [Info.][MPMain]: opening tvdatabase
    2008-05-07 14:12:45.476000 [Info.][MPMain]: using sqlite 3.5.6
    2008-05-07 14:12:45.494000 [Info.][MPMain]: tvdatabase opened
    2008-05-07 14:12:45.511000 [Info.][MPMain]: GUITVCropManager: Started
    2008-05-07 14:12:45.612000 [Info.][MPMain]: Loading references from C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\references.xml
    2008-05-07 14:12:45.615000 [Info.][MPMain]: original skin size:1366x768
    2008-05-07 14:12:45.736000 [Info.][MPMain]: MusicDatabase: Opening database
    2008-05-07 14:12:45.737000 [Info.][MPMain]: MusicDatabase: Database opened
    2008-05-07 14:12:45.903000 [Info.][MPMain]: xml:C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\tvOSD.xml image id:350 width:0 height:0 gfx:-
    2008-05-07 14:12:45.999000 [Info.][MPMain]: xml:C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\videoOSD.xml image id:350 width:0 height:0 gfx:-
    2008-05-07 14:12:46.094000 [Info.][MPMain]: TvGuide StartImportXML: Initialize
    2008-05-07 14:12:46.112000 [Info.][MPMain]: Load plugins from : C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins\windows\Dialogs.dll
    2008-05-07 14:12:46.114000 [Info.][MPMain]: Assembly Version : 0.9.1.31039
    2008-05-07 14:12:46.145000 [Info.][MPMain]: Load plugins from : C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins\windows\TvPlugin.dll
    2008-05-07 14:12:46.149000 [Info.][MPMain]: Assembly Version : 0.9.1.31220
    2008-05-07 14:12:46.216000 [Info.][MPMain]: newsearch ctor
    2008-05-07 14:12:46.217000 [Info.][MPMain]: newsearch ctor
    2008-05-07 14:12:46.217000 [Info.][MPMain]: newsearch init
    2008-05-07 14:12:46.218000 [Info.][MPMain]: newsearch init result:True
    2008-05-07 14:12:46.234000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: ChannelNavigator::ctor()
    2008-05-07 14:12:46.254000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: Remote control:master server :chewie
    2008-05-07 14:12:46.414000 [Info.][MPMain]: TexturePacker: Loaded C:\ProgramData\Team MediaPortal\MediaPortal\Cache\BlueTwo wide\packedgfx20.png texture:2048x2048 miplevels:1
    2008-05-07 14:12:46.415000 [Info.][MPMain]: TexturePacker: fontengine add texure:1999
    2008-05-07 14:12:46.465000 [Info.][MPMain]: xml:C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\tvOSD.xml image id:350 width:0 height:0 gfx:-
    2008-05-07 14:12:46.476000 [Info.][MPMain]: StartImportXML: Initialize
    2008-05-07 14:12:46.477000 [Info.][MPMain]: RadioGuide:OnAdded
    2008-05-07 14:12:46.582000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: ChannelNavigator::Reload()
    2008-05-07 14:12:46.640000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: get channels from database
    2008-05-07 14:12:47.739000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: Exception :Error: DatabaseUnavailableUnclassified
    Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
    Check the connection string: Server=;Database=TvLibrary;User ID=antony;Password=******;charset=utf8;Connection Timeout=300; ---> System.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
    at System.Net.Sockets.Socket.Shutdown(SocketShutdown how)
    at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count)
    at System.IO.BufferedStream.ReadByte()
    at MySql.Data.MySqlClient.PacketReader.ReadHeader()
    at MySql.Data.MySqlClient.PacketReader.OpenPacket()
    at MySql.Data.MySqlClient.NativeDriver.Open()
    at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetConnection()
    at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
    at MySql.Data.MySqlClient.MySqlConnection.Open()
    at Gentle.Provider.MySQL.MySQLProvider.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.MySQL.MySQLAnalyzer.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.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
    at System.Net.Sockets.Socket.Shutdown(SocketShutdown how)
    at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count)
    at System.IO.BufferedStream.ReadByte()
    at MySql.Data.MySqlClient.PacketReader.ReadHeader()
    at MySql.Data.MySqlClient.PacketReader.OpenPacket()
    at MySql.Data.MySqlClient.NativeDriver.Open()
    at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetConnection()
    at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
    at MySql.Data.MySqlClient.MySqlConnection.Open()
    at Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    2008-05-07 14:12:47.749000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: Exception :The database backend (provider MySQL) could not be reached.
    Check the connection string: Server=;Database=TvLibrary;User ID=antony;Password=******;charset=utf8;Connection Timeout=300;
    2008-05-07 14:12:47.749000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
    2008-05-07 14:12:47.750000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: source :Gentle.Common
    2008-05-07 14:12:47.751000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: 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.MySQL.MySQLAnalyzer.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()
    2008-05-07 14:12:47.756000 [Info.][TvClient-Radio: HeartBeat transmitter thread]: ChannelNavigator::LoadSettings()
    2008-05-07 14:12:47.760000 [Info.][MPMain]: TvCropManager: Started
    2008-05-07 14:12:47.761000 [Info.][MPMain]: TVHome V0.9.1.18808:ctor
    2008-05-07 14:12:47.764000 [Info.][MPMain]: TVHome:Init
    2008-05-07 14:12:47.826000 [Info.][MPMain]: TVHome:OnAdded
    2008-05-07 14:12:47.833000 [Info.][MPMain]: TvRecorded:OnAdded
    2008-05-07 14:12:47.838000 [Info.][MPMain]: xml:C:\Program Files (x86)\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\mytvguide.xml image id:0 width:0 height:0 gfx:-
    2008-05-07 14:12:47.856000 [Info.][MPMain]: Load plugins from : C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins\windows\XihSolutions.DotMSN.dll
    2008-05-07 14:12:47.858000 [Info.][MPMain]: Assembly Version : 2.0.1.15051
    2008-05-07 14:12:47.869000 [Info.][MPMain]: Main: Loading windowmanager
    2008-05-07 14:12:47.870000 [Info.][MPMain]: Main: Resizing windowmanager
    2008-05-07 14:12:47.873000 [Warn.][MPMain]: GraphicContext: NO screen calibration file found for resolution 1920x1080!
    2008-05-07 14:12:47.874000 [Info.][MPMain]: GraphicContext: MP will render at 25 FPS, use animations = True
    2008-05-07 14:12:47.881000 [Info.][MPMain]: Main: Initializing windowmanager
    2008-05-07 14:12:48.047000 [Info.][MPMain]: TexturePacker: Loaded C:\ProgramData\Team MediaPortal\MediaPortal\Cache\BlueTwo wide\packedgfx21.png texture:2048x2048 miplevels:1
    2008-05-07 14:12:48.048000 [Info.][MPMain]: TexturePacker: fontengine add texure:1998
    2008-05-07 14:12:48.064000 [Info.][MPMain]: Main: Activating windowmanager
    2008-05-07 14:12:48.126000 [Info.][MPMain]: Main: Initialized skin
    2008-05-07 14:12:48.126000 [Info.][MPMain]: Main: DX9 size: 1920x1080
    2008-05-07 14:12:48.127000 [Info.][MPMain]: Main: Video RAM left: 2062336 KByte
    2008-05-07 14:12:48.149000 [Info.][8]: Commandprocessor: Starting
    2008-05-07 14:12:48.149000 [Info.][MPMain]: Recorder: start
    2008-05-07 14:12:48.344000 [Info.][MPMain]: TexturePacker: Loaded C:\ProgramData\Team MediaPortal\MediaPortal\Cache\BlueTwo wide\packedgfx22.png texture:2048x2048 miplevels:1
    2008-05-07 14:12:48.345000 [Info.][MPMain]: TexturePacker: fontengine add texure:1996
    2008-05-07 14:12:48.420000 [Info.][MPMain]: MAP: using default mappings for DirectInput
    2008-05-07 14:12:48.566000 [Info.][MPMain]: MAP: using default mappings for Microsoft MCE
    2008-05-07 14:12:48.568000 [Info.][MPMain]: MCE: MCE remote enabled
    2008-05-07 14:12:48.574000 [Info.][MPMain]: Main: Running
    2008-05-07 14:12:48.579000 [Info.][MPMain]: Main: Starting up
    2008-05-07 14:12:48.580000 [Info.][MPMain]: PlugInManager.Load()
    2008-05-07 14:12:48.584000 [Info.][MPMain]: Load plugins from : C:\Program Files (x86)\Team MediaPortal\MediaPortal\Plugins\process\ProcessPlugins.dll
    2008-05-07 14:12:48.587000 [Info.][MPMain]: Assembly Version : 0.9.1.31046
    2008-05-07 14:12:48.637000 [Info.][MPMain]: WebEPGGrabber: schedule: 0:0
    2008-05-07 14:12:48.638000 [Info.][MPMain]: WebEPGGrabber: run on: monday:True, tuesday:True, wednesday:True, thursday:True, friday:True, saturday:True, sunday:True
    2008-05-07 14:12:48.639000 [Info.][MPMain]: PlugInManager.Start()
    2008-05-07 14:12:48.656000 [Info.][10]: BASS: Initialize BASS environment ...
    2008-05-07 14:12:49.372000 [Info.][MPMain]: Visualization Window: Loading skin settings...
    2008-05-07 14:12:49.375000 [Info.][MPMain]: BASS: Creating visualization...
    2008-05-07 14:12:49.378000 [Info.][MPMain]: Visualization Manager: Closing current visualization plugin...
    2008-05-07 14:12:49.379000 [Info.][MPMain]: Visualization Manager: Visualization plugin close not required - nothing loaded
    2008-05-07 14:12:49.381000 [Info.][10]: BASS: Loading audio decoder add-ins...
    2008-05-07 14:12:49.410000 [Info.][10]: BASS: Loaded 9 Audio Decoders.
    2008-05-07 14:12:49.603000 [Info.][10]: BASS: Initializing BASS environment done.
    2008-05-07 14:12:52.898000 [Info.][MPMain]: TexturePacker: Loaded C:\ProgramData\Team MediaPortal\MediaPortal\Cache\BlueTwo wide\packedgfx23.png texture:2048x2048 miplevels:1
    2008-05-07 14:12:52.900000 [Info.][MPMain]: TexturePacker: fontengine add texure:1995
    2008-05-07 14:13:07.304000 [Info.][MPMain]: No translation found for id 101002
    2008-05-07 14:13:08.606000 [Info.][MPMain]: ChannelNavigator::Reload()
    2008-05-07 14:13:08.606000 [Info.][MPMain]: get channels from database
    2008-05-07 14:13:09.615000 [Info.][MPMain]: Exception :Error: DatabaseUnavailableUnclassified
    Gentle.Common.GentleException: The database backend (provider MySQL) could not be reached.
    Check the connection string: Server=;Database=TvLibrary;User ID=antony;Password=******;charset=utf8;Connection Timeout=300; ---> System.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
    at System.Net.Sockets.Socket.Shutdown(SocketShutdown how)
    at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count)
    at System.IO.BufferedStream.ReadByte()
    at MySql.Data.MySqlClient.PacketReader.ReadHeader()
    at MySql.Data.MySqlClient.PacketReader.OpenPacket()
    at MySql.Data.MySqlClient.NativeDriver.Open()
    at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetConnection()
    at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
    at MySql.Data.MySqlClient.MySqlConnection.Open()
    at Gentle.Provider.MySQL.MySQLProvider.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.MySQL.MySQLAnalyzer.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.Net.Sockets.SocketException: A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied
    at System.Net.Sockets.Socket.Shutdown(SocketShutdown how)
    at MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count)
    at System.IO.BufferedStream.ReadByte()
    at MySql.Data.MySqlClient.PacketReader.ReadHeader()
    at MySql.Data.MySqlClient.PacketReader.OpenPacket()
    at MySql.Data.MySqlClient.NativeDriver.Open()
    at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
    at MySql.Data.MySqlClient.MySqlPool.GetConnection()
    at MySql.Data.MySqlClient.MySqlPoolManager.GetConnection(MySqlConnectionString settings)
    at MySql.Data.MySqlClient.MySqlConnection.Open()
    at Gentle.Provider.MySQL.MySQLProvider.GetConnection()
    2008-05-07 14:13:09.616000 [Info.][MPMain]: Exception :The database backend (provider MySQL) could not be reached.
    Check the connection string: Server=;Database=TvLibrary;User ID=antony;Password=******;charset=utf8;Connection Timeout=300;
    2008-05-07 14:13:09.616000 [Info.][MPMain]: site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
    2008-05-07 14:13:09.616000 [Info.][MPMain]: source :Gentle.Common
    2008-05-07 14:13:09.617000 [Info.][MPMain]: 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.MySQL.MySQLAnalyzer.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()
    2008-05-07 14:13:17.849000 [Info.][MPMain]: Main: Exit requested
    2008-05-07 14:13:17.888000 [Info.][MPMain]: Main: Stopping FrameMove
    2008-05-07 14:13:17.903000 [Info.][MPMain]: TexturePacker: disposing texture:1999
    2008-05-07 14:13:17.907000 [Info.][MPMain]: TexturePacker: disposing texture:1998
    2008-05-07 14:13:17.910000 [Info.][MPMain]: TexturePacker: disposing texture:1996
    2008-05-07 14:13:17.912000 [Info.][MPMain]: TexturePacker: disposing texture:1995
    2008-05-07 14:13:18.093000 [Info.][MPMain]: Main: Exiting
    2008-05-07 14:13:18.094000 [Info.][MPMain]: Recorder: stop
    2008-05-07 14:13:18.178000 [Info.][8]: Commandprocessor: Stopping all tuners
    2008-05-07 14:13:18.178000 [Info.][8]: Commandprocessor: Stopped
    2008-05-07 14:13:18.197000 [Info.][MPMain]: PlugInManager.Stop()
    2008-05-07 14:13:18.198000 [Info.][MPMain]: fonts.Dispose()
    2008-05-07 14:13:18.198000 [Info.][MPMain]: TextureManager: Dispose()
    2008-05-07 14:13:18.199000 [Info.][MPMain]: TexturePacker:Dispose()
    2008-05-07 14:13:18.240000 [Info.][MPMain]: Main: MediaPortal done
    2008-05-07 14:13:18.251000 [Info.][2]: TvCropManager: Stopped
    2008-05-07 14:13:18.253000 [Info.][2]: GUITVCropManager: Stopped
    2008-05-07 14:13:18.255000 [Info.][2]: SQLiteClient: Closing database: TVDatabaseV21.db3
    2008-05-07 14:13:18.256000 [Info.][2]: SQLiteClient: Closing database: MusicDatabaseV10.db3
     

    rtv

    Retired Team Member
  • Premium Supporter
  • April 7, 2005
    3,622
    301
    Osnabruck
    Home Country
    Germany Germany
    Install latest SVN and start SetupTv with paramter /c
    This will rewrite a correct gentle.config with correct hostname..
     

    sixgun

    MP Donator
  • Premium Supporter
  • March 31, 2008
    80
    12
    Home Country
    United Kingdom United Kingdom
    Sorry If I'm being a bit dim here, but do you mean install the latest SVN on the server or client, or both?

    Would I be right in saying that I can just run the installer without having to uninstall first?

    Thanks.
     

    sixgun

    MP Donator
  • Premium Supporter
  • March 31, 2008
    80
    12
    Home Country
    United Kingdom United Kingdom
    I tried installing the latest SVN snapshot but the TvService just kept crashing.

    So, I decided to try using SQL Express. After installing that and re-installing the RC1 version of TvServer it's all working fine.

    Thanks for all the help/suggestions.
     

    Users who are viewing this thread

    Top Bottom