Results matching “server” 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.

Made some minor style-tweaks to the home page. The text you're reading now, for example, is slightly less-bright (easier on the eyes), while the links are a little brighter .. than they were before. (Might have to refresh your browser to load the revised style sheet.)

Visited-links in the sidebars are now slightly less-bright (grayer) .. than un-visited links. Used to be no diff.

Been studying more CSS. Becoming very comfortable tweaking styles. Fine-tuning. Easier for me to determine what I don't like, than what I do.

Oh, the date is also slightly brighter (whiter) .. than the rest of the text, and has a "text-transform" property applied to make it » UPPERCASE .. via a span tag with 'date' class attribute.

Upgraded the Rad blog to the newest version (4.32), which was released a few days ago. Way easier, now that I have Linux shell skillz & a VPS. Five minutes instead of 2 hours.

Movable Type v5.0 will be coming out soon. Currently at » beta-3. I normally install NEW versions of whole-number upgrades, rather than upgrading previous installations. Keeps the number of blog-entries down for a given installation.

Currently have 167 entries on MT 4.x. Lots of entries tend to make the blog respond sluggishly (when rebuilding). That would be » Ye Olde Rad Blog IV. (Started with v2.63 .. in May 2003.)

Considering installing a wiki (software). Can't hurt. Might help. Would be a place (beside the forum) where folks could post & reference their own info/content. Might be a good learning experience, too.

I have no experience with wiki's .. other than searching Wikipedia. Not sure which one would be best. So many choices. Ideas? Saw this comparison. Nigel once recommended Dokuwiki (I think) as a well-coded (PHP-based) piece of software.

The Dokuwiki download is 1.7 MB. (Compare that with the Movable Type download, which is 4.6 MB.) An über comparison of all Wiki's and their features is posted » HERE. Meanwhile Wikipedia, the mother-of-all wiki's, uses MediaWiki, which is both free & Open Source.

I'm reluctant to republish the content of others (as so many sites already do), but .. I found it interesting & noteworthy that » Microsoft has acknowledged Linux as a threat .. especially since I spent so many hours in Linux these past few weeks (learning the Unix shell)

Copy-n-paste snippet (minor Rad-editing for brevity):

"Microsoft acknowledges Linux as the first viable competitor to its Windows client business, due to the use of Linux on netbooks, which are rising in prominence as an alternative to full-sized notebooks.

Microsoft cited Red Hat and Canonical -- the latter of which maintains the Ubuntu Linux distribution -- as competitors to its client business, which includes the desktop version of its Windows OS." </snippet>

Notice how the article said » DESKTOP, and not server. Linux has long been a dominant force in the server market (.. if not the dominant force).

It's difficult to describe why Linux is so cool .. why using it feels so fresh & clean. But I think it has something to do with the good intentions .. that come from thousands of talented programmers donating their time & expertise .. to bring you (for free) an operating system they obviously believe in.

I might be imagining it, but I think you can actually feel these good intentions (while using Linux). Can you feel the difference (in intentions) between someone who genuinely loves you, and someone who is paid to love you?

Moreover, I feel our economy has a lot to do with the Linux threat to the Microsoft desktop. No matter how compelling the product, basic economics suggest it's hard to compete with free. (Which Windows is not.) And in these troubled economic times, free means more than it used to.

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 learning the UNIX Shell, which uses a command-line interface (from a terminal) .. something I've wanted to do ever since we upgraded to the Virtual Private Server last year. (Linux is a variant of UNIX.)

Even basic knowledge of (how to use) the Linux command line makes life administering a VPS much easier.

The Shell is simply a program that allows users (like me) to interact with the operating system (sometimes termed the 'kernel'). It can be conceived of as a 'layer' sitting between you and the operating system .. hence the term » shell.

Several shells exist, but nearly all Linux distributions come with » bash (Bourne Again Shell) .. cuz it's free, powerful and easy to use.

On my laptop I have installed a copy of Ubuntu Linux that I use to learn the shell (practice). Before jumping into learning the Shell, I figured this was a good time to upgrade my 'installation' of Ubuntu .. to the latest release (» v9.04, 'Jaunty Jackalope').

So I downloaded » this virtual machine (1.1 gig, using uTorrent). Had trouble getting it connected to the Internet, but that was due to my own inexperience with VMware, and not due to any short-comings of Ubuntu.

Anyway, I am really digging learning the Shell, cuz it's something I can use right away. For example, yesterday I upgraded the blogging software we use here at Radified (Movable Type) to the latest version (» 4.26). Something that used to take hours to accomplish was done in minutes .. (using a series of Shell commands). Beautiful.

