+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / Sitefinity hangs on admin login (MySQL)

Sitefinity hangs on admin login (MySQL)

7 posts, 0 answered
  1. Giovanni Pulvirenti
    Giovanni Pulvirenti avatar
    11 posts
    Registered:
    24 Nov 2009
    31 Mar 2010
    Link to this post
    Hi,
    I'm evaluating Sitfinity 3.7 and today I've successfully installed it.
    After the installation process the navigation is redirected to the Admin Login page. After submitting my credentials, the page seems to work but nothing appears and instead an unhandled "Request time out" exception is thrown.

    I've looked into the log file and here I've checked a strange message about the MySQL .Net Connector (I think), just before the mentioned time out exception.

    this is the log file content:

    31/03/2010 16:35:31 [EXCEPTION]
    ************************************************************************************
    ID: 196641ab-bcdf-4c7a-a634-0a8573888fb4; Code: 100103; Occurrence: 7; Sequence: 44
    ------------------------------------------------------------------------------------

    Application information:
    Machine name: CELERON-PC
    OS Version: Microsoft Windows NT 6.1.7600.0
    Product Version: 3.7.2057.2
    Application Path: C:\Program Files\telerik\Sitefinity3.7\WebSites\HwaySitefinity\
    Debug: False

    Process information:
    Process ID: 6580
    Process Name: w3wp

    Request information:
    Request URL: /hwaysitefinity/sitefinity/admin/default.aspx
    Rewrite URL: http://localhost/hwaysitefinity/sitefinity/admin/default.aspx
    Url Referrer: http://localhost/hwaysitefinity/sitefinity/login.aspx?ReturnUrl=/hwaysitefinity/sitefinity/admin/default.aspx
    Is Authenticated: True
    Authentication Type: Forms
    User: admin
    User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/533.3 (KHTML, like Gecko) Chrome/5.0.360.0 Safari/533.3
    User Address: ::1

    Variables:
    AspSession: System.Web.SessionState.HttpSessionState
    RadControlRandomNumber: 0
    AspSessionIDManagerInitializeRequestCalled: True
    CmsHttpRequest: /hwaysitefinity/sitefinity/admin/default.aspx

    - L0 -------------------------------------------------------------------------------

    Exception Type: System.Threading.ThreadAbortException

    Message: Thread interrotto.

    Source: MySql.Data

    Stack Trace: 
       in MyNetworkStream.HandleOrRethrowException(Exception e)
       in MyNetworkStream.Read(Byte[] buffer, Int32 offset, Int32 count)
       in MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
       in System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
       in MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
       in MySql.Data.MySqlClient.MySqlStream.LoadPacket()
       in MySql.Data.MySqlClient.MySqlStream.ReadPacket()
       in MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
       in MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
       in MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
       in MySql.Data.MySqlClient.MySqlDataReader.NextResult()
       in MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
       in MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       in System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       in NNMySQLProvider.MySQLStmtBuilder.HasProcedure(ObjectName procedureName)
       in Nolics.ORMapper.DataProviders.SQLBlockBuilder.DefineCommandProcedure(OdbClassInfo dbclassInfo, SQLCrudOperations operation)
       in Nolics.ORMapper.DataProviders.SQLBlockBuilder.DefineClass(OdbClassInfo dbClassInfo, EmitPhases phase)
       in Nolics.ORMapper.DataProviders.SQLDataProvider.GetSchemaChanges(Boolean fRename)
       in Nolics.ORMapper.Base.OdbDataProvider.Upgrade()
       in Telerik.Polls.Data.NolicsPollsProvider.Initialize(String name, NameValueCollection config)
       in Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType)
       in Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings)
       in Telerik.ManagerBase`1.InstantiateProviders(ProviderSettingsCollection configProviders)
    ------------------------------------------------------------------------------------



    31/03/2010 16:35:31 [UNKNOWN]
    ************************************************************************************
    ID: 79433778-0b81-4eb1-93de-4e01d848972e; Code: 3001; Occurrence: 6; Sequence: 45
    ------------------------------------------------------------------------------------

    Application information:
    Machine name: CELERON-PC
    OS Version: Microsoft Windows NT 6.1.7600.0
    Product Version: 3.7.2057.2
    Application Path: C:\Program Files\telerik\Sitefinity3.7\WebSites\HwaySitefinity\
    Debug: False

    Process information:
    Process ID: 6580
    Process Name: w3wp

    Request information:
    Request URL: /hwaysitefinity/sitefinity/admin/default.aspx
    Rewrite URL: http://localhost/hwaysitefinity/sitefinity/admin/default.aspx
    Url Referrer: http://localhost/hwaysitefinity/sitefinity/login.aspx?ReturnUrl=/hwaysitefinity/sitefinity/admin/default.aspx
    Is Authenticated: True
    Authentication Type: Forms
    User: admin
    User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US) AppleWebKit/533.3 (KHTML, like Gecko) Chrome/5.0.360.0 Safari/533.3
    User Address: ::1

    Variables:
    RadControlRandomNumber: 0
    AspSessionIDManagerInitializeRequestCalled: True
    CmsHttpRequest: /hwaysitefinity/sitefinity/admin/default.aspx

    - L0 -------------------------------------------------------------------------------

    Exception Type: System.Web.HttpException

    Message: Timeout della richiesta.

    Source: 

    Stack Trace: 

    ------------------------------------------------------------------------------------




    Thanks in advance.
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    31 Mar 2010
    Link to this post
    Hello Giovanni Pulvirenti,

    Thank you for using our services.

    When you run a website for the first time and access its administration are the system is creating all dababase objects needed for the data layer. MySQL takes a little bit longer to create database objects, and considering that about 96 tables and even more stored procedures are written to the database the request might timeout. In order to prevent this we can suggest that you either configure your IIS for longer time out, or run the website through the Visual Studio WebDevelopment Server, which generally would not time out.

    Regards,
    Radoslav Georgiev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. Giovanni Pulvirenti
    Giovanni Pulvirenti avatar
    11 posts
    Registered:
    24 Nov 2009
    31 Mar 2010
    Link to this post
    Thank you Radoslav for your answer.

    I think I need some further explanations.
    The problem arises also when I build the start up database configuration. I've already set this tag in ProjectManager web.config:
    <httpRuntime executionTimeout="960"/>
    Do you think should be sufficient?

    Now I've started again from scratch, building again a new project.
    Again, while Sitefinity is building the db objects (before the admin login page), the timeout occurs and only after two or more page refresh I'm able to get the login form.
    I think that until I'll not be able to reach the admin login form, I can't run the web site inside Visual Studio, isn't it?

    Can you point me to the right direction, please?

    Thank you very much.
  4. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    01 Apr 2010
    Link to this post
    Hello Giovanni Pulvirenti,

    You can open a Sitefinity website in Visual Studio. When you create a website in Project Manager on the final step instead of clicking the Go to Administer Project button you can open Visual Studio and go to File -> Open Website. Then you can navigate to the folder your website was created in. By default it would be C:\Program Files\Telerik\Sitefinity3.7\WebSites and select the website you want to open in VS. Then when the website is opened in VS right click the Sitefinity folder and select View in Browser. This will load your website's administration area through the Visual Studio WebDevelopmentServer.

    Best wishes,
    Radoslav Georgiev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  5. Giovanni Pulvirenti
    Giovanni Pulvirenti avatar
    11 posts
    Registered:
    24 Nov 2009
    01 Apr 2010
    Link to this post
    Hi Radoslav,
    I've followed the road map that you suggested in the last post but I wasn't lucky, I think..
    This was the procedure I've applied:
    1. created MySQL database schema using MySQL Workbench (I can connect to this schema using 'root' privileges);
    2. launched ProjectManager in IE8 running as Administrator;
    3. created site with Emerald Template with success;
    4 closed IE8 without accessing the Administrative Panel;
    5 opened the new created web site in Visual Studio;
    6 right click on "Sitefinity" folder and click on "Open Web Site";
    7 the Project Startup appears (Step 1);
    8 now I set the correct parameters to connect to the MySQL schema;
    9 when I click on "continue" an unhandled exception is thrown as you can see in the attached jpg file (I think that you can not understand italian, so I translate the main concept: "System.InvalidOperationException: Cannot map the path '/'.")

    I've found this Microsoft Article (here) and I think there is a problem about the privileges of the running user.
    I am administrator in my Win7 (of course) and I am domain administrator also; by the way, I don't know which user account is used by the process inside Visual Studio app server (Cassini) . How can I fix this?

    Hope you can help me :-)
  6. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    01 Apr 2010
    Link to this post
    Hello Giovanni Pulvirenti,

    Thank you for getting back to me.

    The Casini web server runs under the ASP.NET worker process account. Try assigning the account sufficient privileges as proposed in the linked KB article.

    Regards,
    Radoslav Georgiev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  7. Giovanni Pulvirenti
    Giovanni Pulvirenti avatar
    11 posts
    Registered:
    24 Nov 2009
    01 Apr 2010
    Link to this post
    Yeah, thank you Radoslav... I've got the solution following the instructions of that MS article.
    Now the process seems like is going very well and I am able to get into the administrative panel.
    My next step will be to study how to integrate our code into Sitefinity.

    Thank you again for your precious help.
Register for webinar
7 posts, 0 answered