[Solved]Genealogical program Finfamily & Postgresql-How-To

Questions about Grub, UEFI,the liveCD and the installer
Forum rules
Before you post please read how to get help
Post Reply
User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

[Solved]Genealogical program Finfamily & Postgresql-How-To

Post by OH6IH »

Hi!

I want to install Postgresql-database and use it with genealogical program Finfamily: https://sourceforge.net/projects/finfam ... rce=navbar

Instruction for Windows: http://sourceforge.net/projects/finfami ... f/download

How is it done on Linux Mint 17.3 'Rosa' MATE?

Alf :roll:

I use H2-database instead
Last edited by OH6IH on Thu Jan 07, 2016 6:17 pm, edited 2 times in total.

User avatar
karlchen
Level 20
Level 20
Posts: 12286
Joined: Sat Dec 31, 2011 7:21 am
Location: Germany

Re: Genealogical program Finfamily & Postgresql - How-To

Post by karlchen »

Hello, OH6IH.

In case it does not have to be a genuine Windows application like FinFamily, then this Askubuntu thread might point you into the right direction: How can I manage my genealogy data on Ubuntu?

In case it has to be FinFamily and FinFmaily only, hm, I will pass the question on to someone else ...
Yet, afterall FinFamily is Java application that uses a PostgreSQL database, both of which is not Windows specific.
So chances might not be too bad that someone will come up with a translation of the Windows installation instruction into a Linux Mint installation instruction.

Regards,
Karl
Image
Linux Mint 19.2 64-bit Cinnamon, Total Commander 9.22a 64-bit
Haß gleicht einer Krankheit, dem Miserere, wo man vorne herausgibt, was eigentlich hinten wegsollte. (Goethe)

User avatar
karlchen
Level 20
Level 20
Posts: 12286
Joined: Sat Dec 31, 2011 7:21 am
Location: Germany

Re: Genealogical program Finfamily & Postgresql - How-To

Post by karlchen »

Hello, OH6IH.

Having read the FinFamily - Windows Installation Instruction and inspected the most recent FinFamily Software Download Package, it seems pretty obvious that the only Windows specific thing about FinFamily is the FinFamily - Windows Installation Instruction. :)
The FinFamily Software Download Package even brings along a Linux start script named suku.sh.

But one thing at a time.

The FinFamily - Windows Installation Instruction is subdivided into 4 main parts:
(1) installing Java
(2) installing PostGreSQL
(3) installing FinFamily software
(4) using FinFamily and creating the FinFamily database
  1. Installing Java
    Launch Software Center or Synaptic Package Manager. Search for openjdk. Very likely openjdk has come pre-installed with your Linux Mint. If this is true, you can tick off this step as accomplished. Else select openjdk for installation and install it.
  2. Installing PostGreSQL
    Launch Software Center or Synaptic Package Manager. Search for postgresql. Select postgresql for installation and install it.
  3. Installing FinFamily software
    Download FinFamily Software Download Package and save the ZIP-file to your disk. Use Archive Manager to extract its content (preserving the folder structure) to a target folder of your choice.
    Navigate to the folder that holds the file suku.sh. Make sudku.sh executable. Command "chmod +x suku.sh" (or do so using your file-manager.)
  4. Using FinFamily and creating the FinFamily database
    Launch FinFamily by executing suku.sh. - If you are lucky it will simply launch the FinFamily software as intended.
    Follow the instructions on how to use FinFamily. This part should not be Windows specific.
Hope it is will really be as trivial as this.
In case you experience any problem nonetheless, please, explain in detail
+ which step causes problems
+ what you did exactly
+ which error message you got back precisely.

HTH,
Karl
Image
Linux Mint 19.2 64-bit Cinnamon, Total Commander 9.22a 64-bit
Haß gleicht einer Krankheit, dem Miserere, wo man vorne herausgibt, was eigentlich hinten wegsollte. (Goethe)

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

Re: Genealogical program Finfamily & Postgresql - How-To

Post by OH6IH »

Hi Karl and thank for the advice!

I had difficulties with Finfamily on Windows, but I have solved the problems there now.

So I may go on with installation on Linux side!

:D Ald

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

Re: Genealogical program Finfamily & Postgresql - How-To

Post by OH6IH »

Hi !

Now I have problems with Finfamily.zip-file!

Following errormessage:
7-Zip 9.20 Copyright (c) 1999-2010 Igor Pavlov 2010-11-18
p7zip Version 9.20 (locale=C,Utf16=off,HugeFiles=on,2 CPUs)

Error: /home/alf/Skrivbord/Finfamily/finfamily1243.zip: Can not open file as archive

