Well, it turned out that I had two problems. The first is that starting postgres from the init script (/etc/rc.d/init.d/postgresql start) doesn't always start up postgres properly.
Instead, I'm running: postmaster -i -D /var/lib/pgsql/data in my /etc/rc.d/rc.local The error messages misled me into modifying /var/lib/pgsql/data/pg_hba.conf. I had forgotten that the folder is owned by user postgres, so it changed the ownership to root. The init script did NOT report an error, while the postmaster did. Once I started postgres by running postmaster, and fixed ownership of the /var/lib/pgsql/data/pg_hba.conf to belong to user postgres, SQL Ledger started up fine. I still prefer MySQL, but I have learned a lot about postgres ;-) Fred On Tue, 2002-06-18 at 16:46, Fred Laxton wrote: > 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 > -- -- 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 <<< _______________________________________________ sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.mail-archive.com/[email protected]/
