Originaly by Sean Reifschneider Date Ocbober 8, 2010 on https://www.tummy.com/articles/isolating-heavy-load/ There are typically two reasons that a server will show high load and become unresponsive: CPU and disc utilization. On a rare occasion it’s something like a hardware error causing a disc to become unresponsive. There are some great tools for tracking and isolating these issues, as long… Continue reading Isolating Linux High System Load
apt does NOT deal with “deb” files. Notes: Aptitude is a text based package manager for Debian which is front-end to ‘apt‘, which enables user to manage packages easily. Synaptic Graphical package manager which makes it easy to install, upgrade and uninstall packages even to novice. Tasksel Tasksel lets the user to install all the… Continue reading dpkg commands for Debian based
apt-get utility it’s the package management command line program for Debian family. Does NOT manage .deb files dpkg does it update command is used to resynchronize the package index files from the their sources specified in /etc/apt/sources.list file The upgrade command is used to upgrade all the currently installed software packages on the system. Currently installed… Continue reading apt-get basics
apt-cache is used for searching apt software package cache List available packages Find the package name and description Check package information Check dependencies for specific package
Upgrading Debian wheezy/7 to jessie/8 – skipping backup part – you own it – stop running services such as apache, nginx, mysql, or postgresql: service nginx stop As root edit /etc/apt/sources.list file: Change all instances of wheezy to jessie. This is how my sources.list file looked after replaced the line wheezy with jessie: deb http://ftp.nl.debian.org/debian… Continue reading Debian upgrade from 7 to 8
1. The problem Recently one hard drive (sdb) from a mail server HDD failed. I was having /dev/sda and /dev/sdb, with the 3 partitions /dev/sda1, /dev/sda2 and /dev/sda4 as well as /dev/sdb1, /dev/sdb2 and /dev/sdb4 /dev/md0 = /dev/sda1 + /dev/sdb1 /dev/md1 = /dev/sda3 + /dev/sdb3 /dev/md2 = /dev/sda4 + /dev/sdb4 /dev/sdb failed, and I had… Continue reading Restoring a Linux RAID1 array after one hard drive failed
My task was to ALTER the OWNER of some tables, but you can use the code bellow to alter/grant/select/insert/update/delete on ALL tables/schemas of your PostgreSQL databases. Get the list of tables that we will work on. I have choosen the public schema: SELECT table_name from information_schema.tables WHERE table_schema = ‘public’; Now prepare the sqls queries,… Continue reading PostgreSQL: alter ALL tables OWNER TO myuser
To reset the password for Oracle DB you should first find the password file. This should be under <Oracle instalation>\server\database\PWD<SID>.ora. Delete the file and run the Oracle password utility from the command line as: orapwd file=PWD<SID>.ora password=<password> entries=<users> Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> The <password> is your new sys password. After you log in as sys you… Continue reading How to reset password for OracleDB
Resetting the administrator/root password for PostgreSQL works on both Linux or MS Windows. Actually in PostgreSQL the default admin/root account is named postgres. 1. Make a backup copy then edit your pg_hba.conf usually found in data/pg_hba.conf of your PostgreSQL installation like this: # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32… Continue reading How to reset root password for PostgreSQL
I’m gonna present 2 ways of resetting or let’s say recovering of the Linux root password that you forgot after the 3 months vacation :). This is not for a hacking purpose as you’ll have to be physical near the machine running Linux and it will take some minutes. Reset root password under Linux by… Continue reading How to reset root password under Linux
reset root 