Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
12 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Why does PEAR DB give "DB Error: extension not found [DB Error: extension not found].."
Posted on 2011-03-09
I'm moving a small set of PHP/Postgres applications from Ubuntu 9.x to 10.10. When I try to run the application, I get this error:
DB Error: extension not found [DB Error: extension not found] ** pgsql://jean@/appx
The code is:
require_once('DB.php');
$db=DB::connect("pgsql://j
if (PEAR::isError($db)) {
die($db->getMessage()." ".$db->getUserInfo()." ");
}
if (DB::isError($db)){
die($db->getMessage());
}
When I installed DB, I noticed that it's been supersceded by MDB2, what do I have to change to make it work with MDB2, or what do I need to do make the DB code work?
Thanks.
Jean
DB Error: extension not found [DB Error: extension not found] ** pgsql://jean@/appx
The code is:
require_once('DB.php');
$db=DB::connect("pgsql://j
if (PEAR::isError($db)) {
die($db->getMessage()." ".$db->getUserInfo()." ");
}
if (DB::isError($db)){
die($db->getMessage());
}
When I installed DB, I noticed that it's been supersceded by MDB2, what do I have to change to make it work with MDB2, or what do I need to do make the DB code work?
Thanks.
Jean
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
5
10 Comments
Hi JPNeron,
See if the following works for you:
$ sudo aptitude install php5-psql
(Inside a terminal window, of course)
See if the following works for you:
$ sudo aptitude install php5-psql
(Inside a terminal window, of course)
When I used 'php5-psql' as the package name, it said there was no such package. On a hunch, I tried 'php5-pgsql' instead, and it did download & install it, but I still get the error.
Sorry, it's more likely you're missing the Pear extension. My guess is that when you upgraded, the php extension directory probably changed. If this is the case, you'll need to reinstall the DB package. However, what I would do is try the MBD2 package first. If that fails, just re-install DB.
$ pear install MDB2
Make sure there are no errors, and take note of whether Pear has enabled the extension for you or not. You can post the last couple of lines from the output here.
$ pear install MDB2
Make sure there are no errors, and take note of whether Pear has enabled the extension for you or not. You can post the last couple of lines from the output here.
Both those packages appear to be installed:
root@Ubuntu:/home/jean# pear install MDB2
pear/MDB2 is already installed and is the same as the released version 2.4.1
install failed
root@Ubuntu:/home/jean# pear install DB
pear/DB is already installed and is the same as the released version 1.7.13
install failed
If DB was missing, wouldn't I get an error on the require_once('DB.php') statement?
Also, just to clarify, I'm not upgrading a machine, I have a brand new machine and I copied the php pages from the old server to the new server.
root@Ubuntu:/home/jean# pear install MDB2
pear/MDB2 is already installed and is the same as the released version 2.4.1
install failed
root@Ubuntu:/home/jean# pear install DB
pear/DB is already installed and is the same as the released version 1.7.13
install failed
If DB was missing, wouldn't I get an error on the require_once('DB.php') statement?
Also, just to clarify, I'm not upgrading a machine, I have a brand new machine and I copied the php pages from the old server to the new server.
You're right.
I think I've figured it out though. First, you do actually need the package php5-pgsql. Secondly, you also need php5-mysql. Without MySQL support, PHP in Ubuntu won't support PgSQL either, apparently.
$ sudo aptitude install php5-pgsql php5-mysql
Now, if you want to use MDB2 instead of DB, it's fairly straight forward. Just do the following:
$ sudo pear install pear/MDB2
And then:
$ sudo pear install pear/MDB2#pgsql
Then you need to change your code to following:
Hope that fixes it for you.
I think I've figured it out though. First, you do actually need the package php5-pgsql. Secondly, you also need php5-mysql. Without MySQL support, PHP in Ubuntu won't support PgSQL either, apparently.
$ sudo aptitude install php5-pgsql php5-mysql
Now, if you want to use MDB2 instead of DB, it's fairly straight forward. Just do the following:
$ sudo pear install pear/MDB2
And then:
$ sudo pear install pear/MDB2#pgsql
Then you need to change your code to following:
require_once('MDB2.php'); // CHANGE THIS LINE
$db=MDB2::connect("pgsql://jean@/appx"); // CHANGE THIS LINE ALSO
if (PEAR::isError($db)) {
die($db->getMessage()." ".$db->getUserInfo()." ");
}
if (MDB2::isError($db)){ // AND THIS ONE
die($db->getMessage());
}
Hope that fixes it for you.
We have progress!
Now I get:
MDB2 Error: connect failed _doConnect: [Error message: unable to establish a connection] ** pgsql(pgsql)://jean:xxx@/a
Not sure what the problem is here. This user can run psql, access the 'appx' database, view tables, etc, etc. Maybe there's a problem in the postgres setup that prevents connections from apache?
Now I get:
MDB2 Error: connect failed _doConnect: [Error message: unable to establish a connection] ** pgsql(pgsql)://jean:xxx@/a
Not sure what the problem is here. This user can run psql, access the 'appx' database, view tables, etc, etc. Maybe there's a problem in the postgres setup that prevents connections from apache?
Would you be able to temporarily switch back to DB? It seems to me that DB does error reporting more constructively than MDB2, by default anyway.
Perhaps there's a setting to make MDB2 spit out more details, but I'm not sure where to look for that. But if we can get it working with DB, we should then be able to get it working with MDB2 also.
I'm assuming you have PostgreSQL installed?
$ sudo aptitude install postgresql
Perhaps there's a setting to make MDB2 spit out more details, but I'm not sure where to look for that. But if we can get it working with DB, we should then be able to get it working with MDB2 also.
I'm assuming you have PostgreSQL installed?
$ sudo aptitude install postgresql
Hooray! Just switching back to DB solved the problem, everything works as it should!
I guess the problem all along was I needed to install the php5-mysql package.
Thanks for the help!
I guess the problem all along was I needed to install the php5-mysql package.
Thanks for the help!
The problem was the missing php5-mysql part of PEAR. After installing that, it was not necessary to change anything.
Featured Post
An important part of learning any new piece of software is understanding the terminology it uses. Thankfully WordPress uses fairly simple names for everything that make it easy to start using the software.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Foreword (July, 2015)
Since I first wrote this article, years ago, a great many more people have begun using the internet. They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
I imagine that there are some, like me, who require a way of getting currency exchange rates for implementation in web project from time to time, so I thought I would share a solution that I have developed for this purpose.
It turns out that Yaho…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses
Course of the Month12 days, 9 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.