inventory

inventory

a small IT inventory management system as a opensource project.

(0) download program:

- git clone https://github.com/TorbenMartin/inventory.git

(1) download the mysql driver:

- go mod init test
- go mod tidy

(2) config file example "conf.json":

{
    "User": ["username"],
    "Password": ["p@ssw0rd"],
   "Server": ["localhost"],
    "Port": ["3306"],
    "Db": ["lager"],
    "Init": ["1"]
}

(3) create and install mysql database:

Restore the SQL Backup:

	mysql -u root -p
	source lager.sql;
		
Backup created by:

	mysqldump -u root -p -x -B lager > lager.sql

(4) ssl certificates:

- mkdir -p inventory/certs
- certbot certonly --standalone --preferred-challenges http -d FQDN
- cp /etc/letsencrypt/live/FQDN/cert.pem inventory/certs/
- cp /etc/letsencrypt/live/FQDN/privkey.pem inventory/certs/
- chown USERNAME:USERNAME inventory/certs/*pem

(5) compile:

- for linux: go build -o lager *.go
- for windows: GOOS=windows GOARCH=amd64 go build -o lager.exe *.go

(6) normal run:

- run source: go run *.go

- run binary on linux:
	chmod +x lager
	./lager

-run binary on windows:
	just click it with your fkn mouse

- open webbrowser on http://localhost:50000
- login with: admin:admin

(7) run as a linux service:

cp lager /home/username
chmod +x /home/username

cat >> /etc/systemd/system/lager.service << EOF
[Unit]
Description=Service 1
DefaultDependencies=no
#After=network.target
#Wants=network-online.target systemd-networkd-wait-online.service

StartLimitIntervalSec=500
StartLimitBurst=5

[Service]
Restart=on-failure
RestartSec=5s
WorkingDirectory= /home/username

Type=simple
User=username
Group=username
ExecStart= /home/username/./lager
TimeoutStartSec=0
RemainAfterExit=yes

[Install]
WantedBy=default.target
EOF	

systemctl status lager
systemctl start lager
systemctl status lager