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, > > 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
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 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 >