Hello,
I'm experiencing an issue with the SQL Developer for VSCode extension where the system is using my OS username instead of the one I manually entered for the database connection. Here are the details of my setup and the problem:
Environment:
- Local Machine OS: Windows
- Remote Server OS: Ubuntu
- Extension Versions: 24.1.1, 23.4.1, 23.4.0
- The extension is installed on VSCode server running on the remote Ubuntu server.
- DB Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Issue Description:
- I enter the database username and password manually in the connection properties within the extension (see the attached screenshot for reference, indicated by the green arrow).
- Despite entering the correct database username (
ll), the extension uses my OS username (ig4er) for the connection.
- This results in a "The database name or password is incorrect" error.
Logs: The database logs show that the username being used is my OS username (ig4er) instead of the manually entered database username (ll):
(CONNECT_DATA=(CID=(PROGRAM=Oracle SQL Developer for VS Code/24.1.1)(HOST=__jdbc__)(USER=ig4er))(SERVICE_NAME=REDACTED)(CONNECTION_ID=9iYxhERjQkenPd8AurW7cg==)) (ADDRESS=(PROTOCOL=tcp)(HOST=REDACTED)(PORT=54992)) establish REDACTED * 0
// Entering with service name^
(CONNECT_DATA=(SID=LL)(CID=(PROGRAM=Oracle SQL Developer for VS Code/24.1.1)(HOST=__jdbc__)(USER=ig4er))(CONNECTION_ID=0ULwIe83QZOYEykhLN98mw==)) (ADDRESS=(PROTOCOL=tcp)(HOST=REDACTED)(PORT=59676)) establish LL * 0
// Entering with SID^
As you can see, the USER field in the logs shows ig4er instead of ll.
Expected Behavior:
- The extension should use the manually entered database username (
ll) for the connection.
Additional Information:
$ whoami command output on the remote server: ig4er- The issue persists across multiple versions of the extension (24.1.1, 23.4.1, and 23.4.0).
I hope this provides enough context to understand the issue. Any guidance or solutions would be greatly appreciated.
Thank you!
Attachments:
