Results matching “apache” from Ye Olde Rad Blog III

I have something to show you. Something very exciting. Sexy, even. "What it is, Rad?" you ask, oozing with curiosity. "A picture of a European supermodel? Lying scantily-clad on the sandy beaches of St. Tropez?"

No, my fellow technoluster. Something far more enticing. And seductive. See » HERE (.. but only if you're 18).

No, your eyes don't deceive you. That's right » a screen-shot from phpMyAdmin showing the tables of a MODx database using the UTF-8 character set and utf8_general_ci collation. Smokin', ain't it?

"But, Rad. I thought you said that was impossible?" It is! .. For mere mortals.

"How did you ever pull it off?" Well, I can tell you that banging my head against the wall produced only limited success. It may've even impeded the process. (I can't remember.)

To be honest, I'm not really sure WHAT the magic-bullet was. Cuz I made a number of changes (including enabling suPHP)  .. which I'll tell you all about. I learned a lot. But first, I need to take care of some biz .. and get some coffee. (Was up pretty late last night. Where did I put that Advil?)

Feliz año nuevo. Most Content Management Systems (such as Drupal & MODx) work in conjunction with (require) a database. So do blogs (such as Movable Type) & forums (such as SMF).

MySQL is the world's most popular database software for web-based applications (.. such as CMS's & blogs & forums). It's what I use. It's the only database system I've ever used.

The Rad VPS (« physically located downtown Chicago) uses the cPanel/WHM control panel to help administer the site. cPanel makes it stupid-easy to create a new MySQL database.

You simply » enter a descriptive name for your new DATABASE (such as » rad_modx) and click the button labeled 'Create Database.' cPanel talks to MySQL and creates the database for you. Viola! Done. Too easy.

To use your new DATABASE, you'll also need to create a USER (such as » rad_modx, conveniently same as the database_name). Give this USER a password and click the button labeled » 'Create User.' Voila! Done creating new USER.

Lastly you need to assign a particular USER to a particular DATABASE. You do this by selecting both from their respective drop-down menus (one lists all available DATABASES, the other all possible USERS) and clicking the button labeled 'Add.'

Then you assign to this USER the appropriate PRIVILEDGES (normally ALL) necessary to perform the database functions. Click the button labeled 'Make Changes' and you're done. Voila! As if this weren't easy enough, cPanel even has a wizard to walk you thru these steps.

So, in order to configure a database to work with a particular web application (such as Drupal or MODx), you need 3 pieces of info:

1. database_name
2. user_name
3. user_password

Couldn't be easier. Tho I sometimes forget the final step of actually assigning the USER to the DATABASE (after creating both). Creating new DATABASES is not something I do on a regular basis.

RADIFIED currently uses 5 databases. Three for the blogs » 1-each for the 3 different versions of Movable Type I have installed .. based on v263 (installed 2003), v335 (installed 2007) & v432 (installed 2008). Another for Drupal (2008). And 1 for MODx Revolution (beta5), which I installed a few days ago.

The Rad forum, which uses YaBB, doesn't use a database. (At least not yet.) Might be worth noting here that Movable Type, Drupal, MODx & YaBB are all OPEN SOURCE (better than free) .. as is MySQL.

While installing MODx a few days ago, I noticed they include an option to test your database connection & credentials .. to see if MODx can access it okay.

Created a dedicated 'Guides' page. See here » Radified Guides. Been meaning to do that for .. eons. This will allow me to off-load the guides listed here on the home-page, so I can clean it up.

I indented & right-aligned every other link .. to make them easier to read. What do you think? When the links were all lined-up together & left-aligned, they seemed too .. similar.

Eventually I'd like to include a representative graphic for each guide/link. But for now, I just wanted to create a page that contains a repository of the links to all our guides.

On a related note, I've been looking more deeply into MODx, the Content Management System (CMS). They are fixin' to release a new version (complete-rewrite, from the ground up, based on PHP5) .. called » REVOLUTION. (Current version is called » EVOLUTION.)

Drupal would be cool, but it's way too sophisticated for what I need. I don't want/need a PhD in CMS's. Here's a MODx site, for example. (I used to live in Lancaster, PA .. the heart of Amish country. Nice people there.)

I'd like to become intimately familiar with a good CMS .. as another skill to add to my digital toolkit. Only way to do that is » use one daily.

The good people at MODx claim a 'Release Candidate' version of REVOLUTION will be coming » "Winter 2009" (.. which is now). [ Notice how the words 'Summer 2009' have been lined-out. ] UPDATE » They just changed the RC date to "Spring 2010". Hmmm.

The MODx site is running REVOLUTION. I'm in no hurry, tho. Rather make a good decision than a hasty one.

