github-starred/pangolin
2
0
Fork 0
mirror of https://github.com/fosrl/pangolin.git synced 2026-07-16 14:47:04 -05:00
Code Issues 1.6k Packages Projects Releases 79 Wiki Activity

[GH-ISSUE #3249] Sqlite Error trying to create RDP resource #32410

New Issue
Closed
opened 2026-06-15 09:54:05 -05:00 by GiteaMirror · 6 comments
GiteaMirror commented 2026-06-15 09:54:05 -05:00
Owner
Copy Link

Originally created by @HarryXChen3 on GitHub (Jun 12, 2026).
Original GitHub issue: https://github.com/fosrl/pangolin/issues/3249

Describe the Bug

pangolin  | Stack: SqliteError: NOT NULL constraint failed: resources.sso
pangolin  |     at Statement.all (file:///app/dist/server.mjs:1270:19)
pangolin  |     at PreparedQuery.values (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:106:28)
pangolin  |     at PreparedQuery.all (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:81:23)
pangolin  |     at QueryPromise.all (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:165:28)
pangolin  |     at QueryPromise.execute (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:174:41)
pangolin  |     at QueryPromise.then (file:///app/node_modules/drizzle-orm/query-promise.js:21:17)
pangolin  |     at process.processTicksAndRejections (node:internal/process/task_queues:104:5) {"code":"SQLITE_CONSTRAINT_NOTNULL"}

Please let me know if there's anything else I can provide!

Environment

  • OS Type & Version: Ubuntu 24.04.4
  • Pangolin Version: v1.19.0
  • Edition (Community or Enterprise): Enterprise
  • Gerbil Version: 1.4.0
  • Traefik Version: 3.6
  • Newt Version: 1.13.0
  • Client Version:

To Reproduce

Steps taken:

  1. https://pangolin.example.com/org/settings/resources/public/create
  2. Fill in name, select type RDP
  3. Fill in subdomain, base domain is default (I only have 1)
  4. Select site in RDP section, used destination 192.168.1.243 port 3389

I can work towards a more minimal repro if desired

Expected Behavior

The RDP resource should create without issue

Originally created by @HarryXChen3 on GitHub (Jun 12, 2026). Original GitHub issue: https://github.com/fosrl/pangolin/issues/3249 ### Describe the Bug ``` pangolin | Stack: SqliteError: NOT NULL constraint failed: resources.sso pangolin | at Statement.all (file:///app/dist/server.mjs:1270:19) pangolin | at PreparedQuery.values (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:106:28) pangolin | at PreparedQuery.all (file:///app/node_modules/drizzle-orm/better-sqlite3/session.js:81:23) pangolin | at QueryPromise.all (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:165:28) pangolin | at QueryPromise.execute (file:///app/node_modules/drizzle-orm/sqlite-core/query-builders/insert.js:174:41) pangolin | at QueryPromise.then (file:///app/node_modules/drizzle-orm/query-promise.js:21:17) pangolin | at process.processTicksAndRejections (node:internal/process/task_queues:104:5) {"code":"SQLITE_CONSTRAINT_NOTNULL"} ``` Please let me know if there's anything else I can provide! ### Environment - OS Type & Version: Ubuntu 24.04.4 - Pangolin Version: v1.19.0 - Edition (Community or Enterprise): Enterprise - Gerbil Version: 1.4.0 - Traefik Version: 3.6 - Newt Version: 1.13.0 - Client Version: ### To Reproduce Steps taken: 1. https://pangolin.example.com/org/settings/resources/public/create 2. Fill in name, select type RDP 3. Fill in subdomain, base domain is default (I only have 1) 4. Select site in RDP section, used destination `192.168.1.243` port `3389` I can work towards a more minimal repro if desired ### Expected Behavior The RDP resource should create without issue
GiteaMirror commented 2026-06-15 09:54:07 -05:00
Author
Owner
Copy Link

@AstralDestiny commented on GitHub (Jun 12, 2026):

It's fine I can test when I wake

<!-- gh-comment-id:4687579792 --> @AstralDestiny commented on GitHub (Jun 12, 2026): It's fine I can test when I wake
GiteaMirror commented 2026-06-15 09:54:08 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Jun 12, 2026):

Issue with the migration identified will fix in a patch update shortly

<!-- gh-comment-id:4687587975 --> @oschwartz10612 commented on GitHub (Jun 12, 2026): Issue with the migration identified will fix in a patch update shortly
GiteaMirror commented 2026-06-15 09:54:08 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Jun 12, 2026):

1.19.1 release will be out shortly. Please try to update to that once its out and it should fix this 🤞. Please follow up and LMK

<!-- gh-comment-id:4687646593 --> @oschwartz10612 commented on GitHub (Jun 12, 2026): 1.19.1 release will be out shortly. Please try to update to that once its out and it should fix this 🤞. Please follow up and LMK
GiteaMirror commented 2026-06-15 09:54:10 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Jun 12, 2026):

Its out

<!-- gh-comment-id:4687723144 --> @oschwartz10612 commented on GitHub (Jun 12, 2026): Its out
GiteaMirror commented 2026-06-15 09:54:11 -05:00
Author
Owner
Copy Link

@HarryXChen3 commented on GitHub (Jun 13, 2026):

Resource creation succeeded and am seeing the login page being served now..
Can't seem to login:

Image

Is there extra setup I need to do on the RDP target? I can also make a new issue if unrelated
I looked around but didn't see any relevant logs but happy to post if they'd be helpful

<!-- gh-comment-id:4697194333 --> @HarryXChen3 commented on GitHub (Jun 13, 2026): Resource creation succeeded and am seeing the login page being served now.. Can't seem to login: <img width="469" height="200" alt="Image" src="https://github.com/user-attachments/assets/f729ccf5-d72f-4004-a467-409a6204f45d" /> Is there extra setup I need to do on the RDP target? I can also make a new issue if unrelated I looked around but didn't see any relevant logs but happy to post if they'd be helpful
GiteaMirror commented 2026-06-15 09:54:12 -05:00
Author
Owner
Copy Link

@oschwartz10612 commented on GitHub (Jun 14, 2026):

This usually occurs if your newt cant reach the RDP target. We are going to improve the error message. Make sure it can reach.

<!-- gh-comment-id:4702490635 --> @oschwartz10612 commented on GitHub (Jun 14, 2026): This usually occurs if your newt cant reach the RDP target. We are going to improve the error message. Make sure it can reach.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
api
authentication
bug
config
dependencies
docker
documentation
enhancement
good first issue
help wanted
Improvement
Look Into
needs investigating
networking
new feature
non-critical bug
potential bug
pull-request
Mirrored from GitHub Pull Request
 question
reverse proxy
Security
stale
ui
wontfix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/pangolin#32410
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?