[LIBSQLOD SO][MaxDB] Invalid authorization

[Former Member]

I have installed SAP Content Server 6.40 with Max db version as below

VERSION = 7.6.00

BUILD = DBMServer 7.6.00 Build 018-123-119-055

OS = UNIX

INSTROOT = /sapdb/ADB/db

LOGON = True

CODE = UTF8

SWAP = normal

UNICODE = YES

INSTANCE = OLTP

SYSNAME = AIX

I configured the CSADMIN on SAP ECC 6.0 and created a repository.But when I try to start the repository through CSADMIN->details it gives me error

HTTP error: 500 Internal Server Error Cannot open

Repository: SQLConnect failed, [MySQL

MaxDB][LIBSQLOD SO][MaxDB] Invalid authorization

I ran the report RSCMSPWS and gave the user/password SAPR3/SAP for the particular repository and check the conf.cs file as well.

But the error still confinues.

Can anyone help me .. on this.

Thanks in advance

Murali

[TTK · Accepted solution]

Hello Murali

Maybe this is an issue regarding small/capital letters. Did you try to write user/password with CAPITAL LETTERS in the config file?

Regards Thomas

[Former Member · Accepted solution]

Hi Thomas,

The userid/password is in caps but no use.

Also

I checked the the following

Logged as user 'sdb' adn executed the following

$ dbmcli -n SAPDMS -d ADB -u SAPR3,SAP db_state

OK

State

ONLINE

$ sqlcli -n SAPDMS -d ADB -u SAPR3,SAP \c

• -4008: POS(1) Unknown user name/password combination SQLSTATE: 08004

The user SAPR3 can use dbmcli but cannot connect using sql. In fact the same error repeats for superdba and control users as well.

regards,

Murali

[TTK · Accepted solution]

There is a difference between the control-user and the users, who work with the data of a data base.

Please make sure, who is who on your site. Usually the control user cannot log into the data base as SQL-user, but only for managing purposes (backup, add volume, etc via dbmcli).

Regards Thomas

[former_member302817 · Accepted solution]

logon as user superdba and

manually create

sql_execute CREATE USER SAPR3 PASSWORD SAP DBA NOT EXCLUSIVE

[Former Member · Accepted solution]

Thanks Srinivasan,

That resolved it.

regards,

Murali