Send Ledger-smb-users mailing list submissions to
       ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

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
       ledger-smb-users-request-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

You can reach the person managing the list at
       ledger-smb-users-owner-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org

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: Question about effects of installing LSMB on  template1
     (Chris Bennett)
  2. Re: Question about effects of installing LSMB on  template1
     (Roderick A. Anderson)
  3. Re: Question about effects of installing LSMB on  template1
     (Chris Travers)
  4. LAN Setup (geordie)
  5. Re: LAN Setup (James Stevens)
  6. Re: LAN Setup (Stroller)
  7. Re: LAN Setup (David A. Bandel)
  8. Re: LAN Setup (Michael Richardson)


----------------------------------------------------------------------

Message: 1
Date: Tue, 28 Apr 2009 16:30:00 -0500
From: Chris Bennett <chris-86bi167hAaZd27BlJj9ntlztOkhRWOSc@public.gmane.org>
Subject: Re: [Ledger-smb-users] Question about effects of installing
       LSMB on template1
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <49F77558.8010405-86bi167hAaZd27BlJj9ntlztOkhRWOSc@public.gmane.org>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed



Chris Travers wrote:
> On Tue, Apr 28, 2009 at 2:09 PM, Chris Bennett
> <chris <at> bennettconstruction.biz> wrote:
>
>> I have someone struggling to install LSMB.
>> He is concerned that because he has an Adempiere app installed already,
>> that connecting to template1 in admin interface will cause trouble for
>> other app.
>>
>> I understand that template1 is used to create new databases, but I saw
>> that some alterations are made to it.
>> Is there any real concern that any database app will cause problems for
>> another?
>>
>
> When a db is created, the template db (usually Template1) is copied to
> that location.
>
>
Let me see if I understand clearly.
You are saying that there is a difference between copying from template1
and installing INTO template1?
> If you install into Template1 you can create new LedgerSMB databases
> just by using createdb.
>
> It won't affect existing db's, but you might find some unpleasent
> surprises when trying to create new databases for other applications.
> And, it is a pain to clean up
>
>
I saw a thread somewhere about how to use template0 to recreate template1.
Does LedgerSMB create databases copying from template1 or installing
into template1?

And since I'm writing my own app for my vendors, customers and current
prices,
what is the right/wrong way to create new databases to avoid problems
with other apps?
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>

--
A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet, balance
accounts, build a wall, set a bone, comfort the dying, take orders,
give orders, cooperate, act alone, solve equations, analyze a new
problem, pitch manure, program a computer, cook a tasty meal, fight
efficiently, die gallantly. Specialization is for insects.
  -- Robert Heinlein




------------------------------

Message: 2
Date: Tue, 28 Apr 2009 14:37:12 -0700
From: "Roderick A. Anderson" <raanders-7IaPL7KgwnzfEv0LIimHRA@public.gmane.org>
Subject: Re: [Ledger-smb-users] Question about effects of installing
       LSMB on template1
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <49F77708.8080002-7IaPL7KgwnzfEv0LIimHRA@public.gmane.org>
Content-Type: text/plain; charset=UTF-8; format=flowed

Chris Bennett wrote:
> I have someone struggling to install LSMB.
> He is concerned that because he has an Adempiere app installed already,
> that connecting to template1 in admin interface will cause trouble for
> other app.
>
> I understand that template1 is used to create new databases, but I saw
> that some alterations are made to it.
> Is there any real concern that any database app will cause problems for
> another?

Should not.  To elaborate on what Chris Travers said.  To do anything
with PostgreSQL you need to be connected to "a database".  Template1 is
just convenient and happens to be the "template" other databases are
created from.  You could connect to postgres users database - postgres.

The process of installing LSMB makes a new database from template1 then
connects to it.

If memory serves me nothing besides the creation of the LSMB database
happens in/to template1.

Sometimes a DBA/DBM may decide to add languages and other functionality
into template1 so new databases get them when created.


\\||/
Rod
--
>
> Chris Bennett
>




------------------------------

Message: 3
Date: Tue, 28 Apr 2009 14:39:00 -0700
From: Chris Travers <chris.travers-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: [Ledger-smb-users] Question about effects of installing
       LSMB on template1
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
       <f5cca7ed0904281439m6da37144o8a4740c5b072c342 <at> mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Apr 28, 2009 at 2:30 PM, Chris Bennett
<chris <at> bennettconstruction.biz> wrote:
>

> I saw a thread somewhere about how to use template0 to recreate template1.
> Does LedgerSMB create databases copying from template1 or installing
> into template1?