Last month I mentioned a quest to learn the Unix shell .. specifically » bash (the Bourne Again SHell). Almost done. Currently ~80% complete .. enough to feel reasonably confident at a terminal.

The 'shell' is simply a program that lets you interact with the operating system (actually the kernel, to be more precise) ..

.. by taking your (text-based) commands and passing them on to the kernel. In my case, this kernel happens to be » Linux (which is but one variant of Unix).

The term 'shell' comes from the notion that this software acts like a 'layer' that sits between you and the operating system .. similar to the way an egg-shell sits between you and your hard-boiled breakfast.

The shell can be intimidating, cuz it uses a (text-based) command-line interface (CLI). No intuitive GUI to help you along. You either know the commands or you don't.

Didn't take me long to realize the CLI was where Linux's true power resides. When we upgraded the site, for example, to a Virtual Private Server, the support-techs who helped me with the move all used the command-line to work their mojo.

Most Linux distros do indeed come with an excellent GUI (usually either KDE or Gnome). But (but!) the Rad VPS does not. Which is why it became necessary to learn the Unix shell. (Something I tried to avoid.)

The Rad VPS is based on CentOS (Community ENTerprise Operating System), an off-shoot of Red Hat, which is probably the most popular of all enterprise Linux distros (.. and now a new member of the S&P 500, a development you may find telling).

GUIs (such as KDE or Gnome) require lots of memory/RAM. My laptop, for example, has 2-gigs, but the Rad VPS comes with an allotment of only 512-MB (.. upgraded from 384 just today).

With that limited amount, I need to run not only all the standard web applications .. such as Apache (web server), MySQL (database), Perl (scripting language), etc. but also cPanel/WHM.

So there's not much RAM left to run a GUI. [ Don't think I didn't inquire about installing a GUI. =) ]

Bottom line » if you wanna administer your own VPS, you need to learn the Shell. So that's what I'm doing. (Of course, there have been distractions, making progress uneven.)

Woke at midnight .. to a disturbing dream. (Didn't get back to sleep 'til 3:30.) Like any artist familiar with affliction, I didn't wanna let good angst go to waste. So I fired up the laptop and resumed my study of the UNIX shell.

Somewhere 'round 2AM I stumbled upon » The Art of Unix Programming (» book at Amazon.com), by Eric Steven Raymond. (Tho I can't recall how I got there.) He's the guy who wrote How to Become a Hacker, which I quote from time to time.

In his treatment of Unix Programming, ESR uses words like culture & philosophy .. which caught my attention .. cuz I've always been fascinated by other cultures .. not so much for the better/worse comparative aspects, but rather for the mind-expanding effect one gets from truly seeing the world from another's perspective. Plus he writes well (or has a good editor), which I appreciate. Couldn't stop reading.

Here are 10 statements/ideas I found particularly interesting and revealing. Perhaps you might also. (Minor Rad editing for brevity.)

• Unix was born in 1969. That's several geologic eras by computer-industry standards -- older than the PC or workstations or microprocessors or even video display terminals.
  
  
• Few software technologies have proved durable enough to evolve strong technical cultures, transmitted across generations of engineers. Unix is one. The Internet is another. Arguably they're one and the same.
  
  
• Unix has supported more computing than all other systems combined. It has found use on a wider variety of machines than any other operating system - from supercomputers to handhelds & embedded networking hardware, through workstations & servers, PCs & minicomputers. In its present avatars as Linux, BSD, MacOS X & a half-dozen other variants, Unix today seems stronger than ever.
  
  
• Unix's durability & adaptability have been astonishing. Other technologies come and go like mayflies. Machines have increased in power a thousandfold, languages have mutated, industry practice has gone through multiple revolutions. Still, Unix hangs in there, producing, paying the bills, and commanding loyalty from the best and brightest software minds on the planet.
  

Been reading about web site optimization (WSO), which stresses the importance of small, fast-loading web pages, that are lite on graphics.

First thing I did after analyzing some of my web pages in this cool analyzer .. was to remove the Lightbox script (even tho it was way cool), cuz it was costing me nearly 200-KB. (Ouch!)

Never realized Lightbox was so big. Actually Lightbox itself is only 18-KB, but it uses/needs Prototype.js (which is 124-KB) and Effects.js (which is 40-KB).

Didn't take long, once I delved into the world of WSO, before I began hearing about the virtues of » HTML compression.

Like WinZip for web servers, HTML compression squeezes web pages before sending them to you, which saves bandwidth. (Radified uses ~50 gigs monthly.)

Almost forgot .. June 5th was the site's » 8th anniversary. Happy birthday to Radified.

