membership provider

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
PeterL
Posts: 2
Joined: Fri 05 Dec 2014 16:46

membership provider

Post by PeterL » Fri 05 Dec 2014 16:52

hello. currently trying to convert and exist site from MS SQL to Oracle and devart was recommend to me. on convertion i get the following when trying to login on my site

ORA-00942: table or view does not exist



[OracleException (0x80004005): ORA-00942: table or view does not exist]
Devart.Data.Oracle.cc.d() +1518
Devart.Data.Oracle.bu.m() +95
Devart.Data.Oracle.bu.a() +2942
Devart.Data.Oracle.l.a(Int32 A_0, ci A_1) +4465
Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) +4113
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +1182
Devart.Common.DbCommandBase.ExecuteScalar() +28
Devart.Common.Web.Providers.DbExtendedMembershipProvider.a(DbDatabaseManager A_0, String A_1) +325
Devart.Common.Web.Providers.DbExtendedMembershipProvider.b(DbDatabaseManager A_0, String A_1, Boolean A_2) +31
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +164

[ProviderException: Error validating user]
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +549
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +105
System.Web.UI.WebControls.Login.AttemptLogin() +160
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +93
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804


I have the devart version 8.4.293.4

I have run the scripts provided by devart to create oracle tables but would like to use existing ones if possible.

web.config

Code: Select all

<roleManager enabled="true" defaultProvider="OracleExtendedRoleProvider" cacheRolesInCookie="true" cookieName=".localV4AdminWibbleEURoles" cookieTimeout="7200" cookiePath="/" 
                 cookieRequireSSL="false" cookieSlidingExpiration="true" cookieProtection="All" createPersistentCookie="false" maxCachedResults="25">
      <providers>
        <clear />
        <remove name="OracleExtendedRoleProvider"/>
        <add connectionStringName="OracleAdminConnection" name="OracleExtendedRoleProvider" type="Devart.Data.Oracle.Web.Providers.OracleExtendedRoleProvider, Devart.Data.Oracle.Web, Version=8.4.293.4, Culture=neutral, PublicKeyToken=09af7300eec23701" useridcolumn="UserId" usernamecolumn="UserName" usertablename="ORA_ASPNET_USERS" />
        <!--<add applicationName="/" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" />-->
      </providers>
    </roleManager>
    <profile enabled="true" defaultProvider="TableProfileProvider" inherits="Wibble.Common.Admin.ProfileCommon, Wibble.Common.Admin">
      <providers>
        <clear />
		<add name="TableProfileProvider" type="Wibble.Common.Admin.SqlTableProfileProvider, Wibble.Common.Admin" connectionStringName="OracleAdminConnection" table="PCS_CRM_AdminProfile" applicationName="WibbleEuropeAdministration" />        
      </providers>
    </profile>
    <membership defaultProvider="OracleExtendedMembershipProvider">
      <providers>
        <clear />
        <remove name="OracleExtendedMembershipProvider"/>
        <add name="OracleExtendedMembershipProvider" type="Devart.Data.Oracle.Web.Providers.OracleExtendedMembershipProvider, Devart.Data.Oracle.Web, Version=8.4.293.4, Culture=neutral,  PublicKeyToken=09af7300eec23701" 
             connectionStringName="OracleAdminConnection" applicationName="WibbleEuropeAdministration" 
             enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true" 
      passwordFormat="Hashed" maxInvalidPasswordAttempts="4" minRequiredPasswordLength="9" passwordAttemptWindow="8" useridcolumn="UserId" usernamecolumn="UserName" usertablename="ORA_ASPNET_USERS" />        
      </providers>
    </membership>

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: membership provider

Post by Shalex » Mon 08 Dec 2014 12:00

PeterL wrote:[OracleException (0x80004005): ORA-00942: table or view does not exist]
Devart.Data.Oracle.cc.d() +1518
...
Please run the dbMonitor tool (documentation, download link) and specify the exact SQL statement which fails to execute.

PeterL
Posts: 2
Joined: Fri 05 Dec 2014 16:46

Re: membership provider

Post by PeterL » Tue 09 Dec 2014 12:01

Thanks. Found the misspelt table.

now on to the next error on login

[InvalidCastException: Unable to cast object of type 'System.Byte[]' to type 'System.IConvertible'.]
System.Convert.ToInt32(Object value) +24
Devart.Common.Web.Providers.DbExtendedMembershipProvider.a(DbDatabaseManager A_0, String A_1) +363
Devart.Common.Web.Providers.DbExtendedMembershipProvider.b(DbDatabaseManager A_0, String A_1, Boolean A_2) +31
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +164

[ProviderException: Error validating user]
Devart.Common.Web.Providers.DbExtendedMembershipProvider.ValidateUser(String username, String password) +549
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +105
System.Web.UI.WebControls.Login.AttemptLogin() +160
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +93
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: membership provider

Post by Shalex » Tue 09 Dec 2014 15:17

Please give us an additional information:
1) according to your *.config you are using Devart.Data.Oracle.Web.dll with *.4 revision number. Try running your application with standard tables supplied with provider in C:\Program Files (x86)\Devart\dotConnect\Oracle\Web\ASP.NET 4\InstallExtendedWebTables.sql . Does it work?
2) specify the datatypes of the UserId and UserName columns in your ORA_ASPNET_USERS table
3) are there any errors in dbMonitor logs?

Post Reply