FAQ - How to Install Magento on PC - Asked By waseem kaleem on 20-Jul-11 09:21 AM

I want to install magento cms.I have installed AppServer.I have changed my local computer host from localhost to www.waseem.com when I install Magento cms,In configuration step,when I click Continue then Database Connection error exists. Can any one heps me?

Kalit Sikka replied to waseem kaleem on 20-Jul-11 09:22 AM
Please forward the exact database error

Or

Follow: www.magentocommerce.com/.../tutorial-integrating-3rd-party-cms-.
Reena Jain replied to waseem kaleem on 20-Jul-11 09:24 AM
Hi,

I think the issue may be the use of non alpha numeric characters in the database password. MySQL allows it, but apparently the Magento ap doesn’t. Anyway, change password to a long alpha numeric string (uppercase and lowercase, no symbols) finally you will get to the next page in the installation process.

hope this will help you
waseem kaleem replied to Kalit Sikka on 20-Jul-11 09:26 AM
"Database Connection error" string displayed and page back to Configuration mode.There is no error number or instruction are displayed.
Jitendra Faye replied to waseem kaleem on 20-Jul-11 09:26 AM

Firstly you will need to edit a Magento file to acheive this technique, it’s pretty easy to do so anyone should be able to follow this tutorial but if your not confident editing a file get a friend who is to do it for you. To edit any files we recommend that you use PSpad which is a text editor specifically built for editing php, javascript files etc.

1) Open you Magento folder and go to the directory /js/prototype/

2) You will see a file titled validation.js, open this file in your text editor.

3) Look for the code between lines 505 to 507, it should look like the code snippet below.

1
2
3
    ['validate-url', 'Please enter a valid URL. Protocol is required (http://, https:// or ftp://)', function (v) {
                return Validation.get('IsEmpty').test(v) || /^(http|https|ftp):\/\/(([A-Z0-9][A-Z0-9_-]*)(\.[A-Z0-9][A-Z0-9_-]*)+)(:(\d+))?\/?/i.test(v)
            }],

4) now you want to comment out those three lines of code by typing // in front of each of them, the code snippet below gives an exact example of what you should end up with after the edits. These edits disable only those three lines of code which check for a valid domain name upon Magento installation.

1
2
3
    //['validate-url', 'Please enter a valid URL. Protocol is required (http://, https:// or ftp://)', function (v) {
                //return Validation.get('IsEmpty').test(v) || /^(http|https|ftp):\/\/(([A-Z0-9][A-Z0-9_-]*)(\.[A-Z0-9][A-Z0-9_-]*)+)(:(\d+))?\/?/i.test(v)
            //}],

5) Install Magneto on your localhost, after install has completed successfully revert the validation.js file to it’s original code by removing the instances of // you added.

You should now have a fully functional install of Magento on your WAMP, XAMPP install on your home PC or business development server.

Follow this link-

http://futureplanmedia.com/how-to-install-magento-on-localhost-without-url-validation-error/

waseem kaleem replied to Jitendra Faye on 20-Jul-11 09:32 AM
I have done this technique but the page is backed to Configuration step
Devil Scorpio replied to waseem kaleem on 20-Jul-11 11:06 AM
Hi,

The database is not stored on the same server as the website so you cannot use localhost.

you can view all of your databases connection information by following below mentioned instructions

1. Log in to your Account Manager.
2. From the Products section, click Web Hosting.
3. Next to the hosting account you want to use, click Launch.
4. In the Databases section of the Hosting Control Center, click the MySQL icon.
5. Click the pencil icon next to the database you would like to get connection strings for to open its edit features.
6. Click the Configuration icon in the menu bar. 
Devil Scorpio replied to waseem kaleem on 20-Jul-11 11:08 AM
Hi Waseem,

Magento installation problems on Windows at Configuration step

Case. Magento installation process hangs up on Configuration stage and doesn’t move forward instead redirects and returns to the same step, displayig no error notifications.


Environment. Windows XP, Apache 2.x, PHP 5.2.x, MySQL 5.x, Denwer

Here is solution of the problem.


Solution.

  1. Unpack Magento distribution somewhere under localhost. For example, you should be able to access Magento installation through http://localhost/magento in your browser. Now, use 127.0.0.1 instead of localhost.
  2. Make the following folders writable. These folders are situated in the Magento root directory. To make them writable under Windows, right click on the folder, go to Properties menu, uncheck Read Only property under Attributes section. The directories to be writable are:

    app/etc
    var
    media

  3. Now everything should work. If Magento installation script now throws the following errors:
    Database server does not support InnoDB storage engine
    Database connection error

    open MySQL configuration file my.cnf (foud in your MySQL server directory) and comment the line skip_innodb with a # sign.

The Magento installation process now should move further and proceed to next step.

Radhika roy replied to waseem kaleem on 20-Jul-11 11:10 AM

These instructions document the default installation for Magento. At the end, Magento will be installed without sample data to a directory called magento on your web server. There are four main steps covered here:

Follow this link-

http://www.magentocommerce.com/knowledge-base/entry/magento-installation-cheat-sheet/

Hope this will help you