Jump to content

Switching between hosting providers. Issue with DB server name.

Dolke
 Share

Recommended Posts

Dolke Newbie

Dolke

Posted
Posted

Hi to all,

 

I migrated my website to another hosting provider.

 

They told me that they use word "myql" for mySQL server instead "localhost".

 

I changed that in settings.inc.php file but my website is not loading.

 

Do I need to change this somewhere else to?

 

Ty in advance

Dean

Link to comment
Share on other sites
Dolke Newbie

Dolke

Posted
  • Author
Posted (edited)

My website is loading but after a while it timeouts

 

I didnt change my DNS yet. Instead I added IP and a domain name in my hosts file.

 

I did also:

 

* cleared my browser cash and cookies.

* deleted cash files from cash/smarty and cash/compile folders

Edited by Dolke (see edit history)
Link to comment
Share on other sites
kristianmu Newbie

kristianmu

Posted
Posted

And this is for the fornt office or the back office, or both?

 

When the database is not connecting, you will recieve a message like "Warning: mysql_query() [function.mysql-query]: Access denied for user".

 

Enable display_errors to see if this appears.

And you can try also in smartti config file to change to true this:

// Production mode

$smarty->debugging = false;

  • Like 1
Link to comment
Share on other sites
Dolke Newbie

Dolke

Posted
  • Author
Posted

I didint change DNS and I don't want to change it just yet.

 

I added new server IP address and beside that I added my domain name in the hosts file on my PC.

 

So beside settings.inc.php there is no other place where I state mySQL host name?

Link to comment
Share on other sites
Dolke Newbie

Dolke

Posted
  • Author
Posted (edited)

Guys I think I misspelled IP in the hosts file...

 

I'm hitting the server now but there is another problem.

 

When I go to my website now Im hiting hosting provider parking page of some kind:

http://www.screencast.com/t/DkokRBYm

 

And when I go to my admin URL Im getting this error:

Link to database cannot be established: SQLSTATE[HY000] [2000] mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file

 

New server has php version 5.4.17

Edited by Dolke (see edit history)
Link to comment
Share on other sites
Dolke Newbie

Dolke

Posted
  • Author
Posted

Here are some resources on this issue:

 

http://stackoverflow.com/questions/1575807/cannot-connect-to-mysql-4-1-using-old-authentication

http://forge.prestashop.com/browse/PSCFV-6427

http://forge.prestashop.com/browse/PSCFV-5931

 

This seems like server issue rather then PS but as I don't have root access to my server and customer support doesnt work on weekends at my provider is there a way to fix this without them involved?

 

Ty

Link to comment
Share on other sites
  • 3 months later...
bayyuPratama Newbie

bayyuPratama

Posted
Posted

can you help me with this problem?

 

 

