Jens Kisters's questions

I am running Ubuntu 18.04. When I want to install the PostgreSQL database server package I get the default version 12.
I have unsuccessfully tried to follow multiple instructions on how to install the desired version 9.6.

# cat /etc/apt/sources.list.d/pgdg.list  
deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main  

# sudo apt-get install postgresql-9.6
Reading package lists... Done      
Building dependency tree    
Reading state information... Done    
The following additional packages will be installed:    
  postgresql-contrib-9.6  
Suggested packages:  
  libdbd-pg-perl  
The following NEW packages will be installed:  
  postgresql-9.6 postgresql-contrib-9.6  
0 upgraded, 2 newly installed, 0 to remove and 3 not upgraded.  
Need to get 0 B/4,827 kB of archives.  
After this operation, 23.9 MB of additional disk space will be used.  
Do you want to continue? [Y/n] y  
Preconfiguring packages ...  
Selecting previously unselected package postgresql-9.6.  
(Reading database ... 70763 files and directories currently installed.)  
Preparing to unpack .../postgresql-9.6_9.6.17-2.pgdg18.04+1_amd64.deb ...  
Unpacking postgresql-9.6 (9.6.17-2.pgdg18.04+1) ...  
Selecting previously unselected package postgresql-contrib-9.6.  
Preparing to unpack .../postgresql-contrib-9.6_9.6.17-2.pgdg18.04+1_amd64.deb ...  
Unpacking postgresql-contrib-9.6 (9.6.17-2.pgdg18.04+1) ...  
Setting up postgresql-9.6 (9.6.17-2.pgdg18.04+1) ...  
Setting up postgresql-contrib-9.6 (9.6.17-2.pgdg18.04+1) ...  
Processing triggers for postgresql-common (213.pgdg18.04+1) ...  
Building PostgreSQL dictionaries from installed myspell/hunspell packages...  
Removing obsolete dictionary files:  

# service postgresql start

# su postgres 
postgres@ubuntu-vm-template:~$ psql
psql (12.2 (Ubuntu 12.2-2.pgdg18.04+1))  
Type "help" for help.  

postgres=# SELECT version();
                                                              version  
-----------------------------------------------------------------------------------------------------------------------------------  
 PostgreSQL 12.2 (Ubuntu 12.2-2.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit  
(1 row)  

root@ubuntu-vm-template:~# dpkg -l|grep -i postgres
ii  libpq-dev                             12.2-2.pgdg18.04+1                              amd64        header files for libpq5 (PostgreSQL library)
ii  libpq5:amd64                          12.2-2.pgdg18.04+1                              amd64        PostgreSQL C client library
ii  pgdg-keyring                          2018.2                                          all          keyring for apt.postgresql.org
ii  postgresql-12                         12.2-2.pgdg18.04+1                              amd64        object-relational SQL database, version 12 server
ii  postgresql-9.6                        9.6.17-2.pgdg18.04+1                            amd64        object-relational SQL database, version 9.6 server
ii  postgresql-client-12                  12.2-2.pgdg18.04+1                              amd64        front-end programs for PostgreSQL 12
ii  postgresql-client-9.6                 9.6.17-2.pgdg18.04+1                            amd64        front-end programs for PostgreSQL 9.6
ii  postgresql-client-common              213.pgdg18.04+1                                 all          manager for multiple PostgreSQL client versions
ii  postgresql-common                     213.pgdg18.04+1                                 all          PostgreSQL database-cluster manager
ii  postgresql-contrib                    12+213.pgdg18.04+1                              all          additional facilities for PostgreSQL (supported version)
ii  postgresql-contrib-9.6                9.6.17-2.pgdg18.04+1                            amd64        additional facilities for PostgreSQL

My Question

The output of apt-get install says "9.6". Why doesn't the output of SELECT version(); do so?

i want to reproduce a mail related problem regarding a mail that is sent from a system i have no control over. For this purpose i want to mimic this problematic email.

I have the exact mail as it was received as a text file (headers + base64 encoded body) How can i send a very similar mail from one of our systems?

I tried

mail -s "Test" [email protected] < mail.txt

But it puts the whole text file into the body.

thanks in advance Jens

I developed a small Java program under windows and am now trying to run it on an ubuntu machine.

run.sh:

/opt/atlassian/jira/jre/bin/java -classpath "commons-lang3-3.3.2.jar;opencsv-3.3.jar;.\TisowareExportConverter.class" info.aptis.plakon.TisowareExportConverter /home/tisoware/transfer/tisoware_presence_export.csv /home/tisoware/convert/$

I compiled the .java file under windows

Directory contents

tisoware@server037:~/convert$ ls -la
insgesamt 472

    drwxr-xr-x 2 root         root           4096 Apr 26 11:51 .
    drwxr-xr-x 7 tisoware     tisoware       4096 Apr 26 11:32 ..
    -rw-r--r-- 1 root         root         412739 Apr 18 15:46 commons-lang3-3.3.2.jar
    -rw-r--r-- 1 root         root            293 Apr 26 11:51 convert.sh
    -rw-r--r-- 1 root         root           1024 Apr 26 11:51 .convert.sh.swp
    -rw-r--r-- 1 root         root            108 Apr 26 10:47 doku.txt
    -rw-r--r-- 1 root         root          31217 Apr 18 15:46 opencsv-3.3.jar
    -rw-rw-r-- 1 root         tisoware          5 Apr 26 11:24 outfile.csv
    -rw-r--r-- 1 aptisSupport aptisSupport    200 Apr 19 14:19 tiso_user_mapping.csv
    -rw-r--r-- 1 root         root           4425 Apr 19 14:21 TisowareExportConverter.class

The java class

package info.aptis.plakon;

public class TisowareExportConverter {

    public static void main (String[] args) { /* stuff is done here */}
}

Problem

All I get is

tisoware@server037:~/convert$ bash convert.sh
Fehler: Hauptklasse info.aptis.plakon.TisowareExportConverter konnte nicht gefunden oder geladen werden

(Translation: Could not find or load main class info.aptis.plakon.TisowareExportConverter)

What am I doing wrong?

Under Windows the program runs like this

run.bat

java -classpath libs\commons-lang3-3.3.2.jar;libs\opencsv-3.3.jar;out\production\tisowareExportConverter2 info.aptis.plakon.TisowareExportConverter tiso_infile.csv tiso_outfile.csv tiso_user_mapping.csv

Thank you, Internet <3