Oracle Membership

[Felipe-Reval 0]

Ola !!

 

estou tentando configurar os membership da oracle na minha aplicação web

segui o passo a passo o tutorial da oracle, mas mesmo assim estou com um problema

 

quando abro a abrir a pagina para configurar o membership e vou na aba segurança aparece esse erro:

OracleConnection.ConnectionString is invalid

 

o que tenho que fazer ?

obrigado

[Ivan.Teles 23]

Como está a configuração <connectionStrings> no seu a web.config?

[Felipe-Reval 0]

Esta assim, funcionar normal sem o membership

 

<connectionStrings>

<add name="StringConexao" connectionString="Data Source=NOME BANCO;Persist Security Info=True;User ID=USER;Password=SENHA;Unicode=True" providerName="System.Data.OracleClient" />

</connectionStrings>

[Ivan.Teles 23]

Tenta assim

<connectionStrings>
<clear />
<add name="StringConexao" connectionString="Data Source=NOME BANCO;Persist Security Info=True;User ID=USER;Password=SENHA;Unicode=True" providerName="System.Data.OracleClient" />
</connectionStrings>

[Felipe-Reval 0]

Agora deu esse erro rrs

 

The connection name 'OraAspNetConString' was not found in the applications configuration or the connection string is empty. (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 253)

 

uma coisa que percebi é que quando tava instalando nas imagem do tutorial para configurar o membership

na aba Provider tem a opção:

Membership Provider

era para ter 2 opções -> OracleMembershipProvider falou para assinalar essa

-> AspNetSqlMembershipProvider e essa que deixa desmarcada

 

e tem a opção

Role Provider

que era para ter 3 opções mas tem somente 2, que são essas :

-> AspNetSqlRoleProvider

-> AspNetWindowsTokenRoleProvider marquei essa

 

mas nao era para aparecer mais uma opção ?

 

obrigado

[Ivan.Teles 23]

Deu esse erro pq provavelmente o nome da connectionStringName na tag Membership esta diferente dessa StringConexao? ou não está?

[Felipe-Reval 0]

e sobre as opções que aparece no Provider ?

 

Meu web.config esta assim, segue abaixo

 

<?xml version="1.0" encoding="UTF-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <connectionStrings>
    <clear />
    <add name="StringConexao" connectionString="Data Source=BANCO;Persist Security Info=True;User ID=USER;Password=SENHA;Unicode=True" providerName="System.Data.OracleClient" />
  </connectionStrings>
	<system.web>

    <membership defaultProvider="OracleMembershipProvider" />
    <siteMap defaultProvider="Chamado" enabled="true">
      <providers>
        <add name="Chamado" type="System.Web.XmlSiteMapProvider" siteMapFile="~/SiteMap/chamado.SiteMap" />
      </providers>
    </siteMap>
    
		<compilation debug="true" targetFramework="4.0">
			<assemblies>
				<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
				<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
				<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /></assemblies></compilation>
    <!-- habilita a autenticacao -->
    <authentication mode="Forms">
      <forms name="login" loginUrl="Login.aspx" defaultUrl="~/geral/PaginaPrincipal.aspx" protection="All" path="/" slidingExpiration="true" cookieless="UseDeviceProfile"
             domain="" timeout="60" requireSSL="false" enableCrossAppRedirects="false">
        <credentials passwordFormat="SHA1" />
      </forms>
    </authentication>
    <customErrors defaultRedirect="~/Geral/PaginaErro.aspx" mode="On">
      <error statusCode="404" redirect="~/Geral/PaginaNaoEncontrada.aspx" />
      <error statusCode="403" redirect="~/Geral/AcessoNegado.aspx" />
    </customErrors>
		<profile>
			<providers>
				<clear />
				<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="StringConexao" applicationName="/" />
			</providers>
		</profile>
		<roleManager defaultProvider="AspNetWindowsTokenRoleProvider">
   <providers>
    <clear />
    <add connectionStringName="StringConexao" applicationName="/"
     name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />
    <add applicationName="/" name="AspNetWindowsTokenRoleProvider"
     type="System.Web.Security.WindowsTokenRoleProvider" />
   </providers>
  </roleManager>
	</system.web>
	<system.webServer>
    <modules runAllManagedModulesForAllRequests="true" />
	</system.webServer>
</configuration>

[Ivan.Teles 23]

Seu provider não está 100%, pois você tem que ser algo assim:

 

