asemon / Support Requests / #35 ASEMON Logger V3.1.6 doesnt work with RepServer

Jean-Paul Martin - 2020-10-21

Hi Hardeep,
YES I know this problem : it is due to jConnect V16 when asemon tries to connect using the "encrypt password" to a RS 15.7.1 (it works with RS 16)
Two possible workarounds :
1) uncomment the line :
<traceflag> disableENCPASS </traceflag>
in the config file
2) or, replace jConnect used by asemon_logger installation with a older version

First workaround is better

Best regards
Jpm

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Hardeep - 2020-10-21

Thanks Jpm,
I have tried to disable encrypted password option but then Logger stopped working for ASE as well.
Considering our security & compliance policies , we can't disable password encryption option at ASE level.

Is there an option to disable encrypted password only at Repserver level.
I mean to define it under <monitoredsrv><srv> instead of <asemon><options></options></asemon></srv></monitoredsrv>

=======

2020/10/21 18:11:37.150 main - Start Asemon_logger V3.1.6
2020/10/21 18:11:37.173 main - Current directory is : /dba/sybase/asemon/3.1.6
2020/10/21 18:11:37.173 main - Java version : 1.8.0_262
2020/10/21 18:11:37.174 main - Classpath is : /dba/sybase/asemon/asemon_logger/dist/Asemon_logger_V3.jar:/dba/sybase/asemon/asemon_logger/lib/jdom.jar:/dba/sybase/asemon/asemon_logger/lib/xerces.jar:/dba/sybase/asemon/asemon_logger/lib/java-getopt-1.0.9.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jconn4.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jTDS3.jar
2020/10/21 18:11:37.174 main - Config file used : /dba/sybase/asemon/config/ASEMGLDEVD93F.xml
2020/10/21 18:11:37.355 main - textsize for retreiving text (XML documents) for 'ASEMGLDEVD93F': 65536
2020/10/21 18:11:37.355 main - textsize for retreiving text (XML documents) for 'REPMGLDEVD93F': 65536
2020/10/21 18:11:37.356 main - Active traceflag : 4 = disable ENCRYPT PASSWORD
2020/10/21 18:11:37.404 main - Try to connect to srv : ASEMGLDEVD93F
2020/10/21 18:11:37.426 main - Srv found in interfaces or SQL.INI file. Host=sybaseasehost Port=20002
2020/10/21 18:11:37.427 main - Using password from passwords file for 'ASEMGLDEVD93F.perfmon_dba'
2020/10/21 18:11:37.485 main - ERROR connectSRV (1). Srv=ASEMGLDEVD93F State= JZ00L Err= 0 Msg=JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
2020/10/21 18:11:37.486 main - ERROR connectSRV (2). Srv=ASEMGLDEVD93F State= 01ZZZ Err= 1640 Msg=Adaptive Server requires encryption of the login password on the network.

Regards,
Hardeep

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Jean-Paul Martin - 2020-10-21

Do a separate config file for your RepServer and activate the "disableENCPASS" flag only in this config file
Start a dedicated asemon_logger for this RepServer with this config file
Regards
Jpm

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Thanks Jpm
I don’t think this is viable option for my environment. My monitored server is also having password encryption enabled.
So , individual REP XML wont work for me as a solution. Seems like i have to rely on older version of jConnect .

  <asemon>
      <admin_port> </admin_port>  <!-- admin_port is not mandatory. If defined, it allows to connect to asemon with isql -->
      <name> </name>              <!-- asemon_logger name is mandatory only if admin_port is defined. Used to save the sa password of asemon_logger in passwords file -->
      <options>
      <traceflag> disableENCPASS </traceflag>
      </options>
  </asemon>

  <ArchiveSrv>
      <name> ASEMGLDEVD93F </name>
      <user> perfmon_dba </user>
      <useKerberos> NO </useKerberos>
      <database> asemon_ASEMGLDEVD93F </database>
      <charset>  </charset>
      <GranteeList>  </GranteeList>
      <poolsize> 2 </poolsize>
      <packet_size> </packet_size> <!-- not mandatory. If defined, overrides default network packet size of the archive server -->
      <useLongSrvNames> NO </useLongSrvNames> <!-- Put YES here if server names have more than 20 chars and archive server version is V15 or greater -->
  </ArchiveSrv>

  <MonitoredSrv>
      <SRV>
          <name> REPMGLDEVD93F </name>
          <user> perfmon_dba </user>
          <useKerberos> NO </useKerberos>
          <charset>  </charset>
          <packet_size> </packet_size> <!-- not mandatory. If defined, overrides default network packet size of the monitored server -->
          <srvDescriptor> RS16 </srvDescriptor>
          <purgearchive daysToKeep="32"  deleteSleep="100" />
          <textsize> 65536 </textsize>
      </SRV>
  </MonitoredSrv

