[Gambas-bugtracker] Bug #3052: cannot use postgres GUI connections

[<bugtracker@xxxxxxxxxxxxxx>]

http://gambaswiki.org/bugtracker/edit?object=BUG.3052&from=L21haW4-

Alexandre SIX reported a new bug.

Summary
-------

cannot use postgres GUI connections

Type             : Bug
Priority         : Low
Gambas version   : 3.20
Product          : PostgreSQL driver


Description
-----------

Hello,

I cannot use PostgreSQL GUI connections in my code, although I am able to browse and edit tables and data in the GUI connection tool.

For example, the code:

   Connections["Connection1"].Open()

returns the error: fe_sendauth: no password supplied.

The same happens if I drag and drop a configured datasource + dataview (gb.db2.form).

I have no idea where to set the PostgreSQL password, other than in $project/.connection/connection_name.connection.

Thanks

info :
Gambas version 3.20.4
Debian Trixie


System information
------------------

[System]
Gambas=3.20.4 ab0099ae5 (HEAD)
OperatingSystem=Linux
Distribution=Debian GNU/Linux 13 (trixie)
Kernel=6.14.7-1-liquorix-amd64
Architecture=x86_64
Cores=16
Memory=32010M
Language=fr_FR.UTF-8
Platform=wayland
Desktop=KDE
DesktopResolution=96
DesktopScale=7
WidgetTheme=breeze
Font=Noto Sans,10
DarkTheme=True
[Programs]
dpkg=Programme « dpkg » de gestion de paquets Debian version 1.22.18 (amd64).
gcc=gcc (Debian 14.2.0-19) 14.2.0
git=git version 2.47.2
msgmerge=msgmerge (GNU gettext-tools) 0.23.1
[Libraries]
Cairo=libcairo.so.2.11804.4
Curl=libcurl.so.4.8.0
DBus=libdbus-1.so.3.38.3
GDK2=libgdk-x11-2.0.so.0.2400.33
GDK3=libgdk-3.so.0.2417.32
GStreamer=libgstreamer-1.0.so.0.2601.0
GTK+2=libgtk-x11-2.0.so.0.2400.33
GTK+3=libgtk-3.so.0.2417.32
OpenGL=libGL.so.1.7.0
Poppler=libpoppler.so.147.0.0
QT5=libQt5Core.so.5.15.15
QT6=libQt6Core.so.6.8.2
RSvg=librsvg-2.so.2.60.0
SDL=libSDL2-2.0.so.0.3200.4
SQLite3=libsqlite3.so.0.8.6
[Environment]
DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
DESKTOP_SESSION=plasma
DISPLAY=:1
GB_GUI=gb.qt6
GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
GTK2_RC_FILES=/etc/gtk-2.0/gtkrc:<home>/.gtkrc-2.0:<home>/.config/gtkrc-2.0
GTK_RC_FILES=/etc/gtk/gtkrc:<home>/.gtkrc:<home>/.config/gtkrc
HOME=<home>
ICEAUTHORITY=/run/user/1000/iceauth_bUEpev
INVOCATION_ID=23fcccd72a1d4cd190453016335ff52b
JOURNAL_STREAM=9:19001
KDE_APPLICATIONS_AS_SCOPE=1
KDE_FULL_SESSION=true
KDE_SESSION_UID=1000
KDE_SESSION_VERSION=6
LANG=fr_FR.UTF-8
LANGUAGE=fr_FR.UTF-8
LOGNAME=<user>
MANAGERPID=1004
OLDPWD=<home>
PAM_KWALLET5_LOGIN=/run/user/1000/kwallet5.socket
PATH=<home>/.cargo/bin:/usr/local/bin:/usr/bin:/bin:/usr/games
PWD=<home>
QT_ACCESSIBILITY=1
QT_AUTO_SCREEN_SCALE_FACTOR=0
QT_LOGGING_RULES=*.debug=false
QT_WAYLAND_RECONNECT=1
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1281,unix/<hostname>:/tmp/.ICE-unix/1281
SHELL=/usr/bin/zsh
SSH_AUTH_SOCK=/run/user/1000/openssh_agent
SYSTEMD_EXEC_PID=1349
TZ=:/etc/localtime
USER=<user>
WAYLAND_DISPLAY=wayland-0
XAUTHORITY=/run/user/1000/xauth_FewKlX
XDG_CONFIG_DIRS=<home>/.config/kdedefaults:/etc/xdg:/usr/share/desktop-base/kf5-settings
XDG_CURRENT_DESKTOP=KDE
XDG_MENU_PREFIX=plasma-
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
XDG_SESSION_CLASS=user
XDG_SESSION_DESKTOP=KDE
XDG_SESSION_ID=3
XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session1
XDG_SESSION_TYPE=wayland
XDG_VTNR=1
XKB_DEFAULT_LAYOUT=fr
XKB_DEFAULT_MODEL=pc105
XKB_DEFAULT_VARIANT=latin9
force_s3tc_enable=true


----[ Gambas bugtracker-list is hosted by https://www.hostsharing.net ]----