February 2022 - 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

LedgerSMB 1.6.33 released
by Erik Huelsmann 25 Mar '24

25 Mar '24

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.33 * Follow-up (fix) to upgrades blocked by files attached to transactions (Erik H) Erik H is Erik Huelsmann For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.33/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.33 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.33 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.33 These are the sha256 checksums of the uploaded files: ece4c7f63e725eea5dc2cbebbef0622b8426e24e1742daf98b1bc95fa292f6a9 ledgersmb-1.6.33.tar.gz 16d22e4c2a06a63d90ee5aca2a4e132f8e94b2eef252608da52ae0da7401c69e ledgersmb-1.6.33.tar.gz.asc

1 0

LedgerSMB 1.7.25 released
by Erik Huelsmann 13 Apr '22

13 Apr '22

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.25 * Faster GL account tree consistency check * Maintain consistency between ar/ap/gl and transactions tables on delete * Fix CSV import of inventory adjustment For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.25/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.25 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.25 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.25 These are the sha256 checksums of the uploaded files: 3d457b1f107719baed7210c4ad04140acfb3d16aa5106de2a3862911cc026ecb ledgersmb-1.7.25.tar.gz 4ce17568cd2800ccece2cc7adb0a101c6103a00ffe0c1832784873b382295f42 ledgersmb-1.7.25.tar.gz.asc

2 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

Taxes
by Mathew Cox 22 Feb '22

22 Feb '22

Question; my business is one where we go to different areas and provide service to customers. Each county has a different sales tax rate and the cities within each county also can have a different sales tax rate as well. Total there are 13 entities with different sales tax rates that my customer base resides within. Setting the default sales tax rate doesn't really fit since there isn't a single tax as I'm not brick and mortar. The only solution I've worked out in my head is to add each of these entities in the chart of accounts as a liability, manually add a percentage to an invoice, and then use a journal entry to manually transfer the appropriate amount of tax to the appropriate entity in the chart of accounts. Is there a better way to do this? Mathew

2 2

Looking for translators of Malay, Various Spanish variants and Portugese
by Erik Huelsmann 22 Feb '22

22 Feb '22

Hi! The project received a Hebrew translation last week. Which is great! Unfortunately, we have a few translations without translators. These translations have very good translation levels already and merely need to be kept up to date. We're looking for translators for: - Malay - Spanish (various variants; e.g. Colombian, Paraguayan) - Portugese For any other languages without translators - for which the effort required to get to a good translation level might be a bit higher, though - please have a look at https://www.transifex.com/ledgersmb/ledgersmb/dashboard/ If you need help getting started, please drop by in our chat channel at https://app.element.io/#/room/#ledgersmb:matrix.org or reply to this e-mail on this mailing list so we can help you get started! Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

LedgerSMB 1.9.10 released
by Erik Huelsmann 22 Feb '22

22 Feb '22

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.9.10 * Second fix for sending e-mail due to the incompatibility in Workflow 1.59 * Freshly contributed Hebrew translation For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.9.10/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.9.10 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.9.10 Or pulled from GitHub Container Registry using the command $ docker pull ledgersmb/ledgersmb:1.9.10 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.9.10 These are the sha256 checksums of the uploaded files: 3432498a93d72f2b7a250b32595a2930d539bb9b086e0de68bb46e7fd5348203 ledgersmb-1.9.10.tar.gz 203f2cc83045937eb5627f1ba2a1615f3b2c2b1bd8a4344531e3f3c2264f8e94 ledgersmb-1.9.10.tar.gz.asc

1 0

Re: nginx Error
by Erik Huelsmann 20 Feb '22

20 Feb '22

