I can't get Basic Books, a general ledger accounting system, to load on Vector. It works fine on Fedora 6. Please excuse errors I might make here as I am not too familiar with terminology.

Basic Books requires postgresql to be up and running, so I got postgresql up and running first (ver 8.2.4). Following the Basic Books install, it wouldn't run, giving me an libpq.so.4 error. So I linked to libpq.so.5, which is in /opt/postgres/lib. Then I got a "floating point exception." Called Basic Books and was told that my link was OK but Basic Books (and most other software) looks for the shared libraries in /usr/lib. Copied libpq.so, libpq.so.5 and libpq.so.5.0 over to /usr/lib and linked again, but get same "floating point exception" error.

Does it work with 8.2.4 on Fedora? Perhaps it needs an earlier version, which is why it looks for libpq.so.4. Also, it's best to just symlink libs, no need to copy them. Anyway, an app shouldn't have hard-coded lib paths, should it?

Logged

O'Neill (RE the Asgard): "Usually they ask nicely before they ignore us and do what they damn well please."http://joe1962.bigbox.infoRunning: VL 7 Std 64 + self-cooked XFCE-4.10

The postgresql package from the repo installs a script (/etc/profile.d/postgresql.sh) that adds (among other things) the postgresql lib path to the LD_LIBRARY_PATH environment variable on boot, so it should not be necessary to symlink or copy the libs anywhere. The exception is if the lib version number is greater than the needed one, in which case a symlink in the same dir as the lib should do. However, upward compatibility in this case depends on the developers of the lib and cannot be guaranteed by anyone else. Try an earlier postgresql package from the old/ repo, but first save the profile script, as I don't remember on which version it was first added.

Logged

O'Neill (RE the Asgard): "Usually they ask nicely before they ignore us and do what they damn well please."http://joe1962.bigbox.infoRunning: VL 7 Std 64 + self-cooked XFCE-4.10

Before undertaking Joe1962's suggestion that I try an older version of postgresql, I have a couple of questions:

1. Re grannygeek's idconfig suggestion, I can't seem to get idconfig to run. I just don't know what it is.

2. I get a "floating point exception" when I run helloworld. This is the same error I get when trying to run BasicBooks. Is there something I need to add to compile helloworld? If so, perhaps that might solve my BasicBooks problem.

This is becoming pretty complex for a fellow who is mostly an end-user.

My problem now is starting postgresql. I deleted version 8.2.4 (using G-slapt...deleted everything that came up installed when I typed "postgresql" in the search window). I then loaded postgresql 8.1.4 along with the libpqXX file from Slackware 10.2 repository.

I then moved the postgresql.sh that I had saved back to /etc/profile.d/ and ran that script as root from /etc/profile.d and no error (or message). I then exited from root and typed su postgres and entered my password, which I had changed to "postgres" also. That switched me to postgres but gave several errors, as follows:

I think this means that postgresql is not running (easy to tell with 8.2.4 as a "start" icon and a "stop" icon is on the menu, but no such icon on 8.1.4). Again called BasicBooks but received no suggestions that would start postgres. I need to start it in order to try Joe1962's suggestion to use an older version of postgres and would appreciate any further suggestions.

I removed postgresql 8.1.4 (slackware) and installed vector 8.1.5 postgres from the old repository. It did not seem to load right and I was not sure it started. In any event, when running BasicBooks, it gave the same "floating point exception" error and refused to open basic books. I "updated" it to postgresql 8.2 (on the old repository) and it loaded right and started right but when linked to libpq.so.4 gave the same "floating point error." Thinking that an even older version might work, I then downloaded Vector 8.1.4. but had the same problem as with 8.1.5 in that when running the "first time configuration" program, it seems to bug out, i.e it did something, but didn't ask for root or otherwise act properly.

Basic Books tells me that my problems have nothing to do with what version of postgresql I am using. They have sent me a "helloworld" file which gives the same "floating point exception" error that BasicBooks gives and BasicBooks says that until I figure out how to get helloworld to run, I won't get BasicBooks to run.

I would like to email that program, helloworld, and get your comments. If this is a good idea, please sent me an address I can email to.

The problem was the libpq.so link. BasicBooks requires 3.0. Vector 5.8 running Postgres 8.4.2 uses 5.0. BasicBook's install instructions, expressly for Fedora, put the link in /usr/lib. However, in Vector 5.8 running Postgresql 8.4.2, the link must be in /opt/postgresql/lib. So, go to that directory, change to root, and type "ln -s libpq.so.5.0 libpq.so.3", without the quotes. Works fine.