Ok I’m still obsessed with Chucknorrisfacts.com, (and with such quips as “Chuck Norris can divide by zero”, how can one not be?), but I’ve also got a life, and in this life I do websites, amongst other nefarious schemes to rule the world.
As such, I’ve recently come to encounter Drupal, which, in a sentence, is an open source content management system, and “can support a variety of websites ranging from personal weblogs to large community-driven websites”.
Drupal serves as the machinery behind Spreadfirefox.com and Linux Journal, and that was good enough for Aileen, owner of the famous Pinoywriters mailing list, to which every Pinoy writer I think, gravitates towards at some point in their lives. I know I did, which is how I came to make her acquaintance many years in the past. Aileen owns the domain Pinoywritersonline.com, which until a few days ago merely forwarded to her Multiply site, and which now serves as the area where we will conduct our Drupal activities.
At any rate, this post shall be about the install.txt file where obviously, instructions to its installation are thus provided. Unfortunately, it is without a doubt confusing to the average web developer, meaning one who is used to installing php-based applications using Phpmyadmin, instead of the command line access to MySQL which the instructions assumes.
In other words, the instructions are for users with command line aka terminal access, which is likely only if you run the webserver itself, or you rent webspace on one with a ‘virtual root account’. While arguably a preferable situation due to the more powerful set of activities a command line provides, most webserver accounts provide for Cpanel site management, making such tasks as creating email accounts, adding hosted domains and installing MySQL and PHP installations a menial, GUI controlled task.
Hence, after going through the installation, I have found a rewrite “for the rest of us” in order, where one will use PhpMyAdmin instead of command line commands.
Firstly, download this link install.txt, or at least open it in another window in the fashion your browser prefers.
You may skip the “1. DOWNLOAD DRUPAL” instructions, and just go ahead and download the latest non-beta release, (unless you are sure of what your doing and prefer an untested or older version, which I assume you are not).
It will come in a .rar file format, merely uncompress it and save on your hard disk.
Use FTP to upload everything onto your webspace.
- The 2. CREATE THE DRUPAL DATABASE is the tricky area. Instead of following that, proceed to the phpMyadmin section of the Cpanel of your webspace account. It usually looks like this, under “Site Management Tools”:
Click “MySQL databases” and create your mysql database. Whatever name you decide will usually be preceded by the webspace account. Assign a user with full privileges to it, and remember the password you gave it. I usually cut and paste it to notepad to avoid any unfortunate events.
- Exit the MySQL area, and click phpMyAdmin. It should look something like this, listing all of your mysql installations.
- The following replaces “3. LOAD THE DRUPAL DATABASE SCHEME”The installation files you downloaded include a database.mysql (for mysql) and database.pgsql (postgresql) file in the (drupal-x.x.x)\database folder.
- Next, after you’ve uploaded the files and readied the database, Drupal will now need to ‘connect’ with it, which the install file covers with 4. CONNECTING DRUPAL. We do that by opening the install file in “sites/default/settings.php”, where we see:
- Finally, one more thing. At some point Drupal will ask you to create a directory in your installation to store files in, asking you to name it “files/pictures”. Go ahead and do so, remembering to set the attributes of the pictures directory to be readable and writeable (666). This will assure the Omen will come and appear onto your Drupal install sometime soon, supposedly June 6, 2006. Just Kidding.
Mine looks like this:
We’re using mySQL, so obviously we’ll choose that one. Using phpMyadmin, browse your way to database.mysql on your computer, and press “GO”. I did that here:
In a second, phpMyadmin does its magic and performs the necessary 89 instructions resulting in 55 tables (results vary on version you’re installing).
Before editing, remember that saving a backup never hurts. Granted you’ve done so, edit by replacing the username and password with the mySQL username and password you created earlier, along with the database name. The format should look like this, in line 81 of the settings.php file:
$db_url = ‘mysql://database_user:password@localhost/name_of_database’;
You can leave the “$db_prefix = ”;” alone. Save, then upload to sites\default and voila! Enter the domain on your browser and view the Drupal admin page, where you create an account (the first account automatically has full admin rights), login, and start fiddling around.
Anyway here I am using my preferred FTP client Filezilla to do so.
Do that, refresh this page:
Then that red line will disappear.
I sincerely hope that someone will find this guide useful. Should it not do so or should I have erred in any way please let me know.