Re: [SQL-Ledger-users] New User Install problems on Debian system

[Steve D. <sd...@sw...>]

Hi John.

Check if you can log in through the localhost:

psql -h localhost -d template1

or if you have a network (you'll have to look at pg_hba.conf also),

psql -h "your postgres server ip" -d template1

If not, check postmaster.init and make sure PGALLOWTCPIP=yes and port=5432
is uncommented.  If these aren't set, you'll have to restart postgres after
you change them.

Also make sure you have the package libdbd-pg-perl installed for dbi/dbd
(sounds like you're ok here).

That should do it.
Steve

John Foster wrote:

> I have just installed the latest version of SQL-Ledger on my
> Debian Woody/Sid system. I keep getting the error "database is offline"
> however I am able to login and edit the database from the command line
> using the >psql command, and also using Webmin. I noticed that you have
> the "Driver=Pg" in your example.

The driver is correct.

> This may be correct for my system but I
> am not sure. I do have gdbm, db, dbi, odbc, modules for apache, perl,
> postgresql, all installed. I am at a loss as to what I am doing wrong. I
> simply can not get the scripts to login to the database. I have the
> sql-ledger installed in /var/www/sql-ledger. I have created a symlink
> from there to /usr/lib/cgi-bin. This is working. I was able to add
> myself as a user and followed your example.

Not sure why you could add a user if you can't log in, but try the above.

> I must say that I have been
> using MySQL for several years, but this is my first attempt to use
> Postgresql. I have postgreSQL7.0 installed and boot mesg shows the
> postmaster is running. Any tips or pointers would be appreciated.
> --
>
> John Foster