Errors: 1

Is there other unzipprograms that I could try?

Alf

User avatar
karlchen
Level 20
Level 20
Posts: 12286
Joined: Sat Dec 31, 2011 7:21 am
Location: Germany

Re: Genealogical program Finfamily & Postgresql - How-To

Post by karlchen »

Hello, OH6IH.

actually Archie Manager should be able to handle the ZIP file out of the box. It does do so here on Mint 13 at least.
This is the result of the "Integrity check" that I ran on finfamily1243.zip using Archive Manager v3.4.1. (Help - About)

Code: Select all

7-Zip 9.20  Copyright (c) 1999-2010 Igor Pavlov  2010-11-18
p7zip Version 9.20 (locale=de_DE.UTF-8,Utf16=on,HugeFiles=on,4 CPUs)

Processing archive: /home/karl/Downloads/finfamily1243.zip

Testing     SukuMac
Testing     lib
Testing     lib/commons-logging-1.2.jar
Testing     lib/jcalendarbutton-1.4.5.jar
Testing     lib/jcommon-1.0.21.jar
Testing     lib/jfreechart-1.0.17.jar
Testing     lib/jxl.jar
Testing     lib/jxmapviewer2-2.1.jar
Testing     lib/postgresql-9.0-801.jdbc4.jar
Testing     lib/swingx-all-1.6.5-1.jar
Testing     properties
Testing     properties/logging.properties
Testing     resources
Testing     resources/excel
Testing     resources/excel/FinFamily.xls
Testing     resources/excel/PlaceLocations.xls
Testing     resources/excel/Taivut_fi.xls
Testing     resources/xml
Testing     resources/xml/docx.xsl
Testing     resources/xml/export.xsl
Testing     resources/xml/finfamily.css.xsl
Testing     resources/xml/full2003.xsl
Testing     resources/xml/html.xsl
Testing     resources/xml/main2003.xsl
Testing     resources/xml/styles2003.xsl
Testing     suku.jar
Testing     suku.sh

Everything is Ok

Folders: 5
Files: 22
Size:       6675045
Compressed: 5644891
It would be possible to use the terminal command unzip in order to unzip a ZIP-archive. - First step would be to open a terminal window. Next execute the following commands in the given order.

Code: Select all

cd /home/alf
# create the folder where we will unzip finfamily1243.zip to
mkdir finfamily
# enter the folder where we will unzip finfamily1243.zip to
cd finfamily
# unzip finfamily1243.zip here
unzip /home/alf/Skrivbord/Finfamily/finfamily1243.zip
HTH,
Karl
Image
Linux Mint 19.2 64-bit Cinnamon, Total Commander 9.22a 64-bit
Haß gleicht einer Krankheit, dem Miserere, wo man vorne herausgibt, was eigentlich hinten wegsollte. (Goethe)

Cosmo.
Level 23
Level 23
Posts: 17825
Joined: Sat Dec 06, 2014 7:34 am

Re: Genealogical program Finfamily & Postgresql - How-To

Post by Cosmo. »

Take a look at gramps. I cannot judge, which of both is better.

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

Re: Genealogical program Finfamily & Postgresql - How-To

Post by OH6IH »

Following happens:

Code: Select all

alf@alf-AMILO-Li-2735 ~/finfamily $ unzip /home/alf/Skrivbord/Finfamily/finfamily1243.zip
Archive:  /home/alf/Skrivbord/Finfamily/finfamily1243.zip
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
unzip:  cannot find zipfile directory in one of /home/alf/Skrivbord/Finfamily/finfamily1243.zip or
        /home/alf/Skrivbord/Finfamily/finfamily1243.zip.zip, and cannot find /home/alf/Skrivbord/Finfamily/finfamily1243.zip.ZIP, period.

User avatar
karlchen
Level 20
Level 20
Posts: 12286
Joined: Sat Dec 31, 2011 7:21 am
Location: Germany

Re: Genealogical program Finfamily & Postgresql - How-To

Post by karlchen »

Hi, Alf.

Might be that the finfamily1243.zip file which you downloaded is really corrupt, mabye just a single byte was borked by a transmission error?!
Reason for assuming so: Here everything works as expected (testing the zip-file finds no error. Unzipping the zip-file works without errors, too):

Code: Select all

