Software development, photography, jokes, ....

noyb-logo

Sites by me

 
sds82-logo
tas-logoTransportation Administration System
snoezelkussen-logo-kleinstSnoezelen Pillows for Dementia
ikzoekeenbegeleider-logoBegeleiders voor gehandicapten
Laat uw hond het jaarlijkse vuurwerk overwinnen
Betuweroute en Kunst
logo 50x50Hey Vos! Je eigen naam@vos.net emailadres?
Kunst in huis? Nicole Karrèr maakt echt bijzonder mooie dingen
nettylogo2Kunst in huis? Netty Franssen maakt ook bijzonder mooie dingen

Hosting Favorites

 
ANU Internet Services
Netim
GoDaddy
XEL Media

Blogroll

 
Bomenstichting
Google Translate
PHP
MySQL
jQuery
jQuery UI
YourHead Stacks API
Favicon Generator.
Password Generator.
Check HTTPS problems



Categories

Archives
 Mar 2024 (4)
 Feb 2024 (3)
 Jan 2024 (4)
 Sep 2023 (1)
 Aug 2023 (1)
 Jul 2023 (3)
 May 2023 (2)
 Apr 2023 (2)
 Mar 2023 (2)
 Feb 2023 (1)
 Jan 2023 (2)
 Oct 2022 (2)
 Sep 2022 (2)
 May 2022 (3)
 Mar 2022 (1)
 Feb 2022 (2)
 Jan 2022 (2)
 Nov 2021 (3)
 Oct 2021 (1)
 Sep 2021 (2)
 Aug 2021 (1)
 Jul 2021 (1)
 Jun 2021 (2)
 May 2021 (3)
 Apr 2021 (1)
 Mar 2021 (1)
 Feb 2021 (2)
 Jan 2021 (2)
 Dec 2020 (2)
 Oct 2020 (1)
 Sep 2020 (2)
 Aug 2020 (3)
 Jul 2020 (2)
 May 2020 (3)
 Apr 2020 (1)
 Mar 2020 (2)
 Feb 2020 (1)
 Jan 2020 (3)
 Dec 2019 (1)
 Nov 2019 (1)
 Oct 2019 (2)
 Aug 2019 (2)
 Jun 2019 (2)
 May 2019 (2)
 Apr 2019 (5)
 Feb 2019 (6)
 Dec 2018 (2)
 Nov 2018 (1)
 Oct 2018 (1)
 Sep 2018 (5)
 Aug 2018 (1)
 Jul 2018 (6)
 Jun 2018 (4)
 May 2018 (2)
 Apr 2018 (3)
 Mar 2018 (10)
 Feb 2018 (8)
 Jan 2018 (2)
 Dec 2017 (3)
 Nov 2017 (4)
 Oct 2017 (3)
 Sep 2017 (2)
 Aug 2017 (2)
 Jul 2017 (1)
 Jun 2017 (2)
 May 2017 (4)
 Apr 2017 (4)
 Mar 2017 (2)
 Feb 2017 (2)
 Jan 2017 (5)
 Dec 2016 (5)
 Nov 2016 (5)
 Oct 2016 (2)
 Sep 2016 (4)
 Aug 2016 (2)
 Jul 2016 (4)
 Jun 2016 (2)
 May 2016 (3)
 Apr 2016 (6)
 Mar 2016 (3)
 Feb 2016 (1)
 Jan 2016 (3)
 Dec 2015 (3)
 Nov 2015 (4)
 Oct 2015 (4)
 Sep 2015 (3)
 Aug 2015 (3)
 Jul 2015 (1)
 Jun 2015 (1)
 May 2015 (3)
 Apr 2015 (2)
 Feb 2015 (3)
 Jan 2015 (3)
 Dec 2014 (4)
 Nov 2014 (2)
 Oct 2014 (5)
 Sep 2014 (4)
 Aug 2014 (5)
 Jul 2014 (2)
 Jun 2014 (2)
 May 2014 (5)
 Apr 2014 (2)
 Feb 2014 (1)
 Jan 2014 (2)
 Dec 2013 (2)
 Nov 2013 (3)
 Oct 2013 (3)
 Sep 2013 (2)
 Aug 2013 (1)
 Jul 2013 (3)
 Jun 2013 (2)
 May 2013 (3)
 Apr 2013 (3)
 Mar 2013 (6)
 Feb 2013 (3)
 Jan 2013 (4)
 Dec 2012 (5)
 Nov 2012 (3)
 Oct 2012 (3)
 Sep 2012 (6)
 Aug 2012 (4)
 Jun 2012 (5)
 May 2012 (7)
 Apr 2012 (4)
 Mar 2012 (1)
 Feb 2012 (5)
 Jan 2012 (5)
 Dec 2011 (5)
 Nov 2011 (7)
 Oct 2011 (4)
 Sep 2011 (6)
 Aug 2011 (3)
 Jul 2011 (7)
 Jun 2011 (9)
 May 2011 (3)
 Apr 2011 (8)
 Mar 2011 (7)
 Feb 2011 (2)
 Jan 2011 (3)
 Dec 2010 (6)
 Nov 2010 (10)
 Oct 2010 (4)
 Sep 2010 (3)
 Aug 2010 (10)
 Jul 2010 (10)
 Jun 2010 (1)
 May 2010 (1)
 Apr 2010 (2)
 Mar 2010 (2)
 Feb 2010 (5)
 Jan 2010 (1)
 Dec 2009 (6)
 Nov 2009 (6)
 Oct 2009 (4)
 Sep 2009 (2)
 Jul 2009 (1)

