Reply from jomhosting on installing Drupal

My salute to jomhosting technical of their fast response and straight-to-the-point answer. I should just give them 5 thumbs up out of 5. They replied that i should use another software called Softaculous instead of Fantastico, which i tried and the installation was smooth, easy and no-hassle problematic experience. To my suprise, the installation of drupal took in less than 3 minutes as oppose to my attempt of using Fantastico where at the end of every trial ended up in error message. Well, who's fault is that? Jomhosting should just remove Fantastico immediately so that customers like me would not waste time trying to find workarounds and trouble shoot the bug.



And Yesss, after opening up my drupalfree.com/blog, i am finally able to see the correct output. I know it's so plain and nothing fancy about the site, but that's not the real thing in my head. It's just a test to see drupal is really running on my site.


.

Memang Bangsat Fantastico JomHosting.Net

aku dah try macam2 utk install kan CMS baik Drupal mahupun Wordpress, tapi semua hampeh shit!!! ni dah masuk hari kedua aku dok berjam2 trouble shooting problem running script both Drupal & Wordpress on my site using Fantastico jomhosting. In fact, i tried changing the directories from root to the subdirectories pointing to my addon domain. And not just that, i even manually configure the MySql database by creating new dB and appropriate username assigned to that particular dB with proper privilege access & re-run the script and all of that are in vain. The responded error were the same; everytime the script created the username that is assigned to dB, the character underscore was rejected by jomhosting. I'm pretty sure that this has nothing to do with the installation scripts of both drupal & wordpress because it was obvious that the error was the same. Bloody hell jomhosting nih!

Now the last resort, what i do now is uploading the entire directory structure with complete contents to my hosting. We'll see whether this works or not.

..

Current problems of cpanel seringgit.com to solve

1. The phpmyadmin does not show the menu 'Privilege' where i can add/edit/delete any MySql users. This is where i can add new user for my drupal dB and assign appropriate privilege to him. Perhaps i can try via the following method:
   
   
   
   1. MySQL database or MySQL dB wizard.
      
   2. Execution of SQL query at phpmyadmin - issuing grant privilege access
      
   
   
   
2. cpanel phpmyadmin does not show any mysql dB where i can check the available users inside table user. So there should be another way around for me to ensure a particular username can be created and he has access to my new drupal dB.
   
   
3. The settings.php at site/all/default/ shows a preset values for database name, username and password where they do not tally with the configuration of MySQL at cpanel. This happens when i run drupal script for installation process. Because of this i need to manually change the settings.php value and upload back to the hosting.
   
   
4. Perhaps one way to verify this is to install Wordpress and see whether this problem arises or not. I can also check how does the new username assigned to wordpress dB is contructed in my seringgit.com hosting.
   
   

Trouble-shooting attempts

1. I managed to assign one particular user (i've just created via cpanel) using MySQL database cpanel web-application to my drupal dB. So i think my mistake was, i tried to use phpmyadmin to do this task, but what i should do was to use MysSQL database icon in cpanel.
   
   The values set in settings.php are as below:
   
   Then when i re-run drupal script, another different problem occurs.
   
   
   
   

Problem running drupal script via Fantastico.

Till now i've able to install the complete drupal script but when i want to run & install drupal on my hosting, it failed. Partly because the script does not understand the auto created username seringgi_drupal (example ya) and database seringgi_drpl1 (also example ya) in file settings.php. So, what i need to do right now is to manually change the name and try to setup the valid MysQL username that has all GRANTED access to this particular table.


Well, i still need to refer to the guru-drupal-doc page -> "Installation Guide" along the way of trouble-shooting this problem. I hope i will be able to solve this by today.


The link is http://drupal.org/documentation/install/create-database

.

My 1st attempt of Installing Drupal Successfully

I've finally able to complete installation of drupal script successfully. I captured the whole process and it is attached as below.

First Attempt of running Drupal Script

This is my first attempt of running Drupal script on my computer. I have few bumps and need to spend few hours to find ways to fix the errors. Finally i got it right and i consider my my-first-time-attempt as quite impressive for the first time in a single day to correctly setup all DAMP programs, configure and run Drupal program.

I divided the videolog into 2 because the 1st one, i started to encounter errors in PHP setting file so i took a break while going off to nearby Pasar Borong for a quick shopping, I managed to buy my fresh Salmon slices and some big prawns. The Salmon is pretty expensive although still mush cheaper compared to those sold at Jusco. The price is Rm19/kg so i bought back home in total of RM23.

The 2nd videolog showed my attempt to troubleshoot all errors and they were all fixed.

Enjoy watching.

1st video but with few PHP setting errors.


2nd video with troubleshooting process and finally a success.

2nd attempt of Creating MySQL dB successful

I know already what is wrong with my 1st attempt of creating Mysql db. instead of applying the 'mysqladmin' at the DOS prompt, i wrongly type it inside the MySQL client and executed it, and that's why it resulted error message. The followings are the correct steps.



The complete doc and steps can be accessed from drupal "installation guidelines" as follows:
http://drupal.org/documentation/install/create-database

The link is http://drupal.org/documentation/install/create-database
.

First attempt creating MySql dB Failed

This was my first attempt of creating MySQL database using a command line via MySql client. It's like a DOS and usually for those who do not like command lines will definitely try to avoid using this method. Anyway i'm just trying a different more challenging method instead of using phpmyadmin GUI. And as expected it had failed.



The complete doc and steps can be accessed from drupal "installation guidelines" as follows:
http://drupal.org/documentation/install/create-database

.

Guidelines & Steps for installing Drupal

The actual doc can be found from Installation guideline drupal site. It's important to understand and appreciate few steps that need to be done when you're installing Drupal, this includes setting the settings.php file and creating database before you run the Drupal script.

Guidelines on Downloading Apache & Installation

Minimum Requirement of Drupal

Guidelines on Apache configuration

I'm considered fortunate because i'm able to configure all AMP components without any serious hassle, in fact i did it on my own. Anyway for documentation purpose i show below the steps that need to take when you configure apache; this is to ensure that PHP interpreter works in Apache.



Below are some videologs that explain step-by-step on how to configure.



This 2nd videolog shows the hands-on checking by opening up the actual httpd.conf file and go through the required lines step-by-step, whereas the above video only shows the config that requires update and only refers to drupal doc site.


..

Downloading drupal Core and installation

here is my videolog on how is the downloading and the installation on my notebook.

Drupal installation guidelines - reading stuff

I think the 2nd option of using a special package to install drupal with all required other programs such as AMP is a program called Acquia Drupal. This software package actually bundles altogether all D-A-M-P in a single installation program & once you un-compress and installed them, they will configure each program correctly. So, you don't have to figure out line by line for each program to work. The link is here. The drupal doc site does not specifically explain what is meant by using special package, i presume DAMP is an example of this scenario.