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

[Leo R. Lundgren]

The problem was that after upgrading from the stock (Apple) PHP4 to  
Entrophy's PHP5, the MySQL extension had a different default setting  
for mysql.default_socket. The new default path was invalid/not  
pointing to the correct mysql.sock file, which resulted in the Blog  
to be unable to communicate with MySQL since it used "localhost" as  
the server name. Most likely different compile time configuration  
directives between the two.

The thing is that when you have "localhost", it (the mysql extension/ 
client library) tries to use the socket file for communication, and  
when you use an IP you force it to use TCP/IP instead. When using  
"127.0.0.1" Bob's blog came alive again.

What we did was add "mysql.default_socket = /var/mysql/mysql.sock" to  
any (in this case a new) file in /usr/local/php5/php.d; These files  
are read upon startup of PHP (a restart of Apache is needed since PHP  
runs under mod_php). That way PHP could connect to MySQL again using  
the socket file.

-|


28 jan 2009 kl. 04.08 skrev Bob Patin:

> Leo Lundgren helped me; there was a line missing from a config  
> file... we're not really sure how it got nuked, but apparently had  
> something to do with installing PHP5.
>
> At any rate, it's working now... :)
>
> So feel free to peruse my blog at http://blog.longtermsolutions.com
>
> Best,
>
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> Twitter: bobpatin
> iChat: bobpatin
> AIM: longterm1954
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance & FileMaker TechNet
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> Web hosting • PHP • Full email services • Free DNS hosting •  
> Colocation • Consulting
>
> On Jan 27, 2009, at 8:53 PM, Gareth Evans wrote:
>
>> MySQL is running but the user you are connecting with doesn't have
>> privileges to connect from that hostname. You'll need to GRANT  
>> privileges
>> for that specific hostname or use a wildcard for the host. I use  
>> phpMyAdmin
>> for this, don't know if the MySQL Manager can but I would imagine  
>> it should.
>> -- 
>> GARETH EVANS
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list


-|