No user connect after upgrading to 7.7

[Former Member]

Hello Everybody

We tried an upgrade from 7.6.00.34 to 7.7.07.16

1. db_migratecatalog via dbmcli

2. SDBUPD

Everything looks good, but :

Only the dba,dbm user could connect to the database after upgrade.

Normal user connection does not work ??? Not from sql-studio, not via sqlcli ???

Fehler: -4008 POS (1) Unknown user Name/password combination SQLSTATE 08004

We found out, that we have to set the userpassword again.

DBMGUI-Configuration-Databaseuser-dba login-Schema-User

We retyped the old password for some users and then these users could conntect to the database???

We found this information in the internet:

Informationen aus dem Internet bezüglich db_migratecatalog, MaxDB und Passwörter der Benutzer:

You migrate the database catalog.

The database catalog now uses the Unicode character set instead of the ASCII character set. This command does not affect the format of the user data in the database.

User passwords may have no more than 18 characters in ASCII databases and no more than 9 in Unicode databases. After the migration, all users can still use their existing passwords to log on, but only the first 9 characters are evaluated.

We have about 600 database users!

Do we have to set the password for all these useres again or do we miss something else ???

Any help welcomed

Best regards

Albert

[Former Member]

Hello Thomas

It must be something else!

Even users with a password less then 9 characters could't connect to the upgraded database.

If i understand the hints correct, users with a password with more than 9 characters can still connect, but only the first 9 character are used to verify the logon.

Best regards

Albert

[Former Member]

Hello,

may I ask, how the problem has been solved at the end. Was it the truth that only the first nine characters are been used for password verification ?

Regards,

   Werner

[Former Member]

Changing to unicode truncates the passwords longer then 9 characters.

Isn't that the problem?

User passwords may have no more than 18 characters in ASCII databases and no more than 9 in Unicode databases. 
After the migration, all users can still use their existing passwords to log on, 
but only the first 9 characters are evaluated.