Kein Bild

mysql

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

mysql-fuzzy-logic

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: http://www.jetmore.org/john/code/swaks/ you simply may download the script from the page and execute it like this: perl swaks  

Kein Bild

bitchx-irc-client

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

mssql-check-connection

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 […]

Kein Bild

php packages installation

Mai 15, 2017 stefan 0

Let’s have a look which packages are already installed and show only those with „php“ in the name. A fresh system usually shouldn’t give any […]