Blog

Publishing PGP Keys in DNS

As I now have secured my DNS server with DNSSEC, I was able to publish my public PGP key also via DNS. There are two different possibilities to do that: PKA (public key association) This puts a pointer where to obtain

Debian Jessie: Upgrade BIND9 to newer version

I wanted to update BIND9 on my Debain Jessie Linux system to a newer version than the currently packaged version 9.9. Here are the steps to upgrade it to version 9.11:

cd /usr/local/src
wget ftp://ftp.isc.org/isc/bind9/9.11.0/bind-9.11.0.tar.gz
tar zxvf bind-9.11.0.tar.gz
rm bind-9.11.0.tar.gz
cd bind-9.11.0/
./configure
make
make install

cd /usr/local/src

wget ftp://ftp.isc.org/isc/bind9/9.11.0/bind-9.11.0.tar.gz

tar zxvf bind-9.11.0.tar.gz

rm bind-9.11.0.tar.gz

cd bind-9.11.0/

./configure

make

make install

This will install the new version of BIND9

Technical Changes Behind the Scene …

Long time ago since I posted something here. The reason for that is, that I did some massive technical changes in the background. First, all my stuff is now running on a plain Linux virtual server (based on Debian Jessie)

IBM Connections: Find out which Communities do have a Sharepoint widget added

A customer would like to know which IBM Connections Communities have a Sharepoint widget added. The following SQL statement should give the UUID and the name of these Communities:

select COMMUNITY_UUID,NAME from SNCOMM.COMMUNITY where COMMUNITY_UUID IN(select EXT_RESOURCE_ID from SNCOMM.LC_EXTENSIONS where dbms_lob.instr(EXT_VALUE_EXTENDED,utl_raw.cast_to_raw ('SharePointFiles'), 1,1)>0);

1	select COMMUNITY_UUID,NAME from SNCOMM.COMMUNITY where COMMUNITY_UUID IN(select EXT_RESOURCE_ID from SNCOMM.LC_EXTENSIONS where dbms_lob.instr(EXT_VALUE_EXTENDED,utl_raw.cast_to_raw ('SharePointFiles'), 1,1)>0);

The customer also wanted to send a mail to all creators

IBM HTTP Server: Better logrotate for HTTP server logs in Linux

To rotate your IBM HTTP Server logs (or Apache HTTP server logs) on a daily (or whatever) basis, you normally are using something like

CommonLog "|/opt/IBM/HTTPServer/bin/rotatelog -l /opt/IBM/HTTPServer/log/access_log.%Y.%m.%d 5M" common

1	CommonLog "\|/opt/IBM/HTTPServer/bin/rotatelog -l /opt/IBM/HTTPServer/log/access_log.%Y.%m.%d 5M" common

The disadvantage of that is, that the current log file name changes every day. So if you have e.g.

IBM Websphere: Use arrow key with wsadmin in Linux

Other than in Windows you cannot use the arrow keys to correct a command line of recall your last command with IBM Websphere wsadmin command line in Linux. In order t get that working you need a little tool called

IBM Connections: Batch Mode for accessing configuration files

For many Connections administration tasks you need to specify which Connections configuration file you want to use by running a WSADMIN command like e.g. execfile(“activitiesAdmin.py”). If you have more than one Connections node this command will ask you on which

Urs-o-Log