SSH Connect Script, Hax, Whatever...
Jun. 26th, 2008, 08:58 PM | Computers | Post a comment
I work with many different servers at work. Most tedious part is that I need to ssh in to them on a regular basis. Not all of them can I, nor do I feel should I, be adding SSH keys on to.
So I finally got around to writing a little script to hold onto logins and passwords in a handy little connection script.
Caveat Emptor...
Is it a bit insecure to put these into a single file in my home folder? Maybe. Is it even less secure that said file is executable? Sure. Is it damn convenient? Yes.
So, now on to it:
WordPress Lipsum Plugin
Jun. 20th, 2008, 10:57 PM | Web Design | Post a comment
Tired of copying/pasting Lipsum placeholder text?
Me too.
Behold Gippy's Lipsum Plugin. Bask in its laziness. With a simple {lipsum} in your post, page or comment you can embed 3 paragraphs of Lipsum text. It works on the creation or edit of those items.
Want a more specific number of paragraphs? Ok, you can do {lipsum:1} to get just on paragraph, or {lipsum:5}, all the way up to 10. I stopped at 10 'cause its a reasonably long enough post or page to fill.
Tested with WordPress 2.0 through 2.5 though there's nothing special about it and it should work with 1.5 as well (in fact, I think it does, but you shouldn't be running anything that old anyway). The text could be streamlined a bit while sensing the current activity and I'll do that once I'm more familiar with WordPress, but in getting started this will do.
So, now, go forth and pay attention to better things and let the placeholder text take care of itself.
MySQL bug with GROUP BY
Jun. 19th, 2008, 08:12 AM | Web Design | Post a comment
Found a nice little bug in the stable version of MySQL5 in the MacPorts repository yesterday.
Version is 5.051a and when using GROUP BY it ignored ORDER BY DESC and returned results in ascending order.
Its been a known bug since MARCH.
The MySQL5-devel port is working fine in the mean time, but holy shit. I have to wonder a few things.
1. how did it take me this long to find the bug (to my credit, I have no idea when macports pushed 5.0.51x).
2. why in the world hasn't it been fixed or patched yet?
Edit:
Now that I think a bit harder on the issue I might have noticed it earlier and chalked it up to being a n00b when I wrote other queries. When I upgraded this site I had to rewrite some queries that had mulitple joins and group by statements... I wonder if that was the same bug?
Apple's MobileMe drops support for IE6
Jun. 9th, 2008, 09:41 PM | Computers | Post a comment
For PC: Windows Vista or Windows XP Home or Professional (SP2) or later; Internet Explorer 7, Safari 3, Firefox 2, or later. Microsoft Outlook 2003 or later recommended.
So, Apple's pushing the dependency wagon to IE7. Love it. The faster IE6 is out of here the better.
"su" to root on OS X without enabling the root user
Jun. 4th, 2008, 08:56 PM | Computers | Post a comment
I guess this is an old unix trick, but I didn't know it:
sudo su -
You must have sudo rights (ie: be an administrator).
Thanks, Jeremy!