It looks like my postgresql install is messed up somewhere, now I get an error when I try to run
[postgres@linux fred]$ psql psql: FATAL 1: No pg_hba.conf entry for host localhost, user postgres, database postgres even though I'm running as user "postgres" I've tried messing with the /var/lib/pgsql/data/pg_hba.conf file, and can't seem to make it work no matter what I do. After each change, I issue (as root): kill -s sighup #### where #### is the PID of the postgres postmaster... Any help would be appreciated! Thanks, Fred On Tue, 2002-06-18 at 14:01, Fred Laxton wrote: > 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 > -- -- 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
