…it means this web server was successfully migrated to a RaspberryPi LAMP “server”, sitting piggy-back on the Technicolor DSL router I have at home (that means, powered by its USB port * and connected to one of its Ethernet ports).
I got it from local supplier inMotion making use of a free delivery campaign. There would probably be a few alternative places to look for, but I got it within a few days of ordering it, which is a bonus. Some vendors were having 8 to 12 weeks lead time for delivery, which is a little too much time for anxious geeks.
Overall setup took about 20 minutes, spent copying backup files back and forth, installing new packages (apt-get LOVE) and reconfiguring the Apache2 rewrite rules and vhosts. There’s a Murphy waiting out there for me to screw things up as soon as I try to upgrade WordPress, change the SD card to something bigger, better,faster or finish messing up with the DNS (everything may soon be migrated to pi.against.org).
After being hosted on a HP mini-desktop (with 128Mb RAM and running a stripped version of Debian and nicknamed “reboot” as MySQL would occasionally hog all the memory and hang), a MacMini G3 (which at some point had 500 days uptime and which made me fell in love with lighttpd and other alternatives to Apache) and a MacMini Intel (which is now promoted to MediaCenter of sorts), it is only getting better when I manage to host it inside the access gateway itself (I’ve been farther from reaching that).
With the prospect of plenty of free time in the future and diapers to change regularly, I predict plenty of free time for some hacks. Hopefully.
I’ve been asked about the case. It’s a Rascase I got from ebay, tipped by Rogério’s post. It sure looks cool but it may prevent air from circulating when the CPU goes nuts. I’m feeling tempted to drill a few holes on the top panel to ruin the thing.
(*) Yes, the instructions mention the rPi isn’t supposed to be powered from a USB port on other connected equipment. But voltage measured using the recommended method is going steady on 5.0V.
… has just begun and is turning out to be quite an awesome month…
Through all those years being a DBA, I never really managed to get on the Oracle train as I wanted to. Hours and hours of training went by (which told me countless things I would fail to apply on real use scenarios), several months of operation and support, an infinite amount of time wasted in front of ISQL sessions with Korn Shell (so 19th century) bindings. A nightmare. Third party management apps made it suck a little less (out of which SQL Tools, free software, is REALLY a find), but from the management point of view, even Microsoft SQL Server got it better.
I never liked Oracle. Their website. Their logic. The tnsnames bluntness. Their stupid (and yet deterministic) error messages. Their (I’m lacking negative adjectives here, help) range of products. Their attitude. A little piece of me died when Sun and MySQL got into the Oracle bucket. Sigh. I respect the enterprise database product. I do. It’s probably (eh) quite powerful, but it’s too fucking much.
It’s frigging 2012 and I have to deal with people saying Oracle is better than MySQL for whatever they’re building while a single MySQL by my side peacefully deals with several requests per second on a 30 Gb database and tables with hundred million records. Eh. Whatever.
So I’m stuck with these guys saying I have to install Oracle Database Express Edition somewhere.
After getting through a considerably bad registration form (which I cheerfully filled with fake data) to download the .rpm file (“Linux”, they say. Either that or a Windows .exe) and end up failing to install it seamlessly on the first two systems I tried. The first Ubuntu Server virtual machine failed to satisfy the dependencies (oh, the joy of building packages for multiple distributions), then it had too little swap memory (and that’s it: too little, it wouldn’t help by saying “hey, you need 10G of swap). Then I tried it on CentOS. Installed fine without any complains about dependencies or swap space.
For a moment there, I thought I would be having a field trip to DBA land again. Then I got a pretty clear (not) “Database Configuration failed. Look into /u01/app/oracle/product/11.2.0/xe/config/log for details” error message. The given directory, carefully perused, showed a bazillion entries saying “ORACLE not available”. No shit, Sherlock?
It turns out that the blocking issue was just me not having an entry on /etc/hosts with the same hostname as the one on /etc/sysconfig/network. That simple. I lost an hour looking at log files when a simple Google search could point me to the right place.
Oracle can be a quite powerful tool, I have to admit. I’m glad I no longer have to use it on a daily basis now. But it was about time they got the installation procedures a little clearer, no?
Too good not to share…
but then again, the spanish version doesn’t get any better…
Spotted on a technicolor gateway.