Re: Password exec troubleshooting

2025-10-18 Thread Aditya Toshniwal 
Hi Matt,

Can you share the script to simulate the issue? We may also need to improve
password exec command logging.

On Sun, Oct 12, 2025 at 2:35 AM Matt Warren  wrote:

> Hello pgadmin-support
> Long-time user, first time emailing.
>
> I’m trying to use the Password exec feature to fetch a secret from AWS
> Secrets Manager. I’ve created both a python script and then a sh script and
> neither work. Oddly *nothing* about password exec is reported in logs. I
> just get the error below.
>
> pgAdmin 4 v 9.7 as desktop app
> python 3.13.7
> macOS 15.7.1
>
> Things I’ve tried:
>
>
>- Executing either script from the command line works as expected and
>returns just the password string.
>- scripts have chmod +x for all users.
>- I’ve provided the full path to script in the Password exec entry
>- Tried quoting and escaping command line.
>- The shell script uses aws cli and full path is provided in script.
>- Moved the script to the ~/Library/Application Support/pgAdmin 4 in
>case macOS disk access issues were in play.
>
>
> Error:
>
> connection failed: connection to server at “10.x.x.x", port 5432 failed:
> could not initiate GSSAPI security context: Unspecified GSS failure. Minor
> code may provide more information: Cannot find KDC for realm "
> KERBEROS.MICROSOFTONLINE.COM"
> connection to server at “10.x.x.x", port 5432 failed: fe_sendauth: no
> password supplied
>
> From what I can parse of source code, I don’t think the
> ENABLE_SERVER_PASS_EXEC_CMD comes into play as I’m not operating in server
> mode.
>
> Does anyone have examples of a config that works?
> Any advice on how I can debug further?
>
> Thanks for any pointers!
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: pgAdmin4 v9.2 causes unexpected Windows Server reboot during silent installation

2025-10-18 Thread Aditya Toshniwal 
Hi Sumpei

It should be VC redist (14.40) then. pgAdmin requires that.

On Tue, Oct 7, 2025 at 6:06 AM [email protected] <
[email protected]> wrote:

> Hi, Aditya Toshniwal
>
> Thank you for your reply.
>
> We understand that the pgAdmin installer itself does not explicitly
> request a system restart.
> However, we experienced automatic reboots on several Windows Server 2022
> systems immediately after installing pgAdmin 4 v9.2 (pgadmin4-9.2-x64.exe)
> in silent mode.
>
> Event Viewer shows Event ID 1074 (process: winlogon.exe, user: NT
> AUTHORITY\SYSTEM).
>
> We are wondering if, during the installation,
> the installer might trigger the installation or update of dependent
> modules (such as Visual C++ Redistributables or Python runtime),
> which in turn cause Windows to request a system restart.
>
> Could you please confirm whether this behavior is expected
> or if there are any known dependencies that may require a restart on first
> installation?
>
> Thank you,
>
> Shumpei
>
> 差出人: Aditya Toshniwal 
> 送信: 2025 年 10 月 6 日 (月曜日) 18:07
> 宛先: 坂上 峻平 
> Cc: [email protected] <
> [email protected]>
> 件名: Re: pgAdmin4 v9.2 causes unexpected Windows Server reboot during
> silent installation
>
>
>
>
> Hi Shunpei,
>
>
> pgAdmin installer does not require system restart.
>
> On Mon, Oct 6, 2025 at 2:25 PM [email protected] <
> [email protected]> wrote:
>
> Dear pgAdmin Support Team,
>
> We are using Windows Server 2022 and encountered unexpected system reboots
> right after installing pgAdmin4 v9.2 (pgadmin4-9.2-x64.exe) in silent mode.
>
> Event Viewer shows Event ID 1074 (winlogon.exe, user: NT
> AUTHORITY\SYSTEM).
> Could you please confirm if the installer intentionally triggers system
> reboot or if there is a known issue related to this version?
>
> Thank you for your support.
>
> Best regards,
> Shunpei Sakanoue
> ■--■
> 日本システム技術株式会社
> GAKUEN事業部 インフラ室
> 坂上 峻平（さかのうえ しゅんぺい）
> 〒530-0005
> 大阪市北区中之島2-3-18
> 中之島フェスティバルタワー28階
> E-MAIL:[email protected]
> TEL:06-4560-1030
> MOBILE:070-8821-3509
> ■--■
>
>
>
>
>
> --
>
>
>
>
>
>
> Thanks,
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com
> "Don't Complain about Heat, Plant a TREE"
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: Assistance Required: Code Folding and Line Numbers Not Appearing in pgAdmin 4 (v9.8)

2025-10-18 Thread Aditya Toshniwal 
Hi Mas,

Please check - https://github.com/pgadmin-org/pgadmin4/issues/9160


On Thu, Oct 2, 2025 at 1:38 AM 'Mas Kinato' via pgAdmin Security <
[email protected]> wrote:

