Allows you to search a variety of questions and answers
Source: http://www.directadmin.com/forum/showthread.php?t=24448
I just recently had to do this so I thought I might as well share. There are a few threads already with some info, but it's not entirely complete in my opinion.
Let's get started.
1) First off, issue this command to check your pear/pecl config:
Code:
pecl config-show
This will show you your config. Now if your /tmp is mounted noexec, skip the following and jump to step 2) now.
My /tmp is mounted noexec and instead of messing with it, I just changed the config to a local writable directory.
Your config-show should have:
Code:
Code:
PEAR Installer cache directory cache_dir /tmp/pear/cache PEAR Installer download download_dir /tmp/pear/cache PEAR Installer temp directory temp_dir /tmp/pear/temp
Take note of the /tmp paths.
Type and execute:
Code:
Code:
pear config-set cache_dir /root/tmp/pear/cache pear config-set download_dir /root/tmp/pear/cache pear config-set temp_dir /root/tmp/pear/temp
Feel free to change the path to your own liking.
2) Now we will install pdo and pdo_mysql extensions.
Type and execute:
Code:
Code:
pecl install pdo pecl install pdo_mysql
Now check your extensions directory to make sure they were installed. For my purposes they were in /usr/local/lib/php/extensions/no-debug-non-zts-20060613.
You should see pdo.so and pdo_mysql.so there.
3) Next you will need to re-compile PHP5. Before doing so, edit the configure file and add the following:
Code:
Code:
--enable-pdo=shared \ --with-pdo-mysql=shared \ --with-sqlite=shared \ --with-pdo-sqlite=shared \
Next recompile PHP with your method of choice.
4) Last step is to edit your /usr/local/lib/php.ini file.
Change your extension_dir to:
Code:
Code:
extension_dir = /usr/local/lib/php/extensions/no-debug-non-zts-20060613
or
Code:
extension_dir = /usr/local/lib
Change this path if yours is different.
Scroll down and add the following extensions:
Code:
Code:
extension=pdo.so extension=pdo_mysql.so
Exit and save your php.ini.
5) Restart httpd and open up a phpinfo.php file. You should now see pdo/pdo_mysql entries.
TROUBLESHOOTING
A) If you are receiving the following warning/error:
Code:
Code:
PHP Warning: PHP Startup: Invalid library (maybe not a PHP library) 'pdo_mysql.so' in Unknown on line 0
Try restarting mysqld first.
I have been using AYK for about 2 years now and they are always on top of any issues I have. They have gone over and beyond helping me with any problems that come up with the server and they have never said "no" to any of my requests. I would definitely recommend them to anyone looking for a reliable server company.
Very courteous, professional, and willing to help. They truly care about client based relationships and satisfaction. I will definitely refer more clients their way, and highly recommend Ayksolutions to anyone seeking truly the best.
You can trust your business with AYKsolutions After a horrible experience with my prior host that left me with over 14 hours of downtime, AYKSolutions came in, took care of the transfer completely and made my life easier. When they say their servers are semi-managed, it means they take care of more then most managed server hosting companies. Average ticket response time? 2-5 minutes. One time i n the middle of the night it took 30 minutes. Problems that I create are fixed immediately and they take care of their customers. Artyom is the owner, who is somehow capable of not sleeping. He's always there to take care of everything with a personal touch. 3 AM on a Saturday? Not an issue for AYKSolutions. Trust me, I'm very thorough in researching a company. When it comes to business, you can never be too careful. I trust my business with AYKSolutions