It is possible to install into template1, but normally it copies from
template 1.  I suppose we should probably catch this at create
database time and throw an error (we haven't done this yet because
SQL-Ledger didn't and we haven't gotten around to this point).

>
> And since I'm writing my own app for my vendors, customers and current
> prices,
> what is the right/wrong way to create new databases to avoid problems
> with other apps?

Ok.  On the first screen (which includes login info), you can leave it
at template1.  All this does is connect and get a list of current
db's.

On the second screen (with the chart of accounts options), you should
type the db you want to install into.  This should generally not be
template1.

Best Wishes,
Chris Travers



------------------------------

Message: 4
Date: Fri, 1 May 2009 10:16:21 -0400
From: geordie <geordi-cy0mvYQKRb0@public.gmane.org>
Subject: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <200905011016.21736.geordi-cy0mvYQKRb0@public.gmane.org>
Content-Type: text/plain;  charset="us-ascii"

Hi
I need some help in seting LSMB to run on a household LAN. I have tried many
attempts. Between locking up a computer and just reading way to much and
getting confused, I decided I need some help. The senario I thought was quite
simple, I have Debian (Sidux) box with LSMB installed and I would like the
Windows Xp box to have assess to this information.

I believe /etc/postgresql/8.3/main/pg_hba.conf
should be setup like this

local   ledgersmb       all             169.XXX.X.X             md5

/etc/ledgersmb/ledgersmb.conf

DBname       = ledgersmb
DBhost       = localhost (does this need to be changed to 169.XXX.X.X )
DBport       = 5432
DBUserName   = ledgersmb

Do I need to change /etc/hosts

I am assuming apache2.2 needs to be modified, but I am at a loss to figuire
that out.

I am positive that I have missed something else.

I am open to all suggestions or links

Many thanks
Geordie



------------------------------

Message: 5
Date: Fri, 1 May 2009 10:28:06 -0500
From: "James Stevens" <jstevens-i+tpyP9RE+TR7s880joybQ@public.gmane.org>
Subject: Re: [Ledger-smb-users] LAN Setup
To: <ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>
Message-ID:
       <4680436EBAE96A4381400DC3C7B1C4FB03C3E9-Eq7w66SWOw5vAr953HGj7A@public.gmane.orgnk.net>
Content-Type: text/plain;       charset="us-ascii"

Change you point of view and you can easily accomplish this.

the pg_hba.conf file is telling Debian(postgreSQL) wher to listen and
how to authenticate sql sessions. It only needs to listen localy and
authenticate in that manner (trust). Authenticate the user ledgersmb in
your case localy.

Once that is done, meaning it works on the machine installed on you are
looking at apache to service request to remote users.
Which it should already our of the box.

Knowing the IP address of the Debian machine ( CLI-> ifconfig )
got to your Windows machine and typ http://<ipaddress of the
debian>/ledgersmb/admin.pl

What do you see?

Also go to http://<ipaddress of debian box>/

and tell us what you see...    i.e.
http://192.168.1.1/ledgersmb/login.pl

-----Original Message-----
From: geordie [mailto:geordi-cy0mvYQKRb0@public.gmane.org]
Sent: Friday, May 01, 2009 9:16 AM
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: [Ledger-smb-users] LAN Setup

Hi
I need some help in seting LSMB to run on a household LAN. I have tried
many
attempts. Between locking up a computer and just reading way to much and

getting confused, I decided I need some help. The senario I thought was
quite
simple, I have Debian (Sidux) box with LSMB installed and I would like
the
Windows Xp box to have assess to this information.

I believe /etc/postgresql/8.3/main/pg_hba.conf
should be setup like this

local   ledgersmb       all             169.XXX.X.X             md5

/etc/ledgersmb/ledgersmb.conf

DBname       = ledgersmb
DBhost       = localhost (does this need to be changed to 169.XXX.X.X )
DBport       = 5432
DBUserName   = ledgersmb

Do I need to change /etc/hosts

I am assuming apache2.2 needs to be modified, but I am at a loss to
figuire
that out.

I am positive that I have missed something else.

I am open to all suggestions or links

Many thanks
Geordie

------------------------------------------------------------------------
------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

--
This message has been scanned for viruses and
dangerous content by SISLINK.NET. Come join us!


--
This message has been scanned for viruses and
dangerous content by SISLINK.NET. Come join us!




------------------------------

