PHP Data Objects (PDO) defines a lightweight and consistent interface for accessing databases.

learn more… | top users | synonyms

9
votes
4answers
11k views

How do I tell Apache which PHP to use?

I am running Apache2 on a Mac OS X (10.5). I just compiled PHP 5.2.8 and finally got pdo-mysql working (or so I think). My command line "php --version" is showing 5.2.8 and I have the right modules ...
6
votes
2answers
6k views

AWS RDS connection count

I am using AWS RDS with MySQL for a project and have a "large" instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can't find anything that ...
6
votes
4answers
21k views

How can I install mysql PDO driver in Ubuntu 10.04 and PHP 5.3.2

I tried to install mysql PDO driver with this command: $ sudo pecl install pdo_mysql but I got the following error: WARNING: "pecl/PDO_MYSQL" is deprecated in favor of ...
6
votes
2answers
2k views

Php pdo_dblib - cannot find/unable to load freetds

Self-hosted box, RHEL 6 PHP 5.3.3 PDO installed freetds installed pdo_dblib - so far no luck installing My goal is to use PDO with sybase. Attempting to install pdo_dblib from the appropriate ...
4
votes
3answers
10k views

How do I get PHP 5.3 working on Red Hat Enterprise Linux, with PDO enabled? PHP53 was installed with yum

This problem is complicated, and I'm not an expert at all, so bear with me. My server admin team set me up with a standard RHEL box. It had PHP preinstalled, as well as apache. I am now trying to ...
3
votes
1answer
6k views

PDO_MYSQL Installation on CentOs6

I have a new CentOS 6 server running PHP 5.3.2. The output of php -v shows Unable to load dynamic library '/usr/lib64/php/modules/pdo_mysql.so - /usr/lib64/php/modules/pdo_mysql.so cannot open ...
3
votes
2answers
593 views

Why are these two PDO classes different (and how can I make them the same)?

I have a web-based PHP email client (Roundcube) that I installed on a UNIX server, and right off the bat it produced this error: Fatal error: Undefined class constant 'MYSQL_ATTR_FOUND_ROWS' in ...
3
votes
1answer
412 views

PDO_mysql for mac

Has anybody gotten PDO_mysql working on the default PHP installation on a mac? It works with MAMP but that's inconvenient. I'm developing for Zend Framework and mysql, and Zend_db uses PDO. The ...
2
votes
1answer
239 views

PHP: Can't access to MySQL server on a different server via PDO

I'm trying to connect to a offloaded SQL server offered here. It says that I should connect using the internal IP 172.16.0.51. I installed nginx and PHP (php5-fpm, php5-mysql) on my VPS. phpinfo() ...
2
votes
2answers
472 views

Why do I get a PHP 5.2.6 segmentation fault when using PDO_SQlite?

This is an installation on ModWest's shared hosting. I have enabled both PDO and PDO_sqlite on the server and phpinfo() verifies both are running. When I access PDO itself, I'm fine, and getting a ...
2
votes
1answer
5k views

How to install PostgreSQL extension for PDO in Linux?

I have the VPS. I can build my PHP version using Easy Apache. I can find the option for PDO support for MySQL, SQLite. But I don't have any option of PDO pgsql driver. How can I enable that? It says ...
1
vote
2answers
47 views

SSL Support for PHP 5.3.3 and Apache

After a solid day investigating why I can't get my application to connect to a remote server over SSL using PHP PDO, I found PDO::MYSQL_ATTR_SSL..., but it seems that they exists only for 5.3.7 or ...
1
vote
1answer
2k views

Enable php pdo on cpanel

Getting this error: Fatal error: Class 'PDO' not found Have these lines in php.ini: extension=pdo.so extension=pdo_sqlite.so extension=sqlite.so extension=pdo_mysql.so This shows up in ...
1
vote
1answer
7k views

How enable pdo_mysql

I am trying to install SpaceBukkit. I was wondering how I enable pdo_mysql. When trying to setup the MySQL part I get this error: The "pdo_mysql" extension is NOT loaded in your `php.ini`! Make sure ...
1
vote
2answers
6k views

Installing PDO_DBLIB for PHP

I'm trying to get PDO's to work with SQL Server and I'm completely lost. I found this : http://www.php.net/manual/en/ref.pdo-dblib.php http://pecl.php.net/package/PDO_DBLIB and told to try this: ...
1
vote
1answer
5k views

