Here I am again,
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 = 5432
default_db = lsmb13
host = 127.0.0.1
db_namespace = public
contrib_dir = /usr/share/postgresql/9.1
Perl Version
This is perl, v5.10.1 (*) built for i486-linux-gnu-thread-multi
(with 56 registered patches, see perl -V for more detail)
apache2 error.log from the latest attempt:
[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] DBI
connect('dbname=template1','ledgersmb',...) failed: could not connect to
server: Connection refused, 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.pl
[Sat Mar 17 15:12:04 2012] [error] [client ::1] DBI
connect('dbname=template1','ledgersmb',...) failed: could not connect to
server: Connection refused, referer: http://localhost/ledgersmb/setup.pl
[Sat Mar 17 15:12:04 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:12:04 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
I did this as root and got this output::
grep postgres /etc/services
postgresql 5432/tcp postgres # PostgreSQL Database
postgresql 5432/udp postgres
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.5433
I 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.
Billy
On Sat, Mar 17, 2012 at 3:16 PM, Chris Travers <[email protected]>wrote:
> On Fri, Mar 16, 2012 at 11:11 PM, Robert James Clay <[email protected]>
> wrote:
> > 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.
>
> Either way, both listening IP address and port numbers are stored in
> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
