I must have missed something, but I didn't know of a Flemish vilage called Unnu, let alone a village that exists in East-Flanders, West-Flanders _and_ Flemish Brabant ... ;-)
http://maps.google.be/maps/place?cid=9496107104178907831&q=sony+zaventem...
http://www.mercuriusgids.be/UNNU/Afvalbehandeling
http://www.mercuriusgids.be/TNT
http://www.infobel.com/nl/belgium/business/111000/Kantoorbenodigdheden+/...
This tutorial shows how to set up automated backups of linux hosts through dhcp using Ubuntu.
I will use following software:
In /etc/dhcp3/dhcps.conf add:
on commit {
execute (
"/etc/dhcp3/startbackup.sh",
"start",
binary-to-ascii(10,8,".",leased-address)
);
}
sudo vi /etc/dhcp3/startbackup.sh
#!/bin/bash case "$1" in start) sudo -u backup /etc/dhcp3/rsync.sh $2 ;; *) ;; esac exit 0
sudo vi /etc/dhcp3/rsync.sh
#!/bin/bash nohup rsync -azuvb backup@$1:/home /backup/$1 &
and add the /backup folder:
sudo mkdir /backup
sudo chown backup:backup /backup
sudo useradd backup
Create the private/public ssh keys:
ssh-keygen -t rsa
Copy the public key to all hosts you want to backup:
ssh-copy-id -i ~/.ssh/id_rsa backup@[host]
replace [host] with your hostname(s) or ip address(es)
sudo visudo
and add a line like this:
dhcpd ALL=(backup)NOPASSWD: /etc/dhcp3/startbackup.sh, /etc/dhcp3/rsync.sh
sudo vi /etc/apparmor.d/usr.sbin.dhcpd3
change the part that looks like:
/etc/dhcp3/ r, /etc/dhcp3/** r, /etc/dhcpd.conf r, /etc/dhcpd_ldap.conf r,
to:
/etc/dhcp3/ r, /etc/dhcp3/** r, /etc/dhcp3/startbackup.sh Uxr, /etc/dhcpd.conf r, /etc/dhcpd_ldap.conf r,
sudo /etc/init.d/apparmor restart
sudo /etc/init.d/dhcp3-server restart
sudo useradd backup
sudo usermod -G root
sudo dhclient interface
where interface is the one you want to renew
You should now have a backup of your clients on the server
I have recently released version 0.1 of Cwibber.
Cwibber is an easy to use command line interface to Gwibber, which makes it easy to get (currently) Identica, Twitter and Facebook messages in your Conky.
First of all, add my ppa to your /etc/sources.list:
deb http://ppa.launchpad.net/mcielen/ppa/ubuntu [version] main
deb-src http://ppa.launchpad.net/mcielen/ppa/ubuntu [version] main
Ofcourse subsitute [version] with intrepid, jaunty or karmic. Then add the PGP key:
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 0DA7F92B
Since Cwibber depends on Gwibber >= 2.0, add the Gwibber ppa:
deb http://ppa.launchpad.net/gwibber-daily/ppa/ubuntu [version] main
deb-src http://ppa.launchpad.net/gwibber-daily/ppa/ubuntu [version] main
Again subsitute [version] with intrepid, jaunty or karmic. Add the PGP key:
sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 72D340A3
And, as usual:
sudo apt-get update
Now you're ready to install Cwibber:
sudo apt-get install cwibber
Since Cwibber depends on Gwibber, it'll be installed too.
To use Cwibber 0.1, you'll have to run Gwibber to create the accounts you want to use, and run Gwibber once to start the Gwibber Daemon (this will be changed in Cwibber v0.2). Now call Cwibber from your .conkyrc:
${execi 60 cwibber}
TODO for Cwibber 0.2:
- check whether Gwibber daemon is running, if not start it. For this I depend on the Gwibber developers, since refresh intervals will have to be stored in gconf. Developers promised this will be changed soon. (see https://bugs.edge.launchpad.net/gwibber/+bug/417903)
- allow management of accounts through cwibber instead of through Gwibber
TODO for later versions:
- I'm hoping to convince Gwibber developers to split GUI and Daemon. If this won't happen, I might pack the gwibber daemon with Cwibber. (see https://bugs.edge.launchpad.net/gwibber/+bug/421285)
Call for developers and testers
Test this app, and open an LP bug for any problem you find or features you want to see in next versions.
Since I'm far from a developer myself, I need help for this project. Interested in developing? Contact me through this forum or mail.
You've probably heard about the FSF's new campaign called "Windows7sins". I strongly oppose this way of "PROmoting" Floss. If like me, you think Floss should be promoted in a positive way, put below banner on your blog/website/..., tell your colleagues/friends/... about it and comment on my blog or send me a mail. We should show the world the Floss community is a positive community and I'll write a follow-up post with the results.
For a project I'm working on, I got confronted with a rather ugly and complex mysql-query:
SELECT *,ij_cursta.opmerking as ij_cursta_opm, ij_rad.afhklantnaam as ij_rad_afhklantnaam, ij_rad.levklantnaam as ij_rad_levklantnaam, ij_rad.afhpostcode as ij_rad_afhpostcode, ij_rad.afhgemeente as ij_rad_afhgemeente, ij_rad.levpostcode as ij_rad_levpostcode, ij_rad.levgemeente as ij_rad_levgemeente, ij_bons.uid as ij_bons_uid, ij_afhland.iso as ij_afhland_iso, ij_levland.iso as ij_levland_iso FROM ( SELECT tb_status.bonref, tb_status.datum, MAX(tijd) AS tijd FROM ( SELECT bonref, MAX(datum) AS datum FROM tb_status GROUP BY bonref ) D JOIN tb_status USING(bonref,datum) GROUP BY tb_status.bonref ) T JOIN tb_status AS ij_cursta USING(bonref,datum,tijd) JOIN tb_ritten ON tb_ritten.bonnr = T.bonref JOIN tb_ritadressen AS ij_rad ON tb_ritten.bonnr = ij_rad.bonnr JOIN tb_statuses AS ij_stat ON ij_stat.id = ij_cursta.status JOIN tb_landen AS ij_afhland ON ij_rad.afhland = ij_afhland.land_en JOIN tb_landen AS ij_levland ON ij_rad.levland = ij_levland.land_en JOIN tb_bons AS ij_bons ON tb_ritten.bonnr = ij_bons.bonnr WHERE tb_ritten.klantid=1 OR tb_ritten.klantid=2 OR tb_ritten.klantid=3 OR tb_ritten.klantid=4 OR tb_ritten.klantid=5 OR tb_ritten.klantid=6 OR tb_ritten.klantid=9 GROUP BY tb_ritten.bonnr ORDER BY tb_ritten.encoddatum DESC, tb_ritten.encodtijd DESC
When the php page containing this query was called, it took about 2 minutes to load. Yesterday I was sick of it, and started troubleshooting.
Using EXPLAIN I found out it wasn't using any index, and using profiling, it was clear almost all of the 2 minutes was used to copy data to a temp table.
I decided to start adding some indexes, based on the joins. After that the results (using SQL_NO_CACHE to make sure it wasn't a cached query) were shown after 8 seconds. A vast improvement, but not good enough for me.
I added some more indexes, changed the database slightly (added an intermediate table), and (with help of some people on irc.arstechnica.com, changed the query to:
SELECT *,ij_cursta.opmerking as ij_cursta_opm, ij_rad.afhklantnaam as ij_rad_afhklantnaam, ij_rad.levklantnaam as ij_rad_levklantnaam, ij_rad.afhpostcode as ij_rad_afhpostcode, ij_rad.afhgemeente as ij_rad_afhgemeente, ij_rad.levpostcode as ij_rad_levpostcode, ij_rad.levgemeente as ij_rad_levgemeente, ij_bons.uid as ij_bons_uid, ij_afhland.iso as ij_afhland_iso, ij_levland.iso as ij_levland_iso FROM tb_status_latest as ij_cursta JOIN tb_ritten ON tb_ritten.bonnr = ij_cursta.bonref JOIN tb_ritadressen AS ij_rad ON tb_ritten.bonnr = ij_rad.bonnr JOIN tb_statuses AS ij_stat ON ij_stat.id = ij_cursta.status JOIN tb_landen AS ij_afhland ON ij_rad.afhland = ij_afhland.land_en JOIN tb_landen AS ij_levland ON ij_rad.levland = ij_levland.land_en JOIN tb_bons AS ij_bons ON tb_ritten.bonnr = ij_bons.bonnr WHERE tb_ritten.klantid in (1, 2, 3, 4, 5, 6, 9) GROUP BY tb_ritten.bonnr ORDER BY tb_ritten.encoddatum DESC, tb_ritten.encodtijd DES
After all these changes, of which the indexes brought the most impressive speed gain, the query now executes in 0.6 seconds. That is an unbelievable 2000 times faster than original!
Want to try out #! (Crunchbang Linux) 9.10 the easy way?
sudo apt-get install update-manager
update-manager -c -d
Done.
Disclaimer: 9.10 is an alpha release. Do not install unless you're prepared to run into possibly severe issues!
Imho Ubuntu has a serious design flaw in it's implementation of ecryptfs.
Imagine following situation:
1. You install Ubuntu using the alternate cd, create a separate partition for your /home and encrypt your home.
2. After some time you decide to reinstall Ubuntu (eg a fresh install of a new release) and obviously decide to keep your /home.
3. You log in and find out there's no way to access your previously encrypted data.
This is what happened to me. Somehow, during install, I seem to have missed (read: I don't remember seeing) the warning message that tells yo to print your mount key. After logging on to the new install, and talking to the ecryptfs people, I found out, it needs files located in ~/.ecryptfs. Nothing special it seems, as you have kept your /home, but... In Ubuntu ~/.ecryptfs is a symlink to /var/lib/ecryptfs/$user, which you obviously didn't keep. This, as far as I'm concerned, is a serious design flaw, that completely denies user logic of keeping /home on a separate partition.
One very important lesson that I drew from this: if you use an encrypted /home, and haven't printed your mont key yet, do so now!
Dear Wouter,
let me mix in the political conversation between you and Dag. I'll just throw in my 2 cents on some of the things you say.
What bothers me, however, is the fact that parties such as the N-VA seem to think that everything can be solved by more authonomy, and that an ultimate goal of chopping up this already too small country into a yet even smaller one is desirable. To me, it is not, and that's what my post tried to express.
There's a couple of things bothering me with your argumentation here. The fact Belgium is small, is true. The fact Flanders would be even smaller is logically true too. But... keeping Belgium because of that doesn't make sense. There's smaller countries in Europe and the world, that are perfectly able to be (well-)governed.
To give just a bit of background: My mother grew up in Kuringen, a small town near Hasselt, while my father grew up in Ekeren. After they married, they went to live in the province of Antwerp (in Ekeren eventually, after a short stint in Mortsel). My father's twin brother moved to Wijgmaal near Leuven after his marriage, while my mother's oldest sister married a guy from West-Vlaanderen and moved there. As a result, I have aunts and uncles in all flemish provinces (apart from East-Flanders), which gives me a somewhat unique perspective on the differences that exist within Flanders.
I was born in Limburg, studied in Brussels together with people from Antwerp, East-Flanders and West-Flanders, and moved to Tienen, Vlaams-Brabant. I also have friends and relatives in every Flemish province, and in Liege, so I think your perspective is not as unique as you tend to think.
People sometimes say that there are monetary flows between Flanders and Wallonia, and that therefore we should split up, since that would allow a higher budget for Flanders. I say that there are such differences between Flemish provinces, too; should we therefore boot out some of those provinces as well?
You should make a clear distinction between people and parties that want to split Belgium because of monetary flows, and those that have decent arguments for it. And these arguments exist. You just have to see them. I'll try to give you a couple here.
1. Cultural differences do exist. Wallonia is French, therefore latin culture. Flanders is Dutch, therefore Germanic. If you've ever even remotely looked at history, you won't be able to deny there are huge differences between these two. Not all are better in Germanic cultures (pace of life eg), but the differences are clear.
2. Walloon political fear of change and thus ingovernability. French-speaking politicians have ever since 1830 considered the Germanic culture in Belgium (Flanders) as something that should be eliminated by all means. I urge you to read Anton Roossens on this, there are, documented, examples of this from the past, and from today. One of today's examples is Didier Reynders' flyer recently released stating "If there's one country to give to Walloons, it's one Belgium, one French-speaking Belgium".
3. The above-mentioned political lingual arrogance displayed by French speaking politicians goes far beyond this. What to think of their at first sight perfectly acceptable proposal of making all of Belgium officially bilingual? Do you really think all Walloons will suddenly start to speak Dutch? Forget it! If we allow it, our grandchildren will be speaking French again!
People sometimes say that there are cultural differences between Flanders and Wallonia, and that therefore there is no link between the two. I say that there are cultural differences between Flemish provinces too; should we therefore boot out some of those provinces? As a very stupid example of this one: in Limburg, it is traditional for guests to give a standing ovation to the bride and groom when they first enter the location where the dinner is going to be held. No such tradition exists anywhere else in Flanders. There are more such differences, however.
This is again a very weak argument. Should we, at any price, keep Belgium together just because there are cultural differences anyway? Heck, there are even cultural differences between 2 naighbouring cities. This is as far as I'm concerned neither an argument pro nor contra independance.
People sometimes say that Flanders and Wallonia do not speak the same language. Arguably the best argument in favor of separatism, I would still challenge you to put a person from Limburg in front of someone from West-Flanders, and have them talk to eachother. It's going to be similarly hard for them to understand eachother as it is for them to understand someone from Wallonia.
This is utter B...S... As I said I'm from Limburg myself, and have friends in every Flemish province. I never had difficulties to understand any of them, and you know why? Because we all have the decency to speak "AN". I tend to think using this as an argument tells us more about one's lingual-intellectual capabilities.
Anyway, I'll not further bore my readers with Belgian politics. But I'm still unhappy about the election's results.
I for one am very happy with the results, and don't get me wrong Wouter, I am on the far left side of the political sphere, but, I don't believe in Belgium as a country. To cite The Economist: "If Belgium didn't exist already, would anyone go through the trouble of creating it nowadays?"...
Proposed patched version (2) of xkcd-149 a.k.a. sudo make me a sandwich:
As many have written, and supposedly all of you know, on June 7th, we are "allowed" to vote again. This time for the Flanders' regional parliament and government, and the European parliament.
As many of you know, I'm to be situated on the left side of politics, but I'm strongly opposed to Belgium as a country. Let me explain some history as to why I'm so opposed to it.
1. From the start French speaking politicians in Belgium (notice the "politicians" in this sentence, I'm not judging all French speaking people in Belgium), have had one whish: to eliminate Germanic (Flemish if you whish) culture in Belgium. Infamous example is the saying by MR's Didier Reynders "If there's one country to give to Francophones, it's Belgium, Francophone Belgium".
2. Most French speaking people today wouldn't mind being part of France instead of Belgium. This is strongly related to differences in culture you can't ignore. Ask everyone in Flanders to name 10 Walloon artists. Ask every Walloon to name 10 Flemish artists...
3. Politics, due to the regional and cultural differences has become near impossible in Belgium.
4. I'm not entirely against Europe, but Europe should, in my opinion, be a "Europe of the regions" rather than a "Europe of the nations".
Taking these 4 points into consideration, I'm left with the question "Who to vote for on June 7th?". A question that remains unanswered until today.