Marc's Place


 

Powered by the Blogspot.stack

Casal dos Jordões - Finest Reserve Port

 Permalink
Looking for a superb, organic port wine? I really can recommend this one! More about this company, which wins medal after medal since moving to organic growing of plants in 1994.

casal-dos-jordoes-finest-reserve-port
 Comments

Foto: Dinner in a hotel room

 Permalink
Dinner in a hotel room

Dinner in a hotel room

 Comments

MySQL: Split a comma-separated list and insert result into table

 Permalink
Looking for a SPLIT-function in MySQL, I came across this one. I tried it and I must have have done something not right, because MySQL threw an error at the function. I am not a MySQL guru and since this is a one time Q&D conversion-action, I only took the SUBSTRING code and created a query with which one can split the contents of an old field into separate columns and directly insert the results into a new, normalized table.

My example is about a TEXT-column I want to get rid of and of which I want to transfer the contents to a separate table. This column contains email addresses separated by a comma. Thus, first, I had to find the maximum number of email addresses used in that column, so I found this query and added MAX() around it.

select max(length(emails) - length(replace(emails, ',', ''))) as occurrences
from old_table
where emails<>''


With that number, I created that number+1 of unions, so I would end up with all email addresses in one column. That select statement is then used in a left join to retrieve the corresponding user name and feed the results at the same time into a new table, which uses an ID and a USER-ID, instead of an email address:

insert into new_table
select idnr, user
from (
  select idnr,
  trim(substring(substring_index(emails, ',', 1), char_length(substring_index(emails, ',', 1 -1)) + 1)) as email
  from old_table
  where emails<>''

  union

  select idnr,
  trim(substring(substring_index(emails, ',', 2), char_length(substring_index(emails, ',', 2 -1)) + 2)) as email
  from old_table
  where emails<>''

  union

  select idnr,
  trim(substring(substring_index(emails, ',', 3), char_length(substring_index(emails, ',', 3 -1)) + 2)) as email
  from old_table
  where emails<>''

  union

  select idnr,
  trim(substring(substring_index(emails, ',', 4), char_length(substring_index(emails, ',', 4 -1)) + 2)) as email
  from old_table
  where emails<>''
) as x
join users u on (u.email1=x.email or u.email2=x.email)
where x.email<>''


Now that I have all used email address associated with the IDs of the original rows, I can now delete the old column and change all my LIKE-queries into LEFT JOINs. Much better, because email addresses change.
 
 Comments

Foto: Deer on Dune-top near Zandvoort

 Permalink
Deer on a dune-top

Deer on a dune-top

 Comments

SheepShaver - Mac OS 9.0 Classic Emulation on Mac OS 10.8

 Permalink
If you do not want to spend much money on upgrades for software you hardly use, just because you are running the latest Mac OS, try a Mac OS emulator! These are free and run nice and fast on the new Macs.

Let's take FileMaker Pro 6 for example. A piece of software I need, for a regional tree foundation I do some work for, but rarely use. And I do not want to upgrade - too expensive for the infrequent usage. So I looked at installing it on Windows in Parallels, since I have that software anyway - but that is a bit too much overhead just for running FileMaker 6. WINE did a bad job so I ditched that. Then I got a 500MHz G4 Cube! The advantage was that it runs all my older software too, like the Starwars Episode 1 Racer. But it is a bit much work turing that Mac on and off, just to do some administrative work in FileMaker 6.

So I still want to be able to run FM6 on my iMac, in Mac OS 10.8, because it is simply more convenient. I tried SheepShaver a long time ago, but then it did not work for me, somehow. But today I came across it again while searching for Mac OS emulators for Moutain Lion, and saw '2012' in the SheepShaver's blog, so that means it is still actively supported. I gave it a try and it works fantastic! And it runs my FM6 applications - and some old games, of course, like BreakThru! Really cool!

If you want to try it too, download SheepShaver and download a ROM file and the OS9 System. READ and follow these instructions and you should be ok.

SheepShaver
 Comments

Brunello di Montalcino 2007

 Permalink
A few weeks ago, while shopping at ALDI in my hometown, I came across this wine. Lucky for them I was in a good mood and spend €12 on this wine, just this once.

Well, turns out it was a very good wine!

But, not worth the price. I have had similar quality for just about €8 a bottle. Now I am waiting until the last ones of their stock get a yellow sticker with a reduced price - maybe then this wine gets interesting to buy again.

If you can get it for a reasonable price, I suggest you try it!

