mathz.nu Asterisk Blacklist Hobby webbhotell

2018/08/30

Zoneminder in Docker

Filed under: Docker,Server — Mathz @ 17:15

docker swarm init
docker stack deploy -c docker-compose.yml zm
echo “wait for a few seconds to MySQL start for the first time”
docker service scale zm_web=1
echo “go to ZoneMinder console Options-Servers and declare node.0->stream0.localhost and node.1 … node.3, finally start”
docker service scale zm_stream=3
docker service ls

Good debug commands
sudo docker service ps zm_web
sudo docker service ls
sudo docker service rm

Boot Raspberry PI from iSCSI

Filed under: Server — Mathz @ 16:49

https://www.berryterminal.com/doku.php/berryboot

2018/08/29

Docker

Filed under: Docker,Server — Mathz @ 20:37

docker build

docker-compose up

docker ps

docker exec -i -t <NAMES> /bin/bash

docker logs <NAMES>

docker-compose.yaml

version: '3'
services:
influxdb:
image: influxdb:1.5.4
restart: always
volumes:
- /media/space/dockerVolumes/influxdb.1.5.4:/var/lib/influxdb
ports:
- 8086:8086

/lib/systemd/system/docker.service with your favorite text editor and replace the following line where /new/path/docker is a location of your new chosen docker directory:
FROM:
ExecStart=/usr/bin/docker daemon -H fd://
TO:
ExecStart=/usr/bin/docker daemon -g /new/path/docker -H fd://

2018/04/15

Recreate kernel image

Filed under: Server — Mathz @ 13:01

sudo update-initramfs -u -k 3.13.0-143-generic

sudo update-grub

2018/01/11

Software Raid monitoring in Zabbix 3.2

Filed under: Server,Zabbix — Mathz @ 18:21

Item1:

Item1:

Name: Software Raid exist
Type: Zabbix Agent
Key: vfs.file.regmatch[/proc/mdstat,raid]
Type of information: Character
Application: Filesystem

Item2:

Name: Software Raid broken
Type: Zabbix Agent
Key: vfs.file.regmatch[/proc/mdstat,_]
Type of information: Character
Application: Filesystem

Trigger1:

Name: Software raid broken {HOSTNAME}
Severity: Disaster
Expression: {Template OS Linux:vfs.file.regmatch[/proc/mdstat,raid].last(0)}>0 and {Template OS Linux:vfs.file.regmatch[/proc/mdstat,_].last(0)}>0

2017/12/23

FreeNas Useful Commands

Filed under: Server — Mathz @ 12:22

Useful command for FreeNas

View Zpool info

zpool status -v

View smart info

smartctl -a /dev/<device>

View Gids

glabel status

More useful commands: https://forums.freenas.org/index.php?threads/useful-commands.30314/

2017/11/03

Scsi Autoloader commands

Filed under: Backup,Server — Mathz @ 17:24

mtx -f /dev/sg5 status
mtx -f /dev/sg5 unload

Ladda band från slot 4
mtx -f /dev/sg5 load 4

Listar scsi devices med sg namn
lsscsi -g

2016/09/05

Backup of MSSQL database

Filed under: Server — Mathz @ 09:56

Create stored procedure.


