[Rob Lindsey]

Thanks for the hard work.  This is a great resource of info and people.

Rob Lindsey

[Rob Lindsey]

Rick,

Not sure where you are on this but are you basically trying to run a program to look at the Error DB entries on a schedule?

If that is yes, it is possible to do. We have a Shell script and TCL that run out of CRON (I’m old school) that look at every Error DB ( elog.elogdb ) on each one of our CL systems.

This is the select command that we use in our TCL
set sqlcmd “SELECT SourceConn, MidNum, EdbState, ErrorString, UserData, MessageContent, TimeOut FROM elog_msgs where datetime(TimeOut/1000, ‘unixepoch’) >= datetime(‘$timeStart’, ‘unixepoch’);”

Rob

[Rob Lindsey]

We have developed some web pages that use LDAP for checking to see if someone belongs to a group and we use TCL.
<pre>package require ldap
# Connect, bind, add a new object, modify it in various ways
set handle [ldap::connect <ldap server> <ldap port number>]
set x [ldap::search $handle “<breakdown>” “(userPrincipalName=$username)” {memberOf} ]
ldap::unbind $handle
ldap::disconnect $handle</pre>
The above code is very abbreviated but might give you some ideas.

[Rob Lindsey]

Thanks for this.  Web service stuff is still a bit of a black box to my brain.  I have found out more info.  Web service inbound will need to receive orders.  It will have to ACK those orders and then send them on.  The outbound results will be two of them. 1) client calls web service to pick up results so I know that I will have to call some type of DB to get the results for the client that logs in.  I need more details on how we will be getting that client login and password to the actual result. 2) a web service push – I will need a lot more information this one to design it properly.

As Johnny-5 would say…. “Need more input”

Rob

[Rob Lindsey]

Well I was hoping that someone figured out a way to use the recovery DB in that shape form or fashion.

[Rob Lindsey]

I have seen the same issue in 20.1 and 20.1.2. From what I can tell it is trying to revert the changes since you made a change but did not apply it.

Rob

[Rob Lindsey]

Jeff,

We have found that SMATDB is a useful way to store data for inbound and outbound saves on threads. There are WAL and SHM files that might have the data but doing a SMATDB search via the IDE/GUI should pull that information in.  I have not found where the data messages are missing.  The hardest part is matching messages when outside of the IDE/GUI.  It is faster and smaller footprint than the IDX files.  I have not found in the IDE/GUI where it does not put them into the proper order when I sort them by time when I do it.  I usually use our tools though.

Rob

[Rob Lindsey]

This is all speculation as this new thread (web service) is going to replace an existing service and I don’t know how that one works as of yet.  I am hoping that I could use the standard recovery DB and just have the results waiting there and pick them out by certain values in the MSH segment.  Of course, I don’t know how the current one works and wanted to know how others have setup their Web service threads that listen for connection and send information out after the connection.  It does sounds like calling another service to get the results for the specific client might be the best option.

I don’t like it when I don’t know what I don’t know.

Rob

[Rob Lindsey]

Well this is for results where many clients would be connecting.  I was hoping to use the recovery DB within the site that the thread would be running in.  I do not know exactly where the results are coming from as of yet but I was making the assumption that I would have them coming in on an inbound thread that would send them to a outbound thread that would listen for connections on the URL.

[Rob Lindsey]

I have not seen this before.

I assume you are using the SMATDB IDE/GUI tool.

I have my own tool that I wrote to do that type of thing.

Rob

[Rob Lindsey]

This is how we do it with our 20.1 environment using RHEL

18,48 * * * * source /home/hci/.profile ; /hci/cloverleaf/scripts/export_interface_info_tables_to_web_page_v3.tcl >> /info/logs/export_interface_info_tables_to_web_page_v3_$(date +\%Y\%m\%d).log 2>&1

The source command pulls in the profile which makes sure that all of the Libraries are set correctly for our environment.

Rob

[Rob Lindsey]

So we have a program that we wrote to call a Web service and placed it on the route and not on the outbound thread as we need to enhance the data msg with the return from the web service and send it off to a different end point (i.e. outbound) so using outbound threads won’t work.

So when we get 70,000+ data messages each one using a route, the route has the Web service call and the messages get backed up in state 5 waiting for the reply to come back from the web service.  I am trying to get multiple messages to be translated (i.e. from state 5 into state 7) at the same time.

Added a picture of what a testing set of threads looks like and where the web service call is placed.  imdb_connection is the tclproc.

robert   dot   m   dot  lindsey   at   quest diagnostics    dot  com    (remove spaces and change at and dot to what are necessary)

Thanks

 

Attachments:

You must be logged in to view attached files.

[Rob Lindsey]

Thanks for the Reminder of the Roles.  Completely forgot about those.

I will submit an Enhancement request.

[Rob Lindsey]

Max, would love to speak IRL about this so that maybe I can explain a bit better of what I am seeing and maybe not understanding.

Possible?

6158028183

[Rob Lindsey]

It is the performance but I have to keep the order.  I would really like to be able to have the web service call be called for 5 to 10 messages all at the same time if there are many messages waiting in the Recovery DB I want the route to call the Web service for as many as it can handle.  So if there are 100 msgs in the recovery db I want to process those as fast as possible by have lets say 10 messages start the translation at the same time and each one call the Web service instead of just single threaded.  I hope this makes sense.

[Author]

Replies