PEAR Problem

EviLBoX

I recently installed PHP using ./configure --with-pear=/usr/share/pear --with-sybase-ct=/usr/ --with-apxs2=/usr/sbin/apxs and everything compiled and installed fine. Now when I try to connect to a database using PEAR, it gets stuck in the DB::connect portion of the code and never returns anything, I just see a blank page.

EXAMPLE:
$dsn = array (
'phptype' => 'sybase',
'username' => 'xxx',
'password' => 'xxxx',
'hostspec' => 'xxxxx',
'database' => 'xxxxx',
);

echo "before connect\n";
// Connect to database
$db = DB::connect($dsn);
echo "after connect\n";

Now "before connect" prints out, but it never reaches "after connect".

planetsim

Try adding or die on it like this

$db = DB::connect($dsn)or die(mysql_error());

That function will also depend on your Database whether its MySQL or not.

Also take a look at the Pear Documentation on DB

EviLBoX

Sorry, I forgot to paste that part of my code in there, I do have "die" in there.

planetsim

Did you read the Pear Documentation on it? http://pear.php.net/package/DB/docs/1.6.8/DB/DB.html

jazz_snob

As well as the previously posted docs, here is what I looked at : pear DB howto

Also, I specify the port number in my dsn:

dsn = 'mysql://user:passwd@host:port/database';

-Tom

EviLBoX

I read the documentation and still haven't come up with anything. The same file works on my other Linux box running a different version of PHP, but installed the same way. Could it be a problem with my FreeTDS install? I'm using that to connect to a Sybase database. I did complie PHP --with-sybase-ct=/path_to_freetds and everything compiled okay. I just wish it would give me an error or something.