How do I install the pdo_mysql driver on Red Hat Enterprise Linux 6.1?

I have a RHEL box running PHP 5.3.3, which was installed using the binary packages provided by yum. I have installed the php-pdo package: # yum info php-pdo Loaded plugins: product-id, rhnplugin, ...
1
vote
1answer
373 views

How to enable PDO?

I have little server in Slicehost and i installed PHP 5.2.10 with PDO disabled. Now i'd like to enable it. Is there a way to enable it without too much fuzz? I'm not a pro admin :P. Thanks!
1
vote
2answers
18k views

PDO Disabled in PHP… how to enable it?

Sorry I'm still a bit of a novice with dedicated hosting. Anyway, we have a dedicated server running cPanel and WHM. I have full terminal access and all that. Basically I've tried to install Chive to ...
1
vote
0answers
198 views

Can't seem to install pdo-mysql extension on RHEL6 server

I'll try to be clear, I don't have a lot of server experience, but I'll tell you what I know: I'm trying to install Magento on a site, but I kept getting an error, after looking at the error logs, ...
1
vote
2answers
320 views

php pdo connection cannot be established, but mysql command line client can

situation as follows: php script on server a, run by user 'web' (nginx + php-fpm) should access mysql on server b via pdo library, but gets SQLSTATE[HY000] [2003] Can't connect to MySQL server on ...
1
vote
1answer
901 views

Red Hat 6 connect to MS SQL server 2005 using freetds; pdo_dblib and php

I'm having a problem connecting to my Microsoft SQL Server 2005 from a Red Hat box using freetds. My end goal is to be able to connect using php's PDO, but I don't appear to be able to connect when ...
1
vote
1answer
464 views

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for ...
1
vote
1answer
774 views

Connecting to SQL Server 2005 via PDO

I've upgraded my php installation to 5.4.14 using Microsoft's Web Platform Installer 4.6. Php is working great except I cannot connect to my database. My connection was working great before the ...
1
vote
1answer
308 views

Dynamic column enumeration for preventing SQL injection

I have an application which is completely for internal use but I'm trying to make sure I have my bases covered on SQL injection. Unless someone else has some information to point me otherwise there ...
1
vote
0answers
2k views

phpinfo reports no value for PDO MySQL driver

As per the title I'm having problems with PHP 5.2.10 and getting PDO MySQL to be recognised. My configure command contains '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' ...
1
vote
1answer
179 views

mysql server freezes on inserts on a InnoDB table

CREATE TABLE IF NOT EXISTS `music_batch_song` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `music_batch_id` bigint(20) DEFAULT NULL, `song_id` bigint(20) DEFAULT NULL, `comment` varchar(10) ...
1
vote
1answer
696 views

Can't get php+sqlite working

I'm struggling all morning to make php work with an sqlite database. Here is a piece of php code that I try to execute: #less /var/www/html/test.php <?php $db=new ...
0
votes
4answers
2k views

getting PHP PDO flavors to work on Mac OS X

I'm running OS X 10.5; it looks like it came with Apache and PHP installed (minus some minor configurations which I turned on per this page; I've used Apache before so I know the basics of how ...
0
votes
2answers
2k views

how to get mysql.sock file, mistakenly deleted from “/mysql/tmp/”

