Oracle Membership

Felipe-Reval · October 28, 2010

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 · October 28, 2010

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

Felipe-Reval · October 29, 2010

Esta assim, funcionar normal sem o membership

</connectionStrings>

Ivan.Teles · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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

Felipe-Reval · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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

Felipe-Reval · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

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 · October 29, 2010

Tem algo na string de conexão.

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

Felipe-Reval · October 29, 2010

Mais tem a base de dados sim,

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

Archived

Oracle Membership

Recommended Posts

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Ivan.Teles 23

Share this post

Link to post

Share on other sites

Felipe-Reval 0

Share this post

Link to post

Share on other sites

Orientação - Codificação Caracteres Especiais em Java