<membership defaultProvider="MembershipProvider" userIsOnlineTimeWindow="15">
			<providers>
				<add name="MembershipProvider" type="System.Web.Security.SqlMembershipProvider" applicationName="/" connectionStringName="LocalSqlServer" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="true" passwordFormat="Clear" maxInvalidPasswordAttempts="6" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" description="eCarteira"/>
			</providers>
		</membership>

Este utiliza SQL Server, mas tem q ter esses tipos de configurações, como connectionStringName etc..

Dá uma lida em:

http://download.oracle.com/docs/html/E10928_01/OracleMembershipProviderClass.htm

http://weblogs.asp.net/rudysetyo/archive/2008/11/20/asp-net-membership-and-role-provider-using-oracle-database-part-1.aspx

[Felipe-Reval 0]

adicionei esse comando do membership, apareceu mais uma opção nos provider do membership

 

deu esse erro

The connection name 'OraAspNetConString' was not found in the applications configuration or the connection string is empty. (C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config line 253)

[Ivan.Teles 23]

Felipe, repare que para funcionar o nome da String de conexão no provider tem que ser o mesmo nome da sua string de conexão. sacou?

Tipo:

<connectionStrings>
<add name="StringConexao" connectionString="Data Source=NOME BANCO;Persist Security Info=True;User ID=USER;Password=SENHA;Unicode=True" providerName="System.Data.OracleClient" />
</connectionStrings>

Sua conexão tem o nome de StringConexao

 

Então onde tem connectionStringName="OraAspNetConString" tem que ser connectionStringName="StringConexao" para que o membership possa encontra a base de dados

[Felipe-Reval 0]

Saquei sim, so que em momento nem um uso "OraAspNetConString"

ate nas machine.config que fica nas pasta windows/...., alterei os nome igual a do meu web.config

[Ivan.Teles 23]

não mecha nas machines.

Tenta:

<connectionStrings>
<clear />
<add name="StringConexao" connectionString="Data Source=NOME BANCO;Persist Security Info=True;User ID=USER;Password=SENHA;Unicode=True" providerName="System.Data.OracleClient" />
</connectionStrings>

<membership defaultProvider="OracleMembershipProvider">
      <providers>
        <add name="OracleMembershipProvider"
         	type="Oracle.Web.Security.OracleMembershipProvider, 
         	Oracle.Web, Version=2.111.6.20, Culture=neutral, 
         	PublicKeyToken=89b483f429c47342"
         	connectionStringName="StringConexao"
         	applicationName="/"
         	enablePasswordRetrieval="false"
         	enablePasswordReset="true"
         	requiresQuestionAndAnswer="true"
         	requiresUniqueEmail="true"
         	passwordFormat="Hashed"
         	maxInvalidPasswordAttempts="4"
         	minRequiredPasswordLength="9"
         	passwordAttemptWindow="8"/>
      </providers>
    </membership>

[Felipe-Reval 0]

ja tinha mechido rsrs

voltei o bck delas rs

 

tentei e deu esse erro:

 

An error was encountered. Please return to the previous page and try again.

 

complementando o post acima: esta com esse erro na aba segurança :

 

The entry 'OracleMembershipProvider' has already been added. (\\server51\d$\projetos visual studio\Projetos\Visual Studio 2010\Central de Serviços - TI\Reval.TI.Solucao\CentralServico.Projeto\web.config line 15)

[Ivan.Teles 23]

Tem algo errado em seu webconfig, pare ter algo duplicado. como cita em has already been added -> já foi adicionado

[Felipe-Reval 0]

esse é o meu web.config

 

da uma olhada nao achei nada de estranho nele

 

