spack++

Sometime ago, I got forum.holaservers.com up and running.  I never put anything on it, but today, I at least tried to have it be usable.  I don’t think anything links to it, but it is at least a start.  I added forums for HolaServers and ShopThar.  It would be nice if folks could go use the sites and come give feedback.  Especially for the shopping stuff I would folks to start to come up with user stories and then I can see if I can satisfy them.  Like cool ways to find cool products.  I am pretty sold that I can build a pretty dang useful site, but it isn’t there quite yet.

Feel free to go register and start giving feedback.

Enjoy!

Earl

Kind of afraid that folks will hate me for it, but tonight I tried to add a couple little text links to the bottom of holaservers pages.  You can see examples here and here.  I figure that so long as I don’t have banners or for sure pop-ups, then folks won’t hate it too bad, right?  Guess there’s a decent chance though.  So why risk it?

1. Imagine a world where I have a couple million websites and since they are largely indexed, I would potentially have millions of links to cool sites like computercomparer and potentially cool sites like kindlekindle. Just can’t miss out on the potential page rank.
2. I already wrote good old MyUrl stuff and I might as well use it.
3. Could handle giving folks another reason to actually upgrade.
4. It’s really not that intrusive, really.

Enjoy!

Earl

I spent quite a bit of time getting mod_perl, apache and mysql to play nice on solaris (the nevada builds) some few months ago.  I eventually found CoolStack and after some amount of effort got up and running.  A nice private wiki page documented each command needed to get up and running on a solaris zone.  Recently I got a new X4150 from Sun and wanted to try out their project indiana stuff, which I guess is really OpenSolaris proper.  Oh, and I want my samp to run from inside a zone, did I mention that?

My goal for this post is to go from a fresh OpenSolaris 2008.11 zone and to get this one-liner to work

• perl -e “use DBI;my \$dbh=DBI->connect(‘DBI:mysql:database=mysql’, ‘root’, ”);print ‘ping=’ . \$dbh->ping . qq{\n}”

Here is an overview

1. Install OpenSolaris 2008.11.
2. Create a zone, which I called tester3, since my first couple attempts didn’t go so hot
3. Install some packages
4. Start some services
5. Install some perl packages
6. Give it a go!

After 1 and 2, let’s see where we are.  Just for kicks, let’s give our one-liner a shot.  I get

-bash: perl: command not found

Turns out that the zones create in OpenSolaris are pretty dang bare, as per this article.  In fact, many programs, like less and telnet, that I expected to have there, weren’t.  Using this page, and this command

• pkg search -lr telnet

helped quite a bit.  Looks like my zone starts with 54 packages.  Sun’s Web Stack project provides an amp-dev package, so let’s install that and a couple other things for 3.

• pkg install sunstudioexpress SUNWperl584usr amp-dev

As per the article above, the packages get pulled down and all together those three packages look to be 585.31 megs, so it takes a minute or ten to get downloaded via my cable modem connection.

Once installed I try again and get

• Can’t locate DBI.pm in @INC (@INC contains: /usr/perl5/5.8.4/lib/i86pc-solaris-64int /usr/perl5/5.8.4/lib /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int /usr/perl5/site_perl/5.8.4 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.8.4/i86pc-solaris-64int /usr/perl5/vendor_perl/5.8.4 /usr/perl5/vendor_perl .) at -e line 1.  BEGIN failed–compilation aborted at -e line 1.

DBD::mysql seems to install better with mysql up and running, so as per the Administering MySQL Server section of this page, we

• svccfg import /var/svc/manifest/application/database/mysql.xml
• svcadm enable application/database/mysql:version_50

The DBD::mysql tests want to run mysql_config, so we need to get that in the PATH

• export PATH=$PATH:/usr/mysql/5.0/bin

Now we’re ready to install DBI and DBD::mysql.  The first time or two through I tried installing the SUNWpmdbi package, but it didn’t play well (perhaps because it is like a year old), so instead I do

• perl -MCPAN -e shell
• install Test::More DBI DBD::mysql

Perhaps a little too hard, but now, so, nice!

• root@tester3:~# perl -e “use DBI;my \$dbh=DBI->connect(‘DBI:mysql:database=mysql’, ‘root’, ”);print ‘ping=’ . \$dbh->ping . qq{\n}”
• ping=1

Time to try out mod_perl.

If any Sun or web stack folks are reading, including packages for DBD::mysql and a more modern DBI would be great 🙂  And maybe adding the mysql bin to the path?

Enjoy!

Earl