February 2020 - users - lists.freelock.com

Can't connect to port 5762 (starman) to ledgersmb
by fherman＠inferential.com 01 Apr '24

01 Apr '24

I am a new user. This installation is on a local machine running linuxmint. I installed the latest ledgersmb image for docker via a pull. I have been able to get the PostgreSQL and the ledgersmb containers running. The container name for ledgersmb is myledger. The ps command shows both PostgreSQL and starman running. When I try to browse to http://localhost:5762/setup.pl, I get connection refused. I also tried to telnet to the port but got refused error. When I look for listening ports, port 5762 doesn't show. Apparently I am missing something in my installation. TIA

1 1

'Making Tax Digital' and HMRC in the UK
by Lyn St George 24 Mar '22

24 Mar '22

Hallo, I see WebService::HMRC on cpan with a note that it was originally developed for LedgerSMB, but I can find no reference to it in the list archives. Is there an existing implementation of this? Cheers Lyn

3 4

New install on Debian 10 (buster)
by fmiser 14 Dec '20

14 Dec '20

I'm having troubles with configuration, setup, running. I have been using SQL-Ledger for many years but now I must update... I can access the ledgersmb login using links browser pointed to localhost. But I'm failing to figure out how to allows LAN access. I have a fresh install of Debian on a machine. I used the package manager to install ledgerSMB 1.6.9. To keep it light, no X. This system is for a very small organization. One login typical, never more than 5, access from inside the LAN only. Any clues on how to setup Apache or Starman or ?? to make this setup work? -- fm

3 7

Re: Adding parts
by fmiser 10 Mar '20

10 Mar '20

> Erik wrote: > Please find attached a replacement 'import_csv.pm' to be placed > in lib/LedgerSMB/Scripts/. > * Log into your company > After successful login, the URL will look something like: > http://localhost/login.pl?action=login&company=<your company>. > * Add '#import_csv.pl?action=begin_import&type=goods' at the end > of that URL > > The resulting page looks like a transaction upload page. Don't > mind that; simply select the CSV you want to upload and press > "Save". Should I ignore or fill in the other fields? Like "date", or "Reference", or "Description", or "Transaction"? I'm stumped. I'm not getting either the new "goods" import or the existing "inventory" import to work. Maybe the content or format of my files? Maybe something else missing in my Debian Buster (10) install? LedgerSMB is version 1.6.9 installed from package, with the content of "ledgersmb/old/bin" updated (per email of 2019-12-24) and a new "import_csv.pl" (per email of 2019-12-27). I sent a couple messages to the list with my .csv files attached. Maybe those didn't get through. Any help or hints or clues would be appreciated!! I'm getting two different errors when I try to use the new import_csv.pm. I'm not tracking down what I'm going different to get each message. A dialog box may open with this message: ******************************************* Error! Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517. dbversion: tester, company: 1.6.9 ******************************************** Or, I see the error "Internal Server Error" syslog reports this: ******************************************** Feb 18 01:15:03 host-smb starman[332]: Can't locate LedgerSMB/Template/UI.pm in @INC (you may need to install the LedgerSMB::Template::UI module) (@INC contains: /usr/share/ledgersmb/bin/../old/lib /usr/share/ledgersmb/bin/../lib /usr/share/ledgersmb/bin/.. lib old/lib /etc/perl /usr/local/lib/i386-linux-gnu/perl/5.28.1 /usr/local/share/perl/5.28.1 /usr/lib/i386-linux-gnu/perl5/5.28 /usr/share/perl5 /usr/lib/i386-linux-gnu/perl/5.28 /usr/share/perl/5.28 /usr/local/lib/site_perl /usr/lib/i386-linux-gnu/perl-base) at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 24. Feb 18 01:15:03 host-smb starman[332]: BEGIN failed--compilation aborted at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 24. Feb 18 01:15:03 host-smb starman[332]: Compilation failed in require at /usr/share/perl5/Module/Runtime.pm line 314. *************************************************************** #### #### #### #### #### #### #### #### #### #### Next I tried a different browser. Clean cache. Cookies reset. The error dialog box showed this: ******************************************* Error! Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517. dbversion: tester, company: 1.6.9 ******************************************** Syslog showed this: ******************************************** Feb 18 01:32:11 host-smb starman[332]: Req:C68BB800522011EAADB8D4835481929E 2020/02/18 01:32:11 - ERROR - LedgerSMB::PSGI::catch {...} /usr/share/ledgersmb/bin/../lib/LedgerSMB/PSGI.pm (134) -- Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517.\n Feb 18 01:32:11 host-smb starman[332]: Req:C68BB800522011EAADB8D4835481929E ::1 - - [18/Feb/2020:01:32:11 -0600] "POST /import_csv.pl HTTP/1.1" 500 244 "http://localhost:7777/login.pl?action=login&company=tester" "Mozilla/5.0 (X11; Linux x86_64; rv:72.0) Gecko/20100101 Firefox/72.0" ******************************************** I also tried the existing "import inventory" on the couple of items I added manually. It failed with ******************************************** Error! Can't use an undefined value as a subroutine reference at /usr/share/ledgersmb/bin/../lib/LedgerSMB/Scripts/import_csv.pm line 517. dbversion: tester, company: 1.6.9 ******************************************** Syslog reports ******************************************** Feb 18 01:44:36 host-smb starman[332]: Attempt to reload LedgerSMB/Scripts/import_csv.pm aborted. Feb 18 01:44:36 host-smb starman[332]: Compilation failed in require at /usr/share/perl5/Module/Runtime.pm line 314. ******************************************** The content of the two .csv file I'm using: ******************************************** "partnumber","description","unit","listprice","sellprice","lastcost","weight","notes","makemodel","assembly","alternate","rop","inventory_accno","income_accno","expense_accno","returns_accno","bin","bom","image","drawing","microfiche","partsgroup","avgcost","taxaccnos" "QTSm-RCAf","adapter - 1/4 inch TS plug to RCA jack","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNC75-TERM","adapter - BNC 75 ohm terminator","ea",,$2.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNC75f-BNCf","adapter - BNC barrel, 75 ohm","ea",,$4.25,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNC50f-BNCf","same as above, but 50 ohm","ea",,$2.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNCm-RCAf","adapter - BNC-m to RCA-f","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAf-RCAf","adapter - RCA, barrel","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "YCm-RCAf","adapter - RCA jack to Y/C 4pin plug, signal converter","ea",,$7.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAm-BNCf","adapter - RCA-m to BNC-f","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAm-2RCAf-90Y","adapter - RCAm to two RCAf, 90 deg and 180 deg, wye","ea",,$1.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "NA4LJ","adapter - Speakon to 1/4in jack","ea",,$8.25,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "YCf-YCf","adapter - Y/C 4pin barrel","ea",,$5.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "RCAm-YCf","adapter - Y/C 4pin jack to RCA plug, signal converter","ea",,$7.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "ZFSC-4-1-75","antenna - power splitter, 4-way, BNC, 75 ohm, 10-1000MHz","ea",,$140.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "PB25","box - 1/3 rack wide, project box, ProCo","ea",,$20.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1593KBK","box - 2.6x2.6x1.1 inch, black, with end panels, Hammond","ea",,$4.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "71886BK","box - 5.1x5.1x1.5, black, PacTec","ea",,$9.50,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "KY-BOX","box - keystone, use 1 or 2 modules, surface mount","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551ATS100","box - PCB mounting screws, #2 x 3/8 ","x100",,$15.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551NFLBK","box - tiny project box, flanged lid, short, 35x35x15 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551MFLBK","box - tiny project box, flanged lid, tall, 35x35x20 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551NBK","box - tiny project box, flush lid, short, 35x35x15 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "1551MBK","box - tiny project box, flush lid, tall, 35x35x20 mm, black, Hammond","ea",,$3.00,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 "BNCm-RCAm-06","cable assy - BNC to phono, 6ft","ea",,$8.15,0,,"f","f","f","f",0,1510,4010,5010,1510,,"f",,,,0,,2150 ******************************************** ******************************************** "Part number","On hand","purchase price" "QTSm-RCAf",11,0.75 "BNCm-RCAf",22,1.50 "BNC50f-BNCf",23,5 "nl4fx",8,4.25 ******************************************** -- f