/* Debug only */ define('_PS_MODE_DEV_', true); if (_PS_MODE_DEV_) { @ini_set('display_errors', 'on'); @error_reporting(E_ALL | E_STRICT); define('_PS_DEBUG_SQL_', true); /* Compatibility warning */ define('_PS_DISPLAY_COMPATIBILITY_WARNING_', true); } else { @ini_set('display_errors', 'off'); define('_PS_DEBUG_SQL_', false); /* Compatibility warning */ define('_PS_DISPLAY_COMPATIBILITY_WARNING_', false); } define('_PS_DEBUG_PROFILING_', false); define('_PS_MODE_DEMO_', false); $currentDir = dirname(__FILE__); if (!defined('PHP_VERSION_ID')) { $version = explode('.', PHP_VERSION); define('PHP_VERSION_ID', ($version[0] * 10000 + $version[1] * 100 + $version[2])); } /* Directories */ define('_PS_ROOT_DIR_', realpath($currentDir.'/..')); define('_PS_CLASS_DIR_', _PS_ROOT_DIR_.'/classes/'); define('_PS_CONTROLLER_DIR_', _PS_ROOT_DIR_.'/controllers/'); define('_PS_FRONT_CONTROLLER_DIR_', _PS_ROOT_DIR_.'/controllers/front/'); define('_PS_ADMIN_CONTROLLER_DIR_', _PS_ROOT_DIR_.'/controllers/admin/'); define('_PS_OVERRIDE_DIR_', _PS_ROOT_DIR_.'/override/'); define('_PS_TRANSLATIONS_DIR_', _PS_ROOT_DIR_.'/translations/'); define('_PS_DOWNLOAD_DIR_', _PS_ROOT_DIR_.'/download/'); define('_PS_MAIL_DIR_', _PS_ROOT_DIR_.'/mails/'); define('_PS_PDF_DIR_', _PS_ROOT_DIR_.'/pdf/'); define('_PS_ALL_THEMES_DIR_', _PS_ROOT_DIR_.'/themes/'); define('_PS_IMG_DIR_', _PS_ROOT_DIR_.'/img/'); if (!defined('_PS_MODULE_DIR_')) define('_PS_MODULE_DIR_', _PS_ROOT_DIR_.'/modules/'); define('_PS_CAT_IMG_DIR_', _PS_IMG_DIR_.'c/'); define('_PS_STORE_IMG_DIR_', _PS_IMG_DIR_.'st/'); define('_PS_PROD_IMG_DIR_', _PS_IMG_DIR_.'p/'); define('_PS_SCENE_IMG_DIR_', _PS_IMG_DIR_.'scenes/'); define('_PS_SCENE_THUMB_IMG_DIR_', _PS_IMG_DIR_.'scenes/thumbs/'); define('_PS_MANU_IMG_DIR_', _PS_IMG_DIR_.'m/'); define('_PS_SHIP_IMG_DIR_', _PS_IMG_DIR_.'s/'); define('_PS_SUPP_IMG_DIR_', _PS_IMG_DIR_.'su/'); define('_PS_COL_IMG_DIR_', _PS_IMG_DIR_.'co/'); define('_PS_TMP_IMG_DIR_', _PS_IMG_DIR_.'tmp/'); define('_PS_UPLOAD_DIR_', _PS_ROOT_DIR_.'/upload/'); define('_PS_TOOL_DIR_', _PS_ROOT_DIR_.'/tools/'); define('_PS_GEOIP_DIR_', _PS_TOOL_DIR_.'geoip/'); define('_PS_SWIFT_DIR_', _PS_TOOL_DIR_.'swift/'); define('_PS_GENDERS_DIR_', _PS_IMG_DIR_.'genders/'); define('_PS_FPDF_PATH_', _PS_TOOL_DIR_.'fpdf/'); // @deprecated will be removed in 1.6 define('_PS_TCPDF_PATH_', _PS_TOOL_DIR_.'tcpdf/'); define('_PS_TAASC_PATH_', _PS_TOOL_DIR_.'taasc/'); define('_PS_PEAR_XML_PARSER_PATH_', _PS_TOOL_DIR_.'pear_xml_parser/'); define('_PS_CACHE_DIR_', _PS_ROOT_DIR_.'/cache/'); /* BO THEMES */ if (defined('_PS_ADMIN_DIR_')) define('_PS_BO_ALL_THEMES_DIR_', _PS_ADMIN_DIR_.'/themes/'); /* settings php */ define('_PS_TRANS_PATTERN_', '(.*[^\\\\])'); define('_PS_MIN_TIME_GENERATE_PASSWD_', '360'); if (!defined('_PS_MAGIC_QUOTES_GPC_')) define('_PS_MAGIC_QUOTES_GPC_', get_magic_quotes_gpc()); define('_CAN_LOAD_FILES_', 1); /* Order states Order states has been moved in config.inc.php file for backward compatibility reasons */ /* Tax behavior */ define('PS_PRODUCT_TAX', 0); define('PS_STATE_TAX', 1); define('PS_BOTH_TAX', 2); define('_PS_PRICE_DISPLAY_PRECISION_', 2); define('PS_TAX_EXC', 1); define('PS_TAX_INC', 0); define('PS_ORDER_PROCESS_STANDARD', 0); define('PS_ORDER_PROCESS_OPC', 1); define('PS_ROUND_UP', 0); define('PS_ROUND_DOWN', 1); define('PS_ROUND_HALF', 2); /* Registration behavior */ define('PS_REGISTRATION_PROCESS_STANDARD', 0); define('PS_REGISTRATION_PROCESS_AIO', 1); /* Carrier::getCarriers() filter */ // these defines are DEPRECATED since 1.4.5 version define('PS_CARRIERS_ONLY', 1); define('CARRIERS_MODULE', 2); define('CARRIERS_MODULE_NEED_RANGE', 3); define('PS_CARRIERS_AND_CARRIER_MODULES_NEED_RANGE', 4); define('ALL_CARRIERS', 5); /* SQL Replication management */ define('_PS_USE_SQL_SLAVE_', 0); /* PS Technical configuration */ define('_PS_ADMIN_PROFILE_', 1); /* Stock Movement */ define('_STOCK_MOVEMENT_ORDER_REASON_', 3); define('_STOCK_MOVEMENT_MISSING_REASON_', 4); /** * @deprecated 1.5.0.1 * @see Configuration::get('PS_CUSTOMER_GROUP') */ define('_PS_DEFAULT_CUSTOMER_GROUP_', 3); define('_PS_CACHEFS_DIRECTORY_', _PS_ROOT_DIR_.'/cache/cachefs/'); /* Geolocation */ define('_PS_GEOLOCATION_NO_CATALOG_', 0); define('_PS_GEOLOCATION_NO_ORDER_', 1); define('MIN_PASSWD_LENGTH', 8); define('_PS_SMARTY_NO_COMPILE_', 0); define('_PS_SMARTY_CHECK_COMPILE_', 1); define('_PS_SMARTY_FORCE_COMPILE_', 2); define('_PS_SMARTY_CONSOLE_CLOSE_', 0); define('_PS_SMARTY_CONSOLE_OPEN_BY_URL_', 1); define('_PS_SMARTY_CONSOLE_OPEN_', 2); define('_PS_JQUERY_VERSION_', '1.7.2');
Warning: include_once(_PS_TOOL_DIR_profiling/Controller.php) [function.include-once]: failed to open stream: No such file or directory in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 58

Warning: include_once() [function.include]: Failed opening '_PS_TOOL_DIR_profiling/Controller.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 58

Warning: include_once(_PS_TOOL_DIR_profiling/ObjectModel.php) [function.include-once]: failed to open stream: No such file or directory in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 59

Warning: include_once() [function.include]: Failed opening '_PS_TOOL_DIR_profiling/ObjectModel.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 59

Warning: include_once(_PS_TOOL_DIR_profiling/Hook.php) [function.include-once]: failed to open stream: No such file or directory in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 60

Warning: include_once() [function.include]: Failed opening '_PS_TOOL_DIR_profiling/Hook.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 60

Warning: include_once(_PS_TOOL_DIR_profiling/Db.php) [function.include-once]: failed to open stream: No such file or directory in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 61

Warning: include_once() [function.include]: Failed opening '_PS_TOOL_DIR_profiling/Db.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 61

Warning: include_once(_PS_TOOL_DIR_profiling/Tools.php) [function.include-once]: failed to open stream: No such file or directory in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 62

Warning: include_once() [function.include]: Failed opening '_PS_TOOL_DIR_profiling/Tools.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aerishs1/public_html/baluoto/config/config.inc.php on line 62

Warning: require_once(_PS_TOOL_DIR_smarty/Smarty.class.php) [function.require-once]: failed to open stream: No such file or directory in /home/aerishs1/public_html/baluoto/config/smarty.config.inc.php on line 29

Fatal error: require_once() [function.require]: Failed opening required '_PS_TOOL_DIR_smarty/Smarty.class.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/aerishs1/public_html/baluoto/config/smarty.config.inc.php on line 29

Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...