Did anybody document their 1.2 to 1.3 upgrade process?

Yes; there's at least one known (relatively current) story at https://wiki.koumbit.net/LedgerSmbUpgrade#A1.2.25_to_1.3.18 (written by 'anarcat' on irc)

Should I install LedgerSMB modules in /usr/share or /usr/local?

In general: no.

It works, but interferes with troubleshooting and running side-by-side versions: It works fine but it makes support harder :-)

To undo installation in /usr/local, delete /usr/local/share/perl/5.XX.X/LedgerSMB and move the .pl files that belong to LedgerSMB and LedgerSMB.pm in /usr/local/share/perl/5.XX.XX/ another directory.

I just installed LedgerSMB, but http://localhost/ledgersmb/login.pl says "Forbidden"

The default configuration limits access to the /ledgersmb/login.pl page to connections from localhost ( only for maximum security.

If you want to allow connections from other locations, it's highly advisable to use encrypted (VPN) connections to access your ledger in order to maintain good security.

How do I submit my changes to the project?

# diff -u "original file" "new edited file" > “diff file”

Submit your patches ( “diff file” through the Sourceforge project tracker. If you are going to do somewhat largish changes, it's best to discuss how to do them on the developers list. That increases chances for acceptance which is in general the best solution for you and the lsmb community.

Select all parts in orders

All parts in order, from '2012-04-21' and '2012-04-22':

select p.partnumber, count(*), sum(qty) from orderitems o join parts p on p.id = o.parts_id where trans_id in (select id from oe where not closed and transdate between '2012-04-21' and '2012-04-22') group by p.partnumber;

Grant permission to manage users (on a terminal)

GRANT lsmb_"your company"__users_manage TO "your username";

List available user roles (access types)

SELECT * FROM lsmb_roles;

Show all users in a company

select * from USERS;

Change expire time on users

Change expire time on users, so they can log in and change password when changing through the web interface is no longer an option:

ALTER USER 'myusername' WITH VALID UNTIL '2011-11-09';

LedgerSMB 1.3.23 released

LedgerSMB 1.3.23 has been released. This release includes a number of bugfixes, some of which affect the ability to deploy LedgerSMB in new environments. Most of these bugfixes are relatively minor but they do impact upgrades from 1.2.x for some users. Additionally most of the changes are ones which allow us to present a more polished product to the user.

This also corrects some i18n issues and a few other issues. The complete changelog is below.


Subscribe to 1.3