XML is the foundation for several next-generation web technologies, such as XHTML, Ajax, RSS and Web Services. So it sounds like a good thing to know.

While HTML (the language of the web) is used to display information (how data looks), XML is used to structure & describe information (what data is).

XML is easy to learn, but comes with a set of related technologies, such as:

• XPath .. which is used to extract data from within an XML document (similar to how SQL works).
• XSLT .. a styling language which transforms an XML document/file into something else (such as HTML, PDF, ASCII or another XML file).
• XQuery .. provides advanced query functions on XML data, similar to SQL. More powerful than XPath.
• XPointer & XLink .. which work together to create hyperlinks to XML documents and to sections within XML documents (even if/when no named anchors exist, which is pretty cool).

So there's a lot to learn. (I'm about knee-deep into it.)

Since XML is just plain text, XML documents/files can be created or edited with any text editor, such as Notepad or Wordpad, which come with every version of Windows. But they provide no advanced features such as:

• line numbering
• tag completion
• syntax color coding
• checking for well-formedness
• validating XML files (against DTD & Schema)
• collapse & expand sections of code

I heard that the best (most feature-rich) XML editing software that's FREE is » Microsoft's Visual Web Developer 2008 Express Edition .. which I downloaded and installed.

Holy moly. Big download. Couple of gigs. They make you register the software, too. Took me a long time to finish everything .. after downloading all the updates (including the security patches & SP1, plus installing Microsoft's SQL Server 2008 Express).

Back when I investigated how to create a webpage template, a couple weeks ago, I really had in mind the notion of using a template as the basis for a new Rad guide .. not one on Dreamweaver Templates however, but rather one for » Drive Imaging & Disk Cloning. Today I created that template, and began a new Rad guide.

Definitely takes longer to get up-n-running when using a template, cuz you first must determine exactly how the guide will be structured .. and what items to include in the template, and what parts need to be editable.

Can't just start cranking out pages of text and entertaining new ideas (.. like I used to) .. leaving the details of page structure to deal with later.

Templates force you to pre-think everything up front, before you begin generating content-one. They even force you to anticipate changes .. which is new for me .. especially since I've grown accustomed to the ready-fire-aim approach, which leaves the details of page structure for later .. but by then it's difficult to make changes .. cuz each page must be edited individually (.. hence the need for templates).

I was so eager to get started on the guide that I actually had to start over (several times) .. due to major template modifications. (Arrgh!) Kept getting new ideas .. things I wanted to add/tweak.

You can always modify a template, as that's what they are designed for. But when a template requires many edits, it seems easier to just start over and create a new one. (Something I'm getting good at .. from all the practice.)

If you view this home page in Firefox (or a browser other than IE or Opera), you'll notice I added some rounded corners.

Been reluctant to spend much time focusing on site styling, preferring rather to concentrate on generating » content.

In the world of cars, for example, I've always preferred the spartan cockpit of a Porsche to the bells & whistles you find sitting in a corvette. Tho admittedly, that's just my druthers.

My point » function should never take a back seat to form.

I've considered adding rounded corners many times before. Countless techniques exist. But they always seemed a kludge. (Andy agrees.) So I never felt it worth adding the extra markup necessary.

Techniques that use graphics to achieve their effect involve inserting additional HTML elements that are otherwise unnecessary, because current CSS standards (v2.1) allow only 1 background image per element (while each box has 4 corners). Future versions of CSS (v3.0) will support 8 images per element (for this very reason).

This approach has 2 main problems. First, adding (otherwise) unnecessary markup goes against all that is holy to the Web Standards movement, which touts the tenent of 'Semantic Markup' as one of its pillars.

If I knew then what I know now. Ever uttered those words? Looking back on my progression of web skills, one omission stands out » incorporating the use of templates to help develop & maintain the pages of my web site.

Templates are both powerful & flexible for two reasons:

1. They speed up site development, by allowing the rapid creation of web pages based on a preformed (uniform) structure .. so all your pages have the same look & feel.
   
   
2. They facilitate site maintenance, by enabling structural changes site-wide via the editing of a single-file .. similar to how CSS works. This aspect of templates is considerably more significant than item #1.

If your web site grows bigger than expected (as they usually do), and you want to make structural changes (non CSS-based changes) to your web pages, you'll have to edit each page individually (.. which suks giant goose eggs). Tedious maximus.

When CSS came along, website designers could transfer all style controls into a single file, so that the look of an entire site could be modified by editing a single file (provided, of course, the entire site was based off of the same style sheet). Very cool development.

But what about structural changes? That's where templates come in. To be honest, I'm not sure if web design programs (such as Dreamweaver and Expression) had the ability to generate templates back when I launched the site. But they do now.