Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

NEW CASE FOR IBMi : *CURRENT for user profile and password is not accepted . #388

Open
KobiSaada opened this issue Mar 18, 2024 · 5 comments
Labels
bug Something isn't working

Comments

@KobiSaada
Copy link

  • Node.js version:
  • itoolkit version:
  • IBM i version:
  • XMLSERVICE version:

Describe the bug
To clear things out: we are not trying to change the user profile and password, we are trying to connect to IBM i via NodeJS running on the IBM i.

Connection procedure as described in the documentation of XMLSERVICES using *CURRENT in username and password. This does not work. If instead we specify an IBM i user and password it works.

Screenshots
const { Connection} = require('itoolkit'); //xml services
const connection = new Connection({
transport: 'ssh',
transportOptions: {
database: '*LOCAL',
username: *CURRENT,
password: *CURRENT,
host: 'localhost',
},
});

and its not connected even im already connected to the system and even i run it from the ibmi/as400 system.

I would appreciate a solution, thanks.

@KobiSaada KobiSaada added the bug Something isn't working label Mar 18, 2024
@kadler
Copy link
Member

kadler commented Mar 18, 2024

The IBM i Access ODBC driver has a limitation that using *CURRENT does not work if the user has PASSWORD(*NONE). Does the user have a password assigned?

@KobiSaada
Copy link
Author

KobiSaada commented Mar 19, 2024 via email

@kadler
Copy link
Member

kadler commented Mar 19, 2024

Oh I missed that you were using SSH, yeah you need to provide a username and password in that case or use an SSH key. See the examples: https://nodejs-itoolkit.readthedocs.io/en/latest/Connection.html#examples

@KobiSaada
Copy link
Author

KobiSaada commented Mar 20, 2024 via email

@kadler
Copy link
Member

kadler commented Mar 20, 2024

Yes, but only with ODBC as the *CURRENT thing is a special feature of the ODBC driver. No other transport supports it.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants