Pgadmin4 install fail

rkbanwct · Dec 15, 2023

I've searched for hours and can't get this to install. Keeps failing for psutil, I can install that successfully on it's own but when installing pgadmin4 it fails. How to fix? I can't find any gui database manager for postgres on Freebsd, any suggestions? couldn't get phppgadmin, dbvisualizer or dbeaver to work either. Everything is such a struggle on Freebsd.

Code:

ERROR: Failed building wheel for psutil
  Building wheel for psycopg2-binary (pyproject.toml) ... done
  Created wheel for psycopg2-binary: filename=psycopg2_binary-2.9.9-cp311-cp311-freebsd_14_0_release_p2_amd64.whl size=157148 sha
256=1b0a892bab547e8351306fe7716e4e22df5364813d850f505cfd4e7717f126f2
  Stored in directory: /home/rich/.cache/pip/wheels/44/1f/9b/8c08e243b7eda3a912c15eda01f73644cc2d19e2518748111c
  Building wheel for SQLAlchemy (pyproject.toml) ... done
  Created wheel for SQLAlchemy: filename=SQLAlchemy-1.4.50-cp311-cp311-freebsd_14_0_release_p2_amd64.whl size=1570569 sha256=5ae8
6b7b6136be2fb24f6a9f87977c9c60b8d15e5016b5c50263b1c75bedb9fb
  Stored in directory: /home/rich/.cache/pip/wheels/f0/a1/e1/2e134604818970f21b5fb60e5267b9a8fbc625683a6c60ec85
  Building wheel for Flask-Principal (pyproject.toml) ... done
  Created wheel for Flask-Principal: filename=Flask_Principal-0.4.0-py3-none-any.whl size=5576 sha256=2e3893eef47185f307a34a54f00
b9e72aadba2bdcfa96c00038f56e1fe629cbe
  Stored in directory: /home/rich/.cache/pip/wheels/44/91/ea/10050792b0dd351d8b5a7cd7eeb7421fcfeded69e115ba4a35
  Building wheel for greenlet (pyproject.toml) ... done
  Created wheel for greenlet: filename=greenlet-3.0.2-cp311-cp311-freebsd_14_0_release_p2_amd64.whl size=227924 sha256=59480bc92e
fbd94253e2cb69915445bb9474208ce4338c618e20b6f185a85b4d
  Stored in directory: /home/rich/.cache/pip/wheels/c0/fb/c7/db16187b45438507f75ca5322ff921be2c1b4b81e286bffa32
  Building wheel for markupsafe (pyproject.toml) ... done
  Created wheel for markupsafe: filename=MarkupSafe-2.1.3-cp311-cp311-freebsd_14_0_release_p2_amd64.whl size=15472 sha256=595783c
4629baf763eed70a6a8f85028c0d9e490e38760b9cac765642c4d3754
  Stored in directory: /home/rich/.cache/pip/wheels/2f/66/0d/84667253c0ad7d80a0190753fb87ccd5b12e3e1052d49504eb
  Building wheel for brotli (pyproject.toml) ... done
  Created wheel for brotli: filename=Brotli-1.1.0-cp311-cp311-freebsd_14_0_release_p2_amd64.whl size=399138 sha256=a907084554f18c
2af9effe9cc775727df9978832aeacfb4750ef003f73719736
  Stored in directory: /home/rich/.cache/pip/wheels/4a/27/5f/04b0f447c163442f4a94e217db837f74e3ba76464afb3b77a8
  Building wheel for pynacl (pyproject.toml) ... done
  Created wheel for pynacl: filename=PyNaCl-1.5.0-cp311-cp311-freebsd_14_0_release_p2_amd64.whl size=290486 sha256=1ce6791a8192f8
385b6dfd402803465f854d1fb989974df3f23046b7d2b12a02
  Stored in directory: /home/rich/.cache/pip/wheels/d5/c0/0e/33fb7c64c01b11b37aa150f2972a405d99b8893a805966b817
