Difference between revisions of "Main Page"

From Secure Computing Wiki
Jump to: navigation, search
(Mail Server Stuff)
Line 36: Line 36:
 
==== Links ====
 
==== Links ====
 
* [http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/ http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/]
 
* [http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/ http://www.howtogeek.com/howto/programming/mysql-give-root-user-logon-permission-from-any-host/]
 +
 +
=== Peform DUMP over SSH tunnel ===
 +
 +
== dump|restore over SSH ==
 +
* boot freebsd 6.0 cd, set up partitions correctly
 +
* boot freesbie
 +
** login as root, no password
 +
<pre>
 +
killall dhclient
 +
ifconfig fxp0 inet 208.210.147.XX netmask 255.255.255.224
 +
route add default 208.210.147.65
 +
umount /mnt/ufs.1
 +
newfs -U /dev/ad0s1a
 +
mount /dev/ad0s1a /mnt/ufs.1/
 +
vim /etc/ssh/sshd_config, PermitRootLogin yes
 +
passwd, set root password
 +
kill -HUP `cat /var/run/sshd.pid`
 +
</pre>
 +
 +
*login to catdoor11
 +
<pre>
 +
# edit /etc/rc.conf and set up hostname and IP info for catdoorXX
 +
dump -0aLf - / | ssh catdoorXX "cd /mnt/ufs.1 && cat | restore -rf -"
 +
# revert /etc/rc.conf
 +
</pre>

Revision as of 14:11, 22 May 2007

Mail Server Stuff

First off, the learning curve on postfix blows donkey balls. Secondly, I've been using sendmail for way too long and don't really WANT to use postfix. However, I admit that there are quite a few great advantages to the postfix MTA, such as Virtual Domains and the user interface.

SpamAssassin

Postfix

http://www.freesoftwaremagazine.com/articles/secure_email_servers_from_scratch_with_freebsd_6_part_2

Postfix How-To

vMail.Admin

Link sudo to /usr/bin/sudo

# ln -s /usr/local/bin/sudo /usr/bin/sudo

How to clear the queue

From time to time your mail queue may get filled up. This may be due to network problems or misconfiguration. For instance, if you botch (typo) the relayhost parameter, the mail will be undeliverable.

The first thing to do is fix the problem, meaning get the network back online, or fix the configuration. Issuing this command will tell postfix to try and deliver the mail from the queue.

 postfix flush

However if you discover (using the mailq command) that the deferred mail is useless anyway, it may be desirable to just purge it from the queue without delivering, like so...

 postsuper -d ALL deferred

Finally, specific messages can be removed based on their message ID, which is the first thing shown for each message shown in the mailq output.

 postsuper -d 0C0FF240F2

Firefox

  • No Scroll Tabs: goto about:config, set browser.tabs.tabMinWidth=1
  • Close on Tab: goto about:config, set browser.tabs.closeButtons=1

MySQL Stuff

Links

Peform DUMP over SSH tunnel

dump|restore over SSH

  • boot freebsd 6.0 cd, set up partitions correctly
  • boot freesbie
    • login as root, no password
killall dhclient
ifconfig fxp0 inet 208.210.147.XX netmask 255.255.255.224
route add default 208.210.147.65
umount /mnt/ufs.1
newfs -U /dev/ad0s1a
mount /dev/ad0s1a /mnt/ufs.1/
vim /etc/ssh/sshd_config, PermitRootLogin yes
passwd, set root password
kill -HUP `cat /var/run/sshd.pid`
  • login to catdoor11
# edit /etc/rc.conf and set up hostname and IP info for catdoorXX
dump -0aLf - / | ssh catdoorXX "cd /mnt/ufs.1 && cat | restore -rf -"
# revert /etc/rc.conf