For a lot of log processing, I need to store IP addresses in a database table. The standard process was always to convert it to an unsigned int in perl or php and then insert it. Today I discovered an easier way. MySQL's INET_ATON function. It takes an address in dotted quad format and converts it into an INT. So, all you have to do is this:

INSERT INTO table (ip) VALUES (INET_ATON('$ip_address'));

And done.

Coming to the Hyatt Santa Clara, for the MySQL Conference & Expo 2009? Beware, that this year, the in-room Internet just isn’t so peachy.

When you check in, there’s this option of a “Business Plan” that Hyatt sells you - USD$30, for free wired in-room Internet (a $12.95/day value), free breakfast (this includes 15% gratuity, so a $20+ value), a free bottle of water (yes, otherwise its $3.95), and all the local and long distance calls in the US that you’ll need (depending on what you do, YMMV). It seemed like a good deal.

Now, for the benefit of others, which has taken about four days for me to fix. When you’re on this plan, the Hyatt rebates your Internet within an hour or so of you signing up for the deal. This tells their ISP that you’re now not able to get access to anything else, but Port 80 and Port 443 access — yes, SMTP, IMAP, SSH, IRC and all …

InitMarketing has made its calendar of world-wide conferences and trade fairs related to Free and Open Source Software, IT and specific industries available to the public.

It currently includes 122 events in 17 countries taking place in 2009. 43 of them in Germany, 69 in USA. We use this calendar when planing events for our customers, thus we’ll regularly update it. Please let us know of any events which are not on our radar yet by commenting to my blog or commenting at the bottom of the events page.

« Post 3 | This is the 4th post in my MoFo Futures 2009 blog series

“When I was a child, my mother lectured me on the evils of ‘gossip.’ She held a feather pillow and said, ‘If I tear this open, the feathers will fly to the four winds, and I could never get them back in the pillow. That’s how it is when you spread mean things about people.’ For me, that pillow is a metaphor for Wikipedia.” — John Seigenthaler Sr.

So the future pulled up in her shiny big metaphor and we got in. In the beginning, our road trip made sense, all well-ordered highways and wholesome roadside attractions. Somewhere along the way, we hit bat country and the …

My parents had found a box of old stuff which they delivered to me and I went through yesterday. For instance, did you know that I appeared on a photo of Kellogs Frosties (with Tony the Tiger) in 1995! We have several of those boxes still saved, empty of course. No, I'm not a celebrity. I was in the audience of a hockey game in Lillehammer Olympics which they used on their boxes in 1995. All the more memorable then, since 1995 is still the one and only year that Finland won the World Championships!

read more

During 2008 we are planning to run a series of interviews with interesting persons somehow related to the telecom field. In this first installment, we will have a chat with Juha Heinänen from Finland.

MySQL: Juha, you are a former professor of Computer Science and Communication technology, CTO (or similar positions) in at least Sonera, Telia and Song, former ATM specialist, responsible for bringing Internet to Finland and registering the .fi top-level domain, a consultant for many early network equipment startups some of which succeeded to be still with us today, and author of several RFC's. Nowadays you are a core contributor to the OpenSER SIP proxy, and you sell a VoIP platform called OpenSIPg based on that to Nordic operators. In addition you seem to live a life that would likely be a dream of many hackers, spending time in different parts of the world hacking on your favorite Open Source project. Even to this date, I …

During 2008 we are planning to run a series of interviews with interesting persons somehow related to the telecom field. In this first installment, we will have a chat with Juha Heinänen from Finland.

MySQL: Juha, you are a former professor of Computer Science and Communication technology, CTO (or similar positions) in at least Sonera, Telia and Song, former ATM specialist, responsible for bringing Internet to Finland and registering the .fi top-level domain, a consultant for many early network equipment startups some of which succeeded to be still with us today, and author of several RFC's. Nowadays you are a core contributor to the OpenSER SIP proxy, and you sell a VoIP platform called OpenSIPg based on that to Nordic operators. In addition you seem to live a life that would likely be a dream of many hackers, spending time in different parts of the world hacking on your favorite Open Source project. Even to this date, I …

During 2008 we are planning to run a series of interviews with interesting persons somehow related to the telecom field. In this first installment, we will have a chat with Juha Heinänen from Finland.

MySQL: Juha, you are a former professor of Computer Science and Communication technology, CTO (or similar positions) in at least Sonera, Telia and Song, former ATM specialist, responsible for bringing Internet to Finland and registering the .fi top-level domain, a consultant for many early network equipment startups some of which succeeded to be still with us today, and author of several RFC's. Nowadays you are a core contributor to the OpenSER SIP proxy, and you sell a VoIP platform called OpenSIPg based on that to Nordic operators. In addition you seem to live a life that would likely be a dream of many hackers, spending time in different parts of the world hacking on your favorite Open Source project. Even to this date, I …

A