Re: [U2] Command logging in Universe 10.2.1
You can rename the COMO entry to something else like hiddencomocommand then when they start the command line (e..g either in the login paragraph or the process that escaped them out of your menu) do hiddencomocommand ON. COMO OFF will then not do anything. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpar...@nemianlife.lu Sent: 23 October 2009 09:52 To: u2-users@listserver.u2ug.org Subject: [U2] Command logging in Universe 10.2.1 Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. Many thanks for any help. Brian Parker Systems Manager Nemian Life and Pensions SA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command logging in Universe 10.2.1
In message of599fdc36.969bd559-onc1257656.0049829c-c1257658.00308...@nemian.lu, bpar...@nemianlife.lu writes Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. May be a bit more hassle, might not be ... See what the auditors think about indexes/triggers logging all changes to files. It might create a heck of a lot of disk usage, but it would achieve the same thing and probably be a lot easier to enforce. Or ask what commands they're worried about - obviously ED for a start - and put a wrapper round that ... I don't know how to force comos. To make it worse, you can do a COMO ON and it will kill the first como and start a new one - which is a damn useful feature on occasion! The other thing is, if you use a terminal emulator, can you force that to log all sessions? Many thanks for any help. Brian Parker Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
Change the to , currently you are directing the output of your command back to your command. On Fri, Oct 23, 2009 at 1:56 AM, Richard Blackman richard.black...@itvision.com.au wrote: Hi All, I am trying to capture the output from an EXECUTE statement on a command line program but nothing is being captured, even though I know there is some output. Here is the command CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:'' EXECUTE DOS /c:CMD CAPTURING TRASH Cheers, Richard Blackman -- View this message in context: http://www.nabble.com/Capturing-output-from-a-Command-line-program--tp26021253p26021253.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1 XDOM Support
I have had some success with using XML SOAP with custom namespaces.. I never had any problems extracting the XML data however, my issues were all centred around needing to send SOAP requests with a specific xmlns attribute in the elements, and there was no way of specifying the xmlns values to use in the message without parsing the message as a string and using string manipulation methods immediately prior to send.. Here's a snippet from my program that processes received SOAP messages. FYI we have a number of the types and other common values held as equates in an include to reduce finger trouble, and the xmlns is one of those includes, but I copied the include into the code so you can see what xmlns we are using: * Open Message, and get main element from soap:Body, and determine type RESPONSE.TYPE = TEMP.STATUS = XDOMOpen(IN.DATA,XML.FROM.STRING,ROOT.DOM) TEMP.STATUS = XDOMLocate(ROOT.DOM,/soap:Envelope/soap:Body/*[1],xmlns:soap=http://s chemas.xmlsoap.org/soap/envelope/,RESPONSE.NODE) TEMP.STATUS = XDOMGetNodeName(RESPONSE.NODE,RESPONSE.TYPE) IF TEMP.STATUS # XML.SUCCESS THEN XMLACTION = Locating Response within Message GOTO HANDLE.XML.ERROR END * BEGIN CASE CASE RESPONSE.TYPE = OBJ_QADATA OUT.DATA = ; OUT.DATARECTYPE = RECTYPE_DATASETS CHILD.NO = 0 LOOP CHILD.NO += 1 WHILE XDOMLocateNode(RESPONSE.NODE,XDOM.CHILD,CHILD.NO,XDOM.ELEMENT.NODE, CHILD.NODE) # XML.ERROR DO NODE.NAME = TEMP.STATUS = XDOMGetNodeName(CHILD.NODE,NODE.NAME) IF NODE.NAME = OBJ_DATASET THEN ... END REPEAT CASE RESPONSE.TYPE = OBJ_SYSTEMINFO ... CASE 1 RTN.MSG = Unknown Message Received for processing.:@AM:IN.DATA RTN.STATUS = ERR_FAIL GOTO END.OF.PROGRAM END CASE * Hope that helps... Ray -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 22 October 2009 20:48 To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1 XDOM Support I have never used the XDOM stuff in anger - i tend to define extraction files and whiz through the xml using READXMLDATA etc. We have had problems with namespaces in the past - it does ring a bell, i will take a look at what our problem was. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 22 October 2009 19:05 To: U2 Users List Subject: [U2] Unidata 7.1 XDOM Support Been spending a bit of time with Unidata 7.1 and XDOM support and I have to say that I'm disappointed, frustrated, and really quite concerned. With a simple hand-constructed XML document, everything seems to work pretty well. Throw any xmlns namespaces into the mix and, well, things get butt-ugly. In the test example, we are receiving a SOAP response with a normal XML response. The program holds the XML string in a variable XML.DATA and then issues this: STATUS = XDOMOpen(XML.DATA, XML.FROM.STRING, DOM.HANDLE) ...and everything seems to be okay. This is then followed by: STATUS = XDOMLocate(DOM.HANDLE,START.NODE,'',NODE.HANDLE) ...where START.NODE is a variable containing the starting node. This is where things get ugly. First, the starting node value needs a // prefix, which I see is an XPath syntax thing but the Unidata documentation say nothing about it. Second, for a node to be found - for whatever reason - there must be xmlns= in the node. There can be nothing between the quotes, that doesn't work, but without the xmlns= it's apparently looking to some parent name space and ... well, things don't work. So this xml frag works: Handle xmlns= But this does not: Handle xmlns=http://; ...or... Handle I've tried using XDOMLocate with a full XDOM path to the node, no love. I've tried extracting the first node in the XML document, no love. There are only two situations that seem to work, the first being sending in START.NODE = in which case the entire document is parsed, or with //name in which case it'll work if the XML has been manually munged to either remove all namespacing or to add the xmlns= on the nodes to be extracted. Seems kinda wonky to have to replace something in order to allow it to be extracted, don't it? I've tried different settings for the namespace variable on XDOMLocate (which is the '' above) and nothing seems to work. Could it be because the xmlns= refers to a dead URL? Seems every time I'm in into this kind of thing the namespace urls are dead, so it seems to be something of a common thing. Could this be stopping Unidata from being able to find a specific node? Clearly either I'm doing some stuff incorrectly; otherwise this is a feature that isn't quite fully baked. What say ye, my genius cyberdwellers? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
the should be correct. That's pulling the input from TEMP.FILE what happens if you do: EXECUTE DOS /c dir CAPTURING TRASH ? or you could try (I'm not sure if windows stdin is -) CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:' -' another option might be to see if sendmail has an option to take it's input from a file, therefor eliminating the altogether George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: Friday, October 23, 2009 8:02 AM To: U2 Users List Subject: Re: [U2] Capturing output from a Command line program? Change the to , currently you are directing the output of your command back to your command. On Fri, Oct 23, 2009 at 1:56 AM, Richard Blackman richard.black...@itvision.com.au wrote: Hi All, I am trying to capture the output from an EXECUTE statement on a command line program but nothing is being captured, even though I know there is some output. Here is the command CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:'' EXECUTE DOS /c:CMD CAPTURING TRASH Cheers, Richard Blackman -- View this message in context: http://www.nabble.com/Capturing-output- from-a-Command-line-program--tp26021253p26021253.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
duhhh, my bad George. Thanks for the correction. On Fri, Oct 23, 2009 at 9:35 AM, George Gallen ggal...@wyanokegroup.com wrote: the should be correct. That's pulling the input from TEMP.FILE what happens if you do: EXECUTE DOS /c dir CAPTURING TRASH ? or you could try (I'm not sure if windows stdin is -) CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:' -' another option might be to see if sendmail has an option to take it's input from a file, therefor eliminating the altogether George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: Friday, October 23, 2009 8:02 AM To: U2 Users List Subject: Re: [U2] Capturing output from a Command line program? Change the to , currently you are directing the output of your command back to your command. On Fri, Oct 23, 2009 at 1:56 AM, Richard Blackman richard.black...@itvision.com.au wrote: Hi All, I am trying to capture the output from an EXECUTE statement on a command line program but nothing is being captured, even though I know there is some output. Here is the command CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:'' EXECUTE DOS /c:CMD CAPTURING TRASH Cheers, Richard Blackman -- View this message in context: http://www.nabble.com/Capturing-output- from-a-Command-line-program--tp26021253p26021253.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command logging in Universe 10.2.1
If your using *nix, you might be able to have a program run that will tap and log the input device on login. Didn't UV have a PEEK/POKE utility? Wonder if that could be useful for this? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of bpar...@nemianlife.lu Sent: Friday, October 23, 2009 4:52 AM To: u2-users@ Subject: [U2] Command logging in Universe 10.2.1 Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. Many thanks for any help. Brian Parker Systems Manager Nemian Life and Pensions SA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
In *nix I've used cat. Not sure what the syntax would be in Windows. Here's an attempt: CMD = 'cat ':EMAIL.TEMPFILE:' | C:\usr\lib\sendmail -t' CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:' -' another option might be to see if sendmail has an option to take it's input from a file, therefor eliminating the altogether U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command logging in Universe 10.2.1
Does windows have the equivalent to unix's tee command? I can tell you what I'd try on unix, because I don't think COMO will capture unix SH output. (SH for shell is UV's unix equivanent to DOS verb for windows.) I haven't used tee very much, but I *think* unix tee would capture stdout stderr from all child processes that said children don't explicitly redirect. IF that's right, I'd first try this approach for a general solution on unix: 1. replace the unix SH (On windows DOS) command with a wrapper that records the command that the user wants to run, then runs the user's command via tee. Execute that via SH.RESTRICTED 2. Create SH.RESTRICTED as an R-item pointing to vanilla NEWACC SH and use a remote control subroutine to make sure we got here via your custom SH wrapper. IF that works (I haven't tried any of it), it should automatically handle all existing SH usage already deployed in your ap. That's a unix approach; don't know windows DOS command. Please publish your solution once you've found one. Chuck bpar...@nemianlife.lu wrote: Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. Many thanks for any help. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
Richard, When Universe shells down via the DOS command, it (Universe) doesn't reliably handle standard output and/or error. The result is that DOS output isn't always captured when EXECUTE'd (it seems to depend on the command). A more reliable strategy is to redirect the command output into a type 1 or 19 file, then READ it in. rex Richard Blackman wrote: Hi All, I am trying to capture the output from an EXECUTE statement on a command line program but nothing is being captured, even though I know there is some output. Here is the command CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:'' EXECUTE DOS /c:CMD CAPTURING TRASH Cheers, Richard Blackman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command logging in Universe 10.2.1
One thing to consider is the command stacks that are written to savedlists which has the command line activity. Not gospel as they can be manipulated but something.If it were me, I'd lock down command line access and/or the commands themselves. In past lives, I've had wrappers around system commands that did whatever logging was necessary.For example ED ran our special version which took the command line options and logged them and verified that the particular user was 'authorized' to use ED or access the file they entered. Another method might be to COMO everything and change the name of the COMO command to something only your administrator knows so no one could 'COMO OFF'. Of course you'd need to lock down VOC changes and access to the UV account and certain system tables. A few ideas Mike R. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpar...@nemianlife.lu Sent: Friday, October 23, 2009 4:52 AM To: u2-users@listserver.u2ug.org Subject: [U2] Command logging in Universe 10.2.1 Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. Many thanks for any help. Brian Parker Systems Manager Nemian Life and Pensions SA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Capturing output from a Command line program?
I thought I'd try this on UniData v7.2 (Windows 2K3). Here's what I get: 4 Dev (0)- BPTEST EXECUTE \!dir\ CAPTURING OUTPUT ; CRT OUTPUT Compiling Unibasic: SAVEDLISTS\BpTest_383842951 in mode 'p'. compilation finished Volume in drive E is ShareDbms Volume Serial Number is C45E-045F Directory o f E:\DataTrust\Dev 10/22/2009 03:10 PMDIR . 10/22/2009 03:10 PM DIR .. 10/23/2009 08:29 AM72,704 AE_COMS 10/13/2009 05:13 PMDIR AE_SCRATCH 02/23/2007 09:28 PM 13,776 . . X_MASTER 03/27/2007 06:49 PM32,768 X_MTGFILE 10/14/2009 03:19 PM 557,056 X_NAMES 06/29/2005 12:26 PM 2,048 _DEBUG_ 06/29/2005 12:26 PM 4,096 _EDAMAP_ 10/13/2009 05:13 PMDIR _EDAXMAP_ 10/23/2009 09:21 AMDIR _PH_ 10/13/2009 05:13 PMDIR _XML_ 02 /23/2007 09:22 PM12,288 __V__VIEW 114 File(s) 89,52 7,565 bytes 24 Dir(s) 66,143,858,688 bytes free 4 Dev (0)- It seems to work fine, as long as I'm only looking for output. Bill bradley.sch...@usbank.com said the following on 10/23/2009 8:09 AM: In *nix I've used cat. Not sure what the syntax would be in Windows. Here's an attempt: CMD = 'cat ':EMAIL.TEMPFILE:' | C:\usr\lib\sendmail -t' CMD = 'C:\usr\lib\sendmail -t ':EMAIL.TEMPFILE:' -' another option might be to see if sendmail has an option to take it's input from a file, therefor eliminating the altogether U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Command logging in Universe 10.2.1
I've used Tee32 from here before http://users.csc.calpoly.edu/~bfriesen/software/console.shtml Rob Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Charles Stevenson stevenson.c...@gmail.com 10/23/2009 10:54 AM Does windows have the equivalent to unix's tee command? I can tell you what I'd try on unix, because I don't think COMO will capture unix SH output. (SH for shell is UV's unix equivanent to DOS verb for windows.) I haven't used tee very much, but I *think* unix tee would capture stdout stderr from all child processes that said children don't explicitly redirect. IF that's right, I'd first try this approach for a general solution on unix: 1. replace the unix SH (On windows DOS) command with a wrapper that records the command that the user wants to run, then runs the user's command via tee. Execute that via SH.RESTRICTED 2. Create SH.RESTRICTED as an R-item pointing to vanilla NEWACC SH and use a remote control subroutine to make sure we got here via your custom SH wrapper. IF that works (I haven't tried any of it), it should automatically handle all existing SH usage already deployed in your ap. That's a unix approach; don't know windows DOS command. Please publish your solution once you've found one. Chuck bpar...@nemianlife.lu wrote: Hi all, We are using Universe 10.2.1 to run a Life Insurance application and we use the UV command line to carry out various database administration tasks. All other access is via the application, where all transactions are recorded to an audit trail. We have the auditors in at the moment and they are very interested in having a compulsory tracing of the command line sessions logged as if a COMO ON was issued as the first command however I don't know of any way to make this mandatory, i.e. not allow COMO OFF. Does any one know any better. Many thanks for any help. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Haydon Bishop is out of the office.
I will be out of the office starting 23/10/2009 and will not return until 02/11/2009. I will respond to your message when I return. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users