Dolibarr ERP: 12.0.2 on Debian 10.5

Download stable version dolibarr-12.0.2.tgz from Source Forge -> Dolibarr ERP-CRM https://sourceforge.net/projects/dolibarr/files/. Extract dolibarr-12.0.2.tgz and move folder htdocs to your web root or subfolder.
 
Create user and mariadb database for Dolibar.

Move to your dolibarr web root. Copy configuration example conf folder and make it writeable during installation.
$ cp conf/conf.php.example conf/conf.php
$ chmod o+w conf/conf.php

Create directory documents and make it writeable.
$ mkdir documents
$ chmod o+w documents/


Install Dolibarr using your browser http://localhost/tes/dolibarr/
Ok PHP Version 7.3.19-1~deb10u1 (More information)
Ok This PHP supports variables POST and GET.
Ok This PHP supports sessions.
Ok This PHP supports GD graphical functions.
Ok This PHP supports Curl.
Ok This PHP supports calendars extensions.
Ok This PHP supports UTF8 functions.
Ok This PHP supports Intl functions.
Ok This PHP supports ZIP functions.
Ok Your PHP max session memory is set to 128M. This should be enough.
Ok Configuration file htdocs/conf/conf.php exists.
Ok Configuration file htdocs/conf/conf.php is writable.

Fill database login and password
Configuration file
Saving parameters to ../conf/conf.php    Ok
Reloading parameters from configuration file.    Ok
Server connection (User dolibarr) : localhost    Ok
Database connection (User dolibarr) : dolibarr    Ok

Your Dolibarr ready to install, wait until installation finish.

Last installation, create user admin and password.
olibarr admin login
Last step: Define here the login and password you wish to use to connect to Dolibarr. Do not lose this as it is the master account to administer all other/additional user accounts.

Dolibarr administrator login 'admin' created successfully.
This installation is complete.
Warning, for security reasons, once the install or upgrade is complete, you should add a file called install.lock into the Dolibarr document directory in order to prevent the accidental/malicious use of the install tools again.

You need to configure Dolibarr to suit your needs (appearance, features, ...).

Add file install.lock
$ touch install.lock

Conguratulation! Your Dolibar 12.0.2 is ready to configure to meet your company requirement and use.

Test on Debian 10.5 Kernel Version 4.19.0-10-amd64

Windows 10 sharing printer on private network only

 

1. Enabling Windows sharing "Manage advanced sharing setings"
   1. Private
      1. Turn on network discovery & Turn on automativ setup of network connected device
      2. Turn on file and printer sharing
   2. Guest or Public
      1. Turn off network discovery
      2. Turn off file and printer sharing
   3. All networks
      1. Turn off Public folder sharing (people logged on to this computer can still access these folders)
      2. Use 128-bit encryption to help protect file sharing connectin (recommended)
      3. Turn off password protected sharing
2. Enabling guest user, open cmd with "Run as administrator" permission
       >net user guest /active:yes
3. Share printer, "Printers & Scanners", choose printer to share, "Manage" -> "Printer properties"
   1.     Sharing
      1.         Share this printer (optional: you can change share name)
      2.         Render print-jobs on client computer
   2.     Security
      1.         Everyone: Print, Manage this printer, Manage documents
      2.         Guest: Print, Manage this printer, Manage documents (add group or user name)

 

Warning: only use on private network!!!

Caution: use with your own security risk on non private network!!!

Note:

• Some Windows 10 update, version 1903 or later, may have some problem with your printer driver and printer sharing. You need to find solution on microsoft site if reinstall and reconnect your printer does not solved your problem.
• You can not share printer if the printer is offline

Debian Buster: Installing zoom client meeting

Download zoom client meeting from https://zoom.us/download?os=linux

Install dependency
# apt-get install dconf-cli gir1.2-ibus-1.0 ibus ibus-clutter ibus-gtk ibus-gtk3 im-config libclutter-1.0-0 libclutter-1.0-common libclutter-imcontext-0.1-0 libclutter-imcontext-0.1-bin libcogl-common libcogl-pango20 libcogl-path20 libcogl20 libdouble-conversion1 libibus-1.0-5 libpcre2-16-0 libqt5core5a libqt5dbus5 libqt5gui5 libqt5network5 libqt5svg5 libqt5widgets5 libxcb-icccm4 libxcb-image0 libxcb-keysyms1 libxcb-randr0 libxcb-render-util0 libxcb-xinerama0 libxcb-xkb1 libxcb-xtest0 libxkbcommon-x11-0 qt5-gtk-platformtheme qttranslations5-l10n

Install zoom client meeting
# dpkg -i zoom_amd64.deb
(Reading database ... 93758 files and directories currently installed.)
Preparing to unpack zoom_amd64.deb ...
Unpacking zoom (5.1.422789.0705) over (5.1.422789.0705) ...
run post uninstall script, action is upgrade ...
Setting up zoom (5.1.422789.0705) ...
run post install script, action is configure...
Processing triggers for desktop-file-utils (0.23-4) ...
Processing triggers for mime-support (3.62) ...

Processing triggers for shared-mime-info (1.10-1) ...

Screenshoot zoom client:

Screenshoot zoom setting:

Tested XFCE Desktop on Debian 10.5 linux-image 4.19.0-10-amd64

GPON AN5506-04-F: Enabling routing in Lan port 1

Network schema

   192.168.1.1 (Router Wifi GPON AN5506-04-F)
        |________________________________
        |            |           |           |          |
      wifi 1  port 1  port 2  port 3  port 4
                     |
                     |
                     | DHCP client/port Uplink (TP-Link TL-WR720N)
                     |_____________________
                     |                 |           |
                  wifi 2        port 1  port 2

Login to router GPON

GPON port 3 connected to Indihome STB (It depends on your installation)

We are going to connect TL-TP720N Uplink to GPON Port 1 and enabling GPON Port 1.

Note: blue pencils are existing configuration, red pencil is a modification.

Save your new configuration, and your TP-TP720N is ready to act as router.

Debian Buster: configure local dns cache for Indihome user

To make your debian faster to lookup name server, it is better to use local dns cache.

Install dnsmasq
# apt-get install dnsmasq

Install NetworkManager
# apt-get install network-manager

Edit /etc/NetworkManager/NetworkManager.conf
[main]
plugins=ifupdown,keyfile
dns=dnsmasq

Edit /etc/NetworkManager/system-connections/[your connection profile]
[ipv4]
dns=8.8.8.8;1.1.1.1;
dns-search=8.8.8.8;1.1.1.1;
method=auto

Restart your network manager
# systemctl restart network-manager

Try your local dns cache
# dig garasiku.my.id @localhost
# dig google.com @localhost

Tested on Debian 10.4