> Dear pgAdmin Support Team,
>
> I am reaching out regarding an issue we are encountering with code folding
> in pgAdmin 4 (version 9.8).
>
> Issue Summary:
> • Code folding is enabled under Preferences → Query Tool → Editor (the
> “Code folding” option is toggled on).
> • However, fold carets/triangles are not appearing for foldable regions
> (e.g., WITH (…) CTEs or VALUES (…) blocks).
> • We only see the caret when wrapping a block in BEGIN…END;, but that
> makes the query invalid in SQL execution.
> • Additionally, the “Line numbers” option (expected under Preferences →
> Query Tool → Display) is missing entirely in this version of pgAdmin 4,
> which prevents us from exposing the gutter where fold carets normally
> appear.
>
> Steps Taken So Far:
>
>1. Verified that Code folding is enabled.
>2. Tried different themes (Default, Light, Dark) to check if the caret
>was hidden due to UI visibility.
>3. Restarted Query Tool after preferences changes.
>4. Tested simple foldable examples (e.g., WITH test AS (VALUES (1),
>(2), (3)) SELECT * FROM test;) — no fold caret appeared.
>5. Confirmed with multiple users that the Line numbers preference is
>not visible in our pgAdmin 4 v9.8 builds.
>
> Environment:
> • pgAdmin 4 v9.8
> • Affected across multiple installations
> • OS: [insert OS details if you want to include, e.g., Windows 11 / macOS
> Sonoma]
>
> Request:
> Could you please confirm:
>
>1. Whether the Line numbers option has been relocated or removed in
>pgAdmin 4 v9.8?
>2. If this is a known regression/bug affecting code folding in CTEs
>and parentheses blocks.
>3. Recommended steps or patches to restore proper code folding
>(without relying on BEGIN…END;).
>
> We rely on folding for large SQL queries, and currently this limitation
> makes navigation difficult. If this requires escalation, I’d be grateful if
> you could provide guidance or log it as a support issue with the pgAdmin
> development team.
>
> Thank you for your assistance.
>
> Best regards,
> Mas
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: Strange benhavior of pgAdmin 9.8 on Windows

2025-10-18 Thread Aditya Toshniwal 
Hi Marc,

I am able to reproduce the problem. But it is most likely because of the
warning below. I'm checking if we can fix this.

WARNING: Console code page (437) differs from Windows code page (1252)
 8-bit characters might not work correctly. See psql reference
 page "Notes for Windows users" for detail


On Sat, Oct 4, 2025 at 12:22 PM Marc Linster  wrote:

> Team:
>
> I installed pgAdmin 9.8 on Windows 10 to teach a class. the query tool,
> etc. seem to work well, but plsql tool shows a strange message, and
> commands like \d seem to hang
>
> Microsoft Windows [Version 10.0.22000.2538]
> (c) Microsoft Corporation. All rights reserved.
>
> C:\Program Files\PostgreSQL\18\pgAdmin 4\runtime>"C:\Program
> Files\PostgreSQL\18\pg
> Admin 4\runtime\psql.exe" "host=localhost port=5432 dbname=dlh3
> user=postgres sslmo
> de=prefer connect_timeout=10" 2>>&1
> psql (18.0)
> WARNING: Console code page (437) differs from Windows code page (1252)
>  8-bit characters might not work correctly. See psql reference
>  page "Notes for Windows users" for details.
> Type "help" for help.
>
> When I type '\d', only the '\' shows until I hit return, but execution
> only starts after I hit return for the second time.
>
> Standard plsql works fine.
>
> For the purpose of teaching novices pgAdmin/Postgresql 18 it would be nice
> if I could use plsql in the context of pgAdmin - which used to work.
>
> Thanks for thelp, Marc
> ---
> Marc Linster; [email protected];
> https://www.linkedin.com/in/marclinster;
> https://marclinster.medium.com
> +352 621 430 156
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Re: pgAdmin4 v9.2 causes unexpected Windows Server reboot during silent installation

2025-10-18 Thread [email protected] 
Hi Aditya

Thank you very musch for the additional information.
That makes perfect sense.
Plase go ahead and close this inquiry.

Beat Regards,
Shumpei



差出人: Aditya Toshniwal 
送信: 2025 年 10 月 7 日 (火曜日) 14:07
宛先: 坂上　峻平 
Cc: [email protected] 
件名: Re: pgAdmin4 v9.2 causes unexpected Windows Server reboot during silent 
installation

Hi SumpeiIt should be VC redist (14.40) then. pgAdmin requires that.On Tue, Oct 
7, 2025 at 6:06 AM [email protected] 
 wrote:Hi, Aditya ToshniwalThank you for your 
reply.We understand that the pgAdmin installer itself does not explicitly 
request a system restart.  However, we experienced automatic reboots on several 
Windows Server 2022 systems immediately after installing pgAdmin 4 v9.2 
(pgadmin4-9.2-x64.exe) in silent mode.Event Viewer shows Event ID 1074 
(process: winlogon.exe, user: NT AUTHORITY\SYSTEM).  We are wondering if, 
during the installation, the installer might trigger the installation or update 
of dependent modules (such as Visual C++ Redistributables or Python runtime), 
which in turn cause Windows to request a system restart.Could you please 
confirm whether this behavior is expected or if there are any known 
dependencies that may require a restart on first installation?Thank 
you,Shumpei差出人: Aditya Toshniwal 送信: 2025 年 
10 月 6 日 (月曜日) 18:07宛先: 坂上　峻平 Cc: 
[email protected] 件名: 
Re: pgAdmin4 v9.2 causes unexpected Windows Server reboot during silent 
installationHi Shunpei,pgAdmin installer does not require system restart.On 
Mon, Oct 6, 2025 at 2:25 PM [email protected] 
 wrote:Dear pgAdmin Support Team,We are using 
Windows Server 2022 and encountered unexpected system reboots right after 
installing pgAdmin4 v9.2 (pgadmin4-9.2-x64.exe) in silent mode.Event Viewer 
shows Event ID 1074 (winlogon.exe, user: NT AUTHORITY\SYSTEM).  Could you 
please confirm if the installer intentionally triggers system reboot or if 
there is a known issue related to this version?Thank you for your support.Best 
regards,Shunpei Sakanoue■--■　
日本システム技術株式会社　　GAKUEN事業部　インフラ室坂上　峻平（さかのうえ　しゅんぺい）　〒530-0005　　大阪市北区中之島2-3-18　　　
中之島フェスティバルタワー28階　E-MAIL:[email protected]　TEL:06-4560-1030　
MOBILE:070-8821-3509■--■-- 
Thanks,Aditya ToshniwalpgAdmin Hacker | Sr. Staff SDE II | 
enterprisedb.com"Don't Complain about Heat, Plant a TREE"-- Thanks,Aditya 
ToshniwalpgAdmin Hacker | Sr. Staff SDE II | enterprisedb.com"Don't Complain 
about Heat, Plant a TREE"

Re: Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 error/Access denied

2025-10-18 Thread Bastiaan Wakkie 
UPDATE:

After upgrading to 9.9 still the same problem. 

Im getting...
When saving: ... and [! Request failed with status code 500] error popup and  
“Access denied (…)” in the Message pane. 
When opening an already stored file: ... an  [! Request failed with status code 
500] error  popup.

If Im logged in as pgadmin on the server (the user running the app) and I could 
create a file in the storage directory. I even tried to make one file world 
readable (chmod 777) but still I am getting the above errors. I do see any file 
created directly in the storage. 

I also started Firefox 144.0 without extensions to see if this was causing the 
problem. But not as I expected as an 500 error indicates something server side. 
But I am ticking off any possible way to trace why this problem is happening.

Still nowhere I am able to detect any indication in the log files.

The only thing that works is creating a new folder via the storage manager and 
rename files … weirdly enough.

Could it be that I open the query tool always tool in a new tab? I’m have 
trouble finding the setting to disable this btw to test this hypothesis.
I also note that options/storage/last storage is set to None. While the last 
directory changes when I move around.

Ps running pgadmin4 in a venv with python 3.13.7

Thx,
Bastiaan

> On 11 Oct 2025, at 12:10, Bastiaan Wakkie  wrote:
> 
> 
> 
> Hi all,
> 
> 
> Opening and saving files (crtl-o) (in 9.6 and 9.8) results in 500 
> error/Access denied
> 
> The rest of the pgadmin4 application is working like normal..
> 
> I can run any sql queries without problems, just cannot load or save any 
> files!
> 
> 
> What did I do/remember:
> 
> 1) recently updated postgresql to 17.5 on manjaro rolling release.
> 
> 2) I remember that I went to the root of the storage when it started to act 
> weird. Not sure this is connected though
> 
> 3) When I try opening any file stored in the storage, I'm getting ... 
> "Request failed with status code 500" 
> ... error in the application but I cannot find *anywhere* in the logs an 
> indication of what is happening (Also not in my postgresql, supervisor, nginx 
> or journalctl logs).
> 
> 4) I updated pgadmin4 from 9.6 to 9.8 like I always do (pip install -U 
> pgadmin4) to see if this would fix it but the problem persists.
> 
> 5) ...I changed CONSOLE_LOG_LEVEL = 10 in the hope to see more but alas... 
> 
> 6) ...I enabled postgresql log to see something comes up there, but no 
> postgresql seems quietly doing it's thing..
> 
> 7) I checked the ...
> STORAGE_DIR = "/data/databases/pgadmin4/storage"
> ... and all is owned by the pgadmin user.
> 
> 8) Via the command line I can add/delete/remove files/directories in the 
> storage folder and I will see them in the storage (manager) but still unable 
> to open or save any file.
> 
> 9) BUT when I create a new sql script and try to save it or "save as" I am 
> getting an "Access denied" message :
> "Successfully run. Total query runtime: 311 msec. 14603 rows affected. Access 
> denied (/new script.sql)Access denied (/new_file.sql)Access denied 
> (/two.new.sql)"
> (The message keeps appending my last attempts, btw)
> 
> 
> Did anybody else had this problem before?
> 
> ... and know how to fix it? 
> 
> ... or knows a way to track down the 500 error of the app.
> 
> 
> or is this git issue material?
> 
> Cheers,
> 
> Bastiaan
> 
> 
>