phpwebsite-developers

[Phpwebsite-developers] One more time... (debugging MySQL/Config?)

[darrel <da...@da...>]

Well, before I totally give up on PHPWebsite, I thought I'd pose this 
question one more time...

Is there anyway to 'see' what's going on when PHPWebsite tries to 
connect to MySQL when setting up the config file? Something like a 
verbose error? The generic 'can't connect' error isn't really getting 
me too far.

I've tried a number of things...rebooted machine, installed 
php-mysql, double and triple-checked MySQL Database name, password, 
username, etc.

It's my box, so I have full access to it if that helps at all. It 
doesn't look like MySQL is generating an error log for this database, 
so it seems like the issue is on PHPWebsite's end.

-Darrel

Re: [Phpwebsite-developers] One more time... (debugging MySQL/Config?)

[ChiNoKaze <chi...@ya...>]

> Is there anyway to 'see' what's going on when PHPWebsite tries to 
> connect to MySQL when setting up the config file? Something like a 
> verbose error? The generic 'can't connect' error isn't really getting 
> me too far.


Hi Darrel,

PHPWS uses the DB.php functionality from the PEAR libs. You can find the
specific error that this library is returning by inserting an echo statement in
the set_config.php file in phpwsroot/setup.

At line 231 begins an if/elseif series of statements.

231     if ($error == "DB")
232      echo "Unable to connect to your server's database.<br />";
233     elseif ($error == "prefix")

modify it such:

231     if ($error == "DB"){
232     	echo "Unable to connect to your server's database.<br />";
233     	echo  $core->db->message . "<br />";
234     }elseif ($error == "prefix")

Notice the addition of the curly braces as well as the extra echo statement.

This will show you what error the Pear library is returning.

I had this same problem, and the error it returned me was:

DB Error: extension not found

To resolve the issue in Gentoo I had to redo "emerge mod_php". I don't know
anything about Mandrake though.

HTH,

Michael


	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

Re: [Phpwebsite-developers] One more time... (debugging MySQL/Config?)

[darrel <da...@da...>]

>modify it such:
>
>231     if ($error == "DB"){
>232    	echo "Unable to connect to your server's database.<br />";
>233    	echo  $core->db->message . "<br />";
>234     }elseif ($error == "prefix")

Thanks, Michael.

It's a small step forward. Unfortunately, the error is still pretty vague:

Unable to connect to your server's database.
DB Error: connect failed

Any MySQL experts recognize what might be causing that error?

-Darrel

Re: [Phpwebsite-developers] One more time... (debugging MySQL/Config?)

[Don S. <do...@se...>]

I'm just jumping in this thread in the middle.  Have you tried to log
into the server using the mysql command-line client?

Just wondering if your db and user has proper permissions set up.

Don.

On Tue, May 11, 2004 at 10:17:21PM -0500, darrel wrote:
> >modify it such:
> >
> >231     if ($error =3D=3D "DB"){
> >232    	echo "Unable to connect to your server's database.<br />";
> >233    	echo  $core->db->message . "<br />";
> >234     }elseif ($error =3D=3D "prefix")
>=20
> Thanks, Michael.
>=20
> It's a small step forward. Unfortunately, the error is still pretty vague:
>=20
> Unable to connect to your server's database.
> DB Error: connect failed
>=20
> Any MySQL experts recognize what might be causing that error?
>=20
> -Darrel
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Sleepycat Software
> Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deli=
ver
> higher performing products faster, at low TCO.
> http://www.sleepycat.com/telcomwpreg.php?From=3Dosdnemail3
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers

--=20
"It's very important for folks to understand that when there's more trade
there's more commerce."

George W. Bush
April 21, 2001
=46rom comments made in Quebec City, Canada.

Re: [Phpwebsite-developers] One more time... (debugging MySQL/Config?)

[Greg M. <drk...@co...>]

darrel wrote:
>> modify it such:
>>
>> 231     if ($error == "DB"){
>> 232        echo "Unable to connect to your server's database.<br />";
>> 233        echo  $core->db->message . "<br />";
>> 234     }elseif ($error == "prefix")
> 
> 
> Thanks, Michael.
> 
> It's a small step forward. Unfortunately, the error is still pretty vague:
> 
> Unable to connect to your server's database.
> DB Error: connect failed
> 
> Any MySQL experts recognize what might be causing that error?
> 
> -Darrel

Darrel,

Based on another one of your posts, "Ooh! Had my hopes up there for a 
minute. I didn't have php-mysql installed. Installed it, restarted mySQL 
and HTTPD, but, alas, still can't connect."  I have sense that this 
issue has something to do with how you actually installed phpWS.  This 
is especially true when you resolved the php-mysql issue.   Would you 
please list the steps, the platform you are using, etc.?  There are 
platform specific steps that you must take for phpwebsite to work.  It's 
not that you should give up on phpWS but the combination of platform and 
other installed products that are making your life miserable.  Would you 
also comment on how closely you followed the steps in the 
phpWebSiteRoot/doc/INSTALL.txt file?

Greg