{"id":227,"date":"2005-09-08T18:20:23","date_gmt":"2005-09-09T02:20:23","guid":{"rendered":"http:\/\/www.wiredatom.com\/blog\/?page_id=227"},"modified":"2013-03-09T13:27:03","modified_gmt":"2013-03-09T21:27:03","slug":"note-to-self","status":"publish","type":"page","link":"https:\/\/www.wiredatom.com\/blog\/note-to-self\/","title":{"rendered":"Note to Self"},"content":{"rendered":"

MS Office Notes<\/strong>
\nExcel: To enter line breaks within a cell<\/p>\n

\n
option + ctrl + return<\/div><\/div>\n<\/blockquote>\n

Excel: To edit a cell inline without leaving the keyboard<\/p>\n

\n
ctrl + u<\/div><\/div>\n<\/blockquote>\n

Excel: To combine text from two different cells in one<\/p>\n

\n
=cell1& " " &cell2<\/div><\/div>\n

produces<\/p>\n

cell1 cell2<\/div><\/div>\n

The key is in using the &<\/span> sign at the end of the reference to first cell and the beginning of the reference to the second cell.\n<\/p><\/blockquote>\n

<\/p>\n

 <\/div>\n

Mac OSX Notes<\/strong>
\nHow to screen capture on your Mac<\/p>\n

whole screen (makes 2 pictures for dual screen)<\/p>\n

command + shift + 3<\/div><\/div>\n

free hand<\/p>\n

command + shift + 4<\/div><\/div>\n

active window<\/p>\n

command + shift + 4 + space bar<\/div><\/div>\n

In OSX.3 (Panther), all screen capture files are saved as .tiff files.
\nIn OSX.4 (Tiger), all screen capture files are saved as .png files.\n<\/p><\/blockquote>\n

How to zoom in & out of Mac OSX screen (must turn on Accessibility<\/strong> feature in Preferences<\/strong> pane)<\/p>\n

\n
command + option + 8<\/div><\/div>\n

(“Apple, Option, Eight”) toggles Zoom on\/off<\/p>\n

command + option + =<\/div><\/div>\n

(“Apple, Option, Equal Sign”) zooms in, centering on the cursor position when Zoom is on<\/p>\n

command + option + -<\/div><\/div>\n

(“Apple, Option, Minus Sign” ) zooms out\n<\/p><\/blockquote>\n

Negative Effect (must turn on Accessibility<\/strong> feature in Preferences<\/strong> pane)<\/p>\n

\n
command + option + ctl + 8<\/div><\/div>\n

(“Apple, Option, Ctl, Eight” ) toggles the effect on\/off\n<\/p><\/blockquote>\n

Hide HardwareGrowler from Dock<\/p>\n

\n1. Right click on application -> Show Package Contents<\/span><\/code>
\n2. Edit Info.plist<\/span><\/code> in a text editor
\n3. Add the following<\/p>\n

<key>LSUIElement<\/key>
\n<string>1<\/string><\/div><\/div>\n

4. In command line, type:<\/p>\n

touch ~\/path\/to\/HardwareGrowler.app<\/div><\/div>\n

5. Relaunch application\n<\/p><\/blockquote>\n

Reset menu bar on Leopard Mac OS X<\/p>\n

\n
killall -HUP SystemUIServer<\/div><\/div>\n

If SystemUIServer is not running, open terminal and run<\/p>\n

\/System\/Library\/CoreServices\/SystemUIServer.app<\/div><\/div>\n<\/blockquote>\n

Force bigger fonts on all incoming messages in Mail.app<\/p>\n

\n
defaults write com.apple.mail MinimumHTMLFontSize 13<\/div><\/div>\n<\/blockquote>\n

Restart Cisco VPN daemon<\/p>\n

\n
sudo \/System\/Library\/StartupItems\/CiscoVPN\/CiscoVPN restart<\/div><\/div>\n<\/blockquote>\n

Restart the Mac OSX native VPN client<\/p>\n

\nFirst see if the VPN client is already running:<\/p>\n

If it is, something like this will show up:<\/p>\n

root     36936   0.0  0.0  2435636   2040   ??  Ss    2:17PM   0:00.57 \/usr\/sbin\/racoon -x<\/div><\/div>\n

Kill it:<\/p>\n

sudo killall racoon<\/div><\/div>\n

or<\/p>\n

sudo kill -9 <em>process id<\/em><\/div><\/div>\n

example using the grep result from above:<\/p>\n

sudo -9 36936<\/div><\/div>\n

Start it up again:<\/p>\n

sudo \/usr\/sbin\/racoon<\/div><\/div>\n<\/blockquote>\n

<\/p>\n

 <\/div>\n

Free BSD Notes<\/strong>
\nPost-install configuration interface: <\/p>\n

\n
\/usr\/sbin\/sysinstall<\/div><\/div>\n<\/blockquote>\n

updatedb in FreeBSD is:<\/p>\n

\n
\/usr\/libexec\/locate.updatedb<\/div><\/div>\n

Doh! It’s the same command in Mac OSX! (Duh… )<\/p><\/blockquote>\n

command to upgrade FreeBSD packages:<\/p>\n

\n
portupgrade package_name<\/div><\/div>\n<\/blockquote>\n

Package management:<\/p>\n

\n
pkg_add (_check, _create, _delete, _info, _version) package_name<\/div><\/div>\n

The command adds package from FreeBSD ports (kind of like apt-get<\/span><\/code> for Debian or<\/p>\n

emerge<\/div><\/div>\n

for Gentoo)<\/p><\/blockquote>\n

To change the default startx to gnome:<\/p>\n

\n1. Locate (or create) ~\/.xinitrc<\/span><\/code>
\n2. Add exec genome-session<\/span><\/code> to the file
\n3.Save & exit
\n4. Logout and Login again<\/p><\/blockquote>\n

<\/p>\n

 <\/div>\n

Debian Notes<\/strong>
\nProFTPD: Local users without shell accounts cannot login<\/p>\n

\nIssue \/bin\/false<\/span><\/code> in \/etc\/shells<\/span><\/code> file\n<\/p><\/blockquote>\n

ProFTPD: After the above is issued, local users cannot list directories<\/p>\n

\nIf iptables is being used:
\nAs root, issue insmod ip_conntrack_ftp<\/span><\/code>\n<\/p><\/blockquote>\n

To restart the IMAP server after a server reboot:<\/p>\n

\n
sudo \/etc\/init.d\/dovecot restart<\/div><\/div>\n<\/blockquote>\n

To change apache log permissions while rotating logs:<\/p>\n

\n\/etc\/logrotate.d\/apache<\/span><\/code> (or whatever the log rotation script is called)
\nModify the create 640 root adm<\/span><\/code> line accordingly\n<\/p><\/blockquote>\n

To exit out of Text mode in Adobe Photoshop<\/p>\n

\nWhile still in Text mode, press and hold Command<\/span><\/code> key while pressing the return<\/span><\/code> key\n<\/p><\/blockquote>\n

<\/p>\n

 <\/div>\n

Cool “screen<\/a>” Tips<\/strong>
\nhttp:\/\/www.bangmoney.org\/presentations\/screen.html
\nhttp:\/\/www.darkcoding.net\/strategy\/gnu-screen-basics-quick-reference\/<\/p>\n

<\/p>\n

 <\/div>\n

Geeky Quotes:<\/strong><\/p>\n

To err is human… to really foul up requires the root password.<\/p><\/blockquote>\n

<\/p>\n

Unix is user-friendly. It’s just very selective about who its friends are.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

MS Office Notes Excel: To enter line breaks within a cell option + ctrl + return Excel: To edit a cell inline without leaving the keyboard ctrl + u Excel: To combine text from two different cells in one =cell1& " " &cell2 produces cell1 cell2 The key is in using the & sign at … Continue reading “Note to Self”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-227","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P54IqZ-3F","_links":{"self":[{"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/pages\/227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/comments?post=227"}],"version-history":[{"count":1,"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/pages\/227\/revisions"}],"predecessor-version":[{"id":981,"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/pages\/227\/revisions\/981"}],"wp:attachment":[{"href":"https:\/\/www.wiredatom.com\/blog\/wp-json\/wp\/v2\/media?parent=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}