torsdag den 13. november 2014

Connect to postgresql 9.2 server in openSUSE 13.2

I tried to connect to my postgresql server after upgrading to openSUSE 13.2 from 13.1 using the guide from opensuse.org
That resulted in this error message:

psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?


There was no files in /var/run/postgresql/. So that explained why it could not connect to that Unix domain socket.
So where was the socket? Reading this answer I found that I could run this command to figure out where the socket was:
~> netstat -nlp | grep 5432
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      12827/postgres     
tcp        0      0 :::5432                 :::*                    LISTEN      12827/postgres     
unix  2      [ ACC ]     STREAM     LISTENING     10994605 12827/postgres      /tmp/.s.PGSQL.543


That indicated that the socket was located at /tmp/ instead of /var/run/postgresql/ I was then able to find an explanation here

With that in mind i tried to connect with /tmp/ as host:
~> psql -h /tmp/
psql (9.3.5, server 9.2.7)
Type "help" for help.


That worked and as you can see the server and the client versions does not match. That could explain why the client was compiled with a different default host. Next thing could be to try to update the server from 9.2 to 9.3.

mandag den 6. januar 2014

Get Notes 9.0.1 to run on openSUSE 13.1

I installed openSUSE 13.1 just a week after its release. Unfortunately IBM Notes 9.0.1 crashed so I had to revert back to 12.3 since I wasn't able to fix the issue on my own.

By now the community have done what they do best and come up with a solution that makes it possible to run Notes 9 on openSUSE 13.1.

The issue was reported on the lotus forum.

In the response from Ben Kevan there was a link to a workaround that could get notes to run on openSUSE.

Apparently there is a bug that might be related to KDE. It has been filed on the KDE Bugtracking System as bug 329445.

Btw I am using the 64 bit version of openSUSE.