I’ve just cloned this blog to a development version on my Macbook Pro. The Mac has Apache2 installed by default, so I just had to get mysql working.
Downloading MySQL and installing on Leopard is a breeze with the native package.
I migrated my database (dump/restore) and recreated my wordpress user, but still kept getting this error:
Error establishing a database connection
The user could log into the database from the console as shown:
[email protected]:~ $ mysql -u wordpress -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.1.34 MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use wordpress;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-----------------------------+
| Tables_in_wordpress |
+-----------------------------+
| sk2_blacklist |
So what is the problem?
Google provides an answer, with a log lived post from My Macinations providing the solution. It’s all to do with correcting your php.ini with the proper MySQL socket location.
Now, back to testing my new version of the Twitter Tags wordpress plugin. #hashtags now work!
Seeing as it is International WordPress Day, I’ve written a new WordPress plugin that auto links a twitter at username (like @lantrix) in a post automatically.
Developed initally on WordPress 2.3, it has successfully been tested on WordPress 2.7.1.
Most of the other plugins out there either did this only in their “badge” or “widget” or where too full featured. This is a simple and quick plugin to get links in place to twitter people for the lazy blogger.
Visit my plugin page, give it a try and let me know what you think.
October 17, 2007 at 11:57 · Filed under tech, travel
I’m a twitter user, and this morning came across an enterprising web-site called Melbourne Transport. They use the twitter handle @MelbTransport to publish line and train alerts for Melbourne’s Connex train services. This appears to be the outcome of someones frustration with the dreadful SMS alerts services that Connex provide.
Connex have their own SMS alert system, which states “From Monday to Friday, between 6am and 8pm, we provide instant text messaging to mobile phones with up-to-the-minute information on any train that is more than 15 minutes off schedule”. I have been signed up for about 12 months, and I rarelynever get notified about ANY events, including hearing nothing about the double-whammy fatality/crossing incident disruption to Pakenham and Cranbourne lines yesterday, causing over 1.5 hours in delays
The Melbourne Transport idea allows users of the train system to give direct feedback stating on their site “if you see an issue you can broadcast it to all other MelbTransport followers either using a Direct message (private) or just tweet @MelbTransport”. Good idea!
A system like Melbourne Transport will work much better the more people participate. With only 19 people currently following, and the idea being new, unless they have some mechanism to get data from Connex they will need a much greater twitter following to make this work. Good luck to them.
