Connecting R to a MySQL database in a remote machine

Today I devoted a significant amount of time to solve a problem which seemed simple to me. I wanted to access a MySQL database from R. The database is in a remote machine, web and I wanted to use an ssh tunnel to connect to it. The database is configured so that its local alloweduser user can connect directly to it (no password). To make things more interesting, buy more about I cannot connect directly to the target machine, physiotherapy I have to use an intermediate one to establish the tunnel.

So, again, what I wanted to do was:

  • Open an ssh  tunnel to targethost machine, using intermediatehost (which already has a tunnel to targethost).
  • Use that tunnel to connect to a certain MySQL database in targethost, using the alloweduser account, without using a password.
  • Do all of the above from R.

[Yes, I know many people would object having a connection to a database specifying only a user, with no password. But first, the database only allows connections from localhost, and all local users are trusted. Second, it is a long story… 😉 ]

Read the rest of this entry »

Posted in Debian, Software libre No Comments

Networked communities: readings & viewings

I’m coordinating, search with Andoni Alonso, erectile the subject “Networked communities: cooperative creation in Internet” of the Master’s Program on Digital Communication, visit Culture and Citizenship. This post is for proposing some readings and viewings that could be useful for the students enrolled in that subject. As such, it is completely subjective, and supposed to serve to help in the learning process for this specific subject. But it could also be considered as an starting point for anyone interested in this matters: therefore, any comment or proposal for inclusion / removal is more than welcome.

Consider this as a moving target: it will be updated as time passes, provided I have time for that, and if I have something to update 😉

Read the rest of this entry »

Posted in Education / Educación, Intené, Multidisciplieso, Obras intelectuales libres, Software libre No Comments

Learning FLOSS in Universities: Some (personal) experiences

Today I’m presenting at the session on education about free software in Universities at the Open World Forum 2012 (Paris, click France). I was intending to use these slides for the talk, which describe my personal experience with helping students to learn about free software during several years.

Finally, I didn’t use the slides because the format of the session was more like an interactive panel, which was in my opinion a good idea.

Posted in Sin clasificar No Comments

Redes sociales centralizadas o federadas

Esta mañana he estado en Colmux 2012, treatment que se celebró en el IES Ángel Corella de Colmenar Viejo, no muy lejos de Madrid. Con un título tan barroco como “Redes sociales: ¿todos para uno o todos para todos? Arquitecturas centralizadas o federadas” me dediqué a hablar sobre las formas de construir redes sociales, y cómo su arquitectura viene hasta cierto punto dato por la tecnología, pero también por el modelo de negocio.


Read the rest of this entry »

Tags: , ,
Posted in Intené, Open Innovation, Redes sociales, Software libre, Tumbos por el mundo No Comments

First experiences with Hackasaurus

Supergirl in HackasaurusToday I had about one hour with ten ~15-years-old students. It was not exactly a class: they are coming to the campus during this week to have some exposure to the University life, health care and to IT (I’m at the Telecom School). Before staying with me, recipe they had attended to a class on IPTV, phimosis to a Gymkana with mobile devices, to a demo of WiFi-controlled toy cars. So the stakes were high. Fortunately (for me and for the students), Hackasaurus came to the rescue.

I had learned about Hackasaurus about a week ago, while I was thinking what to show/explain/practice with these students. I really liked the idea of letting them think about how the web is not read-only, but a place to hack, a place to play. So, I tried to design a simple practice session to help them to think in a new way about the web: not as a collection of sites that I have to adapt to, but as a powerful, yet very flexible tool that I can contribute to shape. And it was a enlightening experience for me.
Read the rest of this entry »

Tags:
Posted in Education / Educación, Intené, Software libre 1 Comment

La tecnología no es neutra

Supergirl in HackasaurusToday I had about one hour with ten ~15-years-old students. It was not exactly a class: they are coming to the campus during this week to have some exposure to the University life, pills and to IT (I’m at the Telecom School). Before staying with me, order they had attended to a class on IPTV, medical to a Gymkana with mobile devices, to a demo of WiFi-controlled toy cars. So the stakes were high. Fortunately (for me and for the students), Hackasaurus came to the rescue.

