Stumped - MDB2 & pgsql
| From: | Michael A. Peters | Date: | Thu, 15 Jul 2010 12:08:23 +0000 |
| Subject: | Stumped - MDB2 & pgsql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-306908@lists.php.net to get a copy of this message | ||
I need to switch from MySQL (where everything is peachy) to Postgresql - reason I need to switch is I need to use PostGIS and I don't see a need to run two databases.
I got Postgresql installed (stock CentOS / RHEL 5) and installed the postgresql php module and mdb2 driver. Restarted the web server.
Did a MySQL dump, ran it through a perl script, and managed to get it load into Postgresql without any apparent hickups. I can connect to postgresql and issue queries and expected results are in fact returned.
Made a user called webuser (what, you expect the real name to be disclosed here ??) in postgresql and gave it a password and access to the database. Updated the data/pg_hba.conf to add the following line:
local mydbname webuser 127.0.0.1 passwordrestarted the postgresql server. I *thought* that all I would then have to do is change my mdb2 dsn to reflect the new driver to use and then find parts of my code that are not standard enough SQL - but when I try to use anything, I get - Fatal error: Call to undefined method MDB2_Error::execute() in /path/to/blah on line 63 I'm missing something here. Here's my dsn - $dsn = array( 'phptype' => 'pgsql', 'username' => 'webuser', 'password' => 'secret', 'hostspec' => 'localhost', 'database' => 'mydbname'); What am I doing wrong? I get the same error no matter what I set username/password/hostspec/database to - so I think it is a basic connection error. I'm hoping to be able to get the switch to postgresql finished soon so that I can start playing with using the PostGIS extension. I'm running php 5.2.12 (my own build, based on Fedora src.rpm) w/ pear 1.8.1: pear list Installed packages, channel pear.php.net: =========================================
Package Version State Archive_Tar 1.3.3 stable Console_Getopt 1.2.3 stable Date 1.4.7 stable MDB2 2.4.1 stableMDB2_Driver_mysql 1.4.1 stable MDB2_Driver_pgsql 1.4.1 stable
PEAR 1.8.1 stableStructures_Graph 1.0.2 stable Text_Highlighter 0.7.1 beta
XML_Parser 1.3.2 stable XML_RPC 1.5.1 stable XML_Util 1.2.1 stableThanks for suggestions.