I was stuck with a PDO Exception PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in lock_may_be_available() (line 167 of ...
0
votes
1answer
1k views

Unbuntu 14.04 + Nginx + PHP5-FPM + sqlite3 : pdo sqlite could not find driver

phpinfo() says I have SQLite 3.x driver for PDO. php.ini only mentions sqlite like so: [sqlite] ; http://php.net/sqlite.assoc-case ;sqlite.assoc_case = 0 [sqlite3] ;sqlite3.extension_dir = I ...
0
votes
1answer
2k views

MySQL connections aborted - should I be worried?

I'm tuning MySQL on a webserver with Apache and mod_php for speed so I ran mysqltuner and here's the result: -------- General Statistics -------------------------------------------------- [--] ...
0
votes
1answer
661 views

PHP PDO and cPanel

I've been handled down this project, which is running PHP 5.3.6 with PDO support disabled. I have a cPanel login to interface with the server. What would be the process to install/enable PDO MysQL ...
0
votes
1answer
492 views

PostgreSQL 9.0 and PHP on Amazon EC2

How can I enable PostgreSQL 9.0 support in PHP on my Amazon EC2 instance? I'm running the free 32 bit Linux Micro instance. I've installed PostgreSQL 9.0 by following these instructions ...
0
votes
1answer
89 views

Periodically run an MS SQL query on multiple sites

I have been tasked with pushing Google Analytics data periodically to SQL Server 2005 running on a different server from various websites (about 450 of them) grouped on various servers. I understand I ...
0
votes
1answer
1k views

How to install new PDO driver to existing LAMP install

How do I install a new PDO driver to an existing LAMP installation? I am using Amazon Linux (on AWS EC2), and have installed PHP 5.5 and MySql from the Amazon repositories. When I look at phpinfo I ...
0
votes
2answers
447 views

PDO ODBC error just resets connection

Trying to write an ODBC PDO driver for CakePHP. Seems like I get closer and closer however whenever a PDO function is called that it doesn't like the connection just gets reset immediately and I'm not ...
0
votes
2answers
3k views

php pdo mssql driver on centos

How do I install PHP PDO Mssql Driver on Centos?
0
votes
1answer
3k views

Can't get PDO MySQL driver to work on PHP

Trying to install Vanilla 2 locally using MAMP i got the error: "You must have the MySQL driver for PDO enabled in order for Vanilla to connect to your database". When I check phpinfo() I see: ...
0
votes
1answer
309 views

Installing my mysql adapter properly

I am running on ubuntu 10.04. Can someone tell me how to isntall: PHP5 MySQL with support for PDO All tutorials I've found are a bit old.
0
votes
1answer
426 views

IIS + PHP Data Objects + MS SQL?

We're migrating an LAOP server to Win 2k8 IIS7 MSSQL and PHP (WIMP?) at work, and I'm using the opportunity to clean up the PHP. Currently it doesn't use PDO, and I'd like to rewrite the PHP to use ...
0
votes
1answer
924 views

Compiling PHP 5.1.6 with PDO MySQL

UPDATE I Asked this over on StackOverflow as I hadn't got any answers on here at the time. Here's the link to the answers for completeness' sake. I'll like that page back over here once I've tried ...
0
votes
0answers
164 views

Nginx & PHP: How to install / activate PDO

I have an nginx server with PHP running on Windows Server 2012 and I want to install Collabtive. This web-based project management software requires PDO to connect to a MySQL database. The ...
0
votes
1answer
151 views

Error installing php-mysqlnd

I've been trying to install phpmysqlnd, but I'm not sure what's going wrong. This is on a CentOS system. I run the commands: yum remove php-mysql yum install php-mysqlnd The first one is a ...
0
votes
1answer
104 views

Activating Informix variables on Apache2/Debian

I'm working on adding PDO for Informix on my Debian server. I have a strong set of instructions from a gentleman who has set this up to run on suse, I'm trying to figure out how to add these ...
0
votes
1answer
361 views

Enabling PDO for CLI in vagrant box precise64 (Ubuntu server 12.04 LTS)

I have vagrant box (precise64) utilizing Ubuntu server 12.04. I have installed manually (no use of LAMP) on the server the following: MySql server / MySql client - Server version: ...
0
votes
1answer
25 views

Enable PDO in shared server

My newest client has decided (against my heavy recommendation to use my tried and true host..) to use Webmasters.com to host their site. This is turning into a nightmare... I finally got the full ...
0
votes
1answer
1k views

PHP Fatal error: Class 'PDO' not found

PHP Fatal error: Class 'PDO' not found in /home/bd/public_html/app/webroot/Cake/Model/Datasource/Database/Mysql.php on line 177 PHP INFO: PDO PDO support => enabled PDO drivers => sqlite, ...
0
votes
1answer
989 views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
0
votes
1answer
1k views

Trying to install pdo_oci via PECL fails asking for PDO extension

I'm using Linux Mint 11 (based on Ubuntu 11.04) and I need to use PHP with Oracle through PDO, a requirement of the framework we will work with. I've installed various PDO extensions using the normal ...
0
votes
1answer
688 views

Suse11 - How to install pdo_mysql

I am going to install Drupal 7 to my new server, I have installed all stuff that mentioned in the requirement, however I stall get the error message saying that "...Your web server does not appear ...