grafana service doesn’t auto start with the system

21 August 201721 August 2017 Fabien bash, Linux Leave a comment

When installing grafana and influxDB. I encountered the folowing issue

The service of grafana and influxDB where not starting .

service grafana-server status
grafana-server.service - Starts and stops a single grafana instance on this system
Loaded: loaded (/usr/lib/systemd/system/grafana-server.service; disabled; vendor preset: enabled)
Active: inactive (dead)
Docs: http://docs.grafana.org

I checked using rcconf that my service where enabled , and they where !

I then tried sysv-rc-conf and my service where correctly configured !

the services had absolutely no issue starting when called manually and started fine !

loaded (/usr/lib/systemd/system/grafana-server.service; disabled;

this line was telling me that the service startup was disabled !

after seaching a bit on the web ,the solution to this issue is using systemctl to enables the services.

systemctl enable grafana-server.service
systemctl enable influxdb.service

InfluxDB insert multiples values at once using curl

17 August 201717 August 2017 Fabien bash, Orange PI 2 Comments

If you have to insert multiples values in an influxdb database. You can use curl and insert the values one at the time.

But there is a better way like in this example

Let’s say you want to insert your tree loadaverage values in you influxdb database.

First put them into variables using these 3 lines.

onemin=$(cat /proc/loadavg |awk -F' ' '{print $1}')
fivemin=$(cat /proc/loadavg |awk -F' ' '{print $2}')
fifteenmin=$(cat /proc/loadavg |awk -F' ' '{print $3}')

Then using this curl line, insert them all at once in your influxdb database

curl -i -XPOST 'http://localhost:8086/write?db=database' --data-binary "loadavg 1min=$onemin,5min=$fivemin,15min=$fifteenmin"

Orange PI Zero Plus – A simple and, powerfull SBC

16 August 201716 August 2017 Fabien Linux, Orange PI Leave a comment

if you follow what’s new in the SBC world. You must know Xunglong Orange pi, they are a Chinese manufacturer known for making very cheap sbc’s based on Allwinner chip’s.

One of their most interesting sbc’s was the orange pi zero. It was small, powerful, and was ideal for a small headless server. (still available)

It was extremely cheap: less than 10€ but was plagued with some issues like very poor wifi stability, and poor software support from the manufacturer and, only 100mbps on the Ethernet port.

Now Xunlong has come up with an improved version of this board.

The wifi chip is now a well supported Realtek RTL8189FTV
The Ethernet port is now capable of 1Gb/s transfer rate
The cpu is improved with an Allwinner H5
The layout stay exactly the same so case are compatible.

I’ve already ordered one of these boards. At 16,02€ including shipping

It’s available at Aliexpress

OrangePI : Install OpenRTSP on a ARM device

13 August 201713 August 2017 Fabien bash, Linux, Orange PI 1 Comment

One of my project with my OrangePI is to setup the device as a basic IP security camera server ,

the OrangePI zero , will connect to RTSP flux of the IP camera , and dump the stream on to an external disk , where it will be kept for 7 days before getting automaticly deleted
At a latter date i will run a motion detection program on these files and send a mail if motion is detected on a specific part of the frame.

after a little research , i found that a lot of people are using a program called openRTSP to record their RTSP stream to disk

But , after connecting on my OrangePi zero and trying to look for the program i found out that it’s not part of the default installation of armbian stable.

I tried to install the package using apt install openRTSP

apt install openRTSP
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package openRTSP

I went to google and searched , openRTSP package ,and found out , on the debian website that openRTSP is part of the livemedia-utils package,

I went back to my SSH session and typed apt-get install livemedia-utils

root@orangepizero:~# apt-get install livemedia-utils
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
libbasicusageenvironment1 libgroupsock8 liblivemedia50 libusageenvironment3
The following NEW packages will be installed:
libbasicusageenvironment1 libgroupsock8 liblivemedia50 libusageenvironment3 livemedia-utils
0 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 356 kB of archives.
After this operation, 1,187 kB of additional disk space will be used.
Do you want to continue? [Y/n] y

There is no man pages associated with the program , you have to rely on the developer website to understand all the different options . The documentation is available here : http://www.live555.com/openRTSP/ or here if the website is down.
but as usual , in the officials repositories you only get dated version

you might want to compile the source code to have the last version available:

as root

Go to /usr/src: cd /usr/src
Get the live555 liveMedia source code: wget http://www.live555.com/liveMedia/public/live555-latest.tar.gz
Unpack it: tar -xzf live555-latest.tar.gz
Go into the unpacked directory: cd live
Generate the make files: ./genMakefiles linux
Build the code: make
Install the latest version: make install

The NanoPI NEO Plus 2

19 July 201719 July 2017 Fabien Geek Leave a comment

the guys at Frendly elec Just created a very interesting board witch check a lots of mark in the things I look for in a SBC,

First : a good CPU
the Allwinner H5 , is a powerful enough CPU that you might need to cool if you wish to use it at it’s full potential
Lots of RAM , 1GB DDR3
the main issue i have with the OrangePI zero is that there is only 512 MB of ram in the biggest version. for a lot of usages , it’s not enough.
1GB should be plenty
integrated flash memory
the problem with µSD card is that they degrade overtime , and after a year or two , you will see problem with you card unless you take special precaution to limit writes to the SD card.
With eMMC the life of the memory should be longer.
Wifi b/g/n with a well supported chipset : the AP6212
Some GPIO’s
GIGABIT ethernet , a must have !

the price is 24.99$ at http://www.friendlyarm.com

Libre Computer Board a nice 4K capable SBC

19 July 201719 July 2017 Fabien Geek Leave a comment

Kickstarter spawned a very interesting board ,
it’s called Le Potato from the company Libre Computer Board

this board is designed to offer exactly the same layout as the RPI3 , but absolutely destroy it in term of performance

‘the powerful cpu and the large amount of ram enable usages forbidden by the low power of the RPI3.

A powerful web server
A NAS
A fast VPN gateway
A local media server
A torrent downloader
A media encoder
A IP camera storage server
Or a lightweight desktop computer

The cpu is a Quad 64-bit ARM Cortex-A53 CPU + ARM Mali-450 GPU it will need a active CPU cooling , which is provided in the 65$ option.

The specs given by the manufacturer are

HDMI 2.0
4 USB 2.0 Type A
RJ45 100Mb Fast Ethernet
CVBS
Infrared Receiver
S/PDIF Header
UART Header
I2S + ADC Header
40 Pin Header for PWM, I2C, I2S, SPI, GPIO
eMMC Daughter Board Connector with the option for a 64GB emmc in the 99$ reward
MicroSD Card Slot with UHS Support

In some multiusers cases the 100 mbps ethernet port might limit the usage as a NAS. But in most cases, it should be fine as a NAS for 1 or 2 simultaneous users
But the hdmi 2 port is great if you think using it as a media machine connected to a TV for example
The lack of wifi connectivity is disappointing. And one of the 4 USB ports will be reserved for a Wi-Fi adapter
They justify this decision because of a lengthy certification process.
The maker plan on releasing a Wi-Fi + Bluetooth mezzanine in the future witch will address the lack of radio connectivity

Bash script to clean movies name

22 June 201722 June 2017 Fabien bash, Linux 3 Comments

The issue when you download movies online, is that most of the time the file name is going to be complete trash , filled with useless info like the team that made the rip or the website from where the movie was downloaded.
This is very annoying when you sort by name and the website made the idiotic decision to put their name in front of the actual film name.

for example here a typical movie name
[ Torrent9.info ] Dont.Think.Twice.2016.FRENCH.WEBRip.XviD-NEWCiNE.avi
the actual useful data that i wish to keep is Dont.Think.Twice.2016.avi

for this purpose i’ve developped a small bash script that will list all the files in a chosen directory then , if necessary , will rename the file.

#!/bin/bash
#the location of the folder full of movies to rename.
for file in /media/freebox/*
do
if [[ -f $file ]]; then
#that line will delete all the text after the date but keep the file extension.
nfile=$(echo $file | sed "s/\(20[0-1][0-8]\).*\(mkv\|avi\|mp4\)/\1.\2/")

#this line is going to try to delete a space a the start of the filename if it exist
nfile=$(echo $nfile | sed  "s/\/ /\//")

#this line is going to delete double dots in the filename and replace them with simple dots
nfile=$(echo $nfile | sed -e "s/\.\./\./g")

#that line is going to delete everything between [] including the [] 
nfile=$(echo $nfile | sed -e 's/\[[^][]*\]//g')


#after all this work on the filename
#you can now check if the any changes have been made , 

if [[ "$file" == "$nfile" ]]
then
   #if no change display this
   echo "Not touched : $file"
else
   #if change detected , rename the file
   echo ______
   echo Renamed :
   echo "Original name : $file"
   echo "Renamed to  : $nfile"
   echo ______
#doing the actual renaming
mv "$file" "$nfile"
fi
fi
done

this is not a very efficient script
but it’s fulfill it’s purpose and very rarely encounter a filename that he is unable to clean.

BASH:check if a number is even or odd

19 June 201719 June 2017 Fabien Linux 5 Comments

In a bash script you might need to check if a var is even or odd ,

in my case im going to use a if to make that check

#!/bin/bash
for i in $(seq 10);do
    if (( $i % 2 )); then
        echo $i is odd
    else
        echo $i is even
    fi
done

You can use this simple code to make that check and display the result.

the result will be :


1 is odd
2 is even
3 is odd
4 is even
5 is odd
6 is even
7 is odd
8 is even
9 is odd
10 is even

BASH : Make a SQL query from bash

14 June 201714 June 2017 Fabien SQL Leave a comment

MySQL is a very convenient way to store data .
To use stored MySQL data in a BASH script you can use this simple command

echo "SELECT * FROM table WHERE column=xyz | MYSQL_PWD=sqlpassword mysql database -u root -s

this will display the result in you terminal without ASCII decorations.
if you need to use that data for something , you can store it in a var

var=$(echo "SELECT * FROM table WHERE column=xyz | MYSQL_PWD=sqlpassword mysql database -u root -s)

BASH : Comparison of values

30 May 201730 May 2017 Fabien Linux Leave a comment

In a if test, you often have to compare the value of two variable
of the value a variable against a fixed value

is equal to
if [ "$a" -eq "$b" ]
if [ "$a" -eq "35" ]

not equal to
if [ "$a" -ne "$b" ]

is greater than
if ["$a" -gt "$b" ]

is greater or equal than
if [ "$a" -ge "$b" ]

is lower than
if [ "$a" -lt "$b" ]

is lower or equal than
if [ "$a" -le "$b" ]