Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • luke 2 posts 72 karma points
    Oct 26, 2022 @ 14:15
    luke
    0

    Error on load.

    Hi,

    I'm hoping someone here may be able to shed some light on this issue I'm having. Whenever I attempt to connect to my site the following error occurs:

    ```
    [SocketException (0x274c): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond]
       System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) +249
    
    [IOException: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.]
       System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) +8328249
       MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) +89
    
    [TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond]
       MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e) +189
       MySql.Data.Common.MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count) +174
       MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count) +153
       System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) +185
       MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) +56
       MySql.Data.MySqlClient.MySqlStream.LoadPacket() +86
       MySql.Data.MySqlClient.MySqlStream.ReadPacket() +40
       MySql.Data.MySqlClient.NativeDriver.GetColumnData(MySqlField field) +61
       MySql.Data.MySqlClient.NativeDriver.GetColumnsData(MySqlField[] columns) +45
       MySql.Data.MySqlClient.Driver.GetColumns(Int32 count) +264
       MySql.Data.MySqlClient.ResultSet.LoadColumns(Int32 numCols) +34
       MySql.Data.MySqlClient.ResultSet..ctor(Driver d, Int32 statementId, Int32 numCols) +64
       MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) +183
       MySql.Data.MySqlClient.MySqlDataReader.NextResult() +590
       MySql.Data.MySqlClient.MySqlDataReader.Close() +232
       MySql.Data.MySqlClient.MySqlCommand.ResetReader() +55
       MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) +2591
       MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn) +208
       umbraco.DataLayer.SqlHelpers.MySql.MySqlHelper.ExecuteReader(String commandText, MySqlParameter[] parameters) +82
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
       umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +148
       Umbraco.Core.CacheHelper.GetCacheItem(String cacheKey, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, Func`1 getCacheItem, Object syncLock) +191
       umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +312
       umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +126
       umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemRemovedCallback refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +112
       umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +88
       umbraco.cms.businesslogic.web.Domain.GetDomains() +173
       Umbraco.Web.Routing.PublishedContentRequestBuilder.LookupDomain() +255
       Umbraco.Web.Routing.PublishedContentRequest.ProcessRequest(HttpContextBase httpContext, UmbracoContext umbracoContext, Action`1 onSuccess) +70
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynch
    ```
    

    I should note that the site has recently been moved to a new server. However, I have ensured the same versions of software are running.

    Does anyone have any ideas? I cant really discern much from that output.

    Any ideas would be appreciated.

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Oct 26, 2022 @ 14:32
    Sebastiaan Janssen
    0

    From: [TimeoutException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond] I'd say your site cannot connect to the MySQL server you have configured in web.config (check the connection string).

  • luke 2 posts 72 karma points
    Oct 26, 2022 @ 15:08
    luke
    0

    I've double checked all the credentials and have made sure to use localhost for the connection. Still getting the same error unfortunately so I dont believe its an issue with the DB connection string itself. The user permissions are also all correct for the db user.

Please Sign in or register to post replies

Write your reply to:

Draft