Geordie | 5 May 01:32 2015
Picon

Debian LSMB 1.4.11 install

Good day
I thought I would give Ledgersmb 1.4.11 a spin
Fresh install of Debian testing in a LXC container

Here are the following errors

http:/x.x.x.x/ledgersmb/setup.pl
Error!

Base schema failed to load at LedgerSMB/Database.pm line 614.

dbversion: 1.4.11, company:

/var/log/postgresql/postgresql-9.4-main.log

 ledgersmb <at> postgres ERROR:  function public.setting_get(unknown) does
 not exist at character 15 2015-05-04 19:04:26 EDT [197-2]
 ledgersmb <at> postgres HINT:  No function matches the given name and
 argument types. You might need to add explicit type casts. 2015-05-04
 19:04:26 EDT [197-3] ledgersmb <at> postgres STATEMENT:  SELECT * FROM
 "public"."setting_get"('ignore_version') 2015-05-04 19:04:27 EDT
 [200-1] ledgersmb <at> try2 FATAL:  database "try2" does not exist
 2015-05-04 19:04:27 EDT [201-1] ledgersmb <at> try2 FATAL:  database "try2"
 does not exist 2015-05-04 19:04:27 EDT [204-1] ledgersmb <at> try2 FATAL:
 database "try2" does not exist 2015-05-04 19:04:41 EDT [216-1]
 ledgersmb <at> try2 ERROR:  language "plpgsql" already exists 2015-05-04
 19:04:41 EDT [216-2] ledgersmb <at> try2 STATEMENT:  CREATE LANGUAGE plpgsql

Apache2 error
[Mon May 04 19:06:25.464716 2015] [authz_core:debug] [pid 88:tid
(Continue reading)

Chris Travers | 12 Apr 10:16 2015
Picon

Where is the next version of LedgerSMB? (see below)

Hi all;

I have recently moved to a new laptop and have been having trouble testing LedgerSMB.  The problems are significant in Plack support.  It has taken me a little while to see what the problems were but now we are faced with some significant decisions to make.

Since the problems likely affect current users as wll, this means there is some significant effort that needs to go into fixing plack support and this has to happen before I can test some of the fixes already applied.

I will be sending a message to the devel list today with my findings and recommendations.  I expect development efforts will pick up again shortly.

--
Best Wishes,
Chris Travers

Efficito:  Hosted Accounting and ERP.  Robust and Flexible.  No vendor lock-in.
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Geordie | 10 Apr 20:45 2015
Picon

LedgerSMB 1.3.46

Hi Again
Actually it is running and I am able to create a database.

Notes
apache2 error
[Fri Apr 10 14:24:11.945751 2015] [access_compat:error] [pid 177:tid
140009575257856] [client 10.0.0.13:60672] AH01797: client denied by
server configuration: /var/lib/ledgersmb/css/ledgersmb.css, referer:
http://10.0.0.21/ledgersmb/login.pl

As far as I can tell everything seems to work but given my history take
it as a grain of salt

I tried restoring one of my backup files. No joy here something about
roles needing to be backup. Well you know that did not happen, I am glad
I don't run mission critical stuff here and was going to redo it anyway
but 
I guess a lesson learned

Thanks
Geordie

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Geordie | 10 Apr 04:45 2015
Picon

ledgersmb/setup.pl error

Hi
Apparently something is amiss
for I get this

Error!

Base schema failed to load at LedgerSMB/Database.pm line 614.

dbversion: 1.4.10, company: 

This is after the page asked to create a new database

Directions

thanks
Geordie

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Geordie | 6 Apr 01:43 2015
Picon

user postgres password

Good Day
I am having issues with postgresql 9.4 and the user postgres password. 
So far the Debian Unstable install has failed, the apt.ledgersmb jessie
has failed to install and now I have built from source and my stumbling
block is now postgresql. I think the way passwords have been created or
changed is different then before and I am not familiar enough with
postgresql to understand what has changed.

I did try the script ./tools/prepare-company-database.sh --company
testinc and it failed on multiple levels. Some of the files the program
references have had name changes and there was the password problem

My goal now is get the password sorted out and create the Ledgersmb
user and database

As a side note apache 2.4.10-11 is having a hissy fit with localhost
and 127.0.0.1 and denying connections I will fix that later,for the
moment I can connect to ledgersmb via ip address

Thanks
Geordie

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Geordie | 28 Mar 14:29 2015
Picon

Debian LXC Apache connection Issues

Good Day

Iceweasel
http://10.0.0.15/ledgersmb/setup.pl

You have chosen to open
setup.pl

So how did I get here
ledgersmb:
  Installed: 1.3.40-1
apache2:
  Installed: 2.4.10-10
postgresql:
   Installed: 9.4+166
Kernel: 3.16.0-4-amd64 x86_64 
lxc:
  Installed: 1:1.0.7-1
iceweasel:
  Installed: 37.0~b1-1

I was originally going to ask for the best practices in setting up
Apache2 for Ledgersmb, however, right now I would just like to have it
open. Ledgersmb is installed in a Debian Unstable LXC container on a
Debian Unstable host. As for the install it was relatively painless
there was a problem however

apache2_invoke ledgersmb.conf: already enabled
apache2_reload: Your configuration is broken. Not reloading Apache 2
apache2_reload: AH00526: Syntax error on line 9
of /etc/apache2/conf-enabled/ledgersmb.conf: apache2_reload: Invalid
command 'RewriteEngine', perhaps misspelled or defined by a module not
included in the server configuration ln: failed to create symbolic link
‘/etc/ledgersmb/ledgersmb-httpd-2.4.conf’: File exists dpkg: error
processing package ledgersmb (--configure): subprocess installed
post-installation script returned error exit status 1

I corrected the error added the IP address
to /etc/apache2/conf-enabled/ledgersmb.conf

In playing around with Ledgersmb I tried this
# /usr/share/ledgersmb/setup.pl
and got
Can't locate lsmb-request.pl in  <at> INC ( <at> INC
contains: /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.20.2 /usr/local/share/perl/5.20.2
/usr/lib/x86_64-linux-gnu/perl5/5.20 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.20
/usr/share/perl/5.20 /usr/local/lib/site_perl .)
at /usr/share/ledgersmb/setup.pl line 8.

