I had some new issues while migrating a customer environment from IBM Connections 5.0 to 5.5 (Oracle) and I would like to document them here: ORA-01722: invalid number during Homepage upgrade While running the script “homepage/oracle/upgrade-50CR4-55.sql” we got the
Create tasks in “Remember The Milk” with Siri and the Apple Watch
I am a long year user of “Remember The Milk” (RTM) to manage all my tasks. Although they do still not have a native app on the iPhone, you are able to use Siri on the Apple Watch to automatically
DBEAVER – Universal Database Manager
I normally used “Squirrel” as a free universal database client to connect to databases like DB2, Oracle etc. I just found a new tool called “DBeaver“, which is also free. It looks very nice and it will replace Squirrel for
IBM Connections 5.5 CR2 available
Since last week, IBM Connections 5.5 CR2 is available. Here are some important links: Download IBM Connections 5.5 CR2 Download IBM Connections 5.5 CR2 Database Update Scripts IBM Connections 5.5 CR2 Fix List Updating IBM Connections 5.5 Update Strategy for
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:
|
1 2 3 4 5 6 7 8 |
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:
|
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
|
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