Can't connect to DB2 database when/if password has mixed case

[Albert K]

Hello,

We are using ibm_db version 1.0.4 in our test systems and we are
seeing a problem - when the password to the database is all lowercase
symbols, then the connection succeeds. But if the password contains
mixed characters (e.g. uppercase and lowercase) then connection is not
being established.
Here is an example how we use it:
...
ibm_db.connect("MYDB","d101ap1","MyPass")
...

In the example above - the connection is not established.

Is that a known issue, or maybe we are not doing something correctly
here?

Thanks,
Albert.

[Praveen]

Hi Albert,

Is the mixed case password to the database correct?

Passwords are not processed by the ibm_db driver, they are sent as is
to the server.

Thanks

Praveen

[Albert K]

Hi Praveen,

Yes, the password is correct - for example, if we use the same
password to connect from db2 CLP, it works. Some additional details
are below.
--
bash-3.2$ python
Python 2.5 (r25:51908, Feb 10 2012, 00:17:46) [C] on aix7
Type "help", "copyright", "credits" or "license" for more information.
>>> import ibm_db
>>> ibm_db.connect("DBNAME","<inst name>","<MixedCasePassword>")
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
Exception: [IBM][CLI Driver] SQL30082N Security processing failed
with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
SQLCODE=-30082
>>>


Thanks,
Albert.

[Albert K]

The problem is solved. We forgot to set the db2set DB2AUTH=OSAUTHDB.

Sorry for the confusion!

Regards,

Albert.


On Feb 9, 11:02 pm, Praveen <praveen...@in.ibm.com> wrote: