On Sat, Mar 17, 2012 at 2:36 PM,
<..hidden..> wrote:
Send Ledger-smb-users mailing list submissions to
..hidden..
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
or, via email, send a message with subject or body 'help' to
..hidden..
You can reach the person managing the list at
..hidden..
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Ledger-smb-users digest..."
Today's Topics:
1. Re: ledgersmb password problem (Chris Travers)
2. Re: ledgersmb password problem (billy akazawa)
3. Re: ledgersmb password problem (Robert James Clay)
4. Re: ledgersmb password problem (Chris Travers)
5. Re: ledgersmb password problem (Robert James Clay)
6. Re: ledgersmb password problem (Chris Travers)
7. Re: ledgersmb password problem (billy akazawa)
----------------------------------------------------------------------
Message: 1
Date: Fri, 16 Mar 2012 22:18:12 -0700
From: Chris Travers <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID:
<..hidden..>
Content-Type: text/plain; charset=ISO-8859-1
On Fri, Mar 16, 2012 at 10:02 PM, billy akazawa <..hidden..> wrote:
> Hi,
>
> Thank you for the super-fast response.
>
> I can get up to the Data Management Console now and fill in the information.
> The problem is the next screen demands the ledgersmb password, which I don't
> know.
Next question:
which distro are you running?
Best Wishes,
Chris Travers
------------------------------
Message: 2
Date: Sat, 17 Mar 2012 14:34:03 +0900
From: billy akazawa <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID:
<CAHS2MNWcuj2iA_LgE8zOK0JuCdWeY4BuY_XW4JhccioRBU=..hidden..>
Content-Type: text/plain; charset="iso-8859-1"
Hello again,
Thanks for staying with me on this nightmare problem.
Linux version 2.6.32-5-686 (Debian 2.6.32-41) (..hidden..) (gcc
version 4.3.5 (Debian 4.3.5-4) ) #1 SMP Mon Jan 16 16:04:25 UTC 2012
Thanks again!
Billy
On Sat, Mar 17, 2012 at 2:18 PM, Chris Travers <..hidden..>wrote:
> On Fri, Mar 16, 2012 at 10:02 PM, billy akazawa <..hidden..>
> wrote:
> > Hi,
> >
> > Thank you for the super-fast response.
> >
> > I can get up to the Data Management Console now and fill in the
> information.
> > The problem is the next screen demands the ledgersmb password, which I
> don't
> > know.
>
> Next question:
>
> which distro are you running?
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 3
Date: Sat, 17 Mar 2012 01:49:35 -0400
From: Robert James Clay <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID: <..hidden..>
Content-Type: text/plain; charset="UTF-8"
Billy,
On Sat, 2012-03-17 at 01:34 -0400, billy akazawa wrote:
> Linux version 2.6.32-5-686 (Debian 2.6.32-41) (..hidden..)
> (gcc version 4.3.5 (Debian 4.3.5-4) ) #1 SMP Mon Jan 16 16:04:25 UTC
> 2012
You're running Debian Testing (Squeeze)? (You running Pg 9.1 but
that's in squeeze-backports, & that's the current kernel in squeeze.)
Which means Perl 5.10.
Jame
------------------------------
Message: 4
Date: Fri, 16 Mar 2012 22:53:17 -0700
From: Chris Travers <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID:
<..hidden..>
Content-Type: text/plain; charset=ISO-8859-1
On Fri, Mar 16, 2012 at 10:49 PM, Robert James Clay <..hidden..> wrote:
> Billy,
>
> On Sat, 2012-03-17 at 01:34 -0400, billy akazawa wrote:
>> Linux version 2.6.32-5-686 (Debian 2.6.32-41) (..hidden..)
>> (gcc version 4.3.5 (Debian 4.3.5-4) ) #1 SMP Mon Jan 16 16:04:25 UTC
>> 2012
>
> ? You're running Debian Testing (Squeeze)? ?(You running Pg 9.1 but
> that's in squeeze-backports, & that's the current kernel in squeeze.)
> Which means Perl 5.10.
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.
Best Wishes,
Chris Travers
------------------------------
Message: 5
Date: Sat, 17 Mar 2012 02:11:06 -0400
From: Robert James Clay <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID: <..hidden..>
Content-Type: text/plain; charset="UTF-8"
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.
Jame
------------------------------
Message: 6
Date: Fri, 16 Mar 2012 23:16:50 -0700
From: Chris Travers <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID:
<..hidden..>
Content-Type: text/plain; charset=ISO-8859-1
On Fri, Mar 16, 2012 at 11:11 PM, Robert James Clay <..hidden..> 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
------------------------------
Message: 7
Date: Sat, 17 Mar 2012 15:35:52 +0900
From: billy akazawa <..hidden..>
Subject: Re: [Ledger-smb-users] ledgersmb password problem
To: ..hidden..
Message-ID:
<..hidden..>
Content-Type: text/plain; charset="iso-8859-1"
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.
Hi Frans here
I see u cannot past the ledgersmb logon screen?? This has nothing to do with the postgresql.
This only has to do with perl and apache. It looks like that you did not change ledgersmb.conf.template into ledgersmb.conf
further on did u use sh install.sh? Run server as www-data etc?
The ledgersmb-httpd.conf should be in file /etc/apache2/conf.d and only listen to localhost and 127.0.1.1
regards
frans
e
On Sat, Mar 17, 2012 at 3:16 PM, Chris Travers <..hidden..>wrote:
> On Fri, Mar 16, 2012 at 11:11 PM, Robert James Clay <..hidden..>
> 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 sectio n) 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
------------------------------------------------------------------------------
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
End of Ledger-smb-users Digest, Vol 66, Issue 14
************************************************