Обсуждение: Activeperl 5.8 on windows and postgres 8
Hi all,
I am in the process of installing SQL-Ledger. I am unfamiliar with Postgres not with Perl.
I downloaded DBD-Pg from http://www.edmund-mergl.de/export/ and found out it doesn’t install on Active perl 5.8.
So I started my search for a solution. On the website of SQL-Ledger it says to uninstall Perl 5.8, install 5.6, install the driver and install Perl 5.8.
No, as I already had quite a setup on my machine, I decided to skip the ppm install and do it myself. So I put the files in place, created the pkg and packlist files and … it almost worked.
The connection to the database fails because it cannot load the pg.dll. Looking into that I found that this dll refers directly to perl56.dll which of course is part of ActivePerl 5.6 which I have not installed. So I patched the dll and again got a little further. No more error messages about failing to load a dll. Now a real connect error pops up, which I have no idea to work at.
[Thu Feb 03 14:35:44 2005] [error] [client 127.0.0.1] DBI connect('dbname=template1;host=localhost','sql-ledger',...) failed:
fe_sendauth: authentication type 5 not supported\r, referer: https://localhost/sql-ledger/admin.pl
[Thu Feb 03 14:35:44 2005] [error] [client 127.0.0.1] at SL/User.pm line 509\r, referer: https://localhost/sql-ledger/admin.pl
Any help is appreciated.
Thanks,
Leon Schmets
On Thu, 3 Feb 2005, Leon Schmets wrote: > I downloaded DBD-Pg from http://www.edmund-mergl.de/export/ and found out it > doesn't install on Active perl 5.8. > > fe_sendauth: > authentication type 5 not supported\r, referer: Auth type 5 is md5 authentication that was only introduced in 7.2 which was released early 2002. Since the DBD::Pg driver you have is dated Nov 2000 it does not have support for it. You should really get a newer DBD::Pg, but a temporary workaround would be to use a different auth method. Kris Jurka