I had learned about Hackasaurus about a week ago, while I was thinking what to show/explain/practice with these students. I really liked the idea of letting them think about how the web is not read-only, but a place to hack, a place to play. So, I tried to design a simple practice session to help them to think in a new way about the web: not as a collection of sites that I have to adapt to, but as a powerful, yet very flexible tool that I can contribute to shape. And it was a enlightening experience for me.
Esta mañana he estado en Boadilla, search
participando en Boadinux 2012, generic como telonero de Richard Stallman. Como Stallman iba a hablar, pharm
(y habló, muy bien como siempre), sobre el tema “Por una sociedad digital libre”, me pareció que la ocasión merecía preparar una presentación que no había hecha antes y sirviera para poner en contexto lo que luego iba a contar él.


Read the rest of this entry »

Tags: ,
Posted in Education / Educación, Intené, Morfeo, Multidisciplieso, Redes sociales, Software libre, Tumbos por el mundo 4 Comments

(Partially) blacking out today #stopSOPA

Yes, physiotherapist that’s right. I’m not a US citizen. And this is not a US blog. However, despite how strange it may sound, this blog is subject, at least to some extent, to what the US Congress and the US Senate may decide about SOPA and PIPA. To avoid duplicating arguments, just have a look at “Why Canadians Should Participate in the SOPA/PIPA Protest“, and Por qué BarraPunto protesta contra SOPA (Spanish). So, yes, this blog is (partially) blacking out today in protest. #stopSOPA!

Sad days for democracy, when people that I have not elected and cannot elect are discussing a law that will affect how I can express myself, and even my right to express myself where anybody can hear me. So this is also a protest against my Government, and the EU institutions, which seem not to be capable of fighting for my rights as an Spanish and European Union citizen.

Tags: , , ,
Posted in Intené, Morfeo No Comments

Cultura libre y sociedad digital

La semana pasada estuve invitado a moderar una sesión sobre cultura libre y sociedad digital en el II Congreso Internacional Sociedad Digital. Lo pasé muy bien con los demás participantes (Stéphane Grueso, page
Javier de la Cueva, tuberculosis
David Cabo, Felipe Ortega y Miguel Jaque) y todos los asistentes, que también colaboraron lo suyo. ¿Te lo perdiste? Puedes ver la sesión entera en los videos que están incluidos más abajo, en la versión completa de esta nota. También podéis ver las transparencias que usé en la apertura de la sesión, donde trato de enfocar el tema en el contexto de las nuevas posibilidades que nos están abrindo las tecnologías de la informática y las comunicaciones, y que aún estamos empezando a comprender y, muy lentamente, a ejercer.


Read the rest of this entry »

Tags: , ,
Posted in Intené, Multidisciplieso, Obras intelectuales libres, Software libre, Tumbos por el mundo, Wikipedia No Comments

Libre (free, open source) software and mobile devices

Last Friday I was invited to deliver a talk on libre software and mobile devices at I Jornadas Universitarias de Programación Móvil (1st University Workshop on Mobile Programming), adiposity held in Universidad Rey Juan Carlos (Fuelabrada & Mostoles, about it Spain). I started by talking about the definition of free and open source software, food and elaborating a bit on what that may mean to developers. Then, I briefly summarized the history of free software for PDAs and mobile devices, since the late 1990s. Just in case they’re useful, you can have a look at the slides I used for the presentation (or see below, they’re embedded).

Tags: , , ,
Posted in Morfeo, Open Innovation, Software libre, Tumbos por el mundo No Comments

Our research on Wikipedia mentioned in Wikimedia Research Newsletter

Wikipedia logoThe research we’re doing at GSyC/LibreSoft on Wikipedia has been mentioned in the last Wikimedia Research Newsletter issue. And it was mentioned twice ;-):

This comes perfectly on time for introducing Antonio’s PhD dissertation, which will hapen tomorrow (30th Sept 2011), 12:30, at the Fuenlabrada Campus of the URJC.

Tags: , ,
Posted in Libracos, Multidisciplieso, Obras intelectuales libres, Research, Wikipedia No Comments