Kein Bild

Linux Tutorial Part1

Januar 16, 2018 stefan 0

These tutorials explain the Linux operating system (os) step by step. Starting with simple examples and getting more advanced each lesson. The line where we […]

Kein Bild


Dezember 8, 2017 stefan 0

How to get size of whole mysql-db? SELECT Round(Sum(data_length + index_length) / 1024 / 1024, 1) „size“ FROM information_schema.tables GROUP BY „size“;

Kein Bild


Oktober 4, 2017 stefan 0

If you want to search words that are not spelled correctly you can use mysql’s buildin SOUNDEX function: SELECT * FROM po_images WHERE SOUNDEX(`keyword`) LIKE CONCAT( ‚%‘,SUBSTRING(SOUNDEX(‚wronk spellet […]

Kein Bild

Monitoring network traffic

August 8, 2017 stefan 0

tcpdump You want to track all incomming http-Headers on your Webserver? sudo tcpdump -A -s 10240 ‚tcp port 80‘ | egrep –line-buffered „^……..(GET |HTTP\/|POST |HEAD […]

Kein Bild

dealing with local mta

Juli 10, 2017 stefan 0

MTA stands for „mail transfer agent“. Popular ones are sendmail, exim and postfix. If you want to know what MTA is running locally you can check […]

Kein Bild

test smtp with swaks

Juli 4, 2017 stefan 0

The swiss army knife for smtp is swaks: you simply may download the script from the page and execute it like this: perl swaks  

Kein Bild


Juni 26, 2017 stefan 0

Some usefull commands: change your nick /nick theSilentRider List channels on current server /list Join a channel named „channelname“ /j #channelname Leave a channel /l […]

Kein Bild


Juni 14, 2017 stefan 0

Easiest way to check a connection for a MSSQL database: Create a file called : myfile.udl Paste the following content (make sure to use your […]