<?xml version="1.0" encoding="UTF-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  
	<system.web>

    <membership defaultProvider="OracleMembershipProvider">
      <providers>
        <add name="OracleMembershipProvider" 
             type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342"
             connectionStringName="StringConexao" applicationName="/" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true"
             requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="4" minRequiredPasswordLength="9" passwordAttemptWindow="8"/>
      </providers>
    </membership>    
    
    <siteMap defaultProvider="Chamado" enabled="true">
      <providers>
        <add name="Chamado" type="System.Web.XmlSiteMapProvider" siteMapFile="~/SiteMap/chamado.SiteMap" />
      </providers>
    </siteMap>
    
		<compilation debug="true" targetFramework="4.0">
			<assemblies>
				<add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
				<add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
				<add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /></assemblies></compilation>
    <!-- habilita a autenticacao -->
    <authentication mode="Forms">
      <forms name="login" loginUrl="Login.aspx" defaultUrl="~/geral/PaginaPrincipal.aspx" protection="All" path="/" slidingExpiration="true" 
             cookieless="UseDeviceProfile"
             domain="" timeout="60" requireSSL="false" enableCrossAppRedirects="false">
        <credentials passwordFormat="SHA1" />
      </forms>
    </authentication>
    <customErrors defaultRedirect="~/Geral/PaginaErro.aspx" mode="On">
      <error statusCode="404" redirect="~/Geral/PaginaNaoEncontrada.aspx" />
      <error statusCode="403" redirect="~/Geral/AcessoNegado.aspx" />
    </customErrors>
		<profile>
      <providers>
				<clear />
				<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="StringConexao" applicationName="/" />
			</providers>
		</profile>
		
    <roleManager defaultProvider="AspNetWindowsTokenRoleProvider">
      <providers>
      <clear />
      <add connectionStringName="StringConexao" applicationName="/"
          name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />
      <add applicationName="/" name="AspNetWindowsTokenRoleProvider"
           type="System.Web.Security.WindowsTokenRoleProvider" />
   </providers>
  </roleManager>
	</system.web>
  
	<system.webServer>
    <modules runAllManagedModulesForAllRequests="true" />
	</system.webServer>
</configuration>

[Ivan.Teles 23]

Algumas propriedades tem que ser limpa usando Clear, pra que sua aplicação limpe e depois utilize a que você setar a baixo, se não ele tenta usar a do machine.config

 

<?xml version="1.0" encoding="UTF-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->
<configuration>
  <connectionStrings>
<clear />
    <add name="StringConexao" connectionString="Data Source=HOMOLOGACAO;Persist Security Info=True;User ID=totvs;Password=totvs;Unicode=True" 
     	providerName="System.Data.OracleClient" />
  </connectionStrings>
        <system.web>

    <membership defaultProvider="OracleMembershipProvider">
      <providers>
<clear />
        <add name="OracleMembershipProvider" 
         	type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342"
         	connectionStringName="StringConexao" applicationName="/" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true"
         	requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="4" minRequiredPasswordLength="9" passwordAttemptWindow="8"/>
      </providers>
    </membership>    
    
    <siteMap defaultProvider="Chamado" enabled="true">
      <providers>
<clear />
        <add name="Chamado" type="System.Web.XmlSiteMapProvider" siteMapFile="~/SiteMap/chamado.SiteMap" />
      </providers>
    </siteMap>
    
                <compilation debug="true" targetFramework="4.0">
                        <assemblies>
                                <add assembly="System.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
                                <add assembly="System.Web.Extensions.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
                                <add assembly="System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089" /></assemblies></compilation>
    <!-- habilita a autenticacao -->
    <authentication mode="Forms">
      <forms name="login" loginUrl="Login.aspx" defaultUrl="~/geral/PaginaPrincipal.aspx" protection="All" path="/" slidingExpiration="true" 
         	cookieless="UseDeviceProfile"
         	domain="" timeout="60" requireSSL="false" enableCrossAppRedirects="false">
        <credentials passwordFormat="SHA1" />
      </forms>
    </authentication>
    <customErrors defaultRedirect="~/Geral/PaginaErro.aspx" mode="On">
      <error statusCode="404" redirect="~/Geral/PaginaNaoEncontrada.aspx" />
      <error statusCode="403" redirect="~/Geral/AcessoNegado.aspx" />
    </customErrors>
                <profile>
      <providers>
                                <clear />
                                <add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="StringConexao" applicationName="/" />
                        </providers>
                </profile>
                
    <roleManager defaultProvider="AspNetWindowsTokenRoleProvider">
      <providers>
      <clear />
      <add connectionStringName="StringConexao" applicationName="/"
          name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />
      <add applicationName="/" name="AspNetWindowsTokenRoleProvider"
       	type="System.Web.Security.WindowsTokenRoleProvider" />
   </providers>
  </roleManager>
        </system.web>
  
        <system.webServer>
    <modules runAllManagedModulesForAllRequests="true" />
        </system.webServer>
</configuration>

[Felipe-Reval 0]

agora deu esse erro

An error occurred while attempting to initialize an Oracle.DataAccess.Client.OracleConnection object. The value that was provided for the connection string may be wrong, or it may contain an invalid syntax. Parameter name: connectionString

[Ivan.Teles 23]

Tem algo na string de conexão.

Não teria que ter o nome da base de dados na String?

[Felipe-Reval 0]

Mais tem a base de dados sim,

eu consigo rodar a aplicação normalmente, acesso o banco normal tambem