Was a little distracted at the time. No wonder I missed it. Everything turned out okay, tho. (So we're good to go.)

This is where I usually review the site's origins, philosophy, milestones & future. But I recently revised the About page to include this (+ inject more Rad techno-ego).

Eight is a long time in web-years. We were just getting started back when the dot-com industry was melting-down. Consequently, a small percentage of sites on the web today are older than 8.

This is our first b-day at our new VPS. Maybe someday we'll host on a dedicated web server, or at least a hybrid.

Besides a new web host, this past-year we got an open source version of Movable Type, a new table-less layout for the home page, a new Rad URL (compliments Apache mod_rewrite), and numerous upgrades to the forum (compliments YaBB).

Rode my mountain bike to the coffee shop today with laptop in tow. Now, I've carried my laptop along to the coffee shop numerous times (in the car). And I've ridden there plenty of times. But this is the first time I've biked there *with* laptop.

Not sure why this feels like such a cool thing, but it does. Maybe it's the sense of freedom it brings, like backpacking. Liberating.

I was patting myself on the back, telling a friend how I'd rode there with a zero-carbon footprint .. to which he responded, "Yeah, if you don't consider all the jet-fuel they burned flying in that coffee you're drinking."

On a more technical note, I started studying PHP & MySQL this week. Been wanting to learn those technologies for some time. Now felt like the right time.

PHP has become a powerful scripting language, and also very popular (used by more than 20 million web domains). And since it's based on the C programming language, I might learn some of that in the process.

Woohoo! I worked some Apache mojo today to "alias" the file-name of this home page (index2.html) to » index.rad.

That's so cool! Thanks to Nigel (Ghost Developer from New Zealand) for holding my hand. Here's the code I used to work this magic (added to .htaccess file):

RewriteEngine on
RewriteRule ^index.rad index2.html

Thus far, this technique has only been applied to the home page (starting with a baby-step). But in the future, I'd like to expand its use .. to 'radify' other key pages.

It has been a week since the home page was redesigned .. with a new table-less layout. Have you gotten used to it yet? Like it? (I'm diggin' it.) Been making slight tweaks here and there...

.. such as adding left-padding to the graphics in the center section, to keep text from butting up against images.

This padding also adds a slight indent (6 pixels) to the yellow tri-blade radiation symbols which begin each post.

Speaking of design .. I got a call from somebody saying they wanted to hire me to redesign their web site. (Cool.) My nuclear training instilled in me the notion that I need to know everything about everything before doing anything professionally.

Which might be true in the nuclear world, but friends say that ain't how the real world works, and that I already know more than enough to do web design professionally.

And I must admit, after reading (studying) those excellent books (» Head First XHTML/CSS, » CSS Mastery & » Dreamweaver: The Missing Manual), I *do* feel comfortable wielding web design mojo.

So if you know somebody who needs web work, I'm available. (And cheap.) I don't know PHP yet, but that's coming. Rad Web Design .. has a nice ring, no?

Today I paid for our second month of hosting at our new web host .. WiredTree (using half the refund I received from cancelling my annual subscription with Lunarpages).

During our first month of service, I've been closely monitoring resource usage .. at our new VPS server. So I have a good idea where we stand.

Everything in the world of Virtual Privates Servers, I learned, boils down to memory usage (RAM). Our hosting plan dedicates 384-MB to the site. (256-MB standard plan, plus a 128-MB upgrade).

If we exceed 384-MB, we would have to purcha$e more memory .. at a rate of $7.50/month per additional 64-MB RAM.

Here's what I found » the highest amount of RAM we've used thus far is 366-MB (see here), which equals 95% of our allowable limit. Kinda close, but this was only a short-term transient (1 hour).

Our highest *sustained* memory use is ~325-MB (lasting a few days), so that number might be more meaningful (85% max). Our average memory use tends to be in the range of 270-to-290 MB (75%)...

.. which is actually pretty comfortable. And it's not uncommon, following a reboot, for our usage to drop down to the 220-240 area, tho these low numbers tend to creep up over time (as Apache caches more pages).

Welcome to Chicago! .. "the Windy city." If you can read these words, you are resolving to the NEW server.

My registrar says it's normal for locations to go back and forth between old and new servers for the first 48 hours.

This is Radified's first venture into the world of VPS hosting. We've always used Shared hosting before (way cheaper). VPS is definitely a step up in the web world.

I changed DNS pointers at 2:30 PM (Tuesday afternoon). My registrar is located down in San Diego, so I think the closer you are to San Diego, the faster you'll resolve to the new server. (Not sure if that's how it works, tho.)

The site was backed-up (at OLD server) at 8AM (Tuesday). So any posts made between then and now are lost.

I feel good about the move, having done considerable research, and getting everything I wanted.