Ever had a machine on a very locked down network where the network admins will not give you access to RedHat network for installing and updating packages with yum? If so, it sucks to be you. But do not despair, SSH to the rescue!
First, make sure you have an available http/https proxy. Setting up one of those is beyond the scope of this little reminder-to-self, so JFGI. Then, connect to the remote host with this command:
ssh -R 8080:<Adress to proxy server>:<proxy server port> root@remotehost
Then, on remotehost, make sure /etc/sysconfig/rhn/up2date contains the following (if your proxy needs authentication you will need additional configuration, that file is properly documented so just dive into it.):
# grep -e enableProxy= -e httpProxy= /etc/sysconfig/rhn/up2date
enableProxy=1
httpProxy=localhost:8080
Now you can run yum to your hearts content.
Dagbladet har endeleg oppdaga OLPC, og skriv faktisk ein ok artikkel om historien og tanken bak den. For oss som er litt meir vaksne er slike små ultramobile laptopar ganske så interessante å ha med når ein er på farten, og OLPC er bortsett frå den horrible fargen eit ganske bra alternativ. Det finnest dog ein annan liten røvar som heiter EEE PC, som er konkurransedyktig i pris (vi snakker USA-priser..). Laptopmag.com har ei artig samanlikning mellom OLPC og EEE PC. Personleg tykkjer eg at EEE PC har ein stor fordel i at han har eit tastatur med tactile feedback, gummimatta til OLPC er ikkje spesielt god å skrive på IMHO. Og ein skulle vel tru at softwaren til OLPC (Linux) skulle klare å køyre på Linux-baserte EEE PC også?
When getting the list of blog entries, this select is executed:
SELECT SQL_CALC_FOUND_ROWS wp_posts.*
FROM wp_posts
LEFT JOIN wp_postmeta ON wp_postmeta.post_id = wp_posts.ID
WHERE 1=1 AND (post_type = ‘post’ AND (post_status = ‘publish’))
AND ((wp_postmeta.meta_key != ‘wpicasa_imgfilename’
AND wp_postmeta.meta_key != ‘wpicasa_album’ AND wp_postmeta.meta_key != ‘wpicasa_folder’) OR wp_postmeta.meta_key IS NULL)
ORDER BY post_date DESC LIMIT 0, 5
For some reason the newest WP adds two rows in wp_postmeta per post.
mysql> select * from wp_postmeta where post_id = 171;
+———+———+————+————+
| meta_id | post_id | meta_key | meta_value |
+———+———+————+————+
| 219 | 171 | _pingme | 1 |
| 220 | 171 | _encloseme | 1 |
+———+———+————+————+
2 rows in set (0.00 sec)
This leads to getting two duplicate rows back from the query. I solved this by patching the code, adding a DISTINCT after the SELECT. My bet is that this is some trouble with some weirdo plugin or whatnot, so I’ll just let it slide..
…or at least that was what I hoped. In the update to this article it says it will not be ready in Ubuntu before april 2008. The lack of an easy way of setting up X was my main reason for switching over to MacOSX last year after seven years as a Linux (laptop) user. Having to restart the graphical interface just because you plug in an extra display was too annoying for me to live with. However, it seems I may live happily with my MacBook Pro for quite a while longer anyway 
UPDATE: As Ola Lindberg point out in the comments, the configuration applet actually _did_ make it’s way into Gutsy. And it works. Mostly 
