Topic: How to install SQL Ledger

[wjhobbs]

Dave,

I was following your excellent how-to and then got stuck.

I succeeded in getting PostgreSQL installed. But then when when it came time to update Perl, I ran into a problem. Your instructions say:

cpan> install DBI
(Lots of things happen - check right at the end to see that the operation completed OK)

But you don't say what to do if the operation did not complete OK.

At the end of the 'install DBI' process I got a message that said:

12 tests and 135 subtests skipped.
failed 2/43 test scripts, 95.35% okay. 0/2058 subtests failed, 100.00% okay.
make: *** [test_dynamic] error 11
   /usr/bin/make test -- NOT OK
Running make install
   make test had returned bad status, won't install without force
 
Any suggestions for getting beyond this would be much appreciated. Please bear in mind that I am not a programmer or an experienced Linux person -- but I can usually follow specific instructions.

Thanks for your help.

John[/quote]

[dave_d]

Hello John,

Did you get past your error condition yet?  If not I may be able to help.  I'm just starting a rebuild of my developement server and so I can run the installation again and check my original instructions.

regards,

Dave

[wjhobbs]

Hi Dave,

The problem persists.

I have a fresh install of 6.0.1-01 on a small test machine. I installed Plone using Des Dougan's RPMs (I still have a minor problem there setting up the ProxyPass in httpd.conf) but that's a separate issue.

I installed PostgreSQL 7.4.2 using Michel's HowTo from Sleepy SME as the first step in your HowTo.

I then created an i-bay as instructed, downloaded and installed the four RPMs as specified.

The '# perl -MCPAM -eshell' seemed to work fine.

But the 'cpan> install DBI' failed as noted in my previous post. The messages flew by fairly quickly -- but I seem to recall something that seemed to indicate it expected a component that wasn't there. (I'm so new to this stuff that I don't know how to scroll back through the messages to find out what I saw.)

And that's where I am. I just bought a copy of "Learning Perl" so that I can get better at understanding what the SME Server is all about. I'm a real novice.

I would appreciate any help you can give.

John

[dave_d]

Hello John,

I'll install it again during the next day or so using a clean 6.0.1-01 server.  As soon as I've found time to do it I'll let you know how things went!

Regards,

Dave

[wjhobbs]

Dave,

What version of perl do you have installed? I think SME 6.01 has perl 5.6 installed and I think something in the DBI install process needs 5.8 -- but I don't know if this is the source of my problem.

John

[dave_d]

Hello John,

I just completed an installation of SQL-Ledger on a new 6.0.1-01 server.  I've edited the very first post in this thread to include a couple of steps that I missed out! (the result of continually using a single server to do lots of test work, I'm afraid).

Anyway, it worked for me!

Regards,

Dave

[wjhobbs]

Dave,

Your revised procedure worked like a charm!

Thanks.

John

[warren]

Dave,

Great stuff. One change though,

# pico 95sql-ledger
(insert the following ...)


Alias /html /sql-ledger/ /home/e-smith/files/ibays/sql-ledger/html/

Should Read

Alias /sql-ledger/ /home/e-smith/files/ibays/sql-ledger/html/

Thnks

Warren

[dave_d]

Thanks Warren, you're quite right. I must be getting sloppy in my dotage!

I've changed the post accordingly.  See too my comment near the bottom of the post regarding the creation of the sql-ledger user.

Regards,

Dave

[jester]

I've been trying your howto but on a SME7beta8 installation...

- I had postgres allready installed with an (test) installation of open-xchange (postgresql-7.4.8-1)
- A 'yum install gcc' seemed to work for installing the needed files for the extra perl modules.
- Installing CPAN, MD5, Storable, DBI went fine as well

But installing DBD::Pg is different from the install in SME6.0. I get the following questions wich i can't seem to answer correctly 'cause the install is ending with an NOT OK error:

* Path to pg_config ?!
* Postgres major version number ?! (7)
* Postgres minor version number ?! (4)
* Postgres patch number ?! (
* valid PostGreSQL include dir ?!
* valid PostGreSQL library dir ?!

Someone who knows the (right) answers to the above questions?!

Regards,
jester.