OS X 10.4.6, MySQL and Textpattern problems.

marcel · 2006-05-07 19:15:40

Following the update to 10.4.6 (on my Powermac G5) my textpattern site stopped working — it could n’t connect to the database. Also, my MediaWiki installation stopped working and reported the error:

Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (2)

So, I guessed this was the problem with both installations.

I googled the problem and after a couple of wrong turns I came across this post and followed their advice and now everything is working fine.

Basically I changed one line of the config.php file found in /textpattern/config.php from this:

$txpcfg[‘host’] = ‘localhost’;

to this

$txpcfg[‘host’] = ‘localhost:/tmp/mysql.sock’;

Now everything works fine.

squaredeye · 2006-05-08 03:09:54

Don’t know if you’re so inclined, but I find MAMP to be EXTREMELY helpful, really easy to install, uninstall, and play with.

rui · 2006-05-08 08:34:04

ma_smith wrote:

Don’t know if you’re so inclined, but I find MAMP to be EXTREMELY helpful, really easy to install, uninstall, and play with.

Another MAMP satisfied user… And even has a dashboard widget. Sweet!

All the Best,
rui

squaredeye · 2006-05-08 14:11:08

Rui,

Good to know.

marcel · 2006-05-08 14:49:26

Thanks for the link MAMP looks like it might be less trouble than dealing with each part of the AMP triumvirate individually. My only concern is does Textpattern work okay with Apache 2?
I guess I can go and check out the system requirements for the answer. Also, has anyone used MAMP to run their Tetxpattern site?

Thanks,

Matthew.

squaredeye · 2006-05-08 14:54:06

Marcel,

I run multiple “local” copies of textpattern sites (10+) with the latest version of MAMP.
It works really well. I also run other CMS’s for testing and learning.
I think you’ll enjoy it.

M

marcel · 2006-05-08 15:16:59

Thanks Matthew,

I will take the plunge, what the hell it’s raining outside anyway.

M.

lajackie · 2008-03-09 23:13:21

oh thank god i found some people who are having the same problem as me!
I was setting up a new textpattern site on my macbook w/ OS 10.5.2, and kept running into this error:

“Warning: mysql_connect(): Can’t connect to local MySQL server through socket ‘/usr/local/mysql-5.0/data/mysql.sock’ (2) in …/textpattern/setup/index.php on line 178

Can’t connect to database”

I tried changing the config.php file like the first user, but it did not fix the problem. :( I’ve also tried the two solutions offered by apple.com…
http://docs.info.apple.com/article.html?artnum=301457

But since I don’t know what I’m doing, I might have done the 2nd part wrong (i was never able to get terminal to execute “sudo chmod 775 /var/mysql”)

I have been using the latest version of MAMP (though, the free one, not pro) since the beginning this failed exercise, and I don’t really know how i can use it to fix the problem.

Oh boy. i’m in SO over my head. can anyone help me? Is it possible that by messing around in terminal and changing some of the code in these files, i’ve dug myself into a deeper hole? I wish there were some specific directions about how to install textpattern on a machine with OS 10.5 with MAMP. I’ve been following the directions in TEXTPATTERN SOLUTIONS and i think it’s just not going to help me out with this new issue.

thanks in advance!

Last edited by lajackie (2008-03-09 23:14:32)

graeme · 2008-03-10 00:55:04

lajackie wrote:

Is it possible that by messing around in terminal and changing some of the code in these files, i’ve dug myself into a deeper hole?

Not really, everything is solvable.

Those Apple support instructions were for Mac OS X Server 10.4, which has everything pre installed no wonder the 2nd part didn’t work for your setup with MAMP.

Have you tried installing mysql separately to MAMP? I ask because according to the default setup of MAMP’s version of PHP should be looking for the mysql socket here: /Applications/MAMP/tmp/mysql/mysql.sock.

MAMP maybe conflicting with something else. Lets first determine what is running from where, form the Terminal run these commands:

ps -awx | grep mysqld | grep -v grep
ps -awx | grep httpd | grep -v grep

lajackie · 2008-03-10 01:46:12

hi! thanks for getting back to me! I have not tried installing Mysql separately, i’ll do that now and make sure it’s there?

I tried to run the commands you prompted in terminal, but nothing happened :/ was i entering them wrong?

graeme · 2008-03-10 02:12:47

Nothing, hmm… if nothing was returned then both should be switched off. Which is very strange considering the error your getting. What do you get when you run:

which mysqld_safe
which httpd

lajackie · 2008-03-10 03:58:12

i don’t get anything for the first one, and for the second, i get: /usr/sbin/httpd

Textpattern CMS

Textpattern CMS support forum

#1 2006-05-07 19:15:40

OS X 10.4.6, MySQL and Textpattern problems.

#2 2006-05-08 03:09:54

Re: OS X 10.4.6, MySQL and Textpattern problems.

#3 2006-05-08 08:34:04

Re: OS X 10.4.6, MySQL and Textpattern problems.

#4 2006-05-08 14:11:08

Re: OS X 10.4.6, MySQL and Textpattern problems.

#5 2006-05-08 14:49:26

Re: OS X 10.4.6, MySQL and Textpattern problems.

#6 2006-05-08 14:54:06

Re: OS X 10.4.6, MySQL and Textpattern problems.

#7 2006-05-08 15:16:59

Re: OS X 10.4.6, MySQL and Textpattern problems.

#8 2008-03-09 23:13:21

Re: OS X 10.4.6, MySQL and Textpattern problems.

#9 2008-03-10 00:55:04

Re: OS X 10.4.6, MySQL and Textpattern problems.

#10 2008-03-10 01:46:12

Re: OS X 10.4.6, MySQL and Textpattern problems.

#11 2008-03-10 02:12:47

Re: OS X 10.4.6, MySQL and Textpattern problems.

#12 2008-03-10 03:58:12

Re: OS X 10.4.6, MySQL and Textpattern problems.

Board footer