Re: upgrade from 1.2.21 to 1.3.3

["David A. Bandel" <..hidden..>]

2011/11/4 Philippe Schelté <..hidden..>:
> Hello David,
>
>> Postgres is rejecting authentication.  You must allow a connection to
>> 127.0.0.1 and/or ::1 if using IPv6 to the database on port 5432.
>> Check your /etc/postgresql/9.1/main/pg_hba.conf file.  Reconfigure
>> and
>> restart postgresql.  Once you've upgraded the database, you can
>> change
>> these settings back.
>
> I have check pg_hba.conf, it looks ok :

just for the upgrade, change the following (you can change back afterward):

>
> # Database administrative login by UNIX sockets
> local   all         postgres                          ident

change ident above to trust

>
> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>
> # "local" is for Unix domain socket connections only
> local   all         all                               md5

change md5 above to trust

> # IPv4 local connections:
> host    all         all         127.0.0.1/32          md5

again, md5 to trust

> # IPv6 local connections:
> host    all         all         ::1/128               md5

once more, md5 to trust

>
>
> no mention of the 5432 port, but this one is the default of postgresql
> isn't it ?

this is the default port.  I assume you followed the postgresql
database upgrade procedures when you upgraded to 9.1

netstat -pan | grep 543

you should see 5432 but not 5433.

>
>> Please use setup.pl after fixing postgresql hba.
>
> Same blocking Step on the parts when I choose to upgrade the database
> from 1.2 to 1.3
>
>> Again, please use setup.pl and report back.
>
> I understand thatit is useless trying to login to LedgerSMB since I
> haven't upgrade from 1.2 to 1.3
>
> Best
>
> Philippe
>
> --
> http://www.migratis.net
>
>
> ------------------------------------------------------------------------------
> RSA(R) Conference 2012
> Save $700 by Nov 18
> Register now
> http://p.sf.net/sfu/rsa-sfdev2dev1
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>


David-
-- 
Two things are infinite: the universe and human stupidity; and I'm not
sure about the the universe. -- Albert Einstein
Visit my web page at: http://david.bandel.us/