Re: [Ledger-smb-devel] PostgreSQL release cycles and LedgerSMB 1.3

2011-06-13 Thread Adam Thompson
> LedgerSMB 1.3 officially was written with the idea that it would require > PostgreSQL 8.1 or higher. 8.1 is effectively end-of-lifed in the sense > that > new updates, including security updates, are no longer available from > the project web site. Some vendors (such as Red Hat) continue to su

Re: [Ledger-smb-devel] State of Perl-based database setup utilities for LedgerSMB 1.3

2011-05-28 Thread Adam Thompson
> Where would the data be stored? Do we require write permissions to > the ledgersmb directory? Um, in the case I was describing, yes, I think so. In the examples I've seen, the administrator has the choice of either configuring their webserver & system to allow the PHP script to write to the

Re: [Ledger-smb-devel] State of Perl-based database setup utilities for LedgerSMB 1.3

2011-05-28 Thread Adam Thompson
ry; that check would get automatically triggered if, say, you mucked around on the backend and broke logins. (But you'd get a different error if the app couldn't connected to the database at all.) In short: initial

Re: [Ledger-smb-devel] State of Perl-based database setup utilities for LedgerSMB 1.3

2011-05-28 Thread Adam Thompson
> -Original Message- > From: Luke [mailto:account...@lists.tacticus.com] > Sent: Friday, May 27, 2011 21:28 > To: Development discussion for LedgerSMB > Subject: Re: [Ledger-smb-devel] State of Perl-based database setup > utilities for LedgerSMB 1.3 > > On Fri, 27 May 2011, Chris Travers wr

Re: [Ledger-smb-devel] State of Perl-based database setup utilities for LedgerSMB 1.3

2011-05-27 Thread Adam Thompson
software is excellent quality control exercise in and of itself. -Adam "David F. Skoll" wrote: >On Fri, 27 May 2011 16:23:30 -0500 >Adam Thompson wrote: > >> My point was that effectively, because of the way installs work right >> now, build deps and installed de

Re: [Ledger-smb-devel] State of Perl-based database setup utilities for LedgerSMB 1.3

2011-05-27 Thread Adam Thompson
May 2011 15:59:57 -0500 >Adam Thompson wrote: > >> Make (1) is already effectively a mandatory dependency due to all the >> perl modules that must currently be installed, > >It's a build dependency, but should it be a run-time dependency? >I don't th

Re: [Ledger-smb-devel] State of Perl-based database setup utilities for LedgerSMB 1.3

2011-05-27 Thread Adam Thompson
Make (1) is already effectively a mandatory dependency due to all the perl modules that must currently be installed, and possibly barring OpenBSD with the recent work, I don't know of a single distro that packages all the deps. (and, of course, make is required anyway for OpenBSD ports) -Adam C

Re: [Ledger-smb-devel] Much more evolved database preparation script

2011-05-26 Thread Adam Thompson
, but stop trying to accommodate everyone's personal preferences, and pick a platform. *Then*, once it's working *somewhere*, worry about getting it working everywhere. -Adam Thompson athom...@athompso.net > -Original Message- > From: Erik Huelsmann [mailto:ehu...@gmail.

Re: [Ledger-smb-devel] Features you would like to see in 2.0

2010-07-29 Thread Adam Thompson
I already said this in a previous email, but: # Robust installation documentation. (Not "simplified installation", I just want a single set of detailed install instructions that aren't missing steps or relying on magic.) -Adam Thompson athom...@athompso.net > ---

Re: [Ledger-smb-devel] Upcoming 2.0 of LedgerSMB

2010-07-26 Thread Adam Thompson
I don't know the american situation, but in Manitoba (Canada) it's usually cheaper to hire a service to do payroll for you, up until about 20 employees or so. Granted it's a close-run thing, QB's payroll data isn't *much* more expensive, but the 4-person company I work for has Comcheq? Ceridian

Re: [Ledger-smb-devel] Upcoming 2.0 of LedgerSMB

2010-07-26 Thread Adam Thompson
m simply because it isn't quite polished enough, and I don't want to spend lots of time getting up and running with an accounting system. Administrative overhead, if you will... the same reason I'll be ditching Gentoo on my primary file/print/mail server this week and sw

Re: [Ledger-smb-devel] Upcoming 2.0 of LedgerSMB

2010-07-26 Thread Adam Thompson
l far bigger problems are addressed. See next message for details. -Adam Thompson athom...@athompso.net -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps

Re: [Ledger-smb-devel] Proposal for 2.0: New monetary data types

2010-04-05 Thread Adam Thompson
re non-decimalized currency could be introduced. We probably won't be worrying about currency data types in that event anyway. This still seems complicated, but the pure data type will definitely find useful applications. Thank you for taking the time to explain, -Adam Thompson (204) 29

Re: [Ledger-smb-devel] Proposal for 2.0: New monetary data types

2010-04-04 Thread Adam Thompson
that need it, or if this became some sort of standardized library (again, like TZ data) rather than a data type specific to one database. (Oh, if anyone cares, the various (historically recent) British coinages are listed at http://en.wikiped

Re: [Ledger-smb-devel] How can I help?

2010-03-30 Thread Adam Thompson
had more or less forgotten about it, as the -dev list and the IRC channel are both fairly active and certainly quite responsive. Is it possible to archive and/or simply remove the trackers from the SF project? -Adam Thompson (204) 291-7950 > -Original Message- > From:

Re: [Ledger-smb-devel] Another question re: 2.0

2010-03-17 Thread Adam Thompson
easy to deploy across the smallish number of very-common distribution channels (e.g. Fedora & Ubuntu repositories, among others) merely to avoid drowning in details. In the end, reaching more users benefits (almost) everyone no matter how it happens. -Adam Thompson athom...@athompso.net (2

Re: [Ledger-smb-devel] Another question re: 2.0

2010-03-17 Thread Adam Thompson
;ve gotta be kidding, no way, that's so Old School" - quoting a former employee, on the subject of manually installing from a tarball.) -Adam Thompson (204) 291-7950 athom...@athompso.net -- Download Inte

Re: [Ledger-smb-devel] ready to branch 1.3 off?

2010-03-13 Thread Adam Thompson
codebases of 1.2, 1.3 and 2.0 will be sufficiently different that it would be highly unlikely patches could ever apply to multiple branches at the same time anyway. -- -Adam Thompson (204) 291-7950 -- Download Intel® Paral

[Ledger-smb-devel] SSL explanation (was: Re: Global Namespaces)

2010-03-13 Thread Adam Thompson
that the client can recompute and verify. See http://www.rsa.com/rsalabs/node.asp?id=2152 for an introduction. -- -Adam Thompson (204) 291-7950 -- Download Intel® Parallel Studio Eval Try the new software tools for your

Re: [Ledger-smb-devel] Proof of concept structs for 2.0

2010-03-12 Thread Adam Thompson
more obvious and more likely to help ensure correctness of implementation. A change in auth_module would thus represent a new session altogether - which is sane IMHO, as an attack in that mode would be indistinguishable from an administrative configuration change or simply a valid connec

Re: [Ledger-smb-devel] Proof of concept structs for 2.0

2010-03-12 Thread Adam Thompson
the ::User object is the result of the authentication process... I would also probably consider it an error to treat a user suddenly switching auth mechanisms from one request to the next as a single "session". Now you tell me where I misinterpreted things or am making up demons of sm

[Ledger-smb-devel] bug in 1.2.20 AM.pm line 810

2010-03-09 Thread Adam Thompson
The UPDATE statement ending on line 810 in AM.pm has a trailing ")" that creates a SQL syntax error when updating a SIC entry. Removing the ')' fixes it. -- -Adam Thompson (204) 291-7950 --

Re: [Ledger-smb-devel] Proposed Architecture Changes in 2.0 (Request for comments)

2010-03-08 Thread Adam Thompson
rmation. What benefit would this provide? My gut reaction (without a use case, anyway) is that this sounds neat on paper but potentially opens up bad-data injection problems. If someone really wants, say, a RESTful interface to GL transactions that supplies text/plain format CSV data, that

Re: [Ledger-smb-devel] Proposal for 2.0: SODA 2.0

2010-03-08 Thread Adam Thompson
y-designed databases that needed, effectively, row-level security!) And there shouldn't be any functions that both read and write (I think). -- -Adam Thompson (204) 291-7950 -- Download Intel® Parallel Studi

Re: [Ledger-smb-devel] Proposal for 2.0: SODA 2.0

2010-03-08 Thread Adam Thompson
hat you've been saying? Are there many places where core *read* functionality cannot be implemented as, say, a view instead of an SP? (Write functionality is a different kettle of fish.) Or are you talking about write-access only here? -- -Adam Thompson (204) 291-7950 ---

Re: [Ledger-smb-devel] Another question re: 2.0

2010-03-08 Thread Adam Thompson
Michael Richardson wrote: >>>>>> "Adam" == Adam Thompson writes: > Adam> YES Pretty much every distro has ready-made tools for > Adam> turning CPAN distributions into native packages, this might > Adam> eliminate a lot of the

Re: [Ledger-smb-devel] Proposal for 2.0: SODA 2.0

2010-03-08 Thread Adam Thompson
Agreeing with Chris, *WEB*-based services aren't appropriate for everything - POS being an excellent example. So, I disagree with making REST the common integration point. I also don't want to use web-based APIs on, for example, handheld terminals collecting inventory information. --Origin

Re: [Ledger-smb-devel] Proposal for 2.0: SODA 2.0

2010-03-08 Thread Adam Thompson
2.0 On 10-03-08 10:11 AM, Luke wrote: > On Mon, 8 Mar 2010, Adam Thompson wrote: > >> I'm wondering why the push to move so much functionality into the DB >> instead of using an ORM, which seems to be where you're headed anyway? >> Or, to rephrase that: if you don&#x

Re: [Ledger-smb-devel] Proposal for 2.0: SODA 2.0

2010-03-08 Thread Adam Thompson
Many of the data integrity constraints can be embedded as CHECK or referential constraints in the database schema; this alone can minimize the *possibility* of someone changing data in the wrong way. For those transactions that have to be multi-step, e.g. GL transactions, it makes perfect sense

Re: [Ledger-smb-devel] Proposal for 2.0: SODA 2.0

2010-03-08 Thread Adam Thompson
I'm wondering why the push to move so much functionality into the DB instead of using an ORM, which seems to be where you're headed anyway? Or, to rephrase that: if you don't want an ORM in the Perl framework, why are you trying to build one in the DB? I'm perfectly OK dealing with relational dat

Re: [Ledger-smb-devel] Another question re: 2.0

2010-03-07 Thread Adam Thompson
YES Pretty much every distro has ready-made tools for turning CPAN distributions into native packages, this might eliminate a lot of the app packaging burden. -Adam --Original Message-- From: Chris Travers To: Development discussion for LedgerSMB ReplyTo: Development discussion for L

Re: [Ledger-smb-devel] Looking beyond 1.3: Kernalization andrequirements proposals.

2010-03-06 Thread Adam Thompson
One big caveat: the use of anything other than ActivePerl on Windows. There's no deep, unavoidable reason that Perl+IIS can't be used under Windows - the mod_rewrite functionality can be done in other, almost as easy, ways. For that matter, if 2.0 is a major rewrite, I'm of the opinion it should

Re: [Ledger-smb-devel] Working draft of Application Security Policy for LedgerSMB 1.3

2010-03-03 Thread Adam Thompson
I keep my nose out of formal security standards as a rule, it looks like it is - at least - a good step towards satisfying users who have to worry about demonstrating compliance with [pick your favourite standard]. -- Thank you, -Adam Thompson (204) 291-7950 -

Re: [Ledger-smb-devel] Proposed change for database installation

2010-03-01 Thread Adam Thompson
t; Ok. But that's what we do now :-) Yes. I just meant that between 40-dbsetup.t (& 43-dbtest.t) and 63-lwp.t, we have LSMB_NEW_DB and LSMB_NEW_DATABASE, which seems redundant. -- Thank you, -Adam Thompson (204) 291-7950

Re: [Ledger-smb-devel] Proposed change for database installation

2010-03-01 Thread Adam Thompson
_DB would be sufficient. If it's not set and PGDATABASE is set instead, the database will not get created. If PGDATABASE is set, (IIRC) 43-dbtest.t still runs. -- Thank you, -Adam Thompson (204) 291-7950 -- D

[Ledger-smb-devel] summarizing current "make test" invocation for SVN trunk as of rev 2934

2010-02-28 Thread Adam Thompson
s successfully. Run them afterward with PGDATABASE instead of LSMB_NEW_DB, as far as I can tell. It's safe to say this area is changing rapidly :-) -- Thank you, -Adam Thompson (204) 291-7950 -- Download I

Re: [Ledger-smb-devel] Proposed change for database installation

2010-02-28 Thread Adam Thompson
nstall_db == 1 ) then leave database else delete database" construct, why use two different variables? -- Thank you, -Adam Thompson (204) 291-7950 -- Download Intel® Parallel Studio Eval Try the new sof

[Ledger-smb-devel] oops (diff for install-mycompany.sh)

2010-02-28 Thread Adam Thompson
he version# and then not using is kind of silly. Lastly, it appears the install scripts are going to go in a different direction altogether in the future. So... yeah. Take it or leave it, I guess. -- Thank you, -Ada

[Ledger-smb-devel] sql/modules/LOADORDER - redundant, remove?

2010-02-27 Thread Adam Thompson
ules/LOADORDER to: > The file install.sql loads the scripts in the correct order. Other orderings > *may* work but are not supported. and remove LOADORDER altogether. -- Thank you, -Adam Thompson (204) 291-7950 --

Re: [Ledger-smb-devel] more comments on INSTALL.manual re Postgresql

2010-02-27 Thread Adam Thompson
tic to create a distribution-independent version of that. Probably better to handle those few tasks in dists/*. Er, are any of the distro packaging scripts actively maintained? -- Thank you, -Adam Thompson (204) 291-7950 -

[Ledger-smb-devel] more comments on INSTALL.manual re Postgresql

2010-02-27 Thread Adam Thompson
e we don't all live in the USA). Please see attached diff against SVN trunk. -- Thank you, -Adam Thompson (204) 291-7950 Index: install-mycompany.sh === --- install-mycompany.sh(revision 2916) +++ install-mycompany.sh

Re: [Ledger-smb-devel] file ownership, or INSTALL vs INSTALL.manual vs install.sh vs README in 1.3.0b3

2010-02-27 Thread Adam Thompson
sure which directory "ledgersmb13" referred to. I figured if it was important enough to mention specially like that, it must be something out of the ordinary. Until I found the other references to /path/to/ledgersmb13 which made it reasonably clear, anyway. My $0.02. -- Thank you

Re: [Ledger-smb-devel] file ownership, or INSTALL vs INSTALL.manual vs install.sh vs README in 1.3.0b3

2010-02-27 Thread Adam Thompson
ere are a whole bunch of references to "ledger-smb" throughout the documentation and the code. But as far as filenames go, the only ones still hanging around appear to be in dists/gentoo/. In code, there's a file name in SL2LS.pl, which still open()s "ledger-smb.conf".

[Ledger-smb-devel] file ownership, or INSTALL vs INSTALL.manual vs install.sh vs README in 1.3.0b3

2010-02-27 Thread Adam Thompson
nd in the README file makes all the files in the directory writable as well. The INSTALL* files don't cover this explicitly. -- Thank you, -Adam Thompson (204) 291-7950 -- Download Intel® Parallel Studio Eval

[Ledger-smb-devel] missing filename in install.sh

2010-02-26 Thread Adam Thompson
her INSTALL.manual and install.sh should match more precisely, or which version should prevail. -- Thank you, -Adam Thompson (204) 291-7950 -- Download Intel® Parallel Studio Eval Try the new software tools for yo