Athena.quadratic.net: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
No edit summary
Line 50: Line 50:
/dev/sdd3: UUID="328df938-26d1-4cb9-b608-d22f64bde502" SEC_TYPE="ext2" TYPE="ext3"
/dev/sdd3: UUID="328df938-26d1-4cb9-b608-d22f64bde502" SEC_TYPE="ext2" TYPE="ext3"
/dev/sdd4: UUID="0425f6cc-c1d6-4f26-bc7c-fbb72393b71a" SEC_TYPE="ext2" TYPE="ext3"
/dev/sdd4: UUID="0425f6cc-c1d6-4f26-bc7c-fbb72393b71a" SEC_TYPE="ext2" TYPE="ext3"
</pre>
== Bckups ==
=== Mysql ===
in /etc/logrotate.d/mysql:
<pre>
/var/log/mysql/mysql.err /var/log/mysql/mysql.log /var/log/mysql/mysqld.err {
monthly
create 660 mysql mysql
notifempty
size 5M
sharedscripts
missingok
postrotate
[ -f /var/run/mysqld/mysqld.pid ] && /bin/kill -HUP `cat /var/run/mysqld/mysqld.pid`
endscript
}
/data/backup/cydonia/mysql/dump.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --master-data=1 --single-transaction --flush-privileges --lock-tables --log-error=/var/log/mysql_backup.log --dump-date --opt --flush-logs --all-databases > /data/backup/cydonia/mysql/dump.sql
endscript
}
/var/log/mysql_backup.log {
daily
rotate 14
missingok
}
</pre>
</pre>



Revision as of 17:34, 5 May 2012

Overview

  • replaces cydonia
  • Home server
  • gentoo
  • On the end of a tek savvy connection with static IP.
  • motherboard: D945GCLF
  • processor: atom 230 (64 bit profile) intel product page
  • onboard realtek wasn't working very good on cydonia, is working great now.
  • might be issues with random number generator.

Todo

  • disk clean up
  • Security
    • chkrootkit
    • nessus
    • snort
    • acid
    • aide
  • irssi
  • Pathchar
  • gnuplot
  • ipv6
  • Backups
    • mysql - done
    • code
    • wiki
    • etc

Disk

blkid

WDC WD1200JD-00G 120GB
/dev/sda1: LABEL="DISK2S1" UUID="3224-1BD9" TYPE="vfat"

ST3120827AS 120GB
/dev/sdb1: LABEL="BOOT" UUID="e1380799-31c9-4fe9-a1ff-0113e08be218" SEC_TYPE="ext2" TYPE="ext3"

ST3320620AS 320GB
/dev/sdc1: LABEL="BOOT" UUID="f91862c9-488c-4567-b82a-1d38bc0310ba" SEC_TYPE="ext2" TYPE="ext3"
/dev/sdc2: UUID="b2665415-fa5a-4486-beaf-3a0278a716a8" TYPE="swap"
/dev/sdc3: UUID="603dee13-f28e-4c53-bf4d-bd255f46c229" TYPE="ext3" LABEL="VAR"
/dev/sdc4: UUID="950356e3-2d28-4176-a250-45f56df94d61" TYPE="ext3" LABEL="ROOT"

ST98823AS 80GB
/dev/sdd1: UUID="d13157a2-ba77-48a4-8829-55cd6a0ec518" TYPE="ext2"
/dev/sdd2: UUID="5d3471bf-ae1c-4286-aa7d-1a486d45c6b6" TYPE="swap"
/dev/sdd3: UUID="328df938-26d1-4cb9-b608-d22f64bde502" SEC_TYPE="ext2" TYPE="ext3"
/dev/sdd4: UUID="0425f6cc-c1d6-4f26-bc7c-fbb72393b71a" SEC_TYPE="ext2" TYPE="ext3"

Bckups

Mysql

in /etc/logrotate.d/mysql:

/var/log/mysql/mysql.err /var/log/mysql/mysql.log /var/log/mysql/mysqld.err {
monthly
create 660 mysql mysql
notifempty
size 5M
sharedscripts
missingok
postrotate
[ -f /var/run/mysqld/mysqld.pid ] && /bin/kill -HUP `cat /var/run/mysqld/mysqld.pid`
endscript
}

/data/backup/cydonia/mysql/dump.sql {
daily
rotate 14
missingok
compress
postrotate
/usr/bin/mysqldump --master-data=1 --single-transaction --flush-privileges --lock-tables --log-error=/var/log/mysql_backup.log --dump-date --opt --flush-logs --all-databases > /data/backup/cydonia/mysql/dump.sql
endscript
}

/var/log/mysql_backup.log {
daily
rotate 14
missingok
}

Media:Athena_Disk.vsd