April 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

Import Sales and purchases
by joefrancois＠gmail.com 29 Jul '20

29 Jul '20

Hello, I am testing Ledgersmb to see if it is a fit. I am currently using Shopify for shopping cart and I sell on Amazon. Therefore, I will need to sync my orders and inventory with each of the platform. I look around and I can't see how to upload data to Ledgersmb. I would also find it useful for migration. Any hints? Regards, Joe

4 5

Replacement of tokens in SQL files
by Pete Houston 18 May '20

18 May '20

Hello, I'm trying to upgrade an ancient LSMB (1.2.26) to a slightly less ancient one (1.3.47) and the upgrade is not going smoothly, as you might imagine. This error is present in the database log: 2020-04-16 11:42:42 BST ERROR: role "lsmb_<?lsmb dbname ?>__part_edit" does not exist 2020-04-16 11:42:42 BST STATEMENT: GRANT "lsmb_testbooks__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit"; which seems to relate to line 707 in sql/modules/Roles.sql: GRANT "lsmb_<?lsmb dbname ?>__file_read" TO "lsmb_<?lsmb dbname ?>__part_edit"; So, it looks like the substitution of the second dbname token in that line is not happening. Can you suggest any reason why that might be and how/where I should go about fixing it? Thanks very much, Pete -- Openstrike - improving business through open source https://www.openstrike.co.uk/ or call 01722 770036

3 9

docker-compose install process for LedgerSMB
by jronpaul＠gmail.com 08 May '20

08 May '20

hi all, i am trying to test out LedgerSMB.. im following the process for the docker-compose process.. i downloaded the docker-compose.yml file.. then ran docker-compose pull which seemed to work fine and then docker-compose up which seemed to work fine. this is on a linux mint 19 VM in virtualbox. i assume i missed something, but the docker image and ps commands show that it claims to be running on 5762 but if i do a lsof -i i dont see it running and if i do 127.0.0.1:5762 i get nothing. here is my pull output *docker-compose pull* Pulling postgres (postgres:9.6-alpine)... 9.6-alpine: Pulling from library/postgres aad63a933944: Pull complete a5b4c973b808: Pull complete 074a034a3a7a: Pull complete f0cc5c471b46: Pull complete 5b515caa102b: Pull complete ff417e23115a: Pull complete 15675b8430d7: Pull complete a92cb200dd03: Pull complete 056ca6be8aef: Pull complete Digest: sha256:aab62d85087bbd115c20c0dfb4b1e8dd4fcb4b66c2bbe914d91776f2121ec719 Status: Downloaded newer image for postgres:9.6-alpine Pulling lsmb (ledgersmb/ledgersmb:1.5)... 1.5: Pulling from ledgersmb/ledgersmb 02d147d36283: Pull complete 162568cc8531: Pull complete bb6b4d3a3590: Pull complete f6028461b82d: Pull complete 7dd471d87c20: Pull complete b30fa3988f1b: Pull complete Digest: sha256:23ff0d72c31132070f27e10228a136a033144da096c95e5605e2510aa7c29224 Status: Downloaded newer image for ledgersmb/ledgersmb:1.5 here is my "up" output *docker-compose up* Creating ledgersmb_postgres_1 ... Creating ledgersmb_postgres_1 ... done Creating ledgersmb_lsmb_1 ... Creating ledgersmb_lsmb_1 ... done Attaching to ledgersmb_postgres_1, ledgersmb_lsmb_1 postgres_1 | postgres_1 | PostgreSQL Database directory appears to contain a database; Skipping initialization postgres_1 | postgres_1 | LOG: database system was shut down at 2020-04-20 01:56:03 UTC postgres_1 | LOG: MultiXact member wraparound protections are now enabled postgres_1 | LOG: database system is ready to accept connections postgres_1 | LOG: autovacuum launcher started lsmb_1 | maybe: /usr/lib/perl5 lsmb_1 | Selected PERL5LIB=/usr/lib/perl5 lsmb_1 | 2020/04/20-02:00:45 Starman::Server (type Net::Server::PreFork) starting! pid(1) lsmb_1 | Resolved [*]:5762 to [::]:5762, IPv6 lsmb_1 | Not including resolved host [0.0.0.0] IPv4 because it will be handled by [::] IPv6 lsmb_1 | Binding to TCP port 5762 on host :: with IPv6 lsmb_1 | Setting gid to "33 33" lsmb_1 | Starting Worker on PID 1 Using Built Dojo other info * docker container ls* CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 092fd5beda65 ledgersmb/ledgersmb:1.5 "start.sh" 12 minutes ago Up 12 minutes 5762/tcp ledgersmb_lsmb_1 6dac19991470 postgres:9.6-alpine "docker-entrypoint.s…" 12 minutes ago Up 12 minutes 5432/tcp ledgersmb_postgres_1 *docker-compose images * Container Repository Tag Image Id Size -------------------------------------------------------------------------------- ledgersmb_lsmb_1 ledgersmb/ledgersmb 1.5 be467de7a19e 460 MB ledgersmb_postgres_1 postgres 9.6-alpine c0d2dcd3fa66 34.4 MB *docker-compose version* docker-compose version 1.17.1, build unknown docker-py version: 2.5.1 CPython version: 2.7.17 OpenSSL version: OpenSSL 1.1.1 11 Sep 2018 *docker version * Client: Version: 19.03.6 API version: 1.40 Go version: go1.12.17 Git commit: 369ce74a3c Built: Fri Feb 28 23:45:43 2020 OS/Arch: linux/amd64 Experimental: false Server: Engine: Version: 19.03.6 API version: 1.40 (minimum version 1.12) Go version: go1.12.17 Git commit: 369ce74a3c Built: Wed Feb 19 01:06:16 2020 OS/Arch: linux/amd64 Experimental: false containerd: Version: 1.3.3-0ubuntu1~18.04.2 GitCommit: runc: Version: spec: 1.0.1-dev GitCommit: docker-init: Version: 0.18.0 GitCommit: * docker info * Client: Debug Mode: false Server: Containers: 2 Running: 2 Paused: 0 Stopped: 0 Images: 2 Server Version: 19.03.6 Storage Driver: overlay2 Backing Filesystem: extfs Supports d_type: true Native Overlay Diff: true Logging Driver: json-file Cgroup Driver: cgroupfs Plugins: Volume: local Network: bridge host ipvlan macvlan null overlay Log: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslog Swarm: inactive Runtimes: runc Default Runtime: runc Init Binary: docker-init containerd version: runc version: init version: Security Options: apparmor seccomp Profile: default Kernel Version: 5.3.0-46-generic Operating System: Linux Mint 19.3 OSType: linux Architecture: x86_64 CPUs: 1 Total Memory: 1.941GiB Name: test-VirtualBox ID: 5RM6:BNRV:L7UR:PZSQ:RZUA:IAYP:J3GN:CFXV:SF5P Docker Root Dir: /var/lib/docker Debug Mode: false Registry: https://index.docker.io/v1/ Labels: Experimental: false Insecure Registries: 127.0.0.0/8 Live Restore Enabled: false WARNING: No swap limit support