Hi Mathew, On Sat, Feb 19, 2022 at 10:49 PM Mathew Cox <edmondshire(a)live.com> wrote: > The directions I was using was the following: > > > > https://ledgersmb.org/content/installing-ledgersmb-19 > > > Where things broke down for me was from the sections titled “Configuring a > Reverse Proxy” all the way to the end. I had initially ignored the reverse > proxy section and that didn’t really suit my purposes. > Ok. So, I think the quickest and simplest way to resolve your situation is to change the content of your "ledgersmb-starman.service" file. If you change the line --listen localhost:5762 \ to --port 5762 \ and run systemctl daemon-reload and then restart the service (systemctl restart ledgersmb-starman), you should see netstat output with column 4 " 0.0.0.0:5762" and column 5 "0.0.0.0:*" for the ledgersmb starman server. You should also be able to access the service from any other devices on your home network. Please note that your password can be snooped by anybody with access to your network with this setup (at login time) because the connection won't be encrypted to the server. (I already understood you to be aware of this, but whoever reads this conversation on the mailing list, might have missed that earlier part of the conversation.) > There is much I don’t understand from this point because I can simply go > to the machine address (192.168.88.15) and I get the standard nginx > greeting. > > > > Everything else has worked flawlessly. > There's just a single other downside to not using the proxy: when using the proxy, the static assets will be served by the ledgersmb-starman instead of by Nginx and in terms of speed and resource use, nginx is much faster and more efficient. The one time this is most noticeable is when you log in, so if you're satisfied with the login speed you get, then there's no reason to try to set up the reverse proxy for that purpose. > I did try and connect through port (http://192.168.88.15:5762) and that > page couldn’t be reached. > Yea. As Pete pointed out: the ledgersmb-starman server isn't listening on 192.168.88.15; it's only listening on ::1/128 and/or 127.0.0.1 (on the same port). > Now take what I’m about to say with a grain of salt as it comes from a > place of ignorance: > To keep focus, I'll wait for you to make the above changes and see if you're satisfied with those. After you are (or if you need the reverse proxy after all so you need the steps below), we can go oven the steps below and what they should have been. Regards, Erik. > > > I don’t understand how nginx references the install directory with the > standard nginx configuration. I copied: > > > > within the nginx-vhost.conf file I edited the part where it says root > WORKING_DIR/UI to root /opt/ledgersmb/UI > > > > then > > > > sudo cp /opt/ledgersmb/doc/config/webserver/nginx-vhost.conf > /etc/nginx/available-sites/ledgersmb.conf > > > > within the nginx-vhost.conf file I edited the part where it says root > /opt/ledgersmb/UI > > and then created the link > > ln -s /etc/nginx/sites-available/ledgersmb.conf /etc/nginx/sites-enabled/ > > > > This naturally failed to enable nginx because I assume this line: > > > > server { > > listen 443 ssl; > > listen [::]:443 ssl ipv6only=on; > > > > Was not correct, which I changed to: > > > > server { > > listen 80; > > #listen [::]:443 ssl ipv6only=on; > > > > This seemed to work as nginx fired right up but I was still getting the > standard nginx greeting page on port 80 (which might be normal) but the > connection was still refused on 5762. > > > > So then in the nginx.conf file under the http{} section I added > > > > Include /etc/nginx/sites-available/ledgersmb.conf > > > > Which again was the nginx-vhost.conf file I modified and changed the name > to ledgersmb.conf. > > > > Though I now can’t recall if that failed to start the nginx service or not > as much of what has happened is pretty much egg soufflé. If it didn’t > start nginx I just deleted it but if it did start it, I still can’t pullup: > > > > http://192.168.88.15:5762/setup.pl > > > > > > > > I hope some or all of this makes sense as I’m trying to be as clear as > possible so to avoid confusion. > > > > I sincerely thank you for your time. > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows > > > ------------------------------ > *From:* Erik Huelsmann <ehuels(a)gmail.com> > *Sent:* Saturday, February 19, 2022 12:34:17 PM > *To:* Mathew Cox <edmondshire(a)live.com> > *Cc:* users(a)lists.ledgersmb.org <users(a)lists.ledgersmb.org> > *Subject:* Re: [ledgersmb-users] nginx Error > > Hi Mathew, > > On Sat, Feb 19, 2022 at 8:34 PM Mathew Cox <edmondshire(a)live.com> wrote: > > I’m still confused. > > > Hopefully we can resolve that! > > > I tried going the reverse proxy route but that doesn’t help because I > don’t own a domain name so certbot won’t send me any certs. > > > Now I'm confused: The error you presented comes from Nginx. The only role > that Nginx has in the installation instructions *is* as a reverse proxy > (but you're no longer trying to go that route?). From where I stand, those > are contradictory signals. Can you provide a bit more information of what > you *have* done, which information you used to do it (including a link to > the installation instructions you're using) and which steps you considered > successful, if any? > > > Which was unexpected, I just wanted to run this software on my own home > network but that presents a problem as I am at a complete loss how to > install the software and configure it in such a way that I can simply > access it on my private home network. > > > Ok. I think you may have missed the key point of Pete's mail: you are > almost there and if you're the only user, there's no need to have the > reverse proxy, but you *do* need the server to listen on an address which > can be reached from the other devices on your home network. It's the > "reachable from the other devices on your home network" part which you had > not achieved yet in the mail he answered to, because the server was > strictly listening to connections from itself. > > > Is there any guide or lesser known website that lays out what is required > to simply self host the software on a private network without the necessity > of having a domain name? > > > I'm not aware of any lesser known sites which document it. There's > explicitly not a guide on the main site because it might encourage people > to set up LedgerSMB insecurely. However, in your use-case, getting a > certificate is indeed overkill (although you could generate a so called > self-signed certificate, which would eliminate the need of owning a domain > to go to certbot, but that's a whole can of worms in itself). So, when I > know what is your reference documentation and to what step you have > completed the instructions, I can probably indicate what you need to do to > bind the serverprogram to an external address instead of an internal > address. That way it will become reachable from other network devices. > > > Regards, > > -- > Bye, > > Erik. > > http://efficito.com -- Hosted accounting and ERP. > Robust and Flexible. No vendor lock-in. > -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

