Installing PHP extensions pdo and pdo_mysql on LAMP appliance

Submitted by jgab on Tue, 2009/09/01 - 18:02

Hi, I would like to install PIWIK (Piwik is an open source alternative to Google Analytics) on the LAMP appliance.

One of the Piwik requirements is to have installed the PHP extensions pdo and pdo_mysql.

How can I install them on the LAMP appliance?

Thanks for your help!

Forum:

Support

Add new comment

What I found Googling for "Ubuntu pdo pdo_mysql"

Liraz Siri - Tue, 2009/09/01 - 18:13

Remember that TurnKey Linux is Ubuntu under the hood so nearly all of the information you'll find online that applies to Ubuntu and Debian will also apply to TurnKey Linux.

apt-get install php-pear php5-dev libmysqlclient15-dev
pecl install pdo
pecl install pdo_mysql

This doesn't work all the time...

Gonzalo Oviedo Lambert - Mon, 2016/10/31 - 06:36

In my debian, fail to compile.

So, sudo apt-get install php-mysql or something like that and bingo, of course, after php5-dev i think.

Most instructions on TurnKey site assume you are root

Jeremy Davis - Tue, 2016/12/20 - 00:34

So if you aren't root, then you'll need to prefix commands with 'sudo'.

Also FWIW this thread is quite old, so may not still be 100% relevant.

You might also need...

Alon Swartz - Tue, 2009/09/01 - 18:21

You might also need to add the following to /etc/php5/apache2/php.ini

extension=pdo.so
extension=pdo_mysql.so

And ofcourse, don't forget to restart apache2.

Does not work in Ubuntu 10.04

Christoffer - Thu, 2011/03/17 - 13:34

The PDO drivers are now part of the core instead of PECL.

How can PDO and PDO_MYSQL be configured?

But from a quick google it seems they are a default part of php (since v5.1 - TKL v11.x has v5.3). I would assume that it is enabled by default, but if not then I imagine you just need to add it to the php.ini file (see Alon's post above).

helped me

amila - Tue, 2012/06/12 - 11:41

Thanks it saved me

Thanks

Sudhanshu - Sun, 2012/07/01 - 16:06

Thanks

OMG Thanks!

boss86741 - Wed, 2013/10/09 - 13:10

OMG, thanks! You just saved my life!

Im getting error on Ubuntu 12.04

Arun - Mon, 2014/02/10 - 15:42

When I tried as mentioned above im getting the following error

Both these two commands were giving error

extension=pdo.so
extension=pdo_mysql.so

/tmp/pear/temp/PDO/pdo_dbh.c: In function 'pdo_hash_methods':
/tmp/pear/temp/PDO/pdo_dbh.c:1122:24: warning: assignment discards 'const' qualifier from pointer target type [enabled by default]
/tmp/pear/temp/PDO/pdo_dbh.c:1126:20: warning: assignment discards 'const' qualifier from pointer target type [enabled by default]
make: *** [pdo_dbh.lo] Error 1
ERROR: `make' failed

Pls Help Im very new on LINUX