Re: Windows XP Installation Blues - 2nd Try

[kgendrich <..hidden..>]

Resolution:  in ledgersmb\trunk\ledgerSMB\sysconfig.pm  there is a comment
# For win32: change $pathsep to ';';
$pathsep = ':';

I changed this to $pathsep = ';' and I am now on my way.

I presume this is becuase there is parsing of the Path done in Dynaloader.pm
for the loader to look for dll's (rather than depend on operating system
specific search mechanisms).

so, I think both problems existed.  I havent removed those path statements
for llibqa.dll yet to test, and of course I don't really care, except to
delete the llibqa.dll from windows\system32 because it of course will never
get updated if there is a change to that file.

Thanks again for your assistance:

I have a good bet that most people give up on the windows install long
before this.  When I recover some time :), I may contribute a better windows
for newbies document.

- Ken

PS.  My signature still fails but this is probably to my ignorance of using
gpg....


kgendrich wrote:
> 
>>>I have run into this problem before.  Iirc, the error message is
misleading
>>>and the actual problem is an inability to load libpq.dll from the
PostgreSQL
>>>installation.  You have two options that I can think of:
>>>1)  Copy libpq.dll into C:\Windows\System32
>>>or
>>>2)  Adjust the PATH environment variable to point ot where libpq.dll is
>>>installed (probably C:\Program Files\PostgreSQL\8.2\lib\)
> 
> Interesting.  I tried both, with no avail to "perl admin.pl"  (Using a
> fresh cmd shell)
> But, now, when I delete all the .0s and remake dbd-pg-149, the dbtest
> passes for dbd-pg-149
> I also verified that all the PG.dll's on my system have the same date/time
> stamp, both in the arch folder of the temporary (test passed) and the perl
> auto location
> 
> However, "perl admin" still fails at line 230 of dynaloader.pm
> 
> In dynaloader.pm there is a comment immediately prior to this load.
> # Many dynamic extension loading problems will appera to come from 
> # this section of code: XYZ failed at line abc of DynaLoader.pm
> # often these errors are actually occurring in the initialisation 
> # C code of the extension XS file.  Perl reports the error as being 
> # in this perl code simply becaue this was the last perl code it executed.
> 
> This is consisten with your statement that it is a misleading error, but
> it brings me back to the "malformed" path name using \ instead of /'s.  
> Is this supposed to be resolved by the loader...?
> 
> Which would be odd, since it would imply that no-one running windows and
> this version of dbd::Pg
> can connect to the database 
> 
> - Ken
> 
> 
> Chris Travers-5 wrote:
>> 
>> On 10/11/07, Kenneth Gendrich <..hidden..> wrote:
>>>
>>> Hi
>>>
>>> I've read through the archives and could not find many good stories on
>>> windows xp installs.
>>> I have had a recent steep learning curve, and have muddled through it.
>>> I now find myself stuck in about 3 feet of mud and need an escape
>>> before I give up and go buy a mac :)
>>>
>>> So, here is what I've done so far.
>>> 1.  Learned about gzip, untar
>>> 2.  Installed and started apache 2.2.6
>>> 3   Installed and started postgres sql 8.2.5
>>> 4.  Installed and built dmake
>>> 5.  Installed active perl
>>> 6.  Uninstalled active perl :)
>>> 7.  Installed perl 5.8.8 (vanilla-perl)
>>> 8.  Downloaded what appears to be 1.2.99 from the ledger-smb.org site
>>> 9.  Found the README file
>>> 10.Learned about "perl build.pl"
>>> 11.Discovered CPAN  (many times)
>>> 12. Built every dependency EXCEPT for DBD::Pg
>>> 13. Slept 6 hrs, started again...
>>> This is where I am stuck.
>>> I have tried CPAN DBD::Pg (Forgot what went wrong after 2 hrs of
>>> research)
>>> I have tried downloading the PG-1.49 source for windows (2x)
>>> [both appear to make and compile fine, but fail the signature test and
>>> the Use DBG::Pg tests]
>>> There is a strange error.  I say strange because the system fails to
>>> load pg.dll even though pg.dll is in the specified location
>>> Can't load 'C:\dbd\DBD-Pg-1.49\blib\arch/auto/DBD/Pg/Pg.dll' for
>>> module DBD::Pg: load_file:The specified module could not be found at
>>> C:/vanilla-perl/perl/lib/DynaLoader.pm line 230.
>> 
>> 
>> 
>> I have run into this problem before.  Iirc, the error message is
>> misleading
>> and the actual problem is an inability to load libpq.dll from the
>> PostgreSQL
>> installation.  You have two options that I can think of:
>> 1)  Copy libpq.dll into C:\Windows\System32
>> or
>> 2)  Adjust the PATH environment variable to point ot where libpq.dll is
>> installed (probably C:\Program Files\PostgreSQL\8.2\lib\)
>> 
>> See attachment DBFTestfail.png
>>> What's strange is that pg.dll IS in that location AND  notice the /
>>> after "arch" that should be a \
>>>
>>> I even modified the makefile.pl where this is specified, after which
>>> make failed miserably....
>>>
>>> So, I installed the component anyway, successfully, and then guess
>>> what perl admin.pl turned up:
>>> install_driver(Pg) failed: Can't load
>>> 'C:/vanilla-perl/perl/site/lib/auto/DBD/Pg
>>> /Pg.dll' for module DBD::Pg: load_file:The specified module could not be
>>> found a
>>> t C:/vanilla-perl/perl/lib/DynaLoader.pm line 230.
>>>
>>> Same error message, but correct slashes and the file is really there as
>>> well...
>>> See Attachment AdminFail.png
>>>
>>> Final questions:  Is there a windows template of ledgersmb.conf, I had
>>> to guess on a lot of settings
>>> Most of all, what is the database name?  Is it host, localhost or the
>>> database instance in pg_adminIII?
>>>
>>> DBI_DSN=dbi:Pg:dbname=postgres
>>> DBI_PASS=postgres
>>> DBI_USER=postgres
>>>
>>> Thanks, I hope there is a guru out there to get me past this roadblock
>>> ....
>>>
>>> - Ken G
>>>
>>> -------------------------------------------------------------------------
>>> This SF.net email is sponsored by: Splunk Inc.
>>> Still grepping through log files to find problems?  Stop.
>>> Now Search log events and configuration files using AJAX and a browser.
>>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>>> _______________________________________________
>>> Ledger-smb-users mailing list
>>> ..hidden..
>>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>>
>> 
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Splunk Inc.
>> Still grepping through log files to find problems?  Stop.
>> Now Search log events and configuration files using AJAX and a browser.
>> Download your FREE copy of Splunk now >> http://get.splunk.com/
>> _______________________________________________
>> Ledger-smb-users mailing list
>> ..hidden..
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>> 
>> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Windows-XP-Installation-Blues---2nd-Try-tf4607181.html#a13177037
Sent from the Ledger SMB - Users mailing list archive at Nabble.com.