Successfully built bcrypt cryptography Flask-Mail httpagentparser Pillow psycopg2-binary SQLAlchemy Flask-Principal greenlet mark
upsafe brotli pynacl
Failed to build psutil
ERROR: Could not build wheels for psutil, which is required to install pyproject.toml-based projects

elgrande · Dec 15, 2023

What about DBeaver plugin?
Unfortunately there is no port for the standalone version, but they also offer an Eclipse plugin.
So you may wanna test java/eclipse with the plugin from https://dbeaver.io/download/

rkbanwct · Dec 15, 2023

I couldn't get the install working from the webiste. It had an "install" button with tootip that said drag it to your eclipse workspace but of course it did nothing. I installed java/eclipse but there is no Marketplace in the help menu, of course. Now I have to figure out how to get that working, or did you mean something else?

elgrande · Dec 15, 2023

rkbanwct said:
I couldn't get the install working from the webiste. It had an "install" button with tootip that said drag it to your eclipse workspace but of course it did nothing. I installed java/eclipse but there is no Marketplace in the help menu, of course. Now I have to figure out how to get that working, or did you mean something else?

In Eclipse you have to add the „Eclipse Update URL“ via copy paste from the page I have linked. Paste it somewhere below „Install new Software“.
Not at the PC at the moment, but I can check out later.

Phishfry · Dec 15, 2023

rkbanwct said:
I can't find any gui database manager for postgres on Freebsd, any suggestions?

pgadmin3 is in ports

rkbanwct · Dec 15, 2023

Phishfry said:
pgadmin3 is in ports

yes but unfortunately it's not supported anymore and doesn't work. It flashes a picture of an elephant then crashes when I launch it.

rkbanwct · Dec 15, 2023

elgrande said:
In Eclipse you have to add the „Eclipse Update URL“ via copy paste from the page I have linked. Paste it somewhere below „Install new Software“.
Not at the PC at the moment, but I can check out later.

Eclipse said "Could not find https://dbeaver.io/download/ No repository found at https://dbeaver.io/download/." when I tried to Add but I can get to that in the browser.

Phishfry · Dec 15, 2023

rkbanwct said:
It flashes a picture of an elephant then crashes when I launch it.

That is splash screen then the program comes up. No problems for me. Xfce4/13.2-RELEASE/Quarterly

Log at;
/tmp/pgadmin3.log

Phishfry · Dec 16, 2023

Here is what you need to setup logging.

Uncomment this line:
/usr/local/share/pgadmin3/settings.ini

Code:

;LogFile=/tmp/pgadmin3.log

elgrande · Dec 16, 2023

rkbanwct said:
Eclipse said "Could not find https://dbeaver.io/download/ No repository found at https://dbeaver.io/download/." when I tried to Add but I can get to that in the browser.

The download page says:

https://dbeaver.io/update/latest/

rkbanwct · Dec 16, 2023

That got a little further but then this error:

Code:

Cannot complete the install because one or more required items could not be found.
  Software being installed: DBeaver Git support 1.0.108.202312122044 (org.jkiss.dbeaver.git.feature.feature.group 1.0.108.202312122044)
  Missing requirement: DBeaver Desktop Application Core 23.3.0.202312122044 (org.jkiss.dbeaver.core 23.3.0.202312122044) requires 'osgi.bundle; org.osgi.service.event 0.0.0' but it could not be found
  Cannot satisfy dependency:
    From: DBeaver Git support 1.0.108.202312122044 (org.jkiss.dbeaver.git.feature.feature.group 1.0.108.202312122044)
    To: org.eclipse.equinox.p2.iu; org.jkiss.dbeaver.ui.feature.feature.group 7.0.0
  Cannot satisfy dependency:
    From: DBeaver Desktop UI 23.3.0.202312122044 (org.jkiss.dbeaver.ui.feature.feature.group 23.3.0.202312122044)
    To: org.eclipse.equinox.p2.iu; org.jkiss.dbeaver.core [23.3.0.202312122044,23.3.0.202312122044]

elgrande · Dec 16, 2023

