Back online
January 20th, 2009
Bad news, as they say, always comes in threes. First, I had to attend a family funeral on the other side of the world; then I fell ill, and finally, the motherboard on my dedicated server went into meltdown. As a result, all my websites have been offline since at least Wednesday of last week (14 January 2009), and I have been unable to answer a lot of questions in online forums, including my own blog.
The good news is that my server is now back online, and I hope to deal with the backlog of questions in the next few days. Apologies if you have been waiting for an answer.
Entry Filed under: General
10 Comments Add your own
1. Carol E | January 20th, 2009 at 3:59 pm
May the rest of 2009 be a very good year for you.
I was getting ready to launch into a diatribe about how php was crashing dreamweaver and it all started when I opened one of your download files from phpSolutions. But I composed myself and found the solution (I deleted the WinFileCache) and all seems fine now.
I’m glad I found the solution and didn’t do the diatribe. I’ve gotten a lot of benefit from phpSolutions. It’s the first of several php books I’ve read (including your books on dreamweaver and php) that ever “clicked.”
2. David Powers | January 23rd, 2009 at 7:31 am
Thanks, Carol. Deleting WinFileCache (or MacFileCache) seems to solve 90 percent of problems with Dreamweaver. It’s such a useful technique, I have included it in my book on Dreamweaver CS4.
It’s nice to know that one of my books has clicked.
3. John Sutton | January 31st, 2009 at 10:50 pm
Hi David,
I was sorry to see that you have had so many challenges lately. I hope things are trending up for you as we move into February. At least you don’t have to deal with all the snow an ice we’ve had lately in the northeastern United States.
I was wondering if you might have any suggestions about how to enable the pdo_mysql driver.
I’m working on a Mac Leopard 10.5.6 with a native installation of php and mysql and when I look at my php configuration for PDO, the only drivers enabled are sqlite2 and sqlite.
I’ve been searching the web for a solution to enable pdo_mysql and those I’ve found all involve compiling php from source using the command line, something which is a little beyond my confidence, at this time.
Can you provide guidance on this issue?
Thank you!
John Sutton
4. Rob Hurley | February 4th, 2009 at 4:25 am
I have a question about dedicated servers: what do you need to run one? Not only the hardware, but what sort of internet connection would this require? And, if a T1 or better is necessary, how would one pay for that sort of thing?
5. David Powers | February 9th, 2009 at 6:02 pm
Hi John,
Thanks for your good wishes. Although I’m sure the snow hasn’t been as bad here as in the USA, it’s been the most severe winter for about 20 years. Since we’re not used to it, it has caused a lot of disruption, but things seem to be getting back to normal – at least in London.
As for PDO on Leopard, as you have found, it’s not part of the preinstalled Mac version. I have now given up on the preinstalled version and use MAMP instead. It’s an all-in-one package that contains Apache, PHP, MySQL, and phpMyAdmin. There’s no need to uninstall anything before installing MAMP. Just turn off the native Mac version of Apache by deselecting Web Sharing in System Preferences. After installing MAMP, reset the MAMP ports to use the default ports for Apache and MySQL. MAMP seems the best choice for a Mac. It’s available as a free version or the Pro version is available for a small fee.
6. David Powers | February 9th, 2009 at 6:05 pm
Rob,
I can’t answer your questions about running your own dedicated server, sorry. My dedicated server is rented from a hosting company that looks after all the hardware and maintenance. I’m considering moving to a different host when my current contract runs out, so I can’t recommend anywhere at the moment.
7. Jeremy Bowman | June 19th, 2009 at 3:17 pm
Your comment 5 above — about installing MAMP “on top of” older versions of Apache (etc.) is the most useful thing I’ve heard in months. Thanks!
BTW, I’m enjoying EDGTDW4 every bit as much as EGTDW3 — it’s worth every penny!
8. Jeremy Bowman | March 6th, 2010 at 12:48 pm
I have foolishly changed the root password of MySQL via PHPMyAdmin.
Now when I try to open PHPMyAdmin, I get the message “Error: Could not connect to MySQL server!”
How do I get it back?
9. David Powers | March 6th, 2010 at 2:00 pm
@Jeremy, Judging from your earlier comment, you’re using MAMP. phpMyAdmin stores the MySQL root password in Applications:MAMP:bin:phpMyAdminForPHP5:config.inc.php. Around line 86, set the value of $cfg['Servers'][$i]['password'] to the new password that you chose for root.
10. Jeremy Bowman | March 6th, 2010 at 4:12 pm
That’s it! Thank you so much again!
Leave a Comment
Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Trackback this post | Subscribe to the comments via RSS Feed