pra não esquecer…

October 8th, 2007

PostgreSQL – Npgsql/Windows – Only AuthenticationClearTextPassword and AuthenticationMD5Password

Posted by admin 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:

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