Categories
System Administration

Zones on a single server

A few months ago my co-located Solaris server was hit by a root kit that setup a IRC bot. It appeared that it got it by attacking one of the off the shelf web apps I use.

To prevent having to do a complete rebuild in the future if this happens again, I decided to put each major externally visible service in a Solaris Container (also known as a zone). So, I have a Mail zone, and a web zone, and then actually several more web zones that were proxied behind the first web zone. The global zone uses ipnat to port forward to the mail zone and web zone.

Then, when it turned out that the server was losing a hard-drive when I bought a new server, I was able to copy the zones to the new machine without having to re-install everything.

If I ever move away from Solaris/SPARC, I would probably do a similar setup with VirtualBox or VMWare, but Solaris is particularly nice in that patch management is unified across zones, and I believe the Copy-On-Write nature of ZFS makes for more efficient disk utilization. On the other hand, SATA drive in a modern PC mean that you probably don’t care about those features as much as you do when using a 73gig SCSI disk.

Categories
Family

Another

And another picture of David

Now that he has had a bath and is finally at home.

Categories
Family

Meet The Newbie

Yep, that’s David alright. Deb has the details elsewhere for those that follow her. He is less crusty looking now then an in the picture, but still has the IV in.

Categories
Reviews

Samsung BD-P1590, semi-review

This is an affordable BluRay player that also supports some streaming media. It works with Blockbuster Direct, Netflix, Youtube, and Pandora radio. As far as I can see, Netflix and YouTube are increasingly common features, but Pandora is unique to this device.

To cut to the chase, I rather like this device.  I especially like the Pandora streaming feature.  However, it seems like it could have easily been even better.

Setup

I am using this with a basic Visio 1080p LCD panel connected via HDMI.  The audio out on the LCD panel go to an external stereo amplifier and external 2.1 speakers.

Installing the unit was trivial.  Remove old upscaling DVD player, attach HDMI cable, fish the power out the back, and plug it in.  For networking, I just plugged it in, and it asked me to do a software upgrade, which was painless. I’m happy with that.

Basics

Yep, it is Hi Def. It seems reasonably fast and responsive and easy to use.

Extra Software

I love the YouTube and Pandora features. Especially the Pandora (and I believe this is the only device that supports Pandora).

However, in the extra media players is where some rough edges start to show. The first complaint I have is the requirement that I only use this with no disc in the optical drive. This seems ridiculous to me. I watch a fair amount of episodic shows on DVD, so it isn’t uncommon for me to want to leave the save disc in the machine for a month at a time, and having to remove it to use Pandora or YouTube is irritating. What really rubs me the wrong way about this is that it seems like such a pointless restriction.

The next complaint, which is less significant, is entering text into Pandora. You have to use the arrow buttons to select letters, and there is no auto-suggestion system. This isn’t something you will need to do much though.

Then, entering text in YouTube is done by having multiple letters per numeric key like texting on a cell phone (ABC on 2, etc). Plus in the YouTube player, they provide suggestions for you to pick and edit. This is much superior to the Pandora text editor. However, that leads me to another complaint, which is that they aren’t the same. Why would they include two or more different text editors? Will I find a third style if I ever try to use Netflix?

I complain about the above things because it seems that they should have easily been able to double how nice the device is by fixing the text editors and required disc removal. They really are a bit of a stain on an otherwise great experience.

Beyond that, since this device can stream media over the network, and it can play many types of arbitrary file burned to a DVD, why in the world won’t this device stream music and video from my Mac or home server? Surely it has the power and the extra program space would have trivial?

Finally, I rather wish they would have included a web browser. I realize this is less trivial to do. OTOH, this box does run Linux, and WebKit (the heart of Chrome, Safari, and the web browser on numerous phones) is supposed to be light weight. Considering the potential support headache, I can understand if this were a feature saved for a higher end unit, but they don’t offer it on any of their models as far as I can see. This is still more wishfull thinking than a legitimate criticism though.

Conclusion

Despite the complaints, I really do love this device. I wouldn’t want to replace it with any other single machine. I may be convinced to replace it with a PS3 and a 2009 Mac Mini together, but I don’t anticipate getting those anytime soon.

I do hope that a future firmware update will unify the text editors and remove the requirement to remove the discs. Samsung, I hope you are reading this.

Categories
Cooking

Crockpot Jambalaya

Sorry, no picture this time since I was taking it to a church function.  I think that the seasoning could use some tweaking, maybe a bit less cayenne.  Also, the cooking time for me should have been closer to the smaller number listed, rather than the larger number.  The one time I did make it, I cooked it for 4 hours on high.  Next time I’d prefer to try 6-7 hours on low.

  • 1 pound skinless/boneless chicken breast in 1 in. pieces
  • 1 pound andouille sausage, 1 in. pieces
  • 28 oz. can diced tomatoes with juice
  • 1 large onion, chopped
  • 1 large green bell pepper, chopped
  • 1 cup chopped celery
  • 1 cup chicken broth
  • 2 tsp. dried oregano
  • 2 tsp. dried parsley
  • 2 tsp. Cajun seasoning)
  • 1 tsp. Cayenne pepper
  • 1/2 tsp. dried thyme
  • 1 pound raw shrimp, peeled/deveined (frozen in a bag is fine)
  • 16 oz. frozen okra
  • 2 cups rice

DIRECTIONS

  1. In a slow cooker, mix everything but okra and shrimp and cover.
  2. Cook 7 to 8 hours on Low, or 3 to 4 hours on High.
  3. Stir in okra during last hour of cook time. Stir in the shrimp during the last 30 minutes of cook time.
  4. Serve with crusty baguette bread.
Categories
System Administration

Setting up a jumpstart server for Solaris Express.

I guess this post will have a somewhat limited life span since Solaris Express is being retired in favor of OpenSolaris. However, some of the pages I always refereed to every time I needed to do this have disappeared, so I’m writing it up again anyway for future reference. Maybe I’ll update it again when I try out OpenSolaris finally.

This will require a Solaris 10 Solaris Express, or OpenSolaris system to be the jumpstart server, and then of course a client that you want to install Solaris Express on.

Step 1, download the Solaris Express DVD image from. Currently, a link to this image can be found here: http://hub.opensolaris.org/bin/view/Main/downloads

Step 2, loop back mount that image somewhere on the jumpstart server.

[jdboyd@u80 ~]$ sudo lofiadm -a sol-nv-b127-sparc-dvd.iso /dev/lofi/1
Password:
[jdboyd@u80 ~]$ sudo mount -F hsfs -o ro /dev/lofi/1 /mnt
[jdboyd@u80 ~]$

Step 3, run the install server script.

[jdboyd@u80 ~]$ cd /mnt/Solaris_11/Tools/
[jdboyd@u80 Tools]$ ./setup_install_server /path/to/where/you_want_it

For /path/to/where/you_want_it, I use /export/jumpstart/Solaris_11.  At this point be prepared to wait awhile.  It doesn’t ask any questions while it works, so perhaps you can head onto the next step while still waiting.  When this completes, the install server is installed, so:

[jdboyd@u80 Tools]$ sudo umount /mnt
[jdboyd@u80 Tools]$ sudo lofiadm -d /dev/lofi/1

Step 4, gather the information you need from the machine to install.  You will need the MAC address, the IP address to use, the hostname to use, and the hardware type, which will probably be sun4u or sun4v.  The IP and hostname will already need to be in DNS.

Step 5, add the client to the install server.  This will use the information from step 4.

[jdboyd@u80 ~]$ cd /export/jumpstart/Solaris_11/Solaris_11/Tools/
[jdboyd@u80 Tools]$ sudo ./add_install_client -i $IP -e $MAC $HOSTNAME sun4u

Obviously, you need to substitute the $ items in the above command with the proper values.

Step 6, finally, you are ready to install on the client.  So, on the client, get to the open boot prompt, and do this:

ok boot net - install

At the point, your install proceeds normally. If you get a small stack of “Timeout waiting for ARP/RARP packet” messages right at the beginning, don’t worry. If it does it seemingly forever (say 15+ minutes), then maybe you do need to worry.

Some of this was taken from http://www.sunmanagers.org/pipermail/summaries/2005-March/006223.html

Categories
Programming System Administration

PostgreSQL connection pooling for mod_php

