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

Forums / Sitefinity SDK / Remote database hanging on connect

Remote database hanging on connect

9 posts, 0 answered
  1. Caedmon
    Caedmon avatar
    10 posts
    Registered:
    02 Feb 2011
    07 Mar 2011
    Link to this post
    I'm working with a client to develop a Sitefinity 4.0 site.  I am creating some user controls and custom functionality.  I am currently using a 30-day trial of 4.0.  The genenator tag is rending as: Sitefinity 4.0.1098.0 SE

    Sitefinity works great when I connect to a local database.  But, when I give the site a remote IP and start the site on localhost, it hangs.  It does not timeout on the database connection, just a blank browser screen while the browser waits for a response.  This goes on for a long time and does not timeout.

    Any ideas?  Is this a security feature since it is a Trial copy?

    Thanks!
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    08 Mar 2011
    Link to this post
    Hello Caedmon,

    There should not be such a issue if you use remote SQL sever. Can you check from where the delay comes from? You can use fiddler or Http Watch. These tools can give you more information about the request and response. Also, make sure that the remote SQL server is up end running and it allows remote connections. If the browser hangs, most probably there is some issue with the connection. I was able to replicate similar issue if stop my local instance of the SQL where I have a project working with this instance.

    All the best,
    Ivan Dimitrov
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  3. Caedmon
    Caedmon avatar
    10 posts
    Registered:
    02 Feb 2011
    08 Mar 2011
    Link to this post
    It seems that it was an extremely lagged connection.  Strange that it wasn't timing out faster.  Later in the day it began working correctly.

    Thanks much for all of your help.  I have not interacted with a vendor that was so quick to respond to their customers on a forum.  

    Thanks again!
  4. John
    John avatar
    22 posts
    Registered:
    14 Jan 2011
    08 Aug 2011
    Link to this post
    Hello,

    I'm dealing with the "same" issue. Sometimes, after some work on the back-end and with some others users working at the same time, the browser keep waiting a response and it doesn't come back....

    The DB is serving requests, so the DB is not the problem. 

    I checked the logs and I found this:

    ----------------------------------------
    Timestamp: 8/8/2011 12:09:28 PM


    Message: HandlingInstanceID: 4143117c-0580-43a9-8228-bcd471187a72
    An exception of type 'System.ArgumentException' occurred and was caught.
    ------------------------------------------------------------------------
    08/08/2011 08:09:28
    Type : System.ArgumentException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
    Message : Invalid type specified Telerik.Sitefinity.Security.Data.SecurityDataProvider
    Source : Telerik.Sitefinity
    Help link : 
    ParamName : 
    Data : System.Collections.ListDictionaryInternal
    TargetSite : TProviderBase InstantiateProvider(Telerik.Sitefinity.Configuration.IDataProviderSettings, System.Type, Telerik.Sitefinity.Abstractions.ExceptionPolicyName, Telerik.Sitefinity.Data.ManagerBase`1[TProviderBase])
    Stack Trace :    at Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager)


    Additional Info:


    MachineName : machinename
    TimeStamp : 8/8/2011 12:09:28 PM
    FullName : Telerik.Sitefinity.Utilities, Version=4.1.1395.0, Culture=neutral, PublicKeyToken=b28c218413bdf563
    AppDomainName : /LM/W3SVC/1696818070/Root-1-129572789213592707
    ThreadIdentity : username
    WindowsIdentity : AUTORITE NT\SERVICE RÉSEAU
    Requested URL : /Sitefinity




    Category: ErrorLog


    Priority: 0


    EventId: 9010


    Severity: Warning


    Title:Enterprise Library Exception Handling


    Machine: machinename



    App Domain: /LM/W3SVC/1696818070/Root-1-129572789213592707


    ProcessId: 26348


    Process Name: c:\windows\system32\inetsrv\w3wp.exe


    Thread Name: 


    Win32 ThreadId:20944


    Extended Properties: 
    ----------------------------------------
    ----------------------------------------

    What can I do ?

    Thanks,

    John
  5. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    09 Aug 2011
    Link to this post
    Hi John,

    The stack shows that the error occurs when the configuration files are loaded. Most probably you went to Administration >> Settings >> Advanced and the data provider settings could not be initialized properly because somewhere you have used a type which is not proper. For example you set Telerik.Sitefinity.Security.Data.SecurityDataProvider as a RoleProvider or MembershipProvider type. The error doesn't show which config file has been modified, but you can check App_Data/Sitefinity/Configurations and check all configs. We generate only the configuration files that are changed, so you can easily track your modifications.

    Telerik.Sitefinity.Security.Data.SecurityDataProvider is not a valid type but this is the correct type, so the only reason for this error is changes in the configurations.

    Best wishes,
    Ivan Dimitrov
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

  6. John
    John avatar
    22 posts
    Registered:
    14 Jan 2011
    09 Aug 2011
    Link to this post
    Thanks Ivan,

    After some tests I think I have two problems that are not related at all. 

    1. The website is hanging randomly (not often but this is a serious problem). I cannot replicate the issue yet. What can this be ?

    2. The error appearing in the log (previous post) is coming every time a user log in at the back-end. None of the config files are being updated when this happens, but the site continues to work.

    I'm sending you the DataConfig.config. Could you tell me if everything is ok in it ? If so, what else could I check ?

    <?xml version="1.0" encoding="utf-8"?>
    <dataConfig initialized="True">
    <connectionStrings>
    <add connectionString="data source=SQL_SERVER;initial catalog=DB_NAME;User ID=SQL_USER_LOGIN;Password=SQL_USER_PASS" providerName="System.Data.SqlClient" dbType="MsSql" name="Sitefinity" />
    </connectionStrings>
    </dataConfig>
  7. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    09 Aug 2011
    Link to this post
    Hello John,

    The problem is not in the data config. Check the SecurityConfig if you have changed something related to the membership and role providers.

    Greetings,
    Ivan Dimitrov
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

  8. John
    John avatar
    22 posts
    Registered:
    14 Jan 2011
    09 Aug 2011
    Link to this post
    Hello Ivan,

    I haven't changed anything related to the membership or role providers ever..
    Below the SecurityConfig.config content:

    <?xml version="1.0" encoding="utf-8"?>
    <securityConfig xmlns:config="urn:telerik:sitefinity:configuration" xmlns:type="urn:telerik:sitefinity:configuration:type" config:version="4.1.1395.0" validationKey="9116BD1C3CF1DB1081A140FFB71EBE51581595FADFDE0DE75E12E329F4C7196FB27D005FA69973A97DD7F70EBA7744A791DFE59B3C4990CC033ADD42FAABEAA6" decryptionKey="18EA5BDAC69B40A032BBFF6BB62C043D4960E026148DA388A337DAC36848375F">
    <applicationRoles>
    <role id="50fe4dcd-f4be-4003-90ae-9986df54d2e0" name="Everyone" />
    <role id="152817b0-d3f8-49f9-b278-b9e84b0f1b4d" name="Anonymous" />
    <role id="70618a4e-f160-44e7-b370-f7264e92970d" name="Authenticated" />
    <role id="6750d532-89e6-4767-881b-5749fc93fe43" name="Owner" />
    <role id="b24a1efd-7944-4bcb-a4f1-0042dbbcdcb7" name="Administrators" />
    <role id="873d90e7-abc0-453f-a156-dd1550b4da71" name="BackendUsers" />
    <role id="c8ad9aa7-0d5c-434a-b230-91e21d6e6b1d" name="Authors" />
    <role id="587aab65-268b-4487-9c8e-24e4f651ffc9" name="Editors" />
    <role id="e1db745d-0174-43c1-a7ed-f607dc95b5f6" name="Designers" />
    </applicationRoles>
    <securityProviders>
    <add version="4.1.1395.0" name="OpenAccessDataProvider" />
    <add description="" resourceClassId="" enabled="True" version="4.0.1210.0" name="XmlDataProvider" />
    </securityProviders>
    </securityConfig>

    I made a full text search of «SecurityDataProvider» in ALL solution files. No such string. So I don't understand where this error comes from...
    Do you ?

    Thanks, John.
  9. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    09 Aug 2011
    Link to this post
    Hello John,

    I don't have other explanation for this error and this is what I see in the debug mode  and our code. This type is correct, so the only assumption I can made are related to some changes in the configurations.
    You can try to comment

    <securityProviders>
    <add version="4.1.1395.0" name="OpenAccessDataProvider" />
    <add description="" resourceClassId="" enabled="True" version="4.0.1210.0" name="XmlDataProvider" />
    </securityProviders>

    because you should see the lines above only if the provers are changes. Also in both the lines there is difference between the version  - the first provider shows build 1395, since the second shows 1210.


    I see that you use an older version, so you can try to upgrade.

    All the best,
    Ivan Dimitrov
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

9 posts, 0 answered