Regards
Hardeep

Anonymous

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

Jean-Paul Martin - 2020-10-21

Yes, your only solution is to revert to a previous jConnect

By the way I didn't test a more recent jConnect (V16.0 SP03 PL09)
May be you could try and tell me if it fixes the problem.

Regards
Jpm

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Hardeep - 2020-10-21

Sure, we have recently rolled out ASE/PEP V16.0 SP03 PL09 in our cloud environment

I will share the results how ASEMON goes with jConnect (V16.0 SP03 PL09) and whether its able to connect RS157 with this version.

Regards,
Hardeep

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

FYI
I have used latest released jConnect (V16.0 SP03 PL09) to connect to RS157 instance but that didn't work.

2020/10/22 09:46:25.996 main - Start Asemon_logger V3.1.6
2020/10/22 09:46:26.015 main - Current directory is : /dba/sybase/asemon/3.1.6
2020/10/22 09:46:26.015 main - Java version : 1.8.0_262
2020/10/22 09:46:26.016 main - Classpath is : /dba/sybase/asemon/asemon_logger/dist/Asemon_logger_V3.jar:/dba/sybase/asemon/asemon_logger/lib/jdom.jar:/dba/sybase/asemon/asemon_logger/lib/xerces.jar:/dba/sybase/asemon/asemon_logger/lib/java-getopt-1.0.9.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jconn4.jar:/dba/sybase/asemon/asemon_logger/jConnect-16_0/classes/jTDS3.jar
2020/10/22 09:46:26.016 main - Config file used : /dba/sybase/asemon/config/REPMGLDEVD93F.xml
2020/10/22 09:46:26.184 main - textsize for retreiving text (XML documents) for 'REPMGLDEVD93F': 65536
2020/10/22 09:46:26.234 main - Try to connect to srv : ASEMGLDEVD93F
2020/10/22 09:46:26.259 main - Srv found in interfaces or SQL.INI file. Host=usyddbd32697 Port=20002
2020/10/22 09:46:26.259 main - Using password from passwords file for 'ASEMGLDEVD93F.perfmon_dba'
2020/10/22 09:46:26.370 main - Connected to archive server : ASEMGLDEVD93F Database : asemon_ASEMGLDEVD93F
2020/10/22 09:46:26.373 main - Check/create sp_sysmon procs in archive database
2020/10/22 09:46:26.435 main - Try to connect to srv : REPMGLDEVD93F
2020/10/22 09:46:26.450 main - Srv found in interfaces or SQL.INI file. Host=sybasehost Port=27002
2020/10/22 09:46:26.451 main - Using password from passwords file for 'REPMGLDEVD93F.perfmon_dba'
2020/10/22 09:46:26.477 main - ERROR connectSRV (1). Srv=REPMGLDEVD93F : java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data.
2020/10/22 09:46:26.477 main - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.478 main - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.482 REPMGLDEVD93F_AmStats   - Start thread.
2020/10/22 09:46:26.484 REPMGLDEVD93F_DISKSPCE  - Start thread.
2020/10/22 09:46:26.486 REPMGLDEVD93F_RSConfig  - Start thread.
2020/10/22 09:46:26.488 REPMGLDEVD93F_RSInfo    - Start thread.
2020/10/22 09:46:26.489 REPMGLDEVD93F_RSMem     - Start thread.
2020/10/22 09:46:26.490 REPMGLDEVD93F_RSMemDet  - Start thread.
2020/10/22 09:46:26.492 REPMGLDEVD93F_RSStats   - Start thread.
2020/10/22 09:46:26.495 REPMGLDEVD93F_Trends    - Start thread.
2020/10/22 09:46:26.498 REPMGLDEVD93F_RSWhoSQM  - Start thread.
2020/10/22 09:46:26.567 REPMGLDEVD93F_RSWhoSQM  - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.567 REPMGLDEVD93F_RSWhoSQM  - ERROR connectSRV (2). Srv=REPMGLDEVD93F : java.sql.SQLWarning: JZ0T8: Data received for an unknown request.Please report this error to SAP Technical Support.
2020/10/22 09:46:26.567 REPMGLDEVD93F_RSWhoSQM  - Connection  to REPMGLDEVD93F is closed. Trying to reconnect every 10 s ...

Regards,
Hardeep

Anonymous

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

Jean-Paul Martin - 2020-10-23

Hi Hardeep, thank you forthe feedback

If you have a SAP support contract you should open an incident about this password encryption problem with RS15.7 and jConnect V16
I cannot do myself as I am not a SAP customer

Regards
Jpm

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Hardeep - 2020-10-25

Thanks Jpm ,
Really appreciate your help.

Regards
Hardeep

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

ASEMON Logger V3.1.6 doesnt work with RepServer

Group

Searches

Help

#35 ASEMON Logger V3.1.6 doesnt work with RepServer

Discussion