3 2

Exporting Detailed Vendor List
by Ryle Zabate 03 May '20

03 May '20

Greetings,Hello Team,I am trying to export vendor list but the reporting only displays a limited column.My question is how can I export detailed vendor information list either by extrating it to an spreadsheet or pdf format. Your response is highly appreciated. Best Regards and Keep Safe Everyone! Ryle.Msinc/ITDept

2 2

LedgerSMB 1.7.12 released
by Erik Huelsmann 27 Apr '20

27 Apr '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.12 * Reconciliation reports list now shows usernames rather than user ids (#4388) * Single payment interface throws error without open invoices (#4529) * Fix CSV data imports discading the first row (#4567) * Improve Chart of Accounts import no longer discards heading (#4567) For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.12/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.12 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.12 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.12 These are the sha256 checksums of the uploaded files: 9f25e4a4ff7ac15d4cef7f9d615548b9866fc41fe40d5891c34b1d802157e532 ledgersmb-1.7.12.tar.gz 6537bd20015615a9f10e42e72bc9e1bb8d8a8d039152c2bf41a280100e97d50d ledgersmb-1.7.12.tar.gz.asc

1 0

Data Center Build Technician
by udayfield03＠gmail.com 27 Apr '20

27 Apr '20

Data Center Build Technician is responsible for identifying and troubleshooting any issues with basic network and operating system installation and configuration. The professional must examine and evaluate quality assurance of server hardware. They should professionally troubleshoot any hardware issues with the help of trouble tickets. The expert will offer assistance for automated provisioning system for new server orders. https://www.fieldengineer.com/skills/data-center-build-technician

1 0

installing ledgersmb 1.7.11 on Ubuntu
by John O'Gorman 18 Apr '20

18 Apr '20

Hi After a fortnight of attempting to install Debian on a new Acer Aspire 3, we gave up. We have successfully installed Ubuntu and are now attempting to install LedgerSMB. Our 1st query is how to install liblocal-lib-perl and cpanminus. 1. apt install cpanminus worked fine . 2. we tried the same sort of thing with local::lib apt install liblocal-lib.perl installed without error but when we looked for where it had been installed we found it in /usr/share/local/lib.pm. Our reading of the instructions implied that it should be in my home directory in directory perl5. How do we do that? Regards John O'Gorman john(a)og.co.nz

2 1