HTTP Error 500 : problem connecting to http://<myDomain>.alwaysdata.net/

[lanox]

Hello

 

I am new in the developement of website;

I would like to set up an e-commerce site using the open source solution from Prestashop;

Here is the procedure I use to transfer files to my hosting server (alwaysdata)

 

Prestashop

1. Downloading Prestashop 1.4.6.2

2. Creating a hosting account on alwaysdata (pack 10GB)

3. Use FileZilla (FTP) to transfer prestashop files to ftp.alwaysdata.com (in folder www /)

The created site should normally be under http:// <mydomainname>. alwaysdata.net

<mydomainname> = lanoxjewellery

However, when accessing this link, the following message appears: "link to database cannot be established"

So I realized that the prestashop Database was not created on remote site (alwaysdata). So I followed these steps:

 

4. Export the Prestashop database from my localhost / phpmyadmin

5. Create a prestashop database from admin.alwaysdata.com (name of the db: lanoxjewellery_prestashop)

6. Import the File (previously exported in step4) into phpmyadmin.alwaysdata.com

At this point the same message appears again: "link to database cannot be established"

 

7. I then changed the prestashop config on the remote:

7.1. in www / config directory, i modified the file called "settings.inc.php", by changing the values of the below five variables:

_DB_SERVER_

_DB_NAME_

_DB_USER_

_DB_PASSWD_

__PS_BASE_URI__

 

Here is the content of that updated file

 

define ('_DB_SERVER_', 'mysql.alwaysdata.com');

define ('_DB_TYPE_', 'MySQL');

define ('_DB_NAME_', 'lanoxjewellery_prestashop');

define ('_DB_USER_', 'lanoxjewellery');

define ('_DB_PASSWD_', '<monMotDePasse>');

define ('_DB_PREFIX_', 'ps_');

define ('_MYSQL_ENGINE_', 'InnoDB');

define ('__PS_BASE_URI__','/');

define ('_PS_CACHING_SYSTEM_', 'MCached');

define ('_PS_CACHE_ENABLED_', '0 ');

define ('_MEDIA_SERVER_1_','');

define ('_MEDIA_SERVER_2_','');

define ('_MEDIA_SERVER_3_','');

define ('_THEME_NAME_', 'prestashop');

define ('_COOKIE_KEY_', 'Yj2ii43OUyghkAsXR6KXGFX8fEvNvrHintHx1L7x7VdPiCDpCxdoNA0h');

define ('_RIJNDAEL_KEY_', 'SqEupd3D9oUXXzf18DVzVNIJNNbBMpu5');

define ('_COOKIE_IV_', 'CbewXu8Q');

define ('_RIJNDAEL_IV_', 'fxZUYH0UDOZpRZWUanLY8Q ==');

define ('_PS_CREATION_DATE_', '2012-01-08 ');

define ('_PS_VERSION_', '1 .4.6.2 ');

?>

 

7.2. Then I changed the prestashop database called "ps_configuration" to replace the value of "localhost" with "lanoxjewellery.alwaysdata.net" for two variables below:

 

PS_SHOP_DOMAIN

PS_SHOP_DOMAIN_SSL

 

From there on, i systematically get the following error when I try to access my site(lanoxjewellery.alwaysdata.net)

 

The website has encountered an error while extracting http://lanoxjewellery.alwaysdata.net/. This may be due to maintenance or incorrect configuration.

Here are some suggestions:

Refresh this web page later.

HTTP Error 500 (Internal Server Error): An unexpected condition occurred while the server attempted to process the request.

 

Unfortunately I'm stuck and I do not know what to do else! I am desperate ... Please can you help me??

 

 

I must have forgotten another variable or so... but don't know what !

 

Please HELP!

 

Thank you in advance

[El Patron]

change config/config.inc/php

from:

@ini_set('display_errors', 'off');
define('_PS_DEBUG_SQL_', false);

 

to

 

@ini_set('display_errors', 'on);
define('_PS_DEBUG_SQL_',true);

 

see what errors your site is producting

[lanox]

hi elpatron

thanks for the tips; i've turned the debug on as you indicated. Here is what i am getting

 

Fatal error: Call to undefined function mcrypt_encrypt() in /home/lanoxjewellery/www/classes/Rijndael.php on line 44

 

I checked Rijndael.php file, and here is the contain of that class (in red line 44)

 

<?php

/*

* 2007-2011 PrestaShop

*

* NOTICE OF LICENSE

*

* This source file is subject to the Open Software License (OSL 3.0)

* that is bundled with this package in the file LICENSE.txt.

* It is also available through the world-wide-web at this URL:

*

http://opensource.org/licenses/osl-3.0.php

* If you did not receive a copy of the license and are unable to

* obtain it through the world-wide-web, please send an email

* to [email protected] so we can send you a copy immediately.

*

* DISCLAIMER

*

* Do not edit or add to this file if you wish to upgrade PrestaShop to newer

* versions in the future. If you wish to customize PrestaShop for your

* needs please refer to

http://www.prestashop.com

for more information.

*

* @author PrestaShop SA <[email protected]>

* @copyright 2007-2011 PrestaShop SA

* @version Release: $Revision: 6594 $

* @license

http://opensource.org/licenses/osl-3.0.php

Open Software License (OSL 3.0)

* International Registered Trademark & Property of PrestaShop SA

*/

class RijndaelCore

{

protected $_key;

protected $_iv;

public function __construct($key, $iv)

{

$this->_key = $key;

$this->_iv = base64_decode($iv);

}

// Base64 is not required, but it is be more compact than urlencode

public function encrypt($plaintext)

{

if (($length = strlen($plaintext)) >= 1048576)

return false;

return base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $this->_key, $plaintext, MCRYPT_MODE_ECB, $this->_iv)).sprintf('%06d', $length);

}

public function decrypt($ciphertext)

{

$plainTextLength = intval(substr($ciphertext, -6));

$ciphertext = substr($ciphertext, 0, -6);

return substr(mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $this->_key, base64_decode($ciphertext), MCRYPT_MODE_ECB, $this->_iv), 0, $plainTextLength);

}

}

 

Any idea what's wrong ???

[El Patron]

it would appear that mcrypt is not installed on your system. If you are not familiar on how to get mrcrypt php loaded I'd suggest speaking to your hosting provider.

[lanox]

Thanks again elpatron, i will try to contact my hosting provider.

Just to clarify, is the hosting provider suppose to provide such kind of envirement setup (re. mrcrypt function). or is it something that i need to install on my own PC environement ?In that case how difficult is it to insall such environement ?

 

Also do you know any good hosting provider (performance/price) that can support Prestashop ? Any recommendation ?

 

In any case, i will also contact my hosting provider to clarify?

Thanks again.

[El Patron]

You are very welcome lanox,

 

mcrypt (and you may need more like mhash) are required by PrestaShop. It is not really something very special and should be easily handled by your hosting provider. Note: this would be a requirement for any 'good' e-commerce platform.

 

It's important to note that while we idenfitied mcrypt, you may be missing another module so make sure you tell them it's for a PrestaShop installation. Here is a good source for your server requirements: http://forge.prestashop.com:8081/display/PS14/System+Administrator+Guide#SystemAdministratorGuide-PHPconfiguration

 

I'd post a new thread for reccomendations of a hosting provider in your area. You may want to go ahead and give your hosting provider a chance to resolve your existing issues.

 

Cheers,

 

Fred

[lanox]

Hi elpatron, thanks again for your advise;

I follow your link in put all required extension, library as indicated in my PHP environement (php.ini).

 

extension = php_mysql.dll

extension = php_gd2.dll

allow_url_fopen = On

extension=mcrypt.so

register_globals disabled

magic_quotes disabled

allow_url_include disabled

 

And it seems to work now ! Hope i won't get any other suprises... reason why i am thinking maybe to change hosting provide. Would be good to have your recommendation on hosting provider (I am living in Belgium but guess France would also be ok).

Thanks !!!

[El Patron]

That really good work and you are very welcome.

 

If this solves your problem please put [solved] in your origina title (select More Reply Options).

 

jajajaja "guess France would also be ok"

 

Cheers

[lanox]

[sOLVED].

Thanks again for your support !