[FX.php List] [OFF] Anyone Fluent with setting up Wordpress?

[Bob Patin]

It was all working, but I decided to update PHP, which went fine.

But now, I can't connect to my MySQL databases; I have a messageboard  
on this server too, something my client bought and I installed, which  
also uses MySQL, and it also fails to connect now.

So something I did seems to be keeping the databases from being  
accessible.

On OS X Server there's a handy tool called MySQL Manager; I double- 
checked it and confirmed that MySQL's running.

Then I restarted the machine, but that didn't help either. Neither  
database can be connected to...

I then found a script for testing MySQL connections, and that shows  
failure too.

In Navicat, which is an app I use to set up databases, it has a  
Connection Test button, which works. But that's local, so maybe that's  
why it works and the outside world does not? However, that being the  
case, why can't these 2 sites connect, since they're also local?

I found this PHP, which tests a connection:

$link = mysql_connect($hostname,$dbuser,$dbpassword);
if (!$link) {
	 die('Could not connect to MySQL: ' . mysql_error());
}
	
echo 'Connection OK';
mysql_close($link);

I put this into a PHP page with a little form that sends the values to  
it, and it shows this error:

Could not connect to MySQL: Host  
'dsl253-081-208.bna1.dsl.speakeasy.net' is not allowed to connect to  
this MySQL server

The host above is the web server...

Anyone know why I'm getting this error? Does this mean that MySQL  
really *isn't* running, even though MySQL Manager says that it is?

Oh-so-confusing,

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
Twitter: bobpatin
iChat/AIM: bobpatin
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance & TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Jan 27, 2009, at 5:21 PM, Karl Johnson wrote:

> Min requirements are MySQL 4.0, and PHP 4.3.  OS X server 10.4 comes  
> with Apache 1.3 installed, 2 is available on the dvd but at the time  
> 2 was not production ready.  The best option to updating Apache is  
> to download the newest version and update.
>
> Apache 1.3 is still valid for WordPress based on what I have seen  
> but Apache 2.2.11 is the current version.
>
> If the php upgrade doesn't help, I would recommend updating Apache  
> as well.
>
> Karl
>
>
> On Jan 27, 2009, at 2:21 PM, Bob Patin wrote:
>
>> Karl,
>>
>> The web server is running PHP 4, so it may be time to update to PHP  
>> 5, which might fix the problem.
>>
>> It's an Apple Xserve running OS X Server, which is Apache.
>>
>> I couldn't tell you what version of MySQL is running on it, or  
>> Apache, for that matter. It's OS X Server 10.4.11, for what that's  
>> worth.
>>
>> I think it's Apache 2, from what I'm seeing on Apple's website.
>>
>> I'm updating PHP now... that might fix it...
>>
>> Thanks,
>>
>> BP
>>
>> Bob Patin
>> Longterm Solutions LLC
>> bob at longtermsolutions.com
>> 615-333-6858
>> http://www.longtermsolutions.com
>> Twitter: bobpatin
>> iChat/AIM: bobpatin
>> FileMaker 9 Certified Developer
>> Member of FileMaker Business Alliance & TechNet
>> --------------------------
>> FileMaker hosting and consulting for all versions of FileMaker
>> PHP • Full email services • Free DNS hosting • Colocation •  
>> Consulting
>>
>> On Jan 27, 2009, at 3:55 PM, Karl Johnson wrote:
>>
>>> Most of the sites I maintain we can use cPanel to update.  But I  
>>> did have to manually update from 2.07 to 2.7 and it worked fine.   
>>> I was a little concerned as it was such a large update but  
>>> following the update instructions it worked like a charm.
>>>
>>> Let me think on this for a bit and see if I can come up with a  
>>> possible solution for why admin is giving you problems.  It  
>>> shouldn't be an issue.
>>>
>>> Can you give me some specs on the server - mysql version, php  
>>> version, apache version?  I am wondering if there is a problem  
>>> there.
>>>
>>> Karl
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> Karl Johnson, Tech Dog
> "to code or not to code, that is the question"
> beachdog.com:  are you ready to wag?
> PO Box 954 • 1517 Pacific Ave N • Long Beach, WA 98631
> http://www.beachdog.com • 360.642.4431 • karl at beachdog.com
>
> websites • brochures • business cards • postcards • logos
> It's not about what we do.  It's about what our process and products  
> do for you.
>
>
>
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20090127/995de7be/attachment.html