fbpx
Magento

Configure server to install Magento (Example xampp) enable InnoDB store Engine

By April 9, 2012 No Comments

Magento is a script which requires high configuration of your server. Therefore, many people have encountered difficulties when installing Magento. I would like to guide you how to configure your server to use Magento Script step by step.
First, we make the same analysis of the System Requirements (requirements of the system) of Magento as follows:

Supported Operating Systems: OS is the best to run Magento (optional)

* Linux x86, x86-64

Supported Web Servers: The best Webserver to run Magento (optional)

* Apache 1.3.x
* Apache 2.0.x
* Apache 2.2.x
Supported Browsers: The browser which can be used

* Microsoft Internet Explorer 6 and above
* Mozilla Firefox 2.0 and above
* Apple Safari 2.x
* Google Chrome
* Adobe Flash browser plug-in should be installed (should be installed Plug-in Flash to run)

PHP Compatibility: required with PHP Program

* 5.2.0 and above: Version 5.2.0 and up
* Required extensions: The extension must have
* PDO_MySQL
* Simplexml
* Mcrypt
* Hash
* GD
*DOM
* Iconv
* SOAP (if Webservices API is used)
* Safe_mode off
* Memory_limit 32mb or more

MySQL: Request buocvoi to mysql server

* 4.1.20 or newer: version 4.1.20 and up
* InnoDB storage engine: Since version 1.2.1.1 magento-Mysql requires to support InnoDB. With Magento older versions, you can use MyISAM

SSL: Not required. If you use HTTPS protocol for the management, the PHP extension to support SSL, such as eg openssl

* If HTTPS is used to work in the admin, SSL certificate should be valid. Self-signed SSL certificates are not supported

Server – hosting – setup:

* Ability to run scheduled jobs (crontab) with PHP 5
* Ability to override options in. Htaccess files: Hosting to support htacess

Now I will present the basic steps to configure the webserver, you can run with the application of Magento.

First to check on a configuration, create a file info.php with content as follows:

phpinfo ();
?>

Set this file to your Root. Then access to the address http://localhost/info.php

You will load the information about PHP configuration and your server.

1st Requirement: the webserver must support. Htacess. which means your Apache mod_rewrite must be enabled.

To do this, open the file xampp \ apache \ conf \ httpd.conf

You can edit this file with the basic software available, such as Windows Notepad, WordPad or Notepad + +. Find the following code:

# LoadModule rewrite_module modules / mod_rewrite.so

just remove the # and save

2nd Requirement: Set use of PHP extension

In the http://localhost/info.php you can find information about the php configuration file
Particular line: Configuration File loaded E: \ xampp \ apache \ bin \ php.ini

Find this file, use Notepad + + to edit.

First we find the code
; extension = php_mcrypt.dll

un-check; go, this code will allow load Mycrypt Extension of PHP. We are

extension = php_mcrypt.dll

Next go to line

; extension = php_curl.dll

Un-check; go. This code will allow load curl Extension of PHP. We are

extension = php_curl.dll

Next go to line

; extension = php_pdo_mysql.dll

Un-check; go, this code allows load Extension Pdo Mysql connect with your PHP. We are

extension = php_pdo_mysql.dll

Find code

; extension = php_pdo.dll

Un-check; go, this code allows load Pdo Extension of PHP. We are

extension = php_pdo.dll

If this code is not in your php.ini file, you must add it to any position of php.ini file.

Then save the file php.ini.

3rd requirement (for magento 1.2.1.1 above) Mysql your server must support InnoDB Engine Store.

With this request you open the file xampp \ mysql \ bin \ my.cnf

Note: this file has the same icon with a shorcut’s Window

To edit the file, you will have to drag drop to an edition tool as notepad + +

Find the following code

# Comment the following if you are using InnoDB tables
skip-innodb
# innodb_data_home_dir = “/ xampplite / mysql /”
innodb_data_file_path ibdata1 # =: 10M: autoextend
# innodb_log_group_home_dir = “/ xampplite / mysql /”
# innodb_log_arch_dir = “/ xampplite / mysql /”
# # You can set .. _buffer_pool_size up to 50 – 80%
# # Of RAM but beware of setting memory usage too high
# innodb_buffer_pool_size = 16M
# innodb_additional_mem_pool_size = 2M
# # Set .. _log_file_size to 25% of buffer pool size
# innodb_log_file_size = 5M
# innodb_log_buffer_size = 8M
# innodb_flush_log_at_trx_commit = 1
# innodb_lock_wait_timeout = 50

Edit to

# Comment the following if you are using InnoDB tables
# skip-innodb
innodb_data_home_dir = “/ xampplite / mysql /”
innodb_data_file_path ibdata1 =: 10M: autoextend
innodb_log_group_home_dir = “/ xampplite / mysql /”
innodb_log_arch_dir = “/ xampplite / mysql /”
# # You can set .. _buffer_pool_size up to 50 – 80%
# # Of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# # Set .. _log_file_size to 25% of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

Then save

Restart webserver. With xampp, run the file xampp_restart.exe

Now basically you have completed the configuration of your server to make it work well with magento.