CRV is not the same as Call-ID. You can extract the call id from approtiate fields of ARQ or Setup message. Be aware that the Call-ID is not always unique (in theory it should be, but practice shows different results). ----- Original Message ----- From: "Richard Tolley" <rich.tolley@xxxxxxxxxx> Sent: Monday, November 05, 2007 3:57 AM > Hi All > > I wonder if someone could help me out. > > I am currently using SQLAuth and SQLAccounting. > > Is there any way to expose the %{CallId} (as used in CDRs) to the SQLAuth > CallQuery..? If it were available it would save me hours. > > If there isn't a nice way of doing it I wonder if someone could pass > comment > on an idea below. > > > I don't use username %u and looking at the code for Q.931/H.225 Setup > message to be authenticated > > ---------------------------------------------------------------------------- > ------------------------------------------------------- > ORIGINAL CODE > > const PString traceStr = "SQLAUTH\t" + GetName() + "(Setup from " > + addr.AsString() + " CRV=" + > PString(setup.GetQ931().GetCallReference()) > + ")"; > params["callerip"] = addr.AsString(); > > // get the username for User-Name attribute > params["u"] = GetUsername(setup, authData); > > ---------------------------------------------------------------------------- > ------------------------------------------------------- > > > Would changing > > params["u"] = GetUsername(setup, authData); > > to > > params["u"] = PString(setup.GetQ931().GetCallReference()); > > > fix my problem? > > If not - can anyone advise if there is anything that would give me what I > need? > > > I'm very keen not to break anything but I can't stress how much easier my > life would be having the callID in my Auth Table. > > > Best Regards > > Rich ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________________ Posting: mailto:Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx Archive: http://sourceforge.net/mailarchive/forum.php?forum_name=openh323gk-users Unsubscribe: http://lists.sourceforge.net/lists/listinfo/openh323gk-users Homepage: http://www.gnugk.org/