[WYLUG-help] PostgreSQL and SQL-Ledger

[Mike Goodman]

Some progress - I found pg_hba.conf in /etc/postgresql/8.1/main/ and
there is only one copy, which is an improvement on v7.4 which had
another one in /var/libs/postgresql/data, if I remember correctly. So I
changed the one under /var at that time. No cause for confusion in v8.1.
Changed method to password (from ident sameuser) so that line now reads
loca all all password, saved and ran /etc/init.d/postgresql-8.1 restart

I got as far as setting up the default dataset then tried to set up a
second one with another user and got the same old error:
> Error!
> CREATE SEQUENCE id start 10000
> ERROR: relation "id" already exists
> 
Can anyone tell me how I can set up datasets for my other two users? How
can I get over this problem of whatever sets the IDs' inability to set
another one? Am I doing something wrong?

Getting to the stage now where just abut any ideas would be appreciated.
Pointing sticks at it whilst chanting incantations? ;-)

The last time I got this result, a google showed lots of people
experiencing similar problems whilst installing and configuring a number
of apps, but there did not seem to be too many helpful answers.

TIA Mike

On Sun, 2006-06-04 at 17:02 +0100, Mike Goodman wrote:
> Moving on:
> 
> I tried to start again, but this time with a nice shiny new version of postgresql:
> 
> apt-get --purge remove postgresql
> 
> This gave a files not empty error so directories /etc/postgresql and /var/lib/postgres would not be removed.
> 
> I removed them using rm -fr then went on to delete everything I could find to do with sql-ledger.
> 
> I then installed PostgreSQL-8.1 running apt-get -t sarge-backports install postgresql-8.1 postgresql-client-8.1
> 
> Next I cd'ed to /usr/local and ran tar xzvf sql-ledger-2.6.12.tar.gz, created sql-ledger-httpd.conf in
> /etc/apache2/, added the include to it statement in apache2.conf and altered permissions on the relevant directories in /usr/local/sql-ledger to www-data:www-data
> 
> I've renamed sql-ledger.conf.default to sql-ledger.conf and edited it (only had to remove one f the two default printers).
> 
> Next, su'ed to postgres and set up three new users with passwords.
> 
> Opened up /sql-ledger/admin.pl in a workstation browser and tried to create a dataset using one of the new users. Got the error:
> 
> > Error!
> > 
> > FATAL: Ident authentication failed for user "sql-ledger"
> 
> I strongly suspect that's a wrong configuration in pg_hba.conf but
> that's not where it used to be in v7.4!! and the find command draws a
> blank.
> 
> Incidentally, whilst looking for it I found a file or directory 
> /var/lib/postgres/dumpall/7.4 - perhaps I should have deleted the
> client, too.
> 
> Can anyone help me, please?
> 
> TIA Mike
> 
> 
> _______________________________________________
> Wylug-help mailing list
> Wylug-help at wylug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/wylug-help