http-authentication on postgresql

Hi There,

I have some troubles with the http-authentication using apache2 in
combination with postgresql. I used to do it with Apache::AuthenDBI
configuring access.conf in the following way:

-----------------------
AuthName MyDB
AuthType Basic
PerlAuthenHandler Apache::AuthDBI::authen
PerlSetVar Auth_DBI:data_source dbi:Pg:dbname=mydb
PerlSetVar Auth_DBI_username me
PerlSetVar Auth_DBI_password pw
PerlSetVar Auth_DBI_pwd_table MEMBER
PerlSetVar Auth_DBI_puid_field EMAILADRES
PerlSetVar Auth_DBI_pwd_field PASSWORD
PerlSetVar Auth_DBI_encrypted off
require valid-user
-----------------

But with apache2 this results in errors...

Can anyone give me a hint?

Kind Regards,

Michel Jansen

Re: http-authentication on postgresql

Can you give us a hint as to what the errors are?

On 22 Mar 2011, at 15:10, Michel Jansen wrote:

> Hi There,
>=20
> I have some troubles with the http-authentication using apache2 in =
combination with postgresql. I used to do it with Apache::AuthenDBI =
configuring access.conf in the following way:
>=20
> -----------------------
> AuthName MyDB
> AuthType Basic
> PerlAuthenHandler Apache::AuthDBI::authen
> PerlSetVar Auth_DBI:data_source dbi:Pg:dbname=3Dmydb
> PerlSetVar Auth_DBI_username me
> PerlSetVar Auth_DBI_password pw
> PerlSetVar Auth_DBI_pwd_table MEMBER
> PerlSetVar Auth_DBI_puid_field EMAILADRES
> PerlSetVar Auth_DBI_pwd_field PASSWORD
> PerlSetVar Auth_DBI_encrypted off
> require valid-user
> -----------------
>=20
> But with apache2 this results in errors...
>=20
> Can anyone give me a hint?
>=20
> Kind Regards,
>=20
> Michel Jansen

Re: http-authentication on postgresql

The Apache::AuthDBI package has changed.... Checkout the errors below!

[Tue Mar 22 16:35:50 2011] [error] [client 192.168.112.1] failed to
resolve handler `Apache::AuthDBI::authen': Can't locate
Apache/AuthDBI/authen.pm in @INC (@INC contains: /etc/perl
/usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5
/usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10
/usr/local/lib/site_perl . /etc/apache2) at (eval 2) line 3.\n

Re: http-authentication on postgresql

What version are you using? I'll take a look at this later today if I
can find a spare tuit.

On Tue, Mar 22, 2011 at 8:37 AM, Michel Jansen
wrote:
> The Apache::AuthDBI package has changed.... Checkout the errors below!
>
> [Tue Mar 22 16:35:50 2011] [error] [client 192.168.112.1] failed to resolve
> handler `Apache::AuthDBI::authen': Can't locate Apache/AuthDBI/authen.pm in
> @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1
> /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5
> /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .
> /etc/apache2) at (eval 2) line 3.\n
>
>

Re: http-authentication on postgresql

Op 22-3-2011 18:59, Fred Moyer schreef:
> What version are you using? I'll take a look at this later today if I
> can find a spare tuit.

The lastest from cpan!

Re: http-authentication on postgresql

Have you tried loading Apache::AuthDBI first? It looks confused about
where to find the sub you specified.

- Perrin

On Tue, Mar 22, 2011 at 11:37 AM, Michel Jansen
wrote:
>
> The Apache::AuthDBI package has changed.... Checkout the errors below!
>
> [Tue Mar 22 16:35:50 2011] [error] [client 192.168.112.1] failed to resol=
ve handler `Apache::AuthDBI::authen': Can't locate Apache/AuthDBI/authen.pm=
in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/sh=
are/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/sha=
re/perl/5.10 /usr/local/lib/site_perl . /etc/apache2) at (eval 2) line 3.\n
>