brunello-di-montalcino1 (aldi,okt,12euro)brunello-di-montalcino2 (aldi,okt,12euro)
 Comments

Foto: iMac going crazy

 Permalink
iMac going crazy

iMac going crazy

 Comments

Daily Script on Mac OS X Server did not clean up /tmp

 Permalink
Lately my /tmp folder was piling up with files (krb5cc*) without any signals that these files were regularly deleted. A bit of googling showed that these come from the Open Directory Server, but that's something I cannot control. So I went to investigate why the daily script would not delete them. I googled a bit again and found out where the parameter file for the daily, weekly and monthly cleanup-scripts is located: /etc/defaults/periodic.conf. There, I found these settings for /tmp :

# 110.clean-tmps
daily_clean_tmps_enable="YES"           # Delete stuff daily
daily_clean_tmps_dirs="/tmp"            # Delete under here
daily_clean_tmps_days="3"               # If not accessed for
daily_clean_tmps_ignore=".X*-lock .X11-unix .ICE-unix .font-unix .XIM-unix"
daily_clean_tmps_ignore="$daily_clean_tmps_ignore quota.user quota.group"
                                        # Don't delete these
daily_clean_tmps_verbose="YES"          # Mention files deleted


The one to look for is where it says "3". This indicates that the routine should clean up old files not accessed for 3 days. But it did not - and the files were not mentioned in the ignore-parameters. Even rm -rf krb5cc* returned immediately an error that its argument list was too long. Therefore I started reading what the exact values for this parameter should be.

Well, it turns out that the value needs a qualification, like d(ays) or m(months), etc.. I found that out by reading /etc/periodic/daily/110.clean-tmps and studying how find uses -atime, -ctime and -mtime and how to add or subtract values. Here are a few find-commands, copied from /etc/periodic/daily/110.clean-tmps, which I tried to make sure that what I just read was right:

$ cd /tmp
$ sudo find -dx . -fstype local -type f -atime +1h -mtime +1h -ctime +1h
$ sudo find -dx . -fstype local -type f -atime +1d -mtime +1d -ctime +1d
$ sudo find -dx . -fstype local -type f -atime +2d -mtime +2d -ctime +2d


Further reading suggested to use override-files, so I sudo'd into vi to create the file /etc/periodic.conf with the following contents:

daily_clean_tmps_days="2d"

Yes, 2 days. Three days is too long for a server, in my opinion. The file's attributes look like this:

marcvos @ ~ $ ls -l /etc/periodic.conf
-rw-r--r-- 1 root wheel 27 Oct 25 16:38 /etc/periodic.conf


Next, delete the file daily.out:

$ sudo rm /var/log/daily.out

Reboot the server. Check your /tmp folder and /var/log/daily.out the next days.

With me, I now finally saw all those files getting deleted.
 
 Comments

Foto: Fossiele Vissenkop?

 Permalink
Fossile Fish

Fossile Fish


We gingen fossielen zoeken bij Cadzand-Bad en eindigden uiteindelijk bij Het Zwind. Daar hebben we een middag lopen speuren en daarbij vond ik o.a. deze versteende vissenkop. De bek en het oog zitten ook aan de andere kant, maar of het inderdaad een vissenkop is.....?

We went looking for fossils at Cadzand-Bad but ended up at Het Zwind. There we have spent the afternoon hunting for fossils and then I found, a.o., this fossilized fish head. The beak and eye are also visible on the other side, but if it actually is a fish head....?
 Comments

Multihouse Reünie in Grand Hotel ter Duin, Burgh-Haamstede

 Permalink
In het weekeinde van 22 en 23 september 2012 was er een grootschalige reünie georganiseerd voor en door oud-Multihousers. Grote sponsors van dit idee zijn Inventive en Grand Hotel ter Duin geweest. Het hotel, de bar en het restaurant vond ik echt super! We hebben er heerlijk gegeten, gedronken en geslapen.

Alles over de reünie is te lezen op de website van Inventive. Hieronder vindt je een overzicht van de meegebrachte memorabilia en een hele kleine impressie van het hotel en de reünie - ik heb veel gekletst en weinig foto's gemaakt.

Als je op de memorabilia klikt, wordt er een 12MB grote foto geladen waarop alles wat beter te zien is. Als de foto dan geladen is, kan je met de meeste browsers er nog eens op klikken en dan wordt de foto vergroot tot de werkelijke grootte. Dan kan je alles nóg beter zien.
MH-MemorabiliaReunie1Reunie2


 Comments
© 1997- Marc Vos (and others)   -   Privacy Statement   -    Contact Me

On this website, Google Analytics is used to track visitor statistics. These are anonymised data about the number of visitors, which pages they visit on this site, from which regions they visit, which web browsers they use, etc.. You will also see non-personalised ads via Google AdSense. Cookies from Paddle or Paypal are placed when you click on a 'Buy now!' or 'Donate!' button, and possible cookies from Disqus when you use that system to comment on one or more blogposts.
Privacy Statement