Kategoriarkiv: Knowledge Base

MRTG on debian

Installing an configuring mrtg on debian is quite straightforward. Just issue a “apt-get install mrtg” and you’re done. As for configuring it, there are just another few minutes more. You can use a very useful utility, called “cfgmaker” to generate … Læs resten

Udgivet i Knowledge Base, Linux, Old Base | Skriv en kommentar

Extract a mysql query to XML

echo “select * from table” | mysql -B –xml -h [host] -u [user] -p[password] [database] > output.xml not all of the parameters are needed of course. use –table if you want the nice ascii tables around the result if -B … Læs resten

Udgivet i Knowledge Base, Old Base, SQL | Skriv en kommentar

Install Mono on Debian

This works on Sarge and Etch: apt-get install mono libmono-corlib2.0-cil

Udgivet i Knowledge Base, Linux, Old Base | Skriv en kommentar

Layout til IPAccounting

Traffic trafid INT AUTOINCREMENT time DateTime \ ip INT / Burde være lavet som kombined key med clustered index? sent INT recieved INT Index på `time` og `ip` LocalIPs lid INT AUTOINCREMENT ip INT description VARCHAR(255)

Udgivet i Knowledge Base, Old Base | Skriv en kommentar

HP Procurve commands

Many commands are similar to cisco IOS. Locate a specific mac addres in the port table: switch1.mcn.dk# show mac-address 0010a7-0600d4 Status and Counters – Address Table – 0010a7-0600d4 MAC Address : 0010a7-0600d4 Located on Port : 25

Udgivet i HP, Knowledge Base, Networking, Old Base | Skriv en kommentar

XML formatting with xmllint

To get a nice output of any xml file: xmllint –format <file> To strip all spaces, tabs and newlines: xmllint –noblanks <file> For sorting look at xmlstar.sourceforge.net

Udgivet i Knowledge Base, Old Base | Skriv en kommentar

D-link Switch config

reset config ipif System ipaddress 192.168.1.200/24 config stp priority 49152 config stp ports 1-22 state disable config stp ports 25 cost 100000 priority 144 migrate yes state enabled config stp ports 26 cost 200000 priority 160 migrate yes state enabled … Læs resten

Udgivet i Knowledge Base, Networking, Old Base | Skriv en kommentar

How not to gain knowledge (Stupidity warning)

~Morten131@x1-6-00-14-bf-f2-3a-0c.k427.webspeed.dk (quakenet) 01:59 -!- Irssi: Starting query in quakenet with LaXy^ 01:59 <LaXy^> hallo 02:15 <cybermike2> leave 02:15 <LaXy^> ? 02:16 <LaXy^> why ? 02:16 <cybermike2> Fordi der klart og tydeligt staar paa kanalen at vi ikke gider pm’es 02:16 … Læs resten

Udgivet i Knowledge Base | Skriv en kommentar

UN / LOCODE City Codes

http://www.unece.org/cefact/locode/service/location.htm

Udgivet i Knowledge Base | Skriv en kommentar

Gentoo: How to transfer the world file to a new host

This will transfer all the packages installed on the old host to the new host: cd /var/lib/portage cp world world.bak scp 86.58.131.52:/var/lib/portage/world . emaint –check world >> update cat update | grep “is not installed” | sed “s/’\(.*\)’ is not … Læs resten

Udgivet i Knowledge Base | Skriv en kommentar