You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Michel Jansen <Mi...@Web-ICT.com> on 2011/03/22 16:10:27 UTC
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
Posted by Michel Jansen <Mi...@Web-ICT.com>.
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
Posted by Fred Moyer <fr...@redhotpenguin.com>.
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
<Mi...@web-ict.com> 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
Posted by Perrin Harkins <pe...@elem.com>.
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
<Mi...@web-ict.com> 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
Posted by Michel Jansen <Mi...@Web-ICT.com>.
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
Posted by Dave Hodgkinson <da...@gmail.com>.
Can you give us a hint as to what the errors are?
On 22 Mar 2011, at 15:10, Michel Jansen wrote:
> 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