| From: | Diogo Biazus <diogo(at)ikono(dot)com(dot)br> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | mod_auth_pgsql |
| Date: | 2002-12-04 13:55:28 |
| Message-ID: | 3DEE0950.4040702@ikono.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Please somebody help me,
I'm trying to use the Apache module mod_auth_pgsql, and after entering
the user name and the password the server returns an error page (500 -
Server Internal Error).
The error that apache puts in the error_log is:
access to /var/www/html failed for 10.0.0.6, reason: PGSQL 3: ERROR:
pg_atoi: error in "diogo": can't parse "diogo"
-- Query: select senha from usuarios where codusuario='diogo'
I'm using the PostgreSQL 7.1.3 with RedHat 7.3, and Apache 1.3.23
Here is a bit of my httpd.conf:
AuthName "Atenticador do PostgreSQL"
AuthType basic
Auth_PG_host 10.0.0.7
Auth_PG_port 5432
Auth_PG_user ikono
Auth_PG_pwd *1k0n0
Auth_PG_database eyebot
Auth_PG_pwd_table usuarios
Auth_PG_uid_field codusuario
Auth_PG_pwd_field senha
Auth_PG_log_table access_log
Auth_PG_log_uname_field login
Auth_PG_log_date_field date
Auth_PG_log_uri_field request
Auth_PG_log_addrs_field ip_address
<LIMIT GET POST>
require valid-user
</LIMIT>
--
Diogo de Oliveira Biazus
diogo(at)ikono(dot)com(dot)br
Ikono Sistemas e Automação
http://www.ikono.com.br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vince Vielhaber | 2002-12-04 13:58:23 | Re: [GENERAL] PostgreSQL Global Development Group Announces |
| Previous Message | Chris Boget | 2002-12-04 13:54:52 | Re: Postgresql -- initial impressions and comments |