Re: nginx Error
by Erik Huelsmann 19 Feb '22

19 Feb '22

Hi Mathew, On Sat, Feb 19, 2022 at 8:34 PM Mathew Cox <edmondshire(a)live.com> wrote: > I’m still confused. > Hopefully we can resolve that! > I tried going the reverse proxy route but that doesn’t help because I > don’t own a domain name so certbot won’t send me any certs. > Now I'm confused: The error you presented comes from Nginx. The only role that Nginx has in the installation instructions *is* as a reverse proxy (but you're no longer trying to go that route?). From where I stand, those are contradictory signals. Can you provide a bit more information of what you *have* done, which information you used to do it (including a link to the installation instructions you're using) and which steps you considered successful, if any? > Which was unexpected, I just wanted to run this software on my own home > network but that presents a problem as I am at a complete loss how to > install the software and configure it in such a way that I can simply > access it on my private home network. > Ok. I think you may have missed the key point of Pete's mail: you are almost there and if you're the only user, there's no need to have the reverse proxy, but you *do* need the server to listen on an address which can be reached from the other devices on your home network. It's the "reachable from the other devices on your home network" part which you had not achieved yet in the mail he answered to, because the server was strictly listening to connections from itself. > Is there any guide or lesser known website that lays out what is required > to simply self host the software on a private network without the necessity > of having a domain name? > I'm not aware of any lesser known sites which document it. There's explicitly not a guide on the main site because it might encourage people to set up LedgerSMB insecurely. However, in your use-case, getting a certificate is indeed overkill (although you could generate a so called self-signed certificate, which would eliminate the need of owning a domain to go to certbot, but that's a whole can of worms in itself). So, when I know what is your reference documentation and to what step you have completed the instructions, I can probably indicate what you need to do to bind the serverprogram to an external address instead of an internal address. That way it will become reachable from other network devices. Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

nginx Error
by Mathew Cox 19 Feb '22

19 Feb '22

What does this mean? It is a little confusing as it seems to be stating the error is at line 145 but there are only 144 lines in ledgersmb.conf. -- The job identifier is 2922. Feb 19 06:29:00 cathedral nginx[6008]: nginx: [emerg] unexpected end of file, expecting ";" or "}" in /etc/nginx/sites-enabled/ledgersmb.conf:145 Feb 19 06:29:00 cathedral nginx[6008]: nginx: configuration file /etc/nginx/nginx.conf test failed Feb 19 06:29:00 cathedral systemd[1]: nginx.service: Control process exited, code=exited, status=1/FAILURE -- Subject: Unit process exited -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- -- An ExecStartPre= process belonging to unit nginx.service has exited. -- -- The process' exit code is 'exited' and its exit status is 1. Feb 19 06:29:00 cathedral systemd[1]: nginx.service: Failed with result 'exit-code'. -- Subject: Unit failed -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- -- The unit nginx.service has entered the 'failed' state with result 'exit-code'. Feb 19 06:29:00 cathedral systemd[1]: Failed to start A high performance web server and a reverse proxy server. -- Subject: A start job for unit nginx.service has failed -- Defined-By: systemd -- Support: http://www.ubuntu.com/support -- Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows

2 1