It took some time to figure out, but finally I managed to install DBeaver on FreeBSD 14.0-RELEASE:

The process was very "hacky", I will streamline it and write simpler instructions maybe later.

What I did:
- I compiled DBeaver from source (latest release from https://github.com/dbeaver/dbeaver/releases ) by running mvn package -Pall-platforms
- I copied the following to /usr/local/share/eclipse/dropins
* dbeaver-23.3.0/product/community/target/products/org.jkiss.dbeaver.core.product/linux/gtk/x86_64/dbeaver/features/org.jkiss.dbeaver.*
* dbeaver-23.3.0/product/community/target/products/org.jkiss.dbeaver.core.product/linux/gtk/x86_64/dbeaver/plugins/org.jkiss.*
* dbeaver-23.3.0/product/community/target/products/org.jkiss.dbeaver.core.product/linux/gtk/x86_64/dbeaver/plugins/org.osgi.service.event_1.4.1.202109301733.jar
- I restarted Eclipse
- DBeaver still was not available, but finally I could install DBeaver via "Eclipse -> Help -> Install new Software" as outlined before.

NOTE: I am very well aware, that probably most of the steps may not be required. I just outline how I made it install.

EDIT: I used the java version recommended by DBeaver: java/openjdk17 by issueing setenv JAVA_HOME /usr/local/openjdk17/

rkbanwct · Dec 17, 2023

In /tmp/pgadmin3.log there's this but I don't know what to do about it:

Code:

ERROR  : 00:55:52: Error: ERROR:  column "datlastsysoid" does not exist
LINE 4: ...T oid, pg_encoding_to_char(encoding) AS encoding, datlastsys...
                                                             ^
ERROR  : 00:55:57: Error: Column not found in pgSet: "datlastsysoid"
ERROR  : 00:55:58: Error: Column not found in pgSet: datlastsysoid
ERROR  : 00:56:07: Error: Column not found in pgSet: oid
ERROR  : 00:56:25: Error: Column not found in pgSet: encoding

rkbanwct · Dec 17, 2023

I followed the steps above for Eclipse plugin but still got "Could not find https://dbeaver.io/download/" when trying to Add the repository. I took the file Source code (tar.gz) at the bottom of the list. It compiled ok and I copied the directories but still get error.

elgrande · Dec 17, 2023

rkbanwct: FYI: I created a tutorial for installing DBeaver on FreeBSD:

How to install DBeaver in FreeBSD

The following tutorial shows how to install DBeaver (https://dbeaver.io/). The installation is performed as Eclipse plugin since there is no working standalone version for FreeBSD. 1. As root: Install java/eclipse, devel/maven and java/openjdk17. 2. As user: Download lates DBeaver sourcecode...

forums.freebsd.org

Ole · Jan 6, 2024

This recipe has worked for me for several years now. Recently updated to the latest 8.1 version. This script works in CBSD CI/CD infrastructure (periodic builds + tests) and the artifacrts is published (updated) as an jail image. Since CBSDfile is a regular shell script, you can use this without cbsd ( while cbsd users can get a ready-made image )

pbgc · Jan 30, 2024

rkbanwct said:
I followed the steps above for Eclipse plugin but still got "Could not find https://dbeaver.io/download/" when trying to Add the repository. I took the file Source code (tar.gz) at the bottom of the list. It compiled ok and I copied the directories but still get error.

rkbanwct You are using the wrong url. The correct is: https://dbeaver.io/update/latest/
Unfortunately it also does not work. You must follow the tutorial above from elgrande

PMc · Feb 1, 2024

pgadmin3 was utterly outdated years ago already.

pgadmin4 works here. It was a bit of a hassle getting there, but it can be done.

Occasioanlly there are some prereqs not working properly. Then one must search for a version that does work. But in the case that this "psutil" does install on it's own, I would rather assume there is something wrong in the environment (mixup between pkg installations and pip installations?) Anyway there is no problem with installing the prereqs individually.

Pgadmin4 install fail

Attachments