In a quest for better performance with postgres, I’ve been looking for connection pooling tools. There are a few quirks that I tend to require be met. First, it must run on Solaris. This isn’t so much a quirk, since the server runs Solaris and is SPARC hardware, and I’m not going to install a second server in colo just to accomodate software that doesn’t work on Solaris/SPARC. Additionally, I refuse to install GCC, so it must build with Sun Studio, which is much more GCC compatible that it used to be, but still isn’t GCC. Also, I want it to be reasonably simple to install and setup. I am willing to consider prebuilt packages from sunfreeware. If I get desperate enough, maybe even blastwave. Unfortunately, none of the top choices appear to be on sunfreeware.

The top choices appear to be:

  • pgpool

    • This is the classic choice, building and install is easy, but setup is very arcane.

  • pgbouncer

    • This looks like it should be simple to install and setup, but the configure script refuses to find my libevent install.

  • SQLRelay

    • Works for many databases, unlike the others, including sqlite. However, it requires the rudiments library from the same author, and this library won’t build because the autoconf stuff doesn’t understand anything but GCC.

So, I haven’t broken down to checking out blastwave yet, but so far none of the normal choices are working out for PostgreSQL connection pooling.

Then, I made a small breakthrough when I found that PHP has pg_pconnect. pg_pconnect does some background bookeeping to keep connections open after you call pg_close, and return the same connection if the arguments are the same. Practically, this means that if you use a PHP system that keeps persistant php interpreters (say, mod_php in Apache, which is what I use for PHP), then you have effectively gotten connection pooling for PHP only.

This is a big help already, but I still need a solution that helps out with python.

Yes, I am working on a little web development on vacation.

Categories
System Administration

How to reset a wordpress user password via SQL.

I found I had forgotten an admin password on a WordPress site I run. After figuring out how to reset it, I thought I would stick it here so that I can find it myself again in the future.


UPDATE wp_users SET user_pass=MD5('secret_password_here') WHERE user_login = 'yourself';

Categories
Programming System Administration

Databases for simple web development

I have log been a fan of PostgreSQL over MySQL, believe that PostgreSQL is more feature complete and generally as fast or faster, with obvious caveats about being used appropriately, of course, and not to mention no real comparative testing. Every body gets to have an untested opinion, right?

I did end up doing some performance testing though. What I learned is that both are reasonable fast at simple queries. Great. However opening a new connection to MySQL is much faster than opening a new connection to PostgreSQL. Once the connection is open, but seem equally fast for very simple tests.

Why this matters though is that simple web development in many languages with the most common tools don’t do connection pooling. If you want to just whip up an example PHP program using mod_php, then every page load will result in a new connection. The same goes for mod_python or mod_wsgi (as well as frameworks sitting on top of those plugins). Using each of these common tools with PostgreSQL results in a slow web site. This was driven home when I upgraded from a single 550mhz UltraSPARC II to a dual 1.1Ghz UltraSPARC3 III, and still certain web apps I’ve been tinkering with writing using PostgreSQL for the database are slow.

Certainly there are ways around this. Using a database connection pooling tool for starters, would certainly cure the problem. Also, choosing something that keeps your script running (or a least your database connections open) would also help. Or even writing your application as stand alone program that keeps the database connections open and talks to the web server via JSON-RPC or XML-RPC. But, to quickly whip something out MySQL may be simpler.

Of course, for some applications Sqlite could be a contender. Certainly it is very fast, and very simple to use. For a scalable web site though, it is probably out of the question. There is a reason that Django defaults to using Sqlite first though. And there are also, those less traditional database servers like CouchDB or memcachedb which seem to generally have very fast connection times.

This is a bit disappointing though. AOLServer used to offer connection pooling built into the web server. Of course, I certainly don’t want to use TCL as my development language, but still that would be nice to have.

Meanwhile, can anyone suggest a good Solaris and PostgreSQL connection pooling library?

Categories
Programming

toStr – A small C++ utility function.

This can be used as string(“bob”) + toStr(5) without declaring the type, presuming that the type can correctly be inferred by the compiler. Obviously, T must support operator<<. 

template <class T>
static inline std::string toStr(T v)
{
  std::stringstream s;
  s << v;
  return s.str();
}