John Rynne's weblog

Bueno. esto es un anuncio flagrante. Se trata de la mejor pizzería que conozco: Da Leonardo, en calle Foso 32, Aranjuez (a dos puertas del Barín, por la zona de Alpajés).
Teléfono: 669 137 507

Tiene pizzas de base plana (1 o 2 personas) y de base alta (2 o 4 personas).
Los precios varían según tamaño e ingredientes, desde una media de 8 euros por la pizza baja individual hasta 25 por la pizza de base alta para 4 personas.
De momento no reparten. Se puede comer en el local o llevar.

El pizzero es italiano, y las pizzas son deliciosas. No digo más.

• ITALIA (Mozzarella de búfala, tomatitos frescos, albahaca, orégano y aceite
• MARGHERITA (Tomate, mozzarella, orégano y aceite)
• CAPRICCIOSA (Tomate, mozzarella, jamón york, champiñones, salchichón, aceitunas, orégano y aceite)
• CUATRO ESTACIONES (Tomate, mozzarella, jamón york, salchichón, champiñones, alcachofas, orégano y aceite)
• BOLOÑESA (Tomate, mozzarella, carne picada de ternera, jamón york, orégano y aceite)
• MODENA (Tomate, mozzarella, cebolla, queso parmesano, vinagre de Modena, orégano y aceite)
• PARMA (Tomate, mozzarella, jamón serrano, orégano y aceite)
• NAPOLI (Tomate, mozzarella, anchoas, orégano y aceite)
• DI MARE (Tomate, frutas de mar, ajo, orégano y aceite)
• CARIBE (Tomate, mozzarella, jamón york y piña)
• 4 FORMAGGI (Mozzarella, gorgonzola, emental y fontina)
• GORGO (Mozzarella, queso gorgonzola y cebolla)
• TONNO (Tomate, mozzarella, atún y cebolla)
• MARINAIA (Tomate, ajo, anchoas, orégano y aceite)
• COTTO (Tomate, mozzarella, jamón york, orégano y aceite)
• BEICON (Tomate, mozzarella, jamón york, beicon y cebolla)

Teléfono: 669 137 507

Great little short story about time travel, couched as a Wikipedia edit war. Very funny.

Wikihistory by Desmond Warzel.

The basic premise is that, once time travel is possible, the first thing everybody thinks of is going back in time to kill Hitler.
(Courtesy of BoingBoing).

In other news, Arthur C. Clarke has just died at the age of 90. Though I agree with other bloggers that some of his later stuff was crappy (particularly the co-written books such as the “Rama” series), his early stuff blew my teenage mind and helped retain my sanity through adolescence (along with Heinlein, Asimov and others).

Click below to download UK government’s dastardly plan to foist total control on populace.

NIS_Options_Analysis_Outcome.pdf

From Cory Doctorow at BoingBoing.net

Best-selling author Paulo Coelho was http://www.dld-conference.com/:“Digital, Life, Design” shindig last week (apparently Europe’s answer to http://ted.com:“TED”). He told the audience that he has been putting his books online free of charge for years, in secret. He apparently needed (and obtained) permission from his translators to do this.

El Pais newspaper quotes him as saying that this stimulates book sales: that sales of The Alchemist in Russia topped 100,000 copies as a result.

Video of Coelho’s talk at DLD (apparently 2 hours long, including David Silverman, Carolyn Porco, Oliviero Toscani).

He posts his books online at http://piratecoelho.wordpress.com/:“Pirate Coelho”.

More information:
English: P2P Blog, Jeff Jarvis at The Guardian

Spanish: Ikusimakusi, Barrapunto

Full disclosure: I have never read anything by Coelho and I’m not sure I want to.

Leopard Server (Mac OS 10.5) comes with MySQL 5 preinstalled and it sets it up painlessly. It allows you to set a root password and decide whether or not to allow network connections (i.e. allow connections to MySQL from other machines in your network or elsewhere). Since I’m planning to use it to share translation memory databases for the Heartsome Translation Suite within our LAN, I clearly do want to allow network connections.

However, that’s all that Leopard Server does with regard to MySQL. It would be nice if each user you created in the Workgroup under Leopard Server were given a MySQL username and password. However, it doesn’t work like that.

Moreover, out of several thousand pages of Leopard Server documentation, only 5 (yes, five) refer to MySQL. There are 3 pages in the “Web Technologies Administration” manual (Pages 92-93) and another 2 in the “Command-Line Administration” manual (pages 218-219). Although they do contain some useful information, they refer you to the MySQL manual for practically anything.

My first problem was that, though Server Admin said that MySQL was running, I could find no other evidence of that. In fact, despite having a green light on for MySQL in Server Admin, the programme listed start time as the date I did the install, not today’s date. And the logs hadn’t been updated today at all. That seemed to suggest that it wasn’t really “on” at all. (MySQL doesn’t act like an application; you don’t get an icon in the Dock like when you launch Microsoft Word, iTunes or the like).

A chat with Apple Support points me to the “Command-Line Administration” manual on the docs page. There I discover that MySQL executables are in /usr/bin/ (and elsewhere, but we don’t need to go there).

MySQL can be started and stopped using serveradmin, which is located in /usr/sbin.

So, to make sure MySQL is running, I navigate over to the /usr/sbin directory and stop it:

sudo serveradmin stop mysql

Then started it again

sudo serveradmin start mysql

It worked. Now, in Server Admin showed the new Start Time and was updating the logs.

Now, to get a closer (and more user-friendly) look, I downloaded the MySQL GUI Tools and launched MySQL Administrator. I tried to connect using “root” and the root password but get nowhere. I got such eloquent replies as “Connection Error. Could not connect to MySQL instance at 172.26.1.4. Error: Host ’172.26.1.4’ is not allowed to connect to this MySQL server (code 1130)”. Also got error code 1045. And this was me on the same machine as MySQL is installed on!

Searches on the web for those error codes reveal many frantic requests for support but no authoritative reply as to what is wrong.

After checking through the MySQL manual online, I finally try this (in the /usr/sbin directory):

mysql -u root -p

It works! The machine asks for my root password. And we’re in.

(Why this works where the MySQL Administrator failed is beyond me, since both were using “root” and the valid root password.)

Now to set up users (say “potatohead” using password “spud”). At the mysql> prompt (that semicolon at the end is vital, by the way):
grant all privileges on *.* to 'potatohead'@'*.*' identified by 'spud';
That command allows potatohead to connect the server from anywhere and do anything with MySQL. Powerful medicine indeed!