karl@unimatrix0 ~/Downloads $ ls -l finfamily1243.zip 
-rw-r--r-- 1 karl karl 5644891 Jan  1 17:19 finfamily1243.zip
karl@unimatrix0 ~/Downloads $ cd ..
karl@unimatrix0 ~ $ mkdir finfamily
karl@unimatrix0 ~ $ cd finfamily/
karl@unimatrix0 ~/finfamily $ unzip -t /home/karl/Downloads/finfamily1243.zip 
Archive:  /home/karl/Downloads/finfamily1243.zip
    testing: SukuMac                  OK
    testing: lib/                     OK
    testing: lib/commons-logging-1.2.jar   OK
    testing: lib/jcalendarbutton-1.4.5.jar   OK
    testing: lib/jcommon-1.0.21.jar   OK
    testing: lib/jfreechart-1.0.17.jar   OK
    testing: lib/jxl.jar              OK
    testing: lib/jxmapviewer2-2.1.jar   OK
    testing: lib/postgresql-9.0-801.jdbc4.jar   OK
    testing: lib/swingx-all-1.6.5-1.jar   OK
    testing: properties/              OK
    testing: properties/logging.properties   OK
    testing: resources/               OK
    testing: resources/excel/         OK
    testing: resources/excel/FinFamily.xls   OK
    testing: resources/excel/PlaceLocations.xls   OK
    testing: resources/excel/Taivut_fi.xls   OK
    testing: resources/xml/           OK
    testing: resources/xml/docx.xsl   OK
    testing: resources/xml/export.xsl   OK
    testing: resources/xml/finfamily.css.xsl   OK
    testing: resources/xml/full2003.xsl   OK
    testing: resources/xml/html.xsl   OK
    testing: resources/xml/main2003.xsl   OK
    testing: resources/xml/styles2003.xsl   OK
    testing: suku.jar                 OK
    testing: suku.sh                  OK
No errors detected in compressed data of /home/karl/Downloads/finfamily1243.zip.
karl@unimatrix0 ~/finfamily $ unzip /home/karl/Downloads/finfamily1243.zip 
Archive:  /home/karl/Downloads/finfamily1243.zip
  inflating: SukuMac                 
   creating: lib/
  inflating: lib/commons-logging-1.2.jar  
  inflating: lib/jcalendarbutton-1.4.5.jar  
  inflating: lib/jcommon-1.0.21.jar  
  inflating: lib/jfreechart-1.0.17.jar  
  inflating: lib/jxl.jar             
  inflating: lib/jxmapviewer2-2.1.jar  
  inflating: lib/postgresql-9.0-801.jdbc4.jar  
  inflating: lib/swingx-all-1.6.5-1.jar  
   creating: properties/
  inflating: properties/logging.properties  
   creating: resources/
   creating: resources/excel/
  inflating: resources/excel/FinFamily.xls  
  inflating: resources/excel/PlaceLocations.xls  
  inflating: resources/excel/Taivut_fi.xls  
   creating: resources/xml/
  inflating: resources/xml/docx.xsl  
  inflating: resources/xml/export.xsl  
  inflating: resources/xml/finfamily.css.xsl  
  inflating: resources/xml/full2003.xsl  
  inflating: resources/xml/html.xsl  
  inflating: resources/xml/main2003.xsl  
  inflating: resources/xml/styles2003.xsl  
  inflating: suku.jar                
  inflating: suku.sh                 
karl@unimatrix0 ~/finfamily $ 
Cannot launch FinFamily (suku.sh) now, because I had not bothered to install PostgreSQL on my system.

I suggest to try again using a freshly downloaded finfamily1243.zip archive file: finfamily1243.zip

Cheers,
Karl
Image
Linux Mint 19.2 64-bit Cinnamon, Total Commander 9.22a 64-bit
Haß gleicht einer Krankheit, dem Miserere, wo man vorne herausgibt, was eigentlich hinten wegsollte. (Goethe)

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

Re: Genealogical program Finfamily & Postgresql - How-To

Post by OH6IH »

Hi Karl and thanks!

It looks like downloads all fails for me. I have discussed with the makers, but no solution yet.

Runs well on Windows 10 Pro.

I'll have to wait for a solution.

Alf :twisted:

User avatar
karlchen
Level 20
Level 20
Posts: 12286
Joined: Sat Dec 31, 2011 7:21 am
Location: Germany

Re: Genealogical program Finfamily & Postgresql - How-To

Post by karlchen »

Hello, Alf.
OH6IH wrote:It looks like downloads all fails for me. I have discussed with the makers, but no solution yet.
Hm. I doubt that there is much that the FinFamily developers can do.
If their downloadable ZIP-file works for me (and I suspect for most people that download it) then chances are that something works out wrong on your side.

I could imagine that a faulty RAM bar could cause such weird problems. Therefore it might be worth a try to reboot, select memtest from the Grub boot menu and let memtest check your main memory.

