I used to use SQL Ledger 1.8.2 and 1.8.3, and then I had a hard drive failure and lost my Linux root partition. This was on Mandrake 8.0.
I've since gotten a new drive, installed Mandrake 8.2, and am trying to get SQL Ledger 1.8.4, with the patch, up and running. When I try to use the PG Database Administration page during setup, I set it to: Host: 192.168.0.223 - IP of the machine hosting the site Port: (blank) User: sqlledger Password: <password for postgrers user sqlledger> Connect to: sqlledger I already created postgres user "sqlledger" using Webmin, and created database "sqlledger". I get message: could not connect to server: Connection refused My /var/lib/pgsql/data/pg_hba.conf contains: local all trust host all 192.168.0.223 255.255.255.0 trust Here's another error when I change the parameters: Host: (blank) Port: (blank) User: sqlledger Password: <password for postgres user sqlledger> Connect to: sqlledger FATAL 1: No pg_hba.conf entry for host localhost, user sqlledger, database sqlledger Yet I specifically have a line in pg_hba.conf that says "local all trust" which should do it. Sheesh! One other difference with the last install I did: webmin didn't see that postgres was installed, so I had to locate the configuration files and point webmin to them. Then it was able to access postgres and see the template0 and template1 databases that were already there, for example. I'm new to postgres, I find MySQL much easier to work with - I really wish SQL Ledger used MySQL instead, it's so easy to work with ;-) Oh, and PHP, too ;-) But, if I can get it working, I'll settle for Perl and Postgres... TIA Fred -- -- Fred Laxton My contact information: http://infotechdesign.net/my_contact_information.htm Powered by Yellow Dog Linux and Mandrake Linux ---------------------------------------------------------------------------- Bringing you mounds of caffeinated joy >>> http://thinkgeek.com/sf <<< _______________________________________________ Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users
