Escape from boredom

rblog

Current Blog

rblog

rblog

48 hours of downtime

Work/Geek

My blog has been unavailable for more than 48 hours due to the host server having had some DNS-issues. A call to my hosting company http://www.onnet.no/ and voila, fixed in a few minutes.

Murmansk – the shipwreck outside of Sørvær

Anything but the other

Read an article about Murmansk, the shipwreck just outside of Sørvær, in Hasvik, Finnmark. It is 211 meters long, meaning…very large, so I had to check – and yes, you can see it on Google Maps. The image is kinda dark, you will get a better one if you use www.norgeibilder.no. Would have been interesting to have traveled up there just to see the size of the dry dock, the ship and everything.

Video found on Youtube
[video:youtube:PAL_a8L080w]

The weather can be rough up there [video:youtube:uCNl2bqyy-4]

Install IBM Universial Test Client on WAS

Work/Geek

With Rational Application Developer installed you will find the needed file at
<RAD_INSTALLATION_FOLDER\plugins\com.ibm.ws.ast.st.utc_*
where the star indicates the version of UTC. There you will then find the IBMUTC.ear file which you then can install on your instance of WebSphere Application Server (or Tomcat or whatever application server).

Application will then be available at http://yourhost:yourport/UTC/

Carpe diem

Anything but the other

That’s what friends are for…got a gift, got a gift – a carpe diem-candlestick. Could it be as a follow up of one of my previous gifts, the penis atlas?

I’m so confident in my own sexuality that I have no problems showing this to the world 🙂

Access denied for user ‘USERNAME’@’LOCALHOST’ (using password: YES)

Work/Geek

I have struggled with an issue on our test server running our Jira test instance. Problem was that I could not get it to connect to the database. Jira 5.0 has a script, config.sh, in the bin-folder which pops up an application allowing you to apply settings and then verify them, one of the settings being the information needed to connect to the database. So, I created the database for Jira, added the user and granted the needed access. No problem connecting using command line

mysql -u USERNAME -p DATABASENAME


but when trying “Test connection” using the Jira configuration tool it reported

Access denied for user 'USERNAME'@'LOCALHOST' (using password: YES)


Could not figure out why, until I connected as root and issued the following SQL-statement

SELECT user, password,host F R O M  mysql.user;

Note: I have some restrictions for my blog, so you need to edit F R O M

It showed that the encrypted password was not similar for my user for the two hosts which was defined, localhost and 127.0.0.1. I had recently updated for localhost and by the above error I thought that was sufficient, but now I also issued

SET PASSWORD FOR 'USERNAME'@'127.0.0.1' EQUALSIGN OLD_PASSWORD('PASSWORD');
SET PASSWORD FOR 'USERNAME'@'127.0.0.1' EQUALSIGN OLD_PASSWORD('PASSWORD');

Note: I have some restrictions for my blog, so you need to edit EQUALSIGN

ensuring equal passwords for both hosts, and voila, problem solved.