Author: geekworker
-
Using Excel (and OpenOffice) to Create Timelines
Looking for a way to easily and automatically create timelines, I came across an awesome post by Jon Witwer: How to Create a Timeline in Excel. It’s not exactly the same in OpenOffice, but it works too (I tested it with LibreOffice, actually).
-
Postfix error – fatal: parameter “smtpd_recipient_restrictions”
I encountered this error when I added a check_sender_access clause to my smtpd_recipient_restrictions in postfixes “main.cf”: fatal: parameter “smtpd_recipient_restrictions”: specify at least one working instance of: check_relay_domains, reject_unauth_destination, reject, defer or defer_if_permit. I haven’t really checked, but I am guessing this is because smtpd_recipient_restrictions as the last clause isn’t specifically rejecting all mails that aren’t […]
-
Excel Formula to get Number of Days in a Month
It seems Excel still can’t tell me the days in a particular month. The following formula works, though: =DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1) Obviously, A1 has to have a date in it. Works like a charm: Update, much, much later: Looks like LibreOffice has a DAYSINMONTH function.
-
Cube Root in OpenOffice
OpenOffice.org doesn’t seem to have any built-in functions for cube roots, but there’s an easy workaround. To find the nth root, use powers to the nth fraction. Probably easier to illustrate than to explain with my rusty math skills. 😉 I mean this: You need to use the brackets because otherwise the power would take […]
-
Setting Sender Address in Mutt
I’m a Pine user. I seriously dislike mutt. It’s terribly uncomfortable to use. But it is maintained, and luckily it’s quite flexible and can be changed in how it acts. I’m trying to get by with mutt… and it’s a slow process, one step at a time. First annoyance, by default it uses my machine […]
-
Turning off Date conversions in OpenOffice.org
Yesterday, I had the problem that a number range I entered in a table (“3-4”) was changed into a date by OpenOffice. Never saw that happen before, I think it must be a new functionality. I tried to switch it off but found nothing in the Auto Correction options. The developers put the option in […]
-
Turning off Syntax Highlighting in vim
Today my screen is a bit dark – or rather, the office is bright, what with all the sun outside. This makes some of the colors of vim’s syntax highlighting hard to read. How do you turn this on or off? After you open a file, and press ESC. With: :syntax off you can turn […]
-
Enabling SSL in Apache2 on Ubuntu
I’m using my server for various admin interfaces and so want to SSL encrypt all traffic to the web server. This is easy enough to add to the default vhosts. First, we need an SSL certificate. Create it by running: openssl req -new -x509 -days 3650 -nodes -out /etc/ssl/certs/apacheserver.pem -keyout /etc/ssl/private/apacheserver.pem This generates a self-signed […]
-
Moving eJabberd
If you need to migrate ejabberd, you need to be aware that -at least on Debian/Ubuntu- it uses your machine name as the default nodename, or to be more precise, ejabberd@hostname. This can be controlled in /etc/default/ejabberd but unless you already knew about it, it’s a done deal already. So, my naive approach of just […]
-
SVN Stalling
I had this weird problem where my svn would upload a few MB and then stall and timeout. At first I of course suspected a problem with either svn on the server, the apache, or tortoisesvn. I tried CPU affinity settings, Apache settings – nothing I did helped, including updating to latest patchlevel etc. After […]