New subject: Production Install, Networking and Setup

1 Jan 2019

On Sat, Dec 29, 2018 at 11:28 AM Xboxboy Mageia &lt;xboxboy.mageia(a)gmail.com&gt;
wrote:

...
  Erik, thanks for responding.

 On Mon, Dec 24, 2018 at 9:43 PM Erik Huelsmann &lt;ehuels(a)gmail.com&gt; wrote:

  Hi!

 Good! Feel free to drop in whenever you feel like it. The channel may not
 always be active, but I'm usually monitoring activity. You're most likely
 active during my nights (I'm in Europe), but I'll try to respond as early
 on the day as possible.
  I forgot to mention, I'm on IRC these days as Aussie_matt (registered
 name) or pilot_aus (unregistered).

 Ok. So, I take it your desire is to run the setup in the Debian VM? Or
 are you looking at installing in a CentOS VM?

 Sorry, yes, I'll use a Debian OS guest VM, on a Centos host OS. 

 Sure. No problem. Is the server which hosts the VMs web-facing? (Hmm,
 reading on, I think your point with the fixed IP is probably that it is
 webfacing indeed.)
  Not currently, I only have it running internally on our network: But I
 wish to have LedgerSMB, and one other web app, to be accessible from
 outside: I don't know the ins and outs of VPN's, but I suspect that makes
 it tricky for the accountant to login. Web facing is more practical, but
 more open to web threats? I could be wrong on that.

  I would like LedgerSMB to be web facing to allow
me to
 A: work from home at times
 B: The accountant to log in and work when required (usually year end).

 I have a setup like that myself too, so we can make that work :-)

 Awesome! 
  Which version of LedgerSMB did you install? Do I
remember that you're
 installing 1.5?

 I believe you're correct it was 1.5, as the apt repo wasn't able to do  1.6
for some reason at this point in time: Dependency related IIRC.

  All advice most appreciated. I may need my hand
held significantly at
 first, especially in regards to networking and security.

 In order to run a secure setup, there's one very important thing you need
 to have: a TLS/SSL Certificate. That will help keep the password going over
 the wire, secure.
 Another thought that I have is: when you want to expose only LedgerSMB's
 web interface to the outside world, it's probably best to set up an
 extremely strict firewall/iptables setup which forwards/filters just the
 one single required port. Another idea would be to set up a (reverse)
 proxy: an HTTP server running on an already public VM which forwards the
 traffic to an internal server unaccessible to the internet.

 Ah yes. Ok, so on my home Nextcloud install (internal only) I was able to  create
and use a self signed cert, but if we're going net facing, and the
 accountant is going to access it, I'm guessing using Let's Encrypt or
 similar is worth chasing up?
 I'm all for locking firewalls down tight: I still don't fully understand
 the reverse proxy concept: But I'm sure I can be guided :)

  Many ideas. Please follow-up or join #ledgersmb!

 I've come down sick over the break, so am yet to return to the shop to  look at
doing anything:

 I guess my first step is to install a Debian OS vm, and get the APT repo
 hooked in and installed: Take a snapshot, then we can proceed?

 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.

...
  Regards,

 --
 Bye,

 Erik.

 Many thanks. 
  http://efficito.com -- Hosted accounting and
ERP.
 Robust and Flexible. No vendor lock-in.

 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.

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.

All advice appreciated.

Re: [ledgersmb-users] Production Install, Networking and Setup