PHP – Daoyuan Li

Migrating/Installing Prestashop to Amazon AWS EC2

Published 2015/02/25 by Daoyuan Li

Recently I migrated a Prestashop website to AWS/EC2 and the process is quite smooth. Here’s how to do it.

1. Get your Website data: including Prestashop website files and a latest database dump. Remove all the files except index.php in /cache/smarty/compile and /cache/smarty/cache. (See here.)

2. Launch your EC2 instance. But before doing that, check first if a pre-configured or managed Prestashop is available in your preferred region (more info here). If not, choose the appropriate instance type and get it running. In my case I chose Ubuntu Linux.

3. Install the AMP (Apache, MySQL and PHP). On Ubuntu you can simply do it with a few simple commands:

sudo apt-get update
sudo apt-get upgrade
sudo tasksel install lamp-server
sudo apt-get install phpmyadmin

sudo apt-get update

sudo apt-get upgrade

sudo tasksel install lamp-server

sudo apt-get install phpmyadmin

Make sure that you remember your password for MySQL root user and phpmyadmin user.

4. Copy your database dump and website files to your EC2 instance using scp, for instance:

scp -i you-key.pem files.tar.gz ubuntu@your-ec2-instance.compute.amazonaws.com

1	scp -i you-key.pem files.tar.gz ubuntu@your-ec2-instance.compute.amazonaws.com

5. Create a MySQL user for Prestashop, you don’t want to use the root user for this purpose. You can do this using phpmyadmin or a command line. Also, create a database for Prestashop and grant the user you’ve created just now all privileges on this database.

6. Import your database from the dump:

mysql -u root -p ps < db_dump.sql

1	mysql -u root -p ps < db_dump.sql

7. Extract your website files on your EC2 instance. In my case, inside /var/www/html/. If there is an index.html file inside this directory, remove it first. Make sure you set the correct user and group to all the website files:

sudo chown -R www-data:www-data *
sudo chmod -R 755 *

1 2	sudo chown -R www-data:www-data * sudo chmod -R 755 *

Note that if don’t set the correct permissions, you may get complaints from Apache, like the following:

PHP Fatal error: Uncaught exception ‘SmartyException’ with message ‘unable to write file /var/www/html/cache/smarty/compile/46/d9/69/wrt54ecd6c1856a72.61943173’ in /var/www/html/tools/smarty/sysplugins/smarty_internal_write_file.php:44

Stack trace:

#0 /var/www/html/tools/smarty/sysplugins/smarty_internal_template.php(201): Smarty_Internal_Write_File::writeFile(‘/var/www/html/c…’, ‘<?php /* Smarty…’, Object(Smarty))

#1 /var/www/html/tools/smarty/sysplugins/smarty_internal_templatebase.php(155): Smarty_Internal_Template->compileTemplateSource()

#2 /var/www/html/classes/controller/AdminController.php(1936): Smarty_Internal_TemplateBase->fetch(‘controllers/mod…’)

#3 /var/www/html/classes/controller/AdminController.php(2337): AdminControllerCore->initModal()

#4 /var/www/html/classes/controller/Controller.php(163): AdminControllerCore->init()

#5 /var/www/html/classes/Dispatcher.php(373): ControllerCore->run()

#6 /var/www/html/admin123/index.php(54): DispatcherCore->dispatch()

#7 {main}\n thrown in /var/www/html/tools/smarty/sysplugins/smarty_internal_write_file.php on line 44

8. Enable mcrypt for PHP:

sudo updatedb
locate mcrypt.ini
> /etc/php5/mods-available/mcrypt.ini
locate mcrypt.so
> /usr/lib/libmcrypt.so.4
> /usr/lib/libmcrypt.so.4.4.8
> /usr/lib/php5/20121212/mcrypt.so
sudo vi /etc/php5/mods-available/mcrypt.ini
sudo php5enmod mcrypt
ls -al /etc/php5/cli/conf.d/20-mcrypt.ini
> lrwxrwxrwx 1 root root 31 Feb 24 19:32 /etc/php5/cli/conf.d/20-mcrypt.ini -> ../../mods-available/mcrypt.ini
ls -al /etc/php5/apache2/conf.d/20-mcrypt.ini
> lrwxrwxrwx 1 root root 31 Feb 24 19:32 /etc/php5/apache2/conf.d/20-mcrypt.ini -> ../../mods-available/mcrypt.ini
service apache2 restart

sudo updatedb

locate mcrypt.ini

> /etc/php5/mods-available/mcrypt.ini

locate mcrypt.so

> /usr/lib/libmcrypt.so.4

> /usr/lib/libmcrypt.so.4.4.8

> /usr/lib/php5/20121212/mcrypt.so

sudo vi /etc/php5/mods-available/mcrypt.ini

sudo php5enmod mcrypt

ls -al /etc/php5/cli/conf.d/20-mcrypt.ini

> lrwxrwxrwx 1 root root 31 Feb 24 19:32 /etc/php5/cli/conf.d/20-mcrypt.ini -> ../../mods-available/mcrypt.ini

ls -al /etc/php5/apache2/conf.d/20-mcrypt.ini

> lrwxrwxrwx 1 root root 31 Feb 24 19:32 /etc/php5/apache2/conf.d/20-mcrypt.ini -> ../../mods-available/mcrypt.ini

service apache2 restart

9. Update your Prestashop settings in the config/settings.inc.php file. Set the correct database information.

10. Enable mod_rewrite:

sudo a2enmod rewrite
sudo service apache2 restart

1 2	sudo a2enmod rewrite sudo service apache2 restart

Also, make sure to add something like the following in your apache site configuration file:

        <Directory />
                Options FollowSymLinks
                AllowOverride all
        </Directory>
        <Directory /var/www/html/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride all
                Order allow,deny
                allow from all
        </Directory>

Options FollowSymLinks

AllowOverride all

</Directory>

Options Indexes FollowSymLinks MultiViews

AllowOverride all

Order allow,deny

allow from all

</Directory>

And then remember to restart your apache server.

11. Install sendmail:

sudo apt-get install sendmail

1	sudo apt-get install sendmail

12. Go to your Prestashop back office and reconfigure your domain. Go to Preferences -> SEO & URLs and scroll down to Set shop URL section.

Now everything should be OK, your new Prestashop website is available on your new domain!

If you have any issues, just drop a line here or email me.

4 Comments

Nothing is useless

Published 2012/05/25 by Daoyuan Li

Spring is already in Helsinki; I shot these beautiful flowers on the bus when going to work:

At work Aimmy invites us to have some cake during afternoon coffee break. The cake was very delicious and she’s really good at cooking yummy food. She has already made muffins twice before this; and we are all expected to taste some original Thai food, probably next week.

Yesterday I volunteered to set up a website for the project I’m currently working on. It seems that even my PHP skills will be useful for my career. Some skills developed from hobbies come quite handy when doing serious business. Everything, any experience or lessons are likely to be used sometime later…

I moved my desk to a different position in the room and now I’m enjoying the new layout. Last night I watched Hangover from my bed instead of siting in my uncomfortable chair, thanks to the new layout. 27 inch display looks OK and wireless keyboard acts as remote — a real big remote. Now off to watch Hangover 2. 🙂

Migrating JComments to WordPress

Published 2012/04/28 by Daoyuan Li

I switched back to WordPress from Joomla! after I registered this new domain. After migrated all the posts to WordPress using FG Joomla to WordPress, I noticed the comments have not been transferred. After some digging I didn’t find satisfactory plugin to do that, so I wrote my own PHP script to fulfill this task. The code is also available from GitHub.

<?php

$username = "username";
$password = "password";
$database = "database";

mysql_connect('localhost', $username, $password);
@mysql_select_db($database) or die( "Unable to select database");
@mysql_set_charset('utf8');

$query = "SELECT DISTINCT object_id FROM jos_jcomments";
echo $query; 
print "
";
$pids = mysql_query($query);

if (!$pids) {
	echo mysql_error();
}
$num = mysql_numrows($pids);
$i = 0;
while ($i < $num) {
	$pid = mysql_result($pids, $i, "object_id");
	$query = "SELECT created FROM  jos_content WHERE id = " . $pid;
	echo $query; 
	print "
	";
	$created = mysql_query($query);
	if (!$created) {
		echo mysql_error();
	}
	$ct = mysql_result($created, 0, "created");
	$query = "SELECT ID FROM  wp_posts WHERE  post_date =  '" . $ct . "' AND post_type =  'post'";
	echo $query; 
	print "
	";
	$wpids = mysql_query($query);
	if (!$wpids) {
		echo mysql_error();
	}
	$wpid = mysql_result($wpids, 0, "ID");
	$query = "SELECT * FROM jos_jcomments WHERE object_id = " . $pid;
	echo $query; 
	print "
	";
	$comments = mysql_query($query);
	$comments_count = mysql_numrows($comments);
	$j = 0;
	while ($j < $comments_count) {
		$author = mysql_result($comments, $j, "name");
		$email = mysql_result($comments, $j, "email");
		$url = mysql_result($comments, $j, "homepage");
		$ip = mysql_result($comments, $j, "ip");
		$cdate = mysql_result($comments, $j, "date");
		$content = mysql_result($comments, $j, "comment");
		$content = mysql_real_escape_string($content);
		
		$query = "INSERT INTO wp_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content) VALUES (" . $wpid . ", '" . $author . "', '" . $email . "', '" . $url . "', '" . $ip . "', '" . $cdate . "', '" . $date . "', '" . $content . "')";
		echo $query; 
		print "
		";
		mysql_query($query);
		$j++;
	}
	$query = "UPDATE wp_posts SET comment_count = " . $comments_count . " WHERE ID = " . $wpid;
	echo $query; 
	print "
	";
	mysql_query($query);

	$i++;
}
mysql_close();
?>

<?php

$username = "username";

$password = "password";

$database = "database";

mysql_connect('localhost', $username, $password);

@mysql_select_db($database) or die( "Unable to select database");

@mysql_set_charset('utf8');

$query = "SELECT DISTINCT object_id FROM jos_jcomments";

echo $query;

print "

$pids = mysql_query($query);

if (!$pids) {

echo mysql_error();

}

$num = mysql_numrows($pids);

$i = 0;

while ($i < $num) {

$pid = mysql_result($pids, $i, "object_id");

$query = "SELECT created FROM jos_content WHERE id = " . $pid;

echo $query;

print "

$created = mysql_query($query);

if (!$created) {

echo mysql_error();

}

$ct = mysql_result($created, 0, "created");

$query = "SELECT ID FROM wp_posts WHERE post_date = '" . $ct . "' AND post_type = 'post'";

echo $query;

print "

$wpids = mysql_query($query);

if (!$wpids) {

echo mysql_error();

}

$wpid = mysql_result($wpids, 0, "ID");

$query = "SELECT * FROM jos_jcomments WHERE object_id = " . $pid;

echo $query;

print "

$comments = mysql_query($query);

$comments_count = mysql_numrows($comments);

$j = 0;

while ($j < $comments_count) {

$author = mysql_result($comments, $j, "name");

$email = mysql_result($comments, $j, "email");

$url = mysql_result($comments, $j, "homepage");

$ip = mysql_result($comments, $j, "ip");

$cdate = mysql_result($comments, $j, "date");

$content = mysql_result($comments, $j, "comment");

$content = mysql_real_escape_string($content);

$query = "INSERT INTO wp_comments (comment_post_ID, comment_author, comment_author_email, comment_author_url, comment_author_IP, comment_date, comment_date_gmt, comment_content) VALUES (" . $wpid . ", '" . $author . "', '" . $email . "', '" . $url . "', '" . $ip . "', '" . $cdate . "', '" . $date . "', '" . $content . "')";

echo $query;

print "

mysql_query($query);

$j++;

}

$query = "UPDATE wp_posts SET comment_count = " . $comments_count . " WHERE ID = " . $wpid;

echo $query;

print "

mysql_query($query);

$i++;

}

mysql_close();

13 Comments

Tag: PHP

Migrating/Installing Prestashop to Amazon AWS EC2

Nothing is useless

Migrating JComments to WordPress