Copied to clipboard

Flag this post as spam?

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


  • Newbraco 41 posts 163 karma points
    Apr 11, 2018 @ 14:48
    Newbraco
    0

    Backoffice login gives blank page or "session timed out"-error

    I have a very basic Umbraco page at localhost. Now I cant get into my backoffice :/. I only get either a blank page instead of backoffice or just the error message below "Session timed out" when I try to login.

    enter image description here

    When looking in App_Data\Logs[computername].txt I see something that indicated troublewith the database (see below). I have no trouble connecting to the DB with sql server management studio

    2018-04-11 16:30:35,774 [P8876/D2/T1] ERROR Umbraco.Core.CoreBootManager - An error occurred running OnApplicationStarted for handler Umbraco.Web.BatchedDatabaseServerMessengerStartup
    System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
       at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
       at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at  
     .
     .
     .
    Error Number:-2,State:0,Class:11
    
  • Jan Skovgaard 10938 posts 21806 karma points MVP 4x admin c-trib
    Apr 13, 2018 @ 03:52
    Jan Skovgaard
    0

    Hi there

    are you by any chance running Umbraco 7.10.0? If so the issue you're seeing is probably caused by this bug http://issues.umbraco.org/issue/U4-11164 - The fix is to upgrade to the latest release of Umbraco in this case,

    Hope this helps :)

    /Jan

  • Newbraco 41 posts 163 karma points
    Apr 16, 2018 @ 15:06
    Newbraco
    0

    Hi Had 7.92, updated to latest. The only difference it made was that the error message does not show up anymore. I still cant log in though ;/

  • Newbraco 41 posts 163 karma points
    Apr 16, 2018 @ 15:22
    Newbraco
    0

    ...I must emphasize that i works on my azure site, that uses the same (Umbraco) database

  • Dave Woestenborghs 2798 posts 8563 karma points MVP 3x admin c-trib
    Apr 16, 2018 @ 15:44
    Dave Woestenborghs
    0

    Maybe that is the issue ? Maybe the Azure db does not allow you to connect to it from outside Azure.

    Also I would strongly disadvice to connect to a live database from a development machine. For several reasons :

    • Because two websites are connecting to the same database Umbraco will start acting as loadbalanced environment
    • Any changes you make in the Umbraco backend are immediatly effective on your live site, potentially breaking your website

    Dave

  • Newbraco 41 posts 163 karma points
    Apr 18, 2018 @ 13:26
    Newbraco
    0

    That is correct, you have to register your (calling) IP in the firewall settings on Azure, but that is done and I can connect to it with SQL Mgmt Studio. I have had it working without any fuzz before, so I suspected that I have gotten a new IP, but this is not the case

    I noticed now (after the upgrade probably) that the page Im beeing redirected to is:

    http://localhost:53454/umbraco/AuthorizeUpgrade?redir=%2finstall%2f%3fredir%3dtrue%26url%3d

    Moreover, now I cant get into my "public" pages either ;o(

    As for the sharing of the DB between both sites. I use them both as my dev sites, so no prod env is involved.

  • Newbraco 41 posts 163 karma points
    Apr 19, 2018 @ 13:00
    Newbraco
    0

    This problem occurs in FF but not in Chrome.

    o problem solved, for me at least

Please Sign in or register to post replies

Write your reply to:

Draft