mental spew
In Terminal:
Popularity: 84% [?]
Posted in Snippets.
– 11/5/2007
I have received several requests for the source of my MailAnnounce script that is able to speak the subject of mails using Mail.app and Applescript.
Source for version 1 of the script is now available.
Popularity: 89% [?]
Posted in Apple / Mac, Development.
– 10/9/2007
This weekend I was contacted by a client regarding a server that had run out of room on the main hard drive. Among the things that were corrupted by the drive filling up was the RPM database.
When trying to query of upgrade any package, the error message
A search turned up this howto on repairing the db.
These two commands made quick work of the fix. First remove any old lock files:
Then rebuild the RPM database:
Popularity: 90% [?]
Posted in SysAdmin.
– 9/10/2007
Copy an entire database:
Copy a single table:
This shortcut only works if you can access the local DB without a password. If you have to login to both local and remote MySQL servers, the MySQL password prompts get mashed together. You could specify the password on the command line like
but your shell may keep the password in its history so that anyone with access to your account could pick through your shell history and retrieve the password. Using the MySQL password prompt doesn’t do this.
Popularity: 100% [?]
– 8/31/2007
For PHP’s gethostbyname() to work properly, the server’s DNS must be properly configured with available nameservers in /etc/resolv.conf (on Linux boxes). Without a work domain name resolution kit, gethostbyname() returns the hostname supplied to the function.
Make sure /etc/resolv.conf contains several nameservers to query. The format is
Where xxx.xxx.xxx.xxx and yyy.yyy.yyy.yyy are the IP addresses of nameservers the host has permission to use.
OpenDNS is a free DNS service that allows public access to their nameservers at:
To use in /etc/resolv.conf use:
Using OpenDNS’s nameservers could even boost your server’s performance. Their goal is to provide some of the faster domain name resolvers on the internet for free.
Popularity: 26% [?]
Posted in Development, PHP.
– 8/23/2007
Recent Comments