2 2

An error occurred
by kmstraker＠gmail.com 07 Mar '20

07 Mar '20

I see this question being asked frequently and being solved for some but I cannot see the solution. I installed from the Ubuntu repositories and I get this error when I try to add anything. I have setup chart of accounts and now am trying to set defaults but inventory and income will not give drop down lists like the other fields did. ver 1.6.9

3 5

LedgerSMB 1.7.9 released
by Erik Huelsmann 10 Feb '20

10 Feb '20

The LedgerSMB development team is happy to announce yet another new version of its open source ERP and accounting application. This release contains the following fixes and improvements: Changelog for 1.7.9 * Fix authentication issue due to inconsistent cookie handling For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.9/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.9 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.9 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.9 These are the sha256 checksums of the uploaded files: 44383e829c460ef5a567e03e3a480c4c12083a0f3611f616b4cb37c9026372d4 ledgersmb-1.7.9.tar.gz b3b5c5123ad6994af2e6975df0efe44266b9773a4a3e39a37895ba59f13072b2 ledgersmb-1.7.9.tar.gz.asc

1 0

LedgerSMB 1.6.19 released
by Erik Huelsmann 10 Feb '20

10 Feb '20

The LedgerSMB development team is happy to announce yet another new version of its open source ERP and accounting application. This release contains the following fixes and improvements: Changelog for 1.6.19 * Fix authentication issue due to inconsistent cookie handling (Erik H) Erik H is Erik Huelsmann For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.19/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.19 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.19 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.19 These are the sha256 checksums of the uploaded files: 17d784a326e7963cd048e05c32d9a65ba56b43734ed72b6266d866456f225a6f ledgersmb-1.6.19.tar.gz 2822affae38bfd27c74812288bd33bac129b00c1890b2232d28794673c40bcf8 ledgersmb-1.6.19.tar.gz.asc

1 0