So what do I need to move forward, for my Apache2 Foo is severely
lacking

Thanks
Geordie

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Bill Appelbe | 25 Feb 18:17 2015
Picon

Type of business

Hi
probably something simple that I can't see:

I have added a "Type of Business" with a discount.
How do I edit a customer so that he is this type of business?

Bill

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Mikkel Høgh | 21 Feb 06:16 2015

SQL errors galore when trying to upgrade to 1.4

Hi there,

I'm having a devil of a time trying to upgrade from 1.3.56 to 1.4.10.1. 
I've tried different machines, different older copies of the database, 
different OS'es, different versions of 1.4, both browser-based, and the 
CLI version, but all to no avail.

I simply can't figure out how to get a working upgrade.

Here's how the output from reload_modules.sh looks:

http://pastebin.com/M7L540bE

Any clue what I can do to get a proper upgrade done?

--
Kind regards,

Mikkel Høgh <mikkel <at> hoegh.org>

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Nick Prater | 16 Feb 23:30 2015

Exchange Rates

Am I right in thinking that ledgersmb 1.4 and earlier store exchange rates
globally (in the exchangerate table), rather than per-transaction? So once
an exchange rate is set, that rate is assumed for all other transactions
on that date?

If so, that assumption seems broken in that:

* I have accounts with different banks, each sets their own exchange rate
* A bank may set a different rate for different methods of payment
* Rates may change several times during a day, not just at midnight in my
timezone

I note that it is possible to alter the exchange rate for a particular
date by saving (not even posting) another invoice. But that seems to
jeopardise the consistency of transactions posted earlier in the day.
Perhaps this is a bug?

Ideally, it seems that exchange rates should instead be stored on a
per-transaction basis. Or do I have this wrong?

I'd appreciate a more knowledgeable opinion!

Many thanks,

Nick

------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk
Michael Richardson | 7 Feb 23:05 2015
X-Face
Picon

upgrade from 1.3 to 1.4.10.1


I believe that I previously posted about problems with an upgrade from 1.3 to
1.4. I can't find that outgoing email, so perhaps it was my imagination that
I had reported the issue.

A major source of problems was that I had the debian ledgersmb package
installed, and so there were LedgerSMB modules installed into
/usr/share/perl.  (I really dislike having application-specific modules
installed system-wide.  It makes it extremely difficult to install multiple
versions, debug things, etc.  This may be more of a problem with the debian
packaging than anything else, although I run into this problem with Catalyst
based system I deal with)

I found this, removed the package, and then found more in /usr/local/share/perl.
I re-ran perl Makefile.PL, etc. again, and found that the strange errors went
away; but I still can not seem to save a new AP Transaction.
(I did go back and re-run the setup.pl just to be sure.  If re-loading
my 1.3 saved SQL file is useful, I could do that)

I click on Update, and all is good.  I click on Save, and I get:
  Action: post, ID:

no number at the top, and the form does not change to include Post-As-Saved,
etc.

As an aside, I looked through the list of un-approved transaction, wondering
if it had made it into that list, and it did not.  I did find one from
last August which should go away, and I selected "Delete" and got an error:

2015/02/07 21:54:32 - ERROR - LedgerSMB::_error LedgerSMB.pm (650) -- 23503:ERROR:  update or delete on
table "acc_trans" violates foreign key constraint "business_unit_ac_entry_id_fkey" on table "business_unit_ac"
DETAIL:  Key (entry_id)=(24190) is still referenced from table "business_unit_ac".
CONTEXT:  SQL statement "DELETE FROM acc_trans WHERE trans_id = in_id"
PL/pgSQL function "draft_delete" line 9 at SQL statement at LedgerSMB.pm line 782.
2015/02/07 21:54:32 - ERROR - LedgerSMB::_error LedgerSMB.pm (651) -- dbversion: 1.4.10, company: sswbooks
Died at LedgerSMB.pm line 664.

--
]               Never tell me the odds!                 | ipv6 mesh networks [
]   Michael Richardson, Sandelman Software Works        | network architect  [
]     mcr@...  http://www.sandelman.ca/        |   ruby on rails    [

------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
Nick Prater | 23 Jan 14:48 2015

1.4.x : no transactions report

I'm in the process of moving from 1.3.40 to 1.4.10 but have hit a block.

I am a UK limited company, registered for VAT.

1.3.x has two reports that I use for completing my quarterly VAT return:
  Sales->Reports->Transactions
  Purchases->Reports->Transactions

These reports allowed me to list all transactions for a given time period,
with their associated tax amounts. I see no way to do this in 1.4.x.

Is there any equivalent to these reports in 1.4.10?

Many thanks,

Nick

------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet

Gmane