On Sat, Mar 17, 2012 at 2:36 PM, <
[email protected]> wrote:
> Send Ledger-smb-users mailing list submissions to
> [email protected]
>
> 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
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> 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 <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID:
> <cakt_zfvis6af0880ogbqty7bzht7zywjxja-77xe29oube-...@mail.gmail.com
> >
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Fri, Mar 16, 2012 at 10:02 PM, billy akazawa <[email protected]>
> 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 <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID:
> <CAHS2MNWcuj2iA_LgE8zOK0JuCdWeY4BuY_XW4JhccioRBU=9...@mail.gmail.com
> >
> 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) ([email protected]) (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 <[email protected]
> >wrote:
>
> > On Fri, Mar 16, 2012 at 10:02 PM, billy akazawa <[email protected]>
> > 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
> > [email protected]
> > 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 <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID: <1331963375.30732.6.camel@svrpc>
> 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) ([email protected])
> > (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 <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID:
> <cakt_zfujxop0pjn1kqp4vrxrssz6ka52sz6mqmhnvzymirg...@mail.gmail.com
> >
> Content-Type: text/plain; charset=ISO-8859-1
>
> On Fri, Mar 16, 2012 at 10:49 PM, Robert James Clay <[email protected]>
> 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) ([email protected])
> >> (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 <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID: <1331964666.30732.16.camel@svrpc>
> 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 <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID:
> <cakt_zftrzx30z0pmnc7957cgqrvoopbb_3lk6587pnw4r4k...@mail.gmail.com
> >
> Content-Type: text/plain; charset=ISO-8859-1
>
> 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
>
>
>
> ------------------------------
>
> Message: 7
> Date: Sat, 17 Mar 2012 15:35:52 +0900
> From: billy akazawa <[email protected]>
> Subject: Re: [Ledger-smb-users] ledgersmb password problem
> To: [email protected]
> Message-ID:
> <cahs2mnvn7ay8ikpqlvb98yhvybkgb2yuarugmp20xc+bspt...@mail.gmail.com
> >
> 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 <
> [email protected] <[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 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
> > [email protected]
> > 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
> End of Ledger-smb-users Digest, Vol 66, Issue 14
> ************************************************
>
------------------------------------------------------------------------------
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
