Skip to main content

Posts

My new home server (fight with noise and temperature monitoring)

Hardware I've got another new PC for home purpose and decided to make a home server for my sysadmin and programming tasks.  Also, my old PC  is based on AMD 6-cores phenom and six cores is a good value for virtualization. Are you ready to have a cloud at home? Yes, I'm. I bought a special case  (2U size with six places for hard drives. ) This case also has 3 80mm coolers and I hope this a good way to make cold system. Standart PC power supply is placed at a front side and the power cable is going from the front side to the back side.  My Chiftec power supply has a lot of cord and it is impossible to set up all 6 drives inside. It is no place for the power cord. At this moment I think that power supply with unattachable cord is a good choice.  I spend one drive case for my cables. Another one issue is a noise of low-cost chinese coolers.  They generate a good airstream but noise was unacce...

Update grub using dracut

Fixing grub using dracut Last kernel update was not successful to me. Centos can not boot with next messages:  [ 180.098802] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 180.610167] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 181.121619] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 181.633093] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 182.144831] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 182.656146] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 183.167306] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts [ 183.678755] dracut-initqueue[376]: Warning: dracut-initqueue timeout - starting timeout scripts  Of course simples way  is creating  linux  usb stick ...

Postgresql partituoning (few simple steps)

History I created a simple application for logistic purpose based on Django, PostgresSQL, and Postgis.  This is a service receiving a position of a truck and place it on the map. Service is really simple and uses a virtual machine with small performance.  The main problem of the current solution is a small performance of this cloud server.  Most of the cloud providers use LAN for attaching virtual server's drives. As result speed of disk I/O is really small.   root@sergiy:/home/serg# fdisk -l Disk /dev/xvda1: 20 GiB, 21474836480 bytes, 41943040 sectors Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk /dev/xvda2: 1 GiB, 1073741824 bytes, 2097152 sectors Units: sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes root@sergiy:/home/serg# hdparm -tT /dev/xvda1 /dev/x...

Upgrade postgres 9.4 to 9.6 at Debian linux

I'm using virtual server based on Debian Linux for some my free projects.  One of them is based on Postgres with PostGIS extension.   This windy rainy day is a good time for executing some upgrade. Also I would like to add partman extension for partituoning. Checking new version.  Update package list : aptitude update Get: 1 http://ftp.debian.org/debian jessie-updates InRelease [145 kB] Get: 2 http://security.debian.org stretch/updates InRelease [62.9 kB] Get: 3 http://security.debian.org jessie/updates InRelease [63.1 kB]  Check for new version: dpkg-query -l postgresql* Desired=Unknown/Install/Remove/Purge/Hold | Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend |/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad) ||/ Name ...

checking host hardware using linux kernel

How to collect information about  host without trivial system command   I'm using a lot of hardware boxes with no limit on distro types and versions.  In this case using system command such as ifconfig has a limited usage.  Also,  system config files have a different path and best way for me is getting information from the kernel. Of course,  I'm using cat command for doing this. Next table has information about hardware. Let me know if something is interesting for you and you know something interesting hardware information in the linux kernel file path information /proc/cpuinfo CPU /proc/meminfo memory /sys/block List of block devices. HDD has sd or hd at the beginning /sys/class/block/{digit}/device/model HDD drive and vendor /sys/block/{digit}/size HDD size  /sys/block List of block devices. HDD has sd or hd at the beginning /sys/bus/pci/devices/0000:{digit}/net System name of the network card /sys/device...

Postfix can not start via systemd (simple fix)

Solving problem related to systemd process I like postfix.   This is really smart and secure mail server. I'm helping above  dozen clients around the world and  tunning  postfix is really fun task. This morning I was downgrading postfix  to the stable version for one of the my friends and come across interesting issue.  root@newserver:/etc/init.d# systemctl status postfix ● postfix.service Loaded: masked (/dev/null; bad) Active: inactive (dead) since вт 2017-06-13 14:35:41 EEST; 1h 48min ago Main PID: 25145 (code=exited, status=0/SUCCESS) чер 13 14:47:09 newserver systemd[1]: Stopped postfix.service. чер 13 14:47:29 newserver systemd[1]: Stopped postfix.service. чер 13 14:58:22 newserver systemd[1]: Stopped postfix.service. чер 13 14:58:23 newserver systemd[1]: Stopped postfix.service. чер 13 15:05:20 newserver systemd[1]: Stopped postfix.service. чер 13 15:29:06 newserver systemd[1]: Stopped postfix.service. чер 13 15:29:06 ne...

Another one MySQL monitor

Detecting MySQL loading I've seen strange and randomize increasing  of the  MySQL db loading but mytop did not help to sorted out with this issue. I'm not Mike Tyson and my reaction is more slow then CPU. If I don't catch this dynamically I will catch this statistically.  Main idea Select active request by cron and write it ti file. After this statistic analyze for long period of time sort  this problem out.  Selecting information  from  MySQL  Please add python mod MySQLdb  and set correct credentials up. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 import os , MySQLdb def main (): """ checking process list and save it to file""" LOGFILENAME = 'dbusage.log' MYSQLUSERNAME = 'root' MYSQLPASSWORD = 'password' MYSQLHOST = 'localhost' logfile = open (LOGFILENAME, 'a' ) mydb = MySQLdb . connect(host = MYSQLHOST, ...