MAMP’s MySQL status red & not starting

MAMP is a good way to setup a low-maintenance dev envi­ron­ment for OS X in very lit­tle time, but its han­dling of MySQL is quite annoying.

When you suspend/sleep a com­puter, often when you resume MAMP has lost track of the MySQL instance it started and can no longer con­nect to it. Not sure if this is a prob­lem with the MySQL build being used, but as the prob­lem has existed since 2009, I don’t have high hopes for it being fixed any­time soon.

The quick­est solu­tion is to kill off the process it had started pre­vi­ously and then hit “Start Servers” again — it just takes one line on the terminal.

killall -9 mysqld

Be aware that this will kill all run­ning MySQL processes (includ­ing those out­side of MAMP’s control) — this is nor­mally fine, as no-one actu­ally hosts web­sites on OS X!

# by Josh on May 9th, 2011 Tags: , , ,
| 2 Comments »

CMYK thumbnailing of JPEGs with Gmail/Google Mail

I peri­od­i­cally freak out when review­ing emails that I’ve sent, par­tic­u­larly to print­ers, using Gmail’s (hosted apps) web­mail inter­face. It has this habit of con­vert­ing CMYK JPGs to RGB thumb­nails really badly — but with­out appar­ent corruption.

Gmail getting CMYK thumbnails wrong

The blue in the image above is actu­ally a deep red!

Accord­ingly, while the colours are totally out of whack, there are no other arti­facts in the image. Nor­mally this just looks weird — some­times, in the case of logo vari­ants, it looks plau­si­ble but utterly incor­rect! My guess is they’re using an older ver­sion of PIL (we all know how much Google loves Python) prior to this March 2009 patch. Sounds like the same phenomenon.

Still, those peo­ple email­ing CMYK JPGs has to be a lit­tle bit niche, so I’m not heaps hope­ful of this get­ting fixed too soon! The main rea­son I care is because web inter­faces are so much faster than retriev­ing large attach­ments from IMAP stores.

# by Josh on September 16th, 2009 Tags: , , , , , , , , , , ,
| 1 Comment »

The future of mobile computing

177 hours 38 min (7%) remaining - your battery is low.

I wish this weren’t just Vista being special!

# by Josh on September 8th, 2009 Tags: , , , , , ,
| No Comments »

WordPress issues this last week

Recently upgraded along with the rest of the world to Word­Press 2.8.1 and hit a whole bunch of crazi­ness that essen­tially encour­aged me to move even this site across to Web­Fac­tion (eat­ing your own dog food and all that) because of no longer being able to post from the Word­Press admin panel.

Some issues with posting and mod_securityI hadn’t changed any plu­g­ins, and the rest of the net was con­spic­u­ously quiet, so I fig­ured that either my cur­rent host had near-simultaneously upgraded the data­base & cor­rupted some­thing along the way (with MySQL this can result in read-only tables in cer­tain cases, I’m told), or else there was some­thing more sin­is­ter at work. No plu­g­ins had changed, and because noth­ing else func­tioned dif­fer­ently for even a moment I pre­sumed inno­cence on their behalf. I tried with and with­out Google Gears enabled, with and with­out tags, in dif­fer­ent saved sta­tuses, and still noth­ing worked!

Any­way. Turns out it was my use of the term “wget”. (Even now I need to be care­ful as I write that!)

mod_security on Apache basi­cally threw up its lunch every time I threat­ened to post about it. Accord­ingly, I can’t share with you some things that I’ve learnt in migra­tion just yet, and haven’t been post­ing about any­thing else as I’ve been try­ing to resolve this prob­lem, think­ing it was pre­vent­ing me from post­ing. Per­haps mod_security is try­ing to get me to write about more mean­ing­ful things than file trans­fer trick­ery! *yawn*

At any rate, it’s all over now and we’ll be back to reg­u­larly sched­uled pro­gram­ming shortly.

# by Josh on July 17th, 2009 Tags: , , , ,
| No Comments »