I am trying to use the PostgreSQL membership provider created by Daniel Nauck http://dev.nauck-it.de/projects/aspsqlprovider for an ASP.NET web application (C #) and follow the configuration instructions given in
http://dev.nauck-it.de/projects/1/wiki/Install?version=11
I installed NpgSQL and a membership provider with nuget:
Install-Package Npgsql Install-Package Nauck.PostgreSQLProvider
When accessing the Security tab on the configuration project web page, I get the following error:
exepath must be specified if it does not work inside a standalone exe
I added the SQL membership table data to my postgres database and specified the connection string as well as this configuration in the web.config file.
web.config:
<configuration> <connectionStrings> <add name="PostgreSQL" connectionString="Server=localhost;Port=5432;Database=mydb;User Id=postgres;Password=mypassword;Encoding=UNICODE;Sslmode=Prefer;Pooling=true;" /> </connectionStrings> <system.web> <compilation debug="true" targetFramework="4.0" /> <membership defaultProvider="PgMembershipProvider"> <providers> <clear /> <add name="PgMembershipProvider" type="NauckIT.PostgreSQLProvider.PgMembershipProvider" connectionStringName="PostgreSQL" requiresUniqueEmail="true" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" passwordFormat="Hashed" applicationName="AquilaWeb" /> </providers> </membership> <roleManager enabled="true" defaultProvider="PgRoleProvider" cacheRolesInCookie="true" cookieName=".AspNetRoles" cookiePath="/" cookieProtection="All" cookieRequireSSL="false" cookieSlidingExpiration="true" createPersistentCookie="false" cookieTimeout="30" maxCachedResults="25"> <providers> <clear /> <add name="PgRoleProvider" type="NauckIT.PostgreSQLProvider.PgRoleProvider" connectionStringName="PostgreSQL" applicationName="AquilaWeb" /> </providers> </roleManager> <profile enabled="true" defaultProvider="PgProfileProvider"> <providers> <clear /> <add name="PgProfileProvider" type="NauckIT.PostgreSQLProvider.PgProfileProvider" connectionStringName="PostgreSQL" applicationName="AquilaWeb" /> </providers> <properties> <add name="FirstName" /> <add name="LastName" /> </properties> </profile> <sessionState mode="Custom" customProvider="PgSessionStateStoreProvider"> <providers> <clear/> <add name="PgSessionStateStoreProvider" type="NauckIT.PostgreSQLProvider.PgSessionStateStoreProvider" enableExpiredSessionAutoDeletion="true" expiredSessionAutoDeletionInterval="60000" enableSessionExpireCallback="false" connectionStringName="PostgreSQL" applicationName="AquilaWeb" /> </providers> </sessionState> </system.web> <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="Npgsql" publicKeyToken="5d8b90d52f46fda7" culture="neutral" /> <bindingRedirect oldVersion="0.0.0.0-2.0.12.0" newVersion="2.0.12.0" /> </dependentAssembly> </assemblyBinding> </runtime> </configuration>
source share