Thanks Jame and Chris!
Jame, you're right. I had 8.4 and 9.0 installed before. I removed them using the Synaptic Package Manager in System.
Chris,
Changed from localhost to 127.0.0.1
Now the section in ledgersmb.conf is set as follows:
port = 5432Perl Version
This is perl, v5.10.1 (*) built for i486-linux-gnu-thread-multi
(with 56 registered patches, see perl -V for more detail)
[Sat Mar 17 15:11:10 2012] [notice] Apache/2.2.16 (Debian) DAV/2 SVN/1.6.12 PHP/5.3.3-7+squeeze8 with Suhosin-Patch configured -- resuming normal operations
[Sat Mar 17 15:11:45 2012] [error] [client ::1] DBI connect('dbname=template1','postgres',...) failed: could not connect to server: Connection refused, referer: http://localhost/ledgersmb/setup.pl[Sat Mar 17 15:11:45 2012] [error] [client ::1] \tIs the server running on host "127.0.0.1" and accepting, referer: http://localhost/ledgersmb/setup.pl
[Sat Mar 17 15:11:45 2012] [error] [client ::1] \tTCP/IP connections on port 5432? at /usr/local/share/perl/5.10.1/LedgerSMB.pm line 981, referer: http://localhost/ledgersmb/setup.pl[Sat Mar 17 15:11:51 2012] [error] [client ::1] \tIs the server running on host "127.0.0.1" and accepting, referer: http://localhost/ledgersmb/setup.pl
[Sat Mar 17 15:11:51 2012] [error] [client ::1] \tTCP/IP connections on port 5432? at /usr/local/share/perl/5.10.1/LedgerSMB.pm line 981, referer: http://localhost/ledgersmb/setup.plI did this as root and got this output::
grep postgres /etc/services
postgresql 5432/tcp postgres # PostgreSQL Database
Doing this as root gave the following:
netstat -lp --protocol=unix | grep postgres
unix 2 [ ACC ] STREAM LISTENING 7348 1658/postgres /var/run/postgresql/.s.PGSQL.5433I don't know if this helps.
I still can't get past the Ledgersmb logon screen.
I really appreciate all the ideas and
help.
Thanks again.
On Fri, Mar 16, 2012 at 11:11 PM, Robert James Clay <..hidden..> wrote:Either way, both listening IP address and port numbers are stored in
> On Sat, 2012-03-17 at 01:53 -0400, Chris Travers wrote:
>> Ok, so my guess is that this is what's happening:
>> 1) PostgreSQL is set to listen on 127.0.0.1 but not ::1 (ipv6)
>> 2) Localhost is mapped to ipv6, not ipv4
>>
>> So the connection is not working.
>>
>> To correct set the db host (host in database section) in
>> ledgersmb.conf to 127.0.0.1.
>
> I wonder if it might be an issue with the port? Billy; when you said
> "I decided to install postgres 9.1", does that mean you had 8.4
> installed before (the default for Squeeze)? And perhaps still do? I
> ask because you can have multiple PostgreSQL versions installed on a
> Debian system and IIRC when the other versions gets installed, the port
> number they use gets incremented.
the postgresql.conf, which will be under an appropriately versioned
directory number in debian.
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users