Thread: Activeperl 5.8 on windows and postgres 8

Activeperl 5.8 on windows and postgres 8

From
"Leon Schmets"
Date:
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size:
10.0pt;font-family:Arial">Hi all,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">I am in the process of installing SQL-Ledger. I am unfamiliar with Postgres not with
Perl.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">I downloaded DBD-Pg from http://www.edmund-mergl.de/export/ and found out it doesn’t install
onActive perl 5.8.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">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. </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-US" style="font-size: 
10.0pt;font-family:Arial">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.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">The connection to the database fails because it cannot load the pg.dll. Looking into that I
foundthat this dll refers directly to perl56.dll which of course is part of ActivePerl 5.6 which I have not installed.
SoI patched the dll and again got a little further. No more error messages about failing to load a dll. Now a real
connecterror pops up, which I have no idea to work at.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal" style="margin-left:35.4pt"><font face="Arial"
size="2"><spanlang="EN-US" style="font-size:10.0pt;font-family:Arial">[Thu Feb 03 14:35:44 2005] [error] [client
127.0.0.1]DBI connect('dbname=template1;host=localhost','sql-ledger',...) failed: </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial">                                                           <i><u><span
style="font-style:italic">fe_sendauth:authentication type 5</span></u></i> not supported\r, referer:
https://localhost/sql-ledger/admin.pl</span></font><pclass="MsoNormal" style="text-indent:35.4pt"><font face="Arial"
size="2"><spanlang="EN-US" style="font-size:10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"
style="text-indent:35.4pt"><fontface="Arial" size="2"><span lang="EN-US"
style="font-size:10.0pt;font-family:Arial">[ThuFeb 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</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanlang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Any help is appreciated.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
lang="EN-US"style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Thanks,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Leon Schmets</span></font></div>

Re: Activeperl 5.8 on windows and postgres 8

From
Kris Jurka
Date:

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