// Copyright © Microsoft Corporation. All Rights Reserved.
// This code released under the terms of the
// Microsoft Public License (MS-PL, http://opensource.org/licenses/ms-pl.html.)
USE [master]
GO
/****** Object: StoredProcedure [dbo].[sp_BackupDatabases] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

— =============================================
— Author: Microsoft
— Create date: 2010-02-06
— Description: Backup Databases for SQLExpress
— Parameter1: databaseName
— Parameter2: backupType F=full, D=differential, L=log
— Parameter3: backup file location
— =============================================

CREATE PROCEDURE [dbo].[sp_BackupDatabases]
@databaseName sysname = null,
@backupType CHAR(1),
@backupLocation nvarchar(200)
AS

SET NOCOUNT ON;

DECLARE @DBs TABLE
(
ID int IDENTITY PRIMARY KEY,
DBNAME nvarchar(500)
)

— Pick out only databases which are online in case ALL databases are chosen to be backed up
— If specific database is chosen to be backed up only pick that out from @DBs
INSERT INTO @DBs (DBNAME)
SELECT Name FROM master.sys.databases
where state=0
AND name=@DatabaseName
OR @DatabaseName IS NULL
ORDER BY Name

— Filter out databases which do not need to backed up
IF @backupType=’F’
BEGIN
DELETE @DBs where DBNAME IN (‘tempdb’,’Northwind’,’pubs’,’AdventureWorks’)
END
ELSE IF @backupType=’D’
BEGIN
DELETE @DBs where DBNAME IN (‘tempdb’,’Northwind’,’pubs’,’master’,’AdventureWorks’)
END
ELSE IF @backupType=’L’
BEGIN
DELETE @DBs where DBNAME IN (‘tempdb’,’Northwind’,’pubs’,’master’,’AdventureWorks’)
END
ELSE
BEGIN
RETURN
END

— Declare variables
DECLARE @BackupName varchar(100)
DECLARE @BackupFile varchar(100)
DECLARE @DBNAME varchar(300)
DECLARE @sqlCommand NVARCHAR(1000)
DECLARE @dateTime NVARCHAR(20)
DECLARE @Loop int

— Loop through the databases one by one
SELECT @Loop = min(ID) FROM @DBs

WHILE @Loop IS NOT NULL
BEGIN

— Database Names have to be in [dbname] format since some have – or _ in their name
SET @DBNAME = ‘[‘+(SELECT DBNAME FROM @DBs WHERE ID = @Loop)+’]’

— Set the current date and time n yyyyhhmmss format
SET @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),101),’/’,”) + ‘_’ + REPLACE(CONVERT(VARCHAR, GETDATE(),108),’:’,”)

— Create backup filename in path\filename.extension format for full,diff and log backups
IF @backupType = ‘F’
SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, ‘[‘,”),’]’,”)+ ‘_FULL_’+ @dateTime+ ‘.BAK’
ELSE IF @backupType = ‘D’
SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, ‘[‘,”),’]’,”)+ ‘_DIFF_’+ @dateTime+ ‘.BAK’
ELSE IF @backupType = ‘L’
SET @BackupFile = @backupLocation+REPLACE(REPLACE(@DBNAME, ‘[‘,”),’]’,”)+ ‘_LOG_’+ @dateTime+ ‘.TRN’

— Provide the backup a name for storing in the media
IF @backupType = ‘F’
SET @BackupName = REPLACE(REPLACE(@DBNAME,'[‘,”),’]’,”) +’ full backup for ‘+ @dateTime
IF @backupType = ‘D’
SET @BackupName = REPLACE(REPLACE(@DBNAME,'[‘,”),’]’,”) +’ differential backup for ‘+ @dateTime
IF @backupType = ‘L’
SET @BackupName = REPLACE(REPLACE(@DBNAME,'[‘,”),’]’,”) +’ log backup for ‘+ @dateTime

— Generate the dynamic SQL command to be executed

IF @backupType = ‘F’
BEGIN
SET @sqlCommand = ‘BACKUP DATABASE ‘ +@DBNAME+ ‘ TO DISK = ”’+@BackupFile+ ”’ WITH INIT, NAME= ”’ +@BackupName+”’, NOSKIP, NOFORMAT’
END
IF @backupType = ‘D’
BEGIN
SET @sqlCommand = ‘BACKUP DATABASE ‘ +@DBNAME+ ‘ TO DISK = ”’+@BackupFile+ ”’ WITH DIFFERENTIAL, INIT, NAME= ”’ +@BackupName+”’, NOSKIP, NOFORMAT’
END
IF @backupType = ‘L’
BEGIN
SET @sqlCommand = ‘BACKUP LOG ‘ +@DBNAME+ ‘ TO DISK = ”’+@BackupFile+ ”’ WITH INIT, NAME= ”’ +@BackupName+”’, NOSKIP, NOFORMAT’
END

— Execute the generated SQL command
EXEC(@sqlCommand)

— Goto the next database
SELECT @Loop = min(ID) FROM @DBs where ID>@Loop

END

 

Backup-MSQSQL.bat

sqlcmd -S .\SQLEXPRESS –E -Q “EXEC sp_BackupDatabases @backupLocation=’D:\SQLBackups\’, @backupType=’F'”

 

Took from: https://support.microsoft.com/en-us/kb/2019698

2016/07/28

Install Tomcat 8 on Ubuntu 16.04

Filed under: Server — Mathz @ 22:56

https://www.digitalocean.com/community/tutorials/how-to-install-apache-tomcat-8-on-ubuntu-16-04

2016/07/11

Tomcat 8 install Ubuntu 14.04

Filed under: Server — Mathz @ 20:38

https://www.digitalocean.com/community/tutorials/how-to-install-apache-tomcat-8-on-ubuntu-14-04

Older Posts »

Powered by WordPress