This project is read-only.

Compilation

Download and install System.Data.SQLite from http://sqlite.phxsoftware.com/
Frontend site (zzzCMSFrontend) and ZZZ CMS (zzzCMSBackend) can be hosted on different servers. But they both must point to the same database cmsdb.s3db and Upload folder in their web.config .
To log on ZZZ CMS try

login 'maxim', password '12345' for SQLITE

or

login 'maxim', password '123456!' for SQLSERVER 2005/2008

without quotes.

Using different providers

1. SQLITE

For this server the user is 'maxim'
Password '12345'

Step 1: Use zzzCMS_Backend\App_Data\cmsdb.s3db or execute SQL\sqlite.sql.

Step 2: Change ZZZ CMS web.config like this:
...
 <connectionStrings>
    <add name="System.Data.SQLite"
         connectionString="Data Source=|DataDirectory|cmsdb.s3db;Version=3;" />
  </connectionStrings>
...
<roleManager
      defaultProvider="SQLiteRoleProvider"
      enabled="true"
      cacheRolesInCookie="true"
      cookieName=".ASPROLES"
      cookieTimeout="30" cookiePath="/"
      cookieRequireSSL="false"
      cookieSlidingExpiration="true"
      cookieProtection="All">
      <providers>
        <clear/>
        <add 
          name="SQLiteRoleProvider"
          type="Mascix.SQLiteProviders.SQLiteRoleProvider"
          connectionStringName="System.Data.SQLite"
          applicationName="TEST"
          writeExceptionsToEventLog="true"/>
      </providers>
    </roleManager>
    <membership defaultProvider="SQLiteMembershipProvider"
                userIsOnlineTimeWindow="15">
      <providers>
        <clear/>
        <add
          name="SQLiteMembershipProvider"
          type="Mascix.SQLiteProviders.SqliteMembershipProvider"
          connectionStringName="System.Data.SQLite"
          applicationName="TEST"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="false"
          requiresUniqueEmail="true"
          passwordFormat="Hashed"
          writeExceptionsToEventLog="true"/>
      </providers>
    </membership>
    <profile defaultProvider="SQLiteProfileProvider">
      <providers>
        <clear/>
        <add 
          name="SQLiteProfileProvider"
          type="Mascix.SQLiteProviders.SQLiteProfileProvider"
          connectionStringName="System.Data.SQLite"
          applicationName="TEST"/>
      </providers>
      <properties>
        <add name="Name" type="System.String"/>
        <add name="SureName" type="System.String"/>
        <add name="Address" type="System.String"/>
        <add name="County" type="System.Int32"/>
        <add name="City" type="System.Int32"/>
        <add name="PostalCode" type="System.String"/>
        <add name="HomePhone" type="System.String"/>
        <add name="WorkPhone" type="System.String"/>
        <add name="CellPhone" type="System.String"/>
        <add name="AdsenseID" type="System.String"/>
        <add name="AdsenseChannelID" type="System.String"/>
      </properties>
    </profile>
    <webParts>
      <personalization defaultProvider="personalizationProvider">
        <providers>
          <clear />
          <add name="personalizationProvider"
               type="Mascix.SQLiteProviders.SQLitePersonalizationProvider" 
               connectionStringName="System.Data.SQLite" 
               applicationName="TEST"
               description="MySQL Personalization Provider"
               />
        </providers>
      </personalization>
    </webParts>
...

2. SQLSERVER 2005/2008

For this server the user is 'maxim'
Password '123456!'

Step 1: Restore zzzCMS_Backend\App_Data\cmsdb.bak or execute SQL\sqlserver.sql.

Step 2: Change ZZZ CMS web.config like this:
...
 <connectionStrings>
    <add name="System.Data.SqlClient"
         connectionString="connection string to database CMSDB on your sqlserver" />
  </connectionStrings>
...
 <membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
      <providers>
        <clear />
        <add
          name="SqlProvider"
          type="System.Web.Security.SqlMembershipProvider"
          connectionStringName="System.Data.SqlClient"
          applicationName="MyApplication"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="false"
          requiresUniqueEmail="true"
          passwordFormat="Hashed" />
      </providers>
    </membership>
    
    <roleManager enabled="true" cacheRolesInCookie="true" defaultProvider="SqlProvider">
      <providers>
        <clear />
        <add connectionStringName="System.Data.SqlClient" applicationName="MyApplication"
           name="SqlProvider" type="System.Web.Security.SqlRoleProvider" />
      </providers>
    </roleManager>
...

Last edited Jan 7, 2010 at 9:08 AM by atdushi, version 3

Comments

No comments yet.