Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    120

    Unanswered: unable to connect to database using password with accented characters

    Hi all,
    I'm using DB2 10.5 on Linux.

    I have set the password for db2inst1 with accented characters like "psswrd".
    If I try:
    db2 connect to bfent user db2inst1 using psswrd
    I get

    SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
    PASSWORD INVALID"). SQLSTATE=08001

    while if I do
    db2 connect to bfent (being logged as db2inst1)
    it works.

    What is going wrong here?

    Thanks

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'm going to guess that you're running into a Unicode issue. See the article at http://archive09.linux.com/feature/39912 for additional information if that is your case.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    General naming rules

    Unless otherwise specified, all names can include the following characters:
    • The letters A through Z, and a through z, as defined in the basic (7-bit) ASCII character set. When used in identifiers for objects created with SQL statements, lowercase characters "a" through "z" are converted to uppercase unless they are delimited with quotation marks (")
    • 0 through 9.
    • ! % ( ) { } . - ^ ~ _ (underscore) @, #, $, and space.
    • \ (backslash).

    When you're logged on the server and you don't provide the user name with the 'connect' command, DB2 trust the OS security and doesn't check you password.
    Regards,
    Mark.

  4. #4
    Join Date
    Jan 2016
    Posts
    7
    Hi
    did you try to enclose psw in single quote?

    e.g.
    db2 connect to bfent user db2inst1 using 'psswrd'

    I had the same problem using special chars and working fine using single quote

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •