<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Wireshark?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve used this network sniffing software in the past to look at Ingres connection details.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Some of it (e.g. opening a terminal session) is in text.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Download wireshark/winpcap and do a packet capture when you connect to Ingres as a test.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I’ve notes somewhere if you need them.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='mso-fareast-language:EN-GB'> info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> <b>On Behalf Of </b>Martin Bowes<br><b>Sent:</b> 06 October 2020 10:57<br><b>To:</b> 'Ingres lists' <info-ingres@lists.planetingres.org><br><b>Subject:</b> [Info-ingres] Snooping on another user session<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hi All,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I have a user whose connection details I wish to trap. Specifically their setting of date_type_alias.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>They are running a fairly complicated application and although we *<b>could in theory</b>* get it recut to include a select dbmsinfo(‘date_type_alias’), in practice that may be a lot harder than it sounds.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The error experienced by one (and only one) user would indicate they have connected with date alias of ansidate. Yet a scan of their client config says that should be ingresdate. I’ve trapped their connected activity with sc930 on the two installations on which the application is working but have not found any resetting of the date alias with a set date_alias ‘ansidate’ either. <o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Having looked at the session trace, I can provoke the error using a terminal monitor connection, but only if I set date_alias ‘ansidate’.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Ideas?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Martin Bowes <o:p></o:p></p></div></body></html>