Recently, I was given a consulting project to develop an e-commerce site and I immediately thought of Magento - an open source e-commerce solution written in PHP. Magento is one of the better pieces of software that goes widely unknown by many since very few people develop e-commerce sites (as opposed to say Drupal where everyone and their kids are bloggers).
However, upon installation of Magento on my GoDaddy Linux Virtual Dedicated Server (VDS), the installation will stall on the mcrypt dependency. The mcrypt library stores several algorithms that help secure your e-commerce site's data. Unfortunately, by default, the GoDaddy VDS package does not have the mcrypt library installed. To install mcrypt, follow these steps -
Once the server has restarted, you can re-run the Magento installation and you will be able to successfully complete the wizard.
Magento will not load
I had to switch from godaddy virualu shared hosting (magento worked fine) to virtual dedicated server.
I backed up the database and code base.
Loaded and have tried several debugging techniques but magento will not load.
I get :
There has been an error processing your request.
SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'click2ztq4.db.5357308.hostedresource.com' (4)
Trace:
#0 /home/clickadmin/public_html/showcase/lib/Varien/Db/Adapter/Pdo/Mysql.php(211): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /home/clickadmin/public_html/showcase/lib/Zend/Db/Adapter/Abstract.php(441): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 /home/clickadmin/public_html/showcase/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#3 /home/clickadmin/public_html/showcase/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#4 /home/clickadmin/public_html/showcase/app/code/core/Mage/Core/Model/Resource/Type/Db/Pdo/Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#5 /home/clickadmin/public_html/showcase/app/code/core/Mage/Core/Model/Resource.php(87): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Object(Mage_Core_Model_Config_Element))
#6 /home/clickadmin/public_html/showcase/app/code/core/Mage/Core/Model/Resource/Setup.php(62): Mage_Core_Model_Resource->getConnection('core_setup')
#7 /home/clickadmin/public_html/showcase/app/code/core/Mage/Core/Model/Resource/Setup.php(120): Mage_Core_Model_Resource_Setup->__construct('core_setup')
#8 /home/clickadmin/public_html/showcase/app/code/core/Mage/Core/Model/Config.php(263): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#9 /home/clickadmin/public_html/showcase/app/code/core/Mage/Core/Model/App.php(263): Mage_Core_Model_Config->init(Array)
#10 /home/clickadmin/public_html/showcase/app/Mage.php(434): Mage_Core_Model_App->init('', 'store', Array)
#11 /home/clickadmin/public_html/showcase/app/Mage.php(455): Mage::app('', 'store', Array)
#12 /home/clickadmin/public_html/showcase/index.php(65): Mage::run()
#13 {main}
Any ideas? Pulling my hair out here!
Connection String?
From the first line of the error, I would make sure that your connection string/database credentials are correct. If they are, I would setup a simple .php test page that does a simple SELECT against a table in the Magento database to make sure there are no mySQL/server issues.
Let me know how those two steps turn out and let's see if we can't get this resolved. Good luck.
Which OS on you godaddy VDS
Which OS on you godaddy VDS Fedora 7 or CentOS 5? I found magento need PHP 5.2.0 (or greater). THX
Cent OS
I'm using Cent OS and I can't remember having to upgrade my version of PHP to be honest, but I am running 5.2.6 currently so it does look like 5.2+ is a requirement.
How about magento's speed on
How about magento's speed on Godaddy VDS? Very slow on LINUX HOSTING DELUXE PLAN,about 8 seconds to open home page.
Magento Speed
I've seen no issues with speed, responsiveness or server responsiveness with Magento on GoDaddy VDS packages. Have you implemented caching, gzip compression, etc.? Also, did you write or implement any custom modules/hooks? How big is your product catalog? I'm pretty sure that we could probably determine the root cause of the slowdown with some more information.
Worked like a charm. Thanks!
Worked like a charm. Thanks!
thank you!
Thanks so much for putting this up. It's simple enough that a newbie like me can do it. You saved me a lot of time pulling my hair out!
another way is compile apache
on some server, by this way nothing will install. i installed mcrypt by typing /scripts/easyapache on ssh terminal and while compiling apache, i selected mcrypt
Great Tips
Thanks for this step by step post. I was installing Magento and was having the same problem. I really appreciate it.
Excellent
Thanks a lot!
Thanks for the tip, saved me a lot of hassle
I searched for the last hour before finding this post. A lot of linux guru type sites wanted me to recompile the php installation. If this works, and I assume it will since all commands seemed to process correctly. you saved me a ton of work. FWIW i am also rolling out magento for a e-commerce jewelry site for a customer. I use a dedicated Godaddy server. 3 IP's and a core duo 2.4 4 gig ram linux box are all new to me. So please do shed a tear for jumping into this one.
Speaking of magento, how do you like the software? is the import feature good? I have to import around 3000 items into her catalogs. Hoping for the best, and thanks a bunch!
Mike
Magento
Sorry for the untimely reply. Hopefully, this comment reaches you.
I find Magento a pleasure to work with and I see it being the Drupal of the e-commerce space. I do wish to see more outside development support for the platform, but I do have to say I am really encouraged by the software and would feel comfortable using this software for clients. As for the input feature, as long as the data going in is well formed, the import feature works well.