Category Archives: Weblogs.us

[Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00’

Last night I had an error show up a couple times while using Navicat to backup database on Weblogs.us. This was the error: [Err] [Bak] 1286 – Unknown table engine ‘InnoDB 00:00:00’ On this server MyISAM was preferred so I had specifically disabled InnoDB, yet something was trying to deal with InnoDB and it was causing the backup error . To determine which table(s) were causing the problem, I used the following SQL statement: SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES WHERE TABLE_SCHEMA =

IPCop ‘boot error’ occurs after successful installation

Summary of article: If you mount the IPCop (or smoothwall) ISO via IPMI and then install, you are likely to get a boot error once you reboot and the ISO is unmounted. A workaround is to install via an actual DVD drive* (USB, SATA or IDE should all work) *you can remove the drive after install. All the gory details: This weekend I was at the datacenter for work. Part of my task was to setup a new firewall using

Sweet Designs (contest crash)

Unfortunately it looks like Amy Atlas slashdotted herself today 🙁 SWEET DESIGNS – AMY ATLAS EVENTShttp://blog.amyatlas.comWe hope you guys have had as much fun playing this game as we had putting it together and reading the posts.  We also hope that you loved the Sweet Designs Pastel Pretty chapter.… A cool scavenger hunt contest with a 4PM entry deadline came due today at her site. My wife briefly  described the contest to me and it seems as if 7 related (and some

Travel router tips: use Android for Internet, Ethernet crossover cable for file transfers

I have a makeshift travel office setup: Lenovo X220, Dell M6500, Dell 27″ LCD, keyboard, mouse and a couple Optimus V Android phones… Wifi Hotspot: useful for more than just internet connection sharing! I’m working for a few weeks away from home with only the equipment above. One of the handiest features has been the Android phones. They have the Wifi hotspot feature enabled. This allows both laptops to connect to the Android phone and share its internet connection. But

Monitoring Apache2 bandwidth usage by individual VirtualHosts

At Weblogs.us we have been going through bandwidth at a fast pace lately. We use Apache2 as our web server,  and while we have some rough bandwidth monitoring tools, we could really use a more granular view of bandwidth usage. The ideal solution for us would be a time configurable view (i.e. hour, day, month, year) of bandwidth usage on a per VirtualHost basis. While researching solutions these were the most useful links I found: Apache Virtual Host Bandwidth Monitoring

ProFTPd MySQL configuration / Linux free space check / setting Gentoo static IP

Links and info that were useful during a recent database server move: #1 Setting (or changing) a static IP address on Gentoo: Gentoo Forums :: View topic – Switching to a static IP (within your network)http://forums.gentoo.org/viewtopic-t-747458-start-0.html #2 Find out how much disk space is left in Linux, or what the disk size is Linux Command To Find How Much Disk Space Is Being Used Show Displayhttp://www.wallpaperama.com/forums/linux-command-to-find-how-much-disk-space-is-being-used-show-display-t713.htmla simple linux shell command to show you how much space a directory is using

Fixing Warning: date() [function.date] in PHP 5.3 [solved]

If you recently upgraded to a newer version of PHP, like PHP 5.3, you may be getting some errors similar to this in your PHP scripts: Warning: date() [function.date]: It is not safe to rely on the system’s timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘America/Chicago’ for […]  instead

1030 Got error 28 from storage engine mysql [solved]

If you receive an error from your MySQL databaser server that reads: #1030 Got error 28 from storage engine Then  you will want to check and make sure your server has sufficient free space. One of my servers gave this error and it was because the drive  that MySQL was installed on had no more free space. So, I repeat, if you get this error check and make sure you have free space! After freeing up some space everything started working