Message: 6
Date: Sat, 2 May 2009 13:53:04 +0100
From: Stroller <stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org>
Subject: Re: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
       <C2B60AE7-D94D-4555-BE4B-705285B2B4D0-J8c/PZ/aHpDUCtIbO7P5FQ@public.gmane.org.co.uk>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes


On 1 May 2009, at 15:16, geordie wrote:
> ...
> DBhost       = localhost
> does this need to be changed to 169.XXX.X.X ?

I believe it does, assuming you can ping that address from the Windows
box.

As James observes, this is a slightly unusual network range to use -
192.168.x.y would be more common.

Stroller.





------------------------------

Message: 7
Date: Sat, 2 May 2009 08:28:11 -0500
From: "David A. Bandel" <david.bandel-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Subject: Re: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID:
       <ea6cc0c70905020628p280e2521m1e9c8626b411acba <at> mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On Sat, May 2, 2009 at 7:53 AM, Stroller <stroller-J8c/PZ/aHpCP1P/rox5WkSp2UmYkHbXO@public.gmane.org> wrote:
>
> On 1 May 2009, at 15:16, geordie wrote:
>> ...
>> DBhost ? ? ? = localhost
>> does this need to be changed to 169.XXX.X.X ?

169.254.0.0/16 is a "zeroconf" address -- it's what Windoze uses when
it gets lost (can't figure out what it's address should be), but there
are zeroconf utilities for Linux and other Unices as well.

>
> I believe it does, assuming you can ping that address from the Windows
> box.
>
> As James observes, this is a slightly unusual network range to use -
> 192.168.x.y would be more common.

RFC 1918 outlines the following addresses for use within private networks:

    10.0.0.0        -   10.255.255.255  (10/8 prefix)
    172.16.0.0      -   172.31.255.255  (172.16/12 prefix)
    192.168.0.0     -   192.168.255.255 (192.168/16 prefix)

However, 169.254.0.0/16 is considered a bogus address. It can be found
in the bogon listings and will be dropped by properly configured
routers, so can be used as a private address group (but that's not
recommended).

>
> Stroller.
>
>
>
>

Ciao,

David A. Bandel
--
Focus on the dream, not the competition.
           - Nemesis Air Racing Team motto



------------------------------

Message: 8
Date: Sat, 02 May 2009 23:25:38 -0400
From: Michael Richardson <mcr <at> sandelman.ca>
Subject: Re: [Ledger-smb-users] LAN Setup
To: ledger-smb-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Message-ID: <28671.1241321138-mBdsjq6qcbCdmVUUUnPabdsHgeflEswW@public.gmane.org>
Content-Type: text/plain; charset=iso-8859-1


>>>>> "David" == David A Bandel <david.bandel-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> writes:
   David> 169.254.0.0/16 is a "zeroconf" address -- it's what Windoze
   David> uses when it gets lost (can't figure out what it's address
   David> should be), but there are zeroconf utilities for Linux and

 That's not fair.
 Windoz does get lost lots, but 169.254.0.0/16 was allocated
specifically for zeroconf, and it's a legitimate way to do networking.
 That windoz fails into using their network, and often route 0.0.0.0/0
to this LAN, so anyone within wireless listening of you can hijack *ALL*
your traffic, is certainly a sin, but...

 As you say, Linux and Mac (and Cisco and ...) can easily participate
in such a network, which usually is what you would permit to be
configured if you and your friends are having a LAN party in the middle
of the park.

 I would not call it a bogus address for this reason.
 It's not crazy to use this on your LAN, given Bonjour/LLDMS/mDNS/Avahi
(whichever you want to call it), you can use it along with a stable
name.
 I just don't recommend it either.

--
]     Y'avait une poule de jamm? dans l'muffler!!!!!!!!!        |  firewalls  [
]   Michael Richardson, Sandelman Software Works, Ottawa, ON    |net architect[
] mcr-SWp7JaYWvATD9fKxiKbVOGG8O1WwMoTE@public.gmane.org http://www.sandelman.ottawa.on.ca/ |device driver[
] panic("Just another Debian GNU/Linux using, kernel hacking, security guy"); [





------------------------------

------------------------------------------------------------------------------
Register Now & Save for Velocity, the Web Performance & Operations
Conference from O'Reilly Media. Velocity features a full day of
expert-led, hands-on workshops and two days of sessions from industry
leaders in dedicated Performance & Operations tracks. Use code vel09scf
and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf

------------------------------

_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


End of Ledger-smb-users Digest, Vol 33, Issue 1
***********************************************