Karl
Image
Linux Mint 19.2 64-bit Cinnamon, Total Commander 9.22a 64-bit
Haß gleicht einer Krankheit, dem Miserere, wo man vorne herausgibt, was eigentlich hinten wegsollte. (Goethe)

User avatar
phd21
Level 19
Level 19
Posts: 9559
Joined: Thu Jan 09, 2014 9:42 pm
Location: Florida

Re: Genealogical program Finfamily & Postgresql - How-To

Post by phd21 »

Hi "OH6IH",

I just read your post and the good replies to it. Here are my thoughts on this as well.

I second (+1) the use of "Gramps" for a genealogical program.

Research, organize and share your family tree with Gramps.
https://gramps-project.org/
Features of "Gramps"
https://gramps-project.org/features/

Other genealogy software
https://gramps-project.org/wiki/index.p ... y_software

You could also install VirtualBox, and a version of Ms Windows into that, and run "FinFamily" in that. Since "FinFamily" is Java based it should work on Linux as well, do you have Java installed?

Research Your Family Tree Online
http://www.makeuseof.com/tag/research-y ... ee-online/


Of course nothing is going to work well if you do have a computer memory problem.

Hope this helps ...
Phd21: Mint 19.2 Cinnamon & xKDE (Xfce) & KDE Neon 64-bit Awesome OS's, Ancient Dell OptiPlex 780 Core2Duo E8400 3GHz,4gb Ram, 256gb SDD, only Intel 4 Graphics. Why I use KDE?:https://opensource.com/life/15/4/9-reasons-to-use-kde

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

Re: Genealogical program Finfamily & Postgresql - How-To

Post by OH6IH »

Good morning!

Now I try with two other computer.

First download attempt succeeded on both!

Have installed openjdk, PostgreSQL and pgAdmin III.

With pgAdmin III I can see that the database program PostgreSQL is NOT running! What can I do to start the database?

Then I have to give the admin pwd for the database and start using Finfamily.

Alf :?

MichaelJohn
Level 4
Level 4
Posts: 257
Joined: Fri Dec 12, 2014 6:46 am
Location: UK

Re: Genealogical program Finfamily & Postgresql - How-To

Post by MichaelJohn »

I have run various databases, although never PostgreSQL under Unix/Linux for over quarter of a century. The only time I have had any major issue in getting one running was when I did a download and install on a Mint 13 64-bit system. In the end I removed it all and installed it via the Package Manager. Everything then worked as expected. I would suggest removing your installation and installing PostgreSQL via the Package Manager before doing anything else...

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

Re: Genealogical program Finfamily & Postgresql - How-To

Post by OH6IH »

Hi !

I made the installation with Package Manager, but I'll will uninstall and install again.

How is the PostgreSQL admin password set?

I use both 32 and 64 bit computers.

:)

User avatar
phd21
Level 19
Level 19
Posts: 9559
Joined: Thu Jan 09, 2014 9:42 pm
Location: Florida

Re: Genealogical program Finfamily & Postgresql - How-To

Post by phd21 »

Hi "OH6IH",

Perhaps these links will help...

First steps
https://wiki.postgresql.org/wiki/First_steps


PostgreSQL
https://help.ubuntu.com/community/PostgreSQL

there is no default password. on most unix and linux distributions, the
default authentication mode is set to 'ident' which means a given unix
user X can only connect as the postgres user X. initially, the only
postgres user is 'postgres'

http://www.postgresql.org/message-id/4D ... granch.com

linux PostgreSQL how to set admin pass
https://www.google.com/search?q=Postgre ... ++++++++++

linux starting PostgreSQL
https://www.google.com/search?q=Postgre ... PostgreSQL

starting postgresql ubuntu
https://www.google.com/search?q=Postgre ... sql+ubuntu


Hope this helps ...
Phd21: Mint 19.2 Cinnamon & xKDE (Xfce) & KDE Neon 64-bit Awesome OS's, Ancient Dell OptiPlex 780 Core2Duo E8400 3GHz,4gb Ram, 256gb SDD, only Intel 4 Graphics. Why I use KDE?:https://opensource.com/life/15/4/9-reasons-to-use-kde

User avatar
OH6IH
Level 1
Level 1
Posts: 26
Joined: Mon Nov 17, 2014 4:02 pm

[Solved] Genealogical program Finfamily & Postgresql - How-T

Post by OH6IH »

This issue is solved with help of a H2-database.

I'll leave the PostgreSQL for the moment.

Thank you!

Post Reply

Return to “Installation & Boot”