- users - lists.freelock.com

Re: [ledgersmb-users] Fwd: Fwd: Production Install, Networking and Setup
by Gnucash Xboxboy Mageia 24 Mar '19

24 Mar '19

On Mon, Mar 25, 2019 at 1:50 AM bill Ott <billott(a)theotts.org> wrote: > Can you send me the results of the ifconfig on the VM's host? > > Reviewing I noticed. from below > "virbr0 is on 192.168.122.1" which is the wrong octal. it should be > 192.168.1.XXX. It may be there because your VM is setting up its own DHCP. > But that begs the question of how you are reaching the 192.168.1.188 apache > interface on the VM. > > If you ssh into the VM and issue an ifconfig there, what is its IP address? > > Thanks Bill: Ok, the Host IP has changed, because I didn't have a fixed IP for it: I've now sorted that. So here are the results of 'ifconfig' enp5s0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.1.106 netmask 255.255.255.0 broadcast 192.168.1.255 inet6 fe80::62a4:4cff:fe38:82a9 prefixlen 64 scopeid 0x20<link> ether 60:a4:4c:38:82:a9 txqueuelen 1000 (Ethernet) RX packets 2173 bytes 521229 (509.0 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 176 bytes 19475 (19.0 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536 inet 127.0.0.1 netmask 255.0.0.0 inet6 ::1 prefixlen 128 scopeid 0x10<host> loop txqueuelen 1000 (Local Loopback) RX packets 100 bytes 8648 (8.4 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 100 bytes 8648 (8.4 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 virbr0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 inet 192.168.122.1 netmask 255.255.255.0 broadcast 192.168.122.255 ether 52:54:00:da:32:4e txqueuelen 1000 (Ethernet) RX packets 0 bytes 0 (0.0 B) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 B) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 > Regards, > Bill Ott > > Home: 919-363-0031 > Cell: 919-434-7589 > Email: Mailto:billott@theotts.org <billott(a)theotts.org> > Website: http://www.theotts.org > Profile: http://www.linkedin.com/in/wbott > > On 3/24/19 1:28 AM, Gnucash Xboxboy Mageia wrote: > > > > On Thu, Mar 21, 2019 at 11:00 PM bill Ott <billott(a)theotts.org> wrote: > >> Have you tried temporarily turning off SELinux ("setenforce 0"), then >> trying to connect? After doing the test, turn SELinux back on with >> "setenforce 1". >> > Thanks > Just tried that on the host OS with no change. > The debian VM doesn't have SElinux installed, as 'getenforce' and > 'sestatus' return command not found. > > Regards, >> Bill Ott >> >> Home: 919-363-0031 >> Cell: 919-434-7589 >> Email: Mailto:billott@theotts.org <billott(a)theotts.org> >> Website: http://www.theotts.org >> Profile: http://www.linkedin.com/in/wbott >> >> On 3/21/19 3:40 AM, Xboxboy Mageia wrote: >> >> Bill, >> >> yes, sorry that is a typo: I meant http://192.168.1.118:5762/setup.pl >> >> Regards, >> Xboxboy >> >> ---------- Forwarded message --------- >> From: bill Ott <billott(a)theotts.org> >> Date: Thu, Mar 21, 2019 at 1:21 AM >> Subject: Re: [ledgersmb-users] Fwd: Production Install, Networking and >> Setup >> To: Xboxboy Mageia <xboxboy.mageia(a)gmail.com> >> >> http://192.168.1.*188*:5762/setup.pl???? Did you mean http://192.168.1. >> *118:*5762/setup.pl? >> >> Regards, >> Bill Ott >> >> Home: 919-363-0031 >> Cell: 919-434-7589 >> Email: Mailto:billott@theotts.org <billott(a)theotts.org> >> Website: http://www.theotts.org >> Profile: http://www.linkedin.com/in/wbott >> >> On 3/19/19 9:47 PM, Xboxboy Mageia wrote: >> >> Sorry Bill: I meant to send it to the list :-0 >> >> Please see the network info I've added, in response to both Bill and Erik. >> >> On Mon, Mar 18, 2019 at 6:45 PM Xboxboy Mageia <xboxboy.mageia(a)gmail.com> >> wrote: >> >>> Hello, >>> I was sick over Xmas, and since then business has been booming, only now >>> can I have a second look. Thank you all for you help. >>> >>> >>> On Thu, Jan 10, 2019 at 10:38 AM bill Ott <billott(a)theotts.org> wrote: >>> >>>> Running "brctl show" w/o/ the quotes on the VM's host will show you the >>>> bridge and the interfaces that are connected to it. 'ifconfig" w/o the >>>> quotes on the VM's host will show you the all of interfaces. >>>> >>> brctl show >>> bridge name bridge id STP enabled >>> interfaces >>> virbr0 8000:525400da324e yes >>> virbr0-nic >>> >>> ifconfig >>> >>> enp5s0 is on 192.168.1.109 >>> lo is on 127.0.0.1 >>> virbr0 is on 192.168.122.1 >>> >>> (sorry can't ssh in at the moment, let me know if you need all the >>> details) >>> >>> Might help chasing down the problem. >>>> >>>> Regards, >>>> Bill Ott >>>> >>>> Home: 919-363-0031 >>>> Cell: 919-434-7589 >>>> Email: Mailto:billott@theotts.org <billott(a)theotts.org> >>>> Website: http://www.theotts.org >>>> Profile: http://www.linkedin.com/in/wbott >>>> >>>> On 1/9/19 5:21 PM, Erik Huelsmann wrote: >>>> >>>> Hi, >>>> >>>> Ok, so the debian install went simply. I used debian 9 (Stretch), >>>>>> without a GUI. 'ip addr' gives 192.168.1.101, which sounds right, as that's >>>>>> my lan, 192.168.1.X. >>>>>> >>>>> >>>>> I then followed the instructions on >>>>> https://apt.ledgersmb.org/index.html, but I installed version 1.5, >>>>> and did not add the 'test component', I don't know what that means, sorry. >>>>> >>>> >>>> [snip] >>>> >>>> >>>>> I was able to add the DB admin user where the prompt comes up: Now do >>>>> I need to reset/config mysql's root user and password also? >>>>> >>>>> So from my desktop I tried to access via firefox >>>>> 192.168.1.101:5762/setup.pl, but it's unable to connect. >>>>> >>>> >>>> Ok. Are you able to ping that ip address from your desktop? That should >>>> indicate if you should expect to be able to connect to the web server as >>>> well. >>>> >>>> >>>> Yes, I can ping the debian VM with "ping 192.168.1.118" >>> I can access the default debian apache web server at 192.168.1.118, but >>> no luck with 192.168.1.188:5762/setup.pl >>> >>> I have a functioning fedora os VM on 192.168.1.107 with nextcloud >>> working fine. >>> >>> >>>> I have the VM network set to bridged, networking is my downfall, and >>>>> the other thing I suspect is that I need to open the firewall for the >>>>> webserver. >>>>> >>>> >>>> Bridged sounds fine. quick question: Is the "eth0" (or enpXs0 with X a >>>> number) network on the VM's host part of the bridge? If not, you probably >>>> need to enable IP forwarding. Before we go that route, lets start by >>>> checking you can 'ping' the address though. (And: can you ping the host >>>> that the VM is running on?) >>>> >>>> I can ping the host with "ping 192.168.1.109" >>> >>>> >>>> >>>>> >>>>> All advice appreciated. >>>>> >>>> >>>> Regards, >>>> >>>> -- >>>> Bye, >>>> >>>> Erik. >>>> >>>> http://efficito.com -- Hosted accounting and ERP. >>>> Robust and Flexible. No vendor lock-in. >>>> >>>> _______________________________________________ >>>> users mailing listusers@lists.ledgersmb.orghttps://lists.ledgersmb.org/mailman/listinfo/users >>>> >>>> _______________________________________________ >>>> users mailing list >>>> users(a)lists.ledgersmb.org >>>> https://lists.ledgersmb.org/mailman/listinfo/users >>>> >>> >> _______________________________________________ >> users mailing listusers@lists.ledgersmb.orghttps://lists.ledgersmb.org/mailman/listinfo/users >> >> >> _______________________________________________ >> users mailing listusers@lists.ledgersmb.orghttps://lists.ledgersmb.org/mailman/listinfo/users >> >> _______________________________________________ >> users mailing list >> users(a)lists.ledgersmb.org >> https://lists.ledgersmb.org/mailman/listinfo/users >> > > _______________________________________________ > users mailing listusers@lists.ledgersmb.orghttps://lists.ledgersmb.org/mailman/listinfo/users > >

1 0

Fwd: Production Install, Networking and Setup
by Xboxboy Mageia 20 Mar '19

20 Mar '19

Sorry Bill: I meant to send it to the list :-0 Please see the network info I've added, in response to both Bill and Erik. On Mon, Mar 18, 2019 at 6:45 PM Xboxboy Mageia <xboxboy.mageia(a)gmail.com> wrote: > Hello, > I was sick over Xmas, and since then business has been booming, only now > can I have a second look. Thank you all for you help. > > > On Thu, Jan 10, 2019 at 10:38 AM bill Ott <billott(a)theotts.org> wrote: > >> Running "brctl show" w/o/ the quotes on the VM's host will show you the >> bridge and the interfaces that are connected to it. 'ifconfig" w/o the >> quotes on the VM's host will show you the all of interfaces. >> > brctl show > bridge name bridge id STP enabled > interfaces > virbr0 8000:525400da324e yes > virbr0-nic > > ifconfig > > enp5s0 is on 192.168.1.109 > lo is on 127.0.0.1 > virbr0 is on 192.168.122.1 > > (sorry can't ssh in at the moment, let me know if you need all the details) > > Might help chasing down the problem. >> >> Regards, >> Bill Ott >> >> Home: 919-363-0031 >> Cell: 919-434-7589 >> Email: Mailto:billott@theotts.org <billott(a)theotts.org> >> Website: http://www.theotts.org >> Profile: http://www.linkedin.com/in/wbott >> >> On 1/9/19 5:21 PM, Erik Huelsmann wrote: >> >> Hi, >> >> Ok, so the debian install went simply. I used debian 9 (Stretch), without >>>> a GUI. 'ip addr' gives 192.168.1.101, which sounds right, as that's my lan, >>>> 192.168.1.X. >>>> >>> >>> I then followed the instructions on https://apt.ledgersmb.org/index.html, >>> but I installed version 1.5, and did not add the 'test component', I don't >>> know what that means, sorry. >>> >> >> [snip] >> >> >>> I was able to add the DB admin user where the prompt comes up: Now do I >>> need to reset/config mysql's root user and password also? >>> >>> So from my desktop I tried to access via firefox >>> 192.168.1.101:5762/setup.pl, but it's unable to connect. >>> >> >> Ok. Are you able to ping that ip address from your desktop? That should >> indicate if you should expect to be able to connect to the web server as >> well. >> >> >> Yes, I can ping the debian VM with "ping 192.168.1.118" > I can access the default debian apache web server at 192.168.1.118, but no > luck with 192.168.1.188:5762/setup.pl > > I have a functioning fedora os VM on 192.168.1.107 with nextcloud working > fine. > > >> I have the VM network set to bridged, networking is my downfall, and the >>> other thing I suspect is that I need to open the firewall for the webserver. >>> >> >> Bridged sounds fine. quick question: Is the "eth0" (or enpXs0 with X a >> number) network on the VM's host part of the bridge? If not, you probably >> need to enable IP forwarding. Before we go that route, lets start by >> checking you can 'ping' the address though. (And: can you ping the host >> that the VM is running on?) >> >> I can ping the host with "ping 192.168.1.109" > >> >> >>> >>> All advice appreciated. >>> >> >> Regards, >> >> -- >> Bye, >> >> Erik. >> >> http://efficito.com -- Hosted accounting and ERP. >> Robust and Flexible. No vendor lock-in. >> >> _______________________________________________ >> users mailing listusers@lists.ledgersmb.orghttps://lists.ledgersmb.org/mailman/listinfo/users >> >> _______________________________________________ >> users mailing list >> users(a)lists.ledgersmb.org >> https://lists.ledgersmb.org/mailman/listinfo/users >> >

1 0

Internal Server Error (Receipt Module)
by Bernadette Nicole Rivera 06 Mar '19

06 Mar '19

Hi Team, Good day! Can you please help us resolve our issue with regards the error that appeared on our system? Upon clicking the POST and PRINT button on Receipt Module the "INTERNAL SERVER ERROR" appears, we cannot proceed on our transaction due to that error. It's very inconvenient for the accounting team that they can't update their records, kindly, help us resolve this issue immediately. Version of LedgerSMB 1.3.46 Hoping to hear from you soon and thank you. -- Best Regards, *Bernadette Nicole C. Rivera IT Support L1 * Multistyle Specialist Inc. +639289698563 / (02) 641-6515

2 2

Bank Record
by Bernadette Nicole Rivera 26 Feb '19

26 Feb '19

Hi Erik, Good day! May I ask if it is possible to create a bank record/s on the system? Hoping to hear from you soon. Thank you, -- Best Regards, *Bernadette Nicole C. Rivera IT Support L1 * Multistyle Specialist Inc. +639289698563 / (02) 641-6515

2 3

Statement
by Bernadette Nicole Rivera 04 Feb '19

04 Feb '19

Hi Erik, Good day! I have concern with regards the Statement, is it possible to add PO# on the STATEMENT? If it is yes, how? Hoping to hear from you soon. Thanks, -- Best Regards, *Bernadette Nicole C. Rivera IT Support L1 * Multistyle Specialist Inc. +639289698563 / (02) 641-6515

2 4

Migration to 1.5
by Ryle Zabate 24 Jan '19

24 Jan '19

Greetings!Hello Team, we are still using the 1.3 version of LedgerSMB.Can we directly migrate to the 1.5 by extracting it on top of the 1.3 without any problem/issue? Your response is highly appreciated. Warm Regards. Ryle.Msinc/ITDept

2 3

Release of ledgersmb-1.6 package v1.6.10-1
by Robert J. Clay 20 Jan '19

20 Jan '19

An initial version of the debian ledgersmb-1.6 package version for LedgerSMB v1.6.10 has been created and uploaded to our PPA[1], for Ubuntu 'disco' (v19.04) and 'cosmic' (v18.10) as well as for 'bionic' (v18.04 LTS). (The debian source packages are available as well.) The packages at our PPA: ledgersmb-1.6 ledgersmb-1.6-apache ledgersmb-1.6-lighttpd ledgersmb-1.6-nginx ledgersmb-1.6-varnish Only the main 'ledgersmb-1.6' package is required; the others are related to which web proxy you might want to use and you only need one of them. (They depend on their respective web proxy applications and attempt to do at least some setup for them.) Note that I haven't created a ledgersmb-1.6 package yet at our apt package repository[2] for Debian 'Buster' (which is expected to be Debian v10) as that Debian version has not yet been released. It is, however, expected later this year so if people would like that I start making it available as well, please let me know. -- Robert J. Clay rjclay(a)gmail.com, jame(a)rocasa.us GPG ID: 2448 3AE0 874D 8696 6DCD ECF4 198C AB6F 43B7 EA9A. [1] https://launchpad.net/~ledgersmb/+archive/ubuntu/main/+packages [2] https://apt.ledgersmb.org/

1 0

LedgerSMB 1.7.0-alpha1 released
by Erik Huelsmann 20 Jan '19

20 Jan '19

Hi, After the merge of the (improved) Multi Currency Support branch (MC branch), we have released a preview version of LedgerSMB 1.7.0. It's not feature complete yet, but is intended as a general sense of direction for the 1.7.0 release and a way to solicit feedback. Note that you should run this version *only* on a *copy* of your database; this version is NOT intended for production use. The full changelog for 1.7.0 so far is included below. The most important feature by far is the improved multi currency support, which required quite extensive changes to the software. As such, this is the feature we're looking for feedback on most. If you need help getting set up to test 1.7.0-alpha1, please let me know! Changelog for 1.7 Series Forthcoming New functionalities * Deletion of template transactions (Nick P) * Transaction date now part of purchase history report (Chris T) * UI allows addition and removal of custom `account_link` flags (Nick P) Improved foreign currency support * Multiple rates per day per currency (Erik H) - Reversing a transaction from a closed-period on a day with different rate - Bank transfers with different banks on the same day with bank's fx rate - Migration from systems which support per-transaction or per-line fx rates * Multiple currencies in a single general ledger transaction (Erik H) - Posting an opening balance with all currencies in 1 transaction - Transferring between foreign currencies on e.g. Paypal in 1 transaction * Fixed copying of invoice copies fx rate without option to change (Erik H) * UI showing foreign and default currency amounts in transactions (Erik H) Quality Assurance * Expanded checks and resolutions for schema changes (Erik H) * Testing infrastructure and tests for schema change checks (Erik H) * Ensure correct dependency declaration (RequireExplicitInclusion critic policy) * POD documentation structure improvements, with automated checks (Erik H) * Expanded BDD tests, including payments, batches and approval (Nick P) Dependency updates * Dojo Toolkit (JavaScript UI tools) updated to 1.14.2 (Erik H) Code cleanup * Removed deprecated 'custom table' and 'custom field' tables (Erik H) * Reduce dependencies on deprecated LedgerSMB::App_State (Nick P) * Simplified deprecated LedgerSMB::PGOld (Nick P) * Remove unused LedgerSMB::DBObject and LedgerSMB::PGOld methods (Nick P) * Remove unused configuration settings in ledgersmb.conf (Erik H) * Further (compared to 1.6) reduction of warnings * Implemented tests for LedgerSMB::File(::*) modules (Nick P) * Template engine simplification by separation of UI and printed docs (Erik H) * Consistent copyright notices - with tests - on all Perl files in lib/ (Nick P) * Request handling cleanup by mapping 'flat' POST data into hierarchy (Erik H) Nick P is Nick Prater Erik H is Erik Huelsmann Chris T is Chris Travers -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

LedgerSMB 1.6.10 released
by Erik Huelsmann 20 Jan '19

20 Jan '19

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.10 * Apply correct layout to schema upgrade pages in setup.pl (Erik H) * Fix iteration over row data provided in schema data fixes in setup.pl (Erik H) * Fix schema upgrade with multiple failing checks looping infinitely (Erik H) * Improve wording of correction instructions of schema check failure (Nick P) * Respect tempdir when rendering ODS template (don't use current dir) (Nick P) * Add user feedback when invoice needs recalculation before posting (Erik H) Erik H is Erik Huelsmann Nick P is Nick Prater For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.10/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.10 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.10 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.10 These are the sha256 checksums of the uploaded files: 4028fcd2fd63d90988f031de013b81c4a11fe55b8908114e4c05f142ce6389a0 ledgersmb-1.6.10.tar.gz 071c780fc5d8e5b95f7009a86de8496a705e45496d3d9428bc7db25693244e26 ledgersmb-1.6.10.tar.gz.asc

1 0

Exchange rate
by Erik Huelsmann 11 Jan '19

11 Jan '19

Hi Ryle, Your mails are appearing in the mailing list archive (..) but not in my inbox, so I'm copying the content of your mail here: > How can we set the exchange rates if the currency is different form our country default currency, In order to be able to set exchange rates, you need to indicate that you want to use multiple currencies. You can do that in the "System > Defaults"-menu. On the resulting page, there's a "Currency" input box. If you want to use more than one currency, e.g. USD (as the regular currency (also known as "functional currency")) and EUR as the foreign currency, you enter into the currency box (without the quotes): "USD:EUR" (the ":" is the important separator). When you have that, you can choose the currency when creating an order or invoice. When you choose "EUR" and click "Update", an input box will appear for the exchange rate. > Let's say the purchase order is to be sent to another country. Does the above help your case? Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0