Where does TheBeerHouse store users???

Last post 05-19-2009 11:38 PM by lionkingpuppy. 26 replies.

Sort Posts:

  • Re: Where does TheBeerHouse store users???

    04-30-2009, 8:23 AM
    • Contributor
      2,268 point Contributor
    • Kulrom
    • Member since 01-08-2009, 6:17 PM
    • Republic of Macedonia
    • Posts 413

     I am pretty sure that it's something on your end. It works just fine for me. I can see the records in the table Users.

    i may sound a bit silly but you could check if any apps in conflict with the Management Studio. AV softwares usually cause sucha mess. 

    Sorry cuz i couldn't be more of help. 

    When you ask a question, remember to click "Mark As Answer" when you get a reply which answers your question.
    My Site: ASP.NET Source Code


    My Blog: My New VB.NET Blog
  • Re: Where does TheBeerHouse store users???

    04-30-2009, 10:22 AM

    I worked fine for me.

     I don't know why i can see everything in my db except users. :(. Where does the register control store it? And when I login, It check information from where???

    Should I do now? Attach another database. ?

  • Re: Where does TheBeerHouse store users???

    05-01-2009, 4:35 AM
    Asp.Net Configuration option in Visual Studio. A full list of settings and comments can be found in machine.config.comments usually located in \Windows\Microsoft.Net\Framework\v2.x\Config -->--> section enables configuration of the security authentication mode used by ASP.NET to identify an incoming user. --> section enables configuration of what to do if/when an unhandled error occurs during the execution of a request. Specifically, it enables developers to configure html error pages to be displayed in place of a error stack trace.--><?xml version="1.0"?><!--

    Note: As an alternative to hand editing this file you can use the

    web admin tool to configure settings for your application. Use

    the Website->Asp.Net Configuration option in Visual Studio.

    A full list of settings and comments can be found in

    machine.config.comments usually located in

    \Windows\Microsoft.Net\Framework\v2.x\Config

    -->

    <
    configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

    <configSections>

    <section name="theMotorcycle" type="MB.Motorcycle.TheMotorcycleSection, __code"/>

    <sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

    <sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

    <section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

    <sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">

    <section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>

    <section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

    <section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

    <section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>

    </sectionGroup>

    </sectionGroup>

    </sectionGroup>

    </configSections>

    <theMotorcycle defaultConnectionStringName="connMotorcycle">

    <!--<articles providerType="MB.Motorcycle.DataAccessLayer.SqlClient.SqlArticlesProvider" pageSize="10" rssItems="10" enableCaching="true" cacheDuration="300"/>-->

    <contactForm mailTo="contact@perfume.vn"/>

    <articles pageSize="10"/>

    <!--to make the archive available to everyone-->

    <polls archiveIsPublic="true" votingLockByIP="false"/>

    <newsletters fromEmail="contact@perfume.vn" fromDisplayName="www.Perfume.vn"/>

    <forums threadsPageSize="8" hotThreadPosts="10" bronzePosterPosts="10" silverPosterPosts="20" goldPosterPosts="50"/>

    <store sandboxMode="true" businessEmail="contact@perfume.vn"/>

    </theMotorcycle>

    <appSettings/>

    <connectionStrings>

    <add name="connMotorcycle" connectionString="Data Source = Lionking-pc; Initial Catalog = Perfume; uid = sa; pwd = mypass" providerName="System.Data.SqlClient"/>

    <add name="MotorcycleDBConnectionString" connectionString="Data Source=LIONKING-PC;Initial Catalog = Perfume;User ID=sa; pwd= "mypass" providerName="System.Data.SqlClient"/>

    </connectionStrings>

    <system.web><!--

    Set compilation debug="true" to insert debugging

    symbols into the compiled page. Because this

    affects performance, set this value to true only

    during development.

    -->

    <caching>

    <sqlCacheDependency enabled="true" pollTime="10000">

    <databases>

    <add name="connMotorcycle-Cache" connectionStringName="connMotorcycle" pollTime="2000"/>

    </databases>

    </sqlCacheDependency>

    </caching>

    <!--Define SMTP settings used to send mail-->

    <compilation debug="true">

    <assemblies>

    <add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

    <add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

    <add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

    <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

    <add assembly="System.Web.Extensions.Design, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

    <add assembly="System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></assemblies>

    </compilation>

    <!--

    The <authentication> section enables configuration

    of the security authentication mode used by

    ASP.NET to identify an incoming user.

    -->

    <authentication mode="Forms">

    <forms cookieless="AutoDetect" loginUrl="~/AccessDenied.aspx" name="MForAuth"/>

    </authentication>

    <membership defaultProvider="M_MembershipProvider" userIsOnlineTimeWindow="15">

    <providers>

    <add name="M_MembershipProvider" connectionStringName="LocalSqlServer" applicationName="/" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" passwordFormat="Encrypted" maxInvalidPasswordAttempts="5" passwordAttemptWindow="10" minRequiredNonalphanumericCharacters="0" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

    </providers>

    </membership>

    <roleManager enabled="true" cacheRolesInCookie="true" cookieName="MROLES" defaultProvider="M_RoleProvider">

    <providers>

    <add name="M_RoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

    </providers>

    </roleManager>

    <anonymousIdentification cookieless="AutoDetect" enabled="true"/>

    <profile defaultProvider="M_ProfileProvider">

    <providers>

    <add name="M_ProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

    </providers>

    <properties>

    <add name="FirstName" type="String"/>

    <add name="LastName" type="String"/>

    <add name="Gender" type="String"/>

    <add name="BirthDate" type="DateTime"/>

    <add name="Occupation" type="String"/>

    <add name="Website" type="String"/>

    <add name="ShoppingCart" type="MB.Motorcycle.BusinessLogicLayer.Store.ShoppingCart" serializeAs="Binary" allowAnonymous="true"/>

    <group name="Forum">

    <add name="Posts" type="Int32"/>

    <add name="AvatarUrl" type="String"/>

    <add name="Signature" type="String"/>

    </group>

    <group name="Address">

    <add name="Street" type="String"/>

    <add name="PostalCode" type="String"/>

    <add name="City" type="String"/>

    <add name="State" type="String"/>

    <add name="Country" type="String"/>

    </group>

    <group name="Contacts">

    <add name="Phone" type="String"/>

    <add name="Fax" type="String"/>

    </group>

    <group name="Preferences">

    <add name="Theme" type="String" allowAnonymous="true"/>

    <add name="Culture" type="String" defaultValue="en-US"/>

    <add name="Newsletter" type="MB.Motorcycle.BusinessLogicLayer.Newsletters.SubscriptionType"/>

    </group>

    </properties>

    </profile>

    <machineKey validationKey="C72056E3B85186C754916BFA163B589AE5D1C7E4A6FD2DB260893F7DA6C628B08DDD787C06E0BCAC8D4D3ABCDBCEA0FE19BCC55843F4B6CDDDF31160B8440430" decryptionKey="DE1E2ED3FF6D4580CF42E923C3602E80729CE6B2731B03B6" validation="SHA1"/>

    <siteMap defaultProvider="M_SiteMapProvider" enabled="true">

    <providers>

    <add name="M_SiteMapProvider" type="System.Web.XmlSiteMapProvider" securityTrimmingEnabled="true" siteMapFile="web.sitemap"/>

    </providers></siteMap>

     

    <!--
    The <customErrors> section enables configuration

    of what to do if/when an unhandled error occurs

    during the execution of a request. Specifically,

    it enables developers to configure html error pages

    to be displayed in place of a error stack trace.
    -->

    <customErrors mode="RemoteOnly" defaultRedirect="~/Error.aspx">

    <error statusCode="404" redirect="~/Error.aspx?code=404"/>

    <error statusCode="408" redirect="~/Error.aspx?code=408"/>

    <error statusCode="505" redirect="~/Error.aspx?code=505"/></customErrors>

     

    <pages theme="Motorcycle" masterPageFile="~/MasterPage.master" maintainScrollPositionOnPostBack="true">

    <controls>

    <add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    </controls>

    </pages>

    <httpHandlers>

    <remove verb="*" path="*.asmx"/>

    <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>

    </httpHandlers>

    <httpModules>

    <add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    </httpModules>

    <healthMonitoring heartbeatInterval="10800">

    <providers>

    <remove name="SqlWebEventProvider"/>

    <add name="SqlWebEventProvider" connectionStringName="LocalSqlServer" buffer="false" bufferMode="Notification" maxEventDetailsLength="1073741823" type="System.Web.Management.SqlWebEventProvider,System.Web, Version=2.0.0.0,Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"/>

    </providers>

    <eventMappings>

    <add name="M Events" type="MB.Motorcycle.WebCustomEvent, MB.Motorcycle.CustomEvents"/>

    </eventMappings>

    <rules>

    <clear/>

    <add name="M Events" eventName="M Events" provider="SqlWebEventProvider" profile="Critical"/>

    <add name="All Errors" eventName="All Errors" provider="SqlWebEventProvider" profile="Critical"/>

    <add name="Failure Audits" eventName="Failure Audits" provider="SqlWebEventProvider" profile="Critical"/>

    <add name="Heartbeats" eventName="Heartbeats" provider="SqlWebEventProvider" profile="Critical"/>

    </rules>

    </healthMonitoring>

    </system.web>

    <location path="~/Admin/EditProfile.aspx">

    <system.web>

    <authorization>

    <deny users="?"/>

    <allow users="*"/>

    </authorization>

    </system.web>

    </location>

    <location path="AddEditArticle.aspx">

    <system.web>

    <authorization>

    <allow roles="Administrators,Editors,Contributors"/>

    <deny users="*"/>

    </authorization>

    </system.web>

    </location>

    <location path="AddEditPost.aspx">

    <system.web>

    <authorization>

    <allow roles="Administrators,Editors,Moderators,Posters"/>

    <deny users="*"/>

    </authorization>

    </system.web>

    </location>

    <location path="~/Admin/Default.aspx">

    <system.web>

    <authorization>

    <allow roles="Administrators,Editors,Contributors"/><!--Administrators,Editors,Contributors-->

    <deny users="*"/>

    </authorization>

    </system.web>

    </location>

    <system.net>

    <mailSettings>

    <smtp deliveryMethod="PickupDirectoryFromIis" from="test@motorcycle.vn">

    <network defaultCredentials="true" host="(localhost)" port="25"/>

    </smtp>

    </mailSettings>

    </system.net>

    <system.codedom>

    <compilers>

    <compiler language="c#;cs;csharp" extension=".cs" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

    <providerOption name="CompilerVersion" value="v3.5"/>

    <providerOption name="WarnAsError" value="false"/>

    </compiler>

    <compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" warningLevel="4" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

    <providerOption name="CompilerVersion" value="v3.5"/>

    <providerOption name="OptionInfer" value="true"/>

    <providerOption name="WarnAsError" value="false"/>

    </compiler>

    </compilers>

    </system.codedom><!--

    The system.webServer section is required for running ASP.NET AJAX under Internet

    Information Services 7.0. It is not necessary for previous version of IIS.

    -->

    <system.webServer>

    <validation validateIntegratedModeConfiguration="false"/>

    <modules>

    <remove name="ScriptModule"/>

    <add name="ScriptModule" preCondition="managedHandler" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    </modules>

    <handlers>

    <remove name="WebServiceHandlerFactory-Integrated"/>

    <remove name="ScriptHandlerFactory"/>

    <remove name="ScriptHandlerFactoryAppServices"/>

    <remove name="ScriptResource"/>

    <add name="ScriptHandlerFactory" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add name="ScriptHandlerFactoryAppServices" verb="*" path="*_AppService.axd" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    <add name="ScriptResource" preCondition="integratedMode" verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

    </handlers>

    </system.webServer>

    <runtime>

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

    <dependentAssembly>

    <assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>

    <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

    </dependentAssembly>

    <dependentAssembly>

    <assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>

    <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>

    </dependentAssembly>

    </assemblyBinding>

    </runtime>

    </configuration>

  • Re: Where does TheBeerHouse store users???

    05-01-2009, 4:36 AM

    Above is my web config file. Pls check if there is some errors.

  • Re: Where does TheBeerHouse store users???

    05-12-2009, 12:04 PM

    any helps? Plsssssssssssssss!

  • Re: Where does TheBeerHouse store users???

    05-13-2009, 12:28 PM
    • Member
      20 point Member
    • rargie
    • Member since 02-17-2009, 6:31 AM
    • Buenos Aires, Argentina
    • Posts 11

    I ran into similar issues when I was first using TBH, the issue I had was around the Membership providers- make sure it's pointing to the right place. So some things you might consider:

    Have you changed anything regarding the membership providers? Is this on your local machine or on a webserver? Did you add additional DBs to the app or rename the DB? You could also try re-installing TBH as a new project and see if it was any tinkering you did in web.config.

  • Re: Where does TheBeerHouse store users???

    05-13-2009, 9:43 PM

    As u can c in my config file. I changed the name of MembershipProvider.

  • Re: Where does TheBeerHouse store users???

    05-13-2009, 10:06 PM

    I created the database by using scripts in THB not attaching the MDF file.

  • Re: Where does TheBeerHouse store users???

    05-13-2009, 11:49 PM
    • Member
      20 point Member
    • rargie
    • Member since 02-17-2009, 6:31 AM
    • Buenos Aires, Argentina
    • Posts 11

     <membership defaultProvider="M_MembershipProvider" userIsOnlineTimeWindow="15">

    <providers>

    <add name="M_MembershipProvider" connectionStringName="LocalSqlServer" applicationName="/" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="true" requiresUniqueEmail="true" passwordFormat="Encrypted" maxInvalidPasswordAttempts="5" passwordAttemptWindow="10" minRequiredNonalphanumericCharacters="0" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

    </providers>

    </membership>

    Are you able to log on to the website? The Membership provider is using the connection string "LocalSqlServer" and not the connection string you have specified in the connection string section, so it seems the membership details are being stored elsewhere (wherever LocalSqlServer connects to). Check which databases you have set up. I'd hazard a wild guess you have an ASPNETDB.mdf in the App_Data folder and the details are sat in there, as is the default set up for ASP.NET. Whilst I'm certainly no expert on the subject, your membership provider and connection string config details look odd to me, for example I couldn't see a connection string for LocalSqlServer so I can't see what you are connecting to at all?

  • Re: Where does TheBeerHouse store users???

    05-14-2009, 12:18 AM

    Yes, I'm having a aspnetdb.mdf on appdata folder. And I can log on my site, of course!

  • Re: Where does TheBeerHouse store users???

    05-14-2009, 1:04 AM
    Answer
    • Member
      20 point Member
    • rargie
    • Member since 02-17-2009, 6:31 AM
    • Buenos Aires, Argentina
    • Posts 11

    lionkingpuppy:

    Yes, I'm having a aspnetdb.mdf on appdata folder. And I can log on my site, of course!

     

     

    ...then the users are probably stored in there. Go check it. The provider model used for membership, roles, profiles, aricles, forums, etc allows it's own connection string. You specify it in the web.config section, and it looks for the ACTUAL connection string in the connection string section of the web.config. This means you can have multiple data sources and swap out databases, etc. If you want for example, just one database for your application, you need to update all of the providers and connection strings to point to the correct database, otherwise it will keep storing stuff in the default ASPNETDB.mdf database.

    All fixed?

  • Re: Where does TheBeerHouse store users???

    05-19-2009, 11:38 PM

    Thank you much for your help! It's done.

Page 2 of 2 (27 items) < Previous 1 2