Skip to Content
avatar image
Former Member

Could not load SYB library libsybdrvodb.so - sybcrtl - ASE 15.7

Hello,

After system rename backups scheduled fails with the following error in <SID>_JSAGENT.log

00:140737286690560:140737353873248:2017/12/05 23:00:00.69 workerct_connect() failed.

00:140737286690560:140737353873248:2017/12/05 23:00:00.69 workerjsj__RunSQLJob: jsd_MakeConnection() failed for user sapsa to server <SID>

00:140737286690560:140737353873248:2017/12/05 23:00:00.69 workerjsj__RunSQLJob() failed for xid 1017311

00:140737278297856:140737353873248:2017/12/06 23:00:00.82 workerClient message: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

According to note 2256605, steps describe in note 1796540 should be follow:

set_sapsa_passwd : set password of SAP ASE system administrative user (sapsa)

An issue while executing the above command or the following one is obtained however:

ERROR: setup of odbc failed.
Error: verification of passwords in secure storage failed.
Could not load SYB library libsybdrvodb.so. No database connection possible.spd

LD_LIBRARY_PATH is correctly set......./usr/sap/<SID>/SYS/global/syb/linuxx86_64/sybodbc

The ldd command does not show any missing dependency:

ldd libsybdrvodb.so
linux-vdso.so.1 => (0x00007ffff7ffe000)
libsybcsi_openssl29.so => /usr/sap/JAQ/SYS/global/syb/linuxx86_64/sybodbc/libsybcsi_openssl29.so (0x00007ffff770c000)
libsybcsi_core29.so => /usr/sap/JAQ/SYS/global/syb/linuxx86_64/sybodbc/libsybcsi_core29.so (0x00007ffff74b0000)
libsybcsi_profiler29.so => /usr/sap/JAQ/SYS/global/syb/linuxx86_64/sybodbc/libsybcsi_profiler29.so (0x00007ffff72ac000)
libsybcsi_propertiesconfig29.so => /usr/sap/JAQ/SYS/global/syb/linuxx86_64/sybodbc/libsybcsi_propertiesconfig29.so (0x00007ffff70a8000)
libsybcsi_rolecheck29.so => /usr/sap/JAQ/SYS/global/syb/linuxx86_64/sybodbc/libsybcsi_rolecheck29.so (0x00007ffff6ea6000)
librt.so.1 => /lib64/librt.so.1 (0x00007ffff6c6b000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007ffff6a53000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007ffff684e000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007ffff6631000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007ffff6329000)
libm.so.6 => /lib64/libm.so.6 (0x00007ffff60af000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007ffff5e98000)
libc.so.6 => /lib64/libc.so.6 (0x00007ffff5b24000)
/lib64/ld-linux-x86-64.so.2 (0x0000555555554000)

It worth to mention that connection to DB using isql works ok for user sapsa.

Could you please advise on how to correct this error to finally be able to change sapsa password at secure storage level?

DB release: 15.7.0.136

OS: Linux GNU SLES-11 x86_64 cc4.3.4 use-pr151120

Thanks in advance.

Regards



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 11, 2017 at 10:44 AM

    Hi,

    I believe you need to use the sybctrl utility to reset passwords in the secure storage area. See note 1796540 for more details.

    Once you have your passwords set to what you want there you can use the instructions in note 2228120 to align the passwords on ASE if necessary.

    Hope this helps,
    Andy Ashwood

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Diego,

      Are you logged in as <sid>adm user before executing set_sapsa_passwd ?

      You have to reinstate each of the following passwords as well :

      set_connect_passwd : set password of database connect user (SAPSR3).
      set_sapsso_passwd : set password of SAP ASE system security officer (sapsso).
      set_sybsid_passwd : set password of SAP ASE OS user (syb<sid>).

      Alternatively, execute the following commands as <sid>adm :

      rsecssfx put DB_CONNECT/SYB/SADB_PASSWORD <password> /* sapsa */

      rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <password> /* SAPSR3 */

      rsecssfx put DB_CONNECT/SYB/SSODB_PASSWORD <password> /* sapsso */

      rsecssfx put DB_CONNECT/SYB/SYBSID_PASSWORD <password> /* sybsid */

      sybctrl offers also the possibility to verify the users and passwords stored in the secure storage by using the option verify_secure_store [<user>|all]. For the required patch level, check note 2129883.

      Hope this helps.

      By the way, any question related to SAP on ASE, please use the tag SAP ASE ERP Enablement.

      Best Regards

      Mehrab