headers
turtle | 18 May 2013 21:45
Favicon

Testing out 1.4 with apache 2.4

Greetings all this weekend I am testing out 1.4 on apache 2.4 with
postgres 9.2 is there a ledgersmb-httpd.conf configured to apache 2.4 ?
That would have converted the outdated Allow Deny format to the "Require"
format?
Also the install script install.sh might want to check apache versions
unless I missed something.

http://httpd.apache.org/docs/2.4/upgrading.html

Cheers
Turtle

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
Permalink | Reply | 5 comments |
headers
Robert J. Clay | 17 May 2013 17:13
Picon

Copyright year for locale/po/hu.po ?

   I'm sorry I didn't notice this when it came out but shouldn't the
copyright year in locale/po/hu.po be "2013"? (If not something like
"2003, 2013"?)

--
Robert J. Clay
rjclay@...

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
Permalink | Reply | 0 comments |
headers
Chris Travers | 16 May 2013 04:59
Picon

LedgerSMB 1.3.32 released

Hi everyone

LedgerSMB 1.3.32 has been released.  This release adds overlooked functionality, and corrects a number of minor to moderate problems with previous releases.  Those who are running 1.3.31 should upgrade sooner rather than later.  Others should upgrade after reviewing the 1.3.31 inventory changes.

The overlooked functionality was that books could not be re-opened after closing.  Now they can through the same interface as 1.2.x.

This release also corrects an issue where the reconciliation database routines failed to load for 1.3.31 users.  For new users of LedgerSMB this would prevent bank account reconciliation workflows from working but upgrading users would continue to run bank reconciliation with no changes.

Other fixes include attention to cash reconciliation and GL draft approval, and some fixes to the LaTeX template engine to handle extr anewlines and em-dashes better.

The complete changelog is below.

Best Wishes,
Chris Travers

Changelog for 1.3.32
* Fixed em-dash handling for pdfs (Chris T)
* Fixed multiple blank line handling for pdfs (Chris T)
* Fixed multiple repeat entries in chart of accounts drop down (Nick P, 812)
* Fixed transaction list empty if searched by creditor name (Nick P, 806)
* Fixed cash transfer enforces ticked 'FX' boxes (Nick P, 802)
* Fixed extra newline-related errors in tex template engine (Chris T)
* Reopen books now works again (Chris T, 792)
* Added address line to ar/ap transaction and invoice screens (Chris T)
* Fixed draft review issues for Cash Transfer GL drafts (Chris T, 802)
* Added fx boxes for GL transactions (Chris T, required to fix 802)
* Fixed odd UI issues with voiding GL transactions (Chris T, 803)
* Fixed department dropdown not showing values (Chris T, 805)
* Fixed error causing Reconciliation.sql not to be loaded/reloaded (Chris T)
* Added updated Hungarian charts of accounts (Pongracz I, 813)

Nick P is Nick Prater
Chris T is Chris Travers
Pongracz I is Pongracz Istvan
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 0 comments |
headers
Chris Calef | 15 May 2013 21:02
Picon

Re: A little trouble installing 1.4.

Hi again,

Sorry, got distracted away from keys for a day or two, but I just updated and tried my setup.pl again, and _almost_ all my errors went away with the recent changes to Reconciliation.sql. (Yay!)

The main one that is still shows up repeatedly looks like this:

  psql:/tmp/ledgersmb/lsmb_roles.sql:635: ERROR:  insert or update on table "menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
  DETAIL:  Key (node_id)=(17) is not present in table "menu_node".
  psql:/tmp/ledgersmb/lsmb_roles.sql:637: ERROR:  insert or update on table "menu_acl" violates foreign key constraint "menu_acl_node_id_fkey"
  DETAIL:  Key (node_id)=(18) is not present in table "menu_node".


Which seems a little weird, I'm no SQL expert but menu_node and menu_acl in my database both have the same foreign key definition for "menu_acl_node_id_fkey":  "FOREIGN KEY (node_id) REFERENCES menu_node(id)".  Unless it's trying to refer to the entire string "(node_id)=(17)" as a key(??)



Also, my dblog concludes with this error, I don't know if it's related to the other one or an independent problem:

  psql:/tmp/ledgersmb/lsmb_roles.sql:1651: ERROR:  syntax error at or near "END"
  LINE 10:    END IF;
            ^
  psql:/tmp/ledgersmb/lsmb_roles.sql:1655: ERROR:  function tg_enforce_perms_eclass() does not exist
  psql:/tmp/ledgersmb/lsmb_roles.sql:1659: ERROR:  function tg_enforce_perms_eclass() does not exist


Thanks for all your work!

Chris


On Sun, May 12, 2013 at 12:38 PM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
Oh, whoops, I tried to attach all those files for you, but my message is now in purgatory awaiting moderator approval, because it was bigger than 40k.  Here, I'll try just sending the one dblog file, it was most interesting... also I chopped out a lot of repetitive SQL like CREATE FUNCTION, GRANT, COMMENT just to get the file size down.  All the errors and warnings are untouched.




On Sun, May 12, 2013 at 11:23 AM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
Yes, sir!  Thanks for sticking with me!

Turns out there are several errors in there. I'll attach all four log files, then go see if I can figure anything out on my own.  In dblog, a number of transactions got cancelled, due to a large number of entities either already existing, or not existing.   Do these make any sense to you?
Chris


On Sun, May 12, 2013 at 2:11 AM, Erik Huelsmann <ehuels-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:

On Sun, May 12, 2013 at 12:02 AM, Chris Calef <chris.calef-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
Hm, well I got a different set of errors this time anyway.  Attached is another version of fullpermissions.error.log.

The first error claims that my database does not exist, but it did get created.  Again I got as far as the create user screen before crashing.  The database has all the tables, but the users table is still empty, no user got created.


When creating a database, setup.pl also creates a number of logs in /tmp/ledgersmb/ (on unix); you can find more errors and issues there. So far, I can only see from your logs that there may be interesting information (such as errors) in those logs. Could you go through those and search for transaction aborted errors?

Thanks!

Bye,

Erik.



------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel




------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 19 comments |
headers
Chris Travers | 15 May 2013 09:19
Picon

Any concerns over releasing 1.3.32 tomorrow (rc2 with no changes)?

Automated tests are run and passing.

Best Wishes,
Chris Travers
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 2 comments |
headers
Chris Travers | 14 May 2013 09:53
Picon

LedgerSMB 1.3.32-rc2 released

Hi;

It has been pointed out to me that one of the things we thought we merged we hadn't.  The change is extremely localized and so I have gone ahead and done this, and released 1.3.32-rc2 at https://sourceforge.net/projects/ledger-smb/files/Beta%20Releases/1.3.32-rc2/

The only difference between this and rc1 is that the Hungarian charts of accounts have been updated.  As no code has changed, I see no reason to reset the code freeze clock.

Best Wishes,
Chris Travers
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 1 comment |
headers
Chris Travers | 14 May 2013 08:04
Picon

1.3.32-rc1

Hi everyone;


This release corrects a number of relatively minor bugs, but it also corrects the issue with the Reconciliation.sql file not loading properly which is a bigger deal for upgrades from non-recent versions or new installations.

The changelog is below.

Best Wishes,
Chris Travers

Changelog for 1.3.32
* Fixed em-dash handling for pdfs (Chris T)
* Fixed multiple blank line handling for pdfs (Chris T)
* Fixed multiple repeat entries in chart of accounts drop down (Nick P, 812)
* Fixed transaction list empty if searched by creditor name (Nick P, 806)
* Fixed cash transfer enforces ticked 'FX' boxes (Nick P, 802)
* Fixed extra newline-related errors in tex template engine (Chris T)
* Reopen books now works again (Chris T, 792)
* Added address line to ar/ap transaction and invoice screens (Chris T)
* Fixed draft review issues for Cash Transfer GL drafts (Chris T, 802)
* Added fx boxes for GL transactions (Chris T, required to fix 802)
* Fixed odd UI issues with voiding GL transactions (Chris T, 803)
* Fixed department dropdown not showing values (Chris T, 805)
* Fixed error causing Reconciliation.sql not to be loaded/reloaded (Chris T)

------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 1 comment |
headers
Chris Travers | 14 May 2013 07:46
Picon

1.3.32 schedule

Hi;

Given Bob's bug (Reconciliation.sql not loading), I would like to get 1.3.32 out as soon as is reasonable.

I will be putting together a package of 1.3.32-rc1 today.  Tomorrow I will probably ask for release feedback, and I would like to release if no problems are found in two days.

Are there any objections?

Best wishes,
Chris Travers
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 0 comments |
headers
Erik Huelsmann | 13 May 2013 23:12
Picon
Gravatar

Proposed change: bank import function "parse_<id>()" to be changed to "parse_<accno>()"?

Hi,


Currently, LedgerSMB 1.4 has a bank reconciliation / bank statement import functionality which uses a function "parse_<id>()" where <id> is the sequence number of the account. I'm proposing we use the account number instead: since we can't expect our users to be highly trained admins, this will definitely help more people to understand how to set up recon (or so I think).

Comments? (Since 1.4 isn't released yet, I think we should be able to change it still, right?)

Bye,

Erik.
------------------------------------------------------------------------------
AlienVault Unified Security Management (USM) platform delivers complete
security visibility with the essential security capabilities. Easily and
efficiently configure, manage, and operate all of your security controls
from a single console and one unified framework. Download a free trial.
http://p.sf.net/sfu/alienvault_d2d
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 0 comments |
headers
Chris Travers | 13 May 2013 12:33
Picon

Shipping label and envelope support in trunk

Hi;

I just committed svn revision 5781 to trunk as a feature request for a customer.  It provides mailing label and envelope printing for orders and invoices.

If anyone wants to play with it on 1.3, it does merge (with a conflict on the changelog which is to be expected, but just select "conflicts mine" on that one).  It should work on 1.3, but this is one of those cases where it's probably better as far as official stuff goes not to backport.

Best Wishes,
Chris Trravers
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and 
their applications. This 200-page book is written by three acclaimed 
leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 0 comments |
headers
Chris Travers | 12 May 2013 11:42
Picon

Most work done on 1.3.32

Wanted to let everyone know we have gotten the major fixes for 1.3.32 in place.  Absent unexpected, urgent reports we expect to start a release candidate at some point in the next few weeks.  if you want to try the end of branches/1.3 you should go and use setup.pl to rebuild your database routines.

I will be taking a little bit of a break from 1.3 development to work on 1.4 and some other matters.  The goal is to get 1.4 ready for release candidate testing as soon as possible.

Best Wishes,
Chris Travers
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and 
their applications. This 200-page book is written by three acclaimed 
leaders in the field. The early access version is available now. 
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Ledger-smb-devel mailing list
Ledger-smb-devel@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Permalink | Reply | 0 comments |

Gmane