PK70391: CEIUSER PASSWORD CANNOT TERMINATE WITH COMMA ','

Fixes are available

APAR status

Closed as program error.

Error description

Problem:
1.install WebSphere Process Server 612:WebSphere Application
Server Network Deployment 6.1.0.17 and WebSphere Business
Integration 6.1.2.0 on Microsoft Windows 2008
2.Create profiles with profile wizard, select sqlserver as
Common Event Infrastructure (CEI) database product, and set
ceiuser password to "abc123," (the string end is a comma), cei
configuration
3.Start server1, test event and event catalog datasource
connection. The following exception happens:
The test connection operation failed for data source event on
server server1 at node WIN2k81Node01 with the following
exception: java.sql.SQLException: [IBM][SQLServer JDBC
Driver][SQLServer]Login failed for user 'ceiuser'.DSRA0010E:
SQL State = 28000, Error Code = 18,456. View JVM logs for
further details.
4.set ceiuser password to "abc123"  from administrative console
JAAS-J2C authentication data page. Test event and event
catalog connection once more, it's ok.
5.Another way, don't do step4. open Microsoft SQL Server
Management studio, set ceiuser's password to "abc123," in
login properties dialog for ceiuser.
Open the administrative console, test event and event catalog
connection, it's successful.

The analysis according to step 4 and step 5: password is not
the original password which is set in profiles wizard when cei
dbscripts create login user "ceiuser" in sqlserver.
6.Try to execute cei db scripts in command window, for
example:cr_event_mssql.bat ceiuser abc123, server=WIN2K81
sauser=sa sapassword="abc123,"
we can get same results as profiles wizard executing this
scrips. Debug and trace cr_event_mssql.bat, I watched,
variable userpassword is set to "abc123" but not "abc123,"

Password "abc123," is compatible with Microsoft Windows 2008
default password policy.

Local fix

Problem summary

****************************************************************
* USERS AFFECTED:  Common Event Infrastructure (CEI) users on  *
*                  Microsoft Windows.                          *
****************************************************************
* PROBLEM DESCRIPTION: The CEI administrative task used for    *
*                      configuration with Microsoft SQL        *
*                      Server will fail when MS DOS special    *
*                      characters, like comma (,), are put     *
*                      in the passwords. This happens even     *
*                      if you quote the passwords.             *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
The configuration command fails because the MS DOS command
prompt interpreter will fail. It will only read the first part
of the string that was passed as password parameter, the part
in front of the first special character. So basically it will
pass the wrong password to the script that creates the CEI user
in the database. But on the other hand, when the
configurations are made via the same administrative task, the
password for the CEI user is set as it was given. This leads
to an inconsistency between the password in the database and
the password in the CEI configurations on WebSphere
Application Server, which means that CEI will not be  able to
connect to the database because the password is wrong.

Problem conclusion

Support for passwords containing MS DOS special characters
(like comma (,)) was added to the CEI configuration with SQL
Server admin task.

The fix for this APAR is currently targeted for inclusion in
fixpack 6.1.0.21. Please refer to the recommended updates page
for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Temporary fix

Comments

APAR Information

APAR number
PK70391
Reported component name
WEBSPHERE APP S
Reported component ID
5724J0800
Reported release
61W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-08-11
Closed date
2008-09-16
Last modified date
2008-09-16

APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name
WEBSPHERE APP S
Fixed component ID
5724J0800

Applicable component levels

R61W PSY
UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
29 December 2021

Tips

PK70391: CEIUSER PASSWORD CANNOT TERMINATE WITH COMMA ','

Fixes are available

Subscribe

APAR status

Closed as program error.

Error description

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

APAR number

Reported component name

Reported component ID

Reported release

Status

PE

HIPER

Special Attention

Submitted date

Closed date

Last modified date

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Fix information

Fixed component name

Fixed component ID

Applicable component levels

R61W PSY

Document Information

Share your feedback

Need support?