pra não esquecer…

October 8th, 2007

PostgreSQL – Npgsql/Windows – Only AuthenticationClearTextPassword and AuthenticationMD5Password

Posted by Felipe Olivaes in Postgre SQL, Windows

para resolver esse problema:

PLAIN TEXT
CODE:
  1. Exception Details: Npgsql.NpgsqlException: Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 4
  2.  
  3. Source Error:
  4.  
  5. An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
  6.  
  7. Stack Trace:
  8.  
  9. [NpgsqlException: Only AuthenticationClearTextPassword and AuthenticationMD5Password supported for now. Received: 4]
  10. Npgsql.NpgsqlConnector.CheckErrors() +86
  11. Npgsql.NpgsqlConnector.Open() +425
  12. Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection) +508
  13. Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection) +66
  14. Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection) +124
  15. Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection) +54
  16. Npgsql.NpgsqlConnection.Open() +243
  17. System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
  18. System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
  19. System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
  20. contato.TextBox1_PreRender(Object sender, EventArgs e) +136
  21. System.Web.UI.Control.OnPreRender(EventArgs e) +2114636
  22. System.Web.UI.WebControls.TextBox.OnPreRender(EventArgs e) +11
  23. System.Web.UI.Control.PreRenderRecursiveInternal() +77
  24. System.Web.UI.Control.PreRenderRecursiveInternal() +161
  25. System.Web.UI.Control.PreRenderRecursiveInternal() +161
  26. System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

Edite o arquivo /usr/local/pgsql/data/pg_hba.conf e adicione:

PLAIN TEXT
CODE:
  1. #host BASE_DE_DADOS USUARIO IP MASK METHOD
  2. host BASEDEDADOS USUARIO  0.0.0.0 0.0.0.0 md5

só mudar a autenticação para md5 =-)

One Response to ' PostgreSQL – Npgsql/Windows – Only AuthenticationClearTextPassword and AuthenticationMD5Password '

Subscribe to comments with RSS or TrackBack to ' PostgreSQL – Npgsql/Windows – Only AuthenticationClearTextPassword and AuthenticationMD5Password '.

  1. rafael said,

    on October 28th, 2007 at 4:45 pm

    vlw totoro :D

Leave a reply


 



nuvem de tags:

24 horas acentuação Apache bash benchmark bios boot celular centos charset comando console Download esxi Firebird firefox http importação intel ipod iscsi kinghost legenda Linux lost mod_deflate msn mssql MySQL owner Padel PHP placa mãe portabilidade Postgre SQL recovery root password shell sinuca sql server svn temporada completa veronica mars vmware Windows ícones