Greate . It's workink fine . Thanks.
But now , " 03:44:37.370 GMT Mon Jun 14 2004" is not a good date format ,
how I can change it ???
Thanks in advanced
Fabio
----- Original Message -----
From: "yudhi kukuh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 14, 2004 5:50 AM
Subject: Re: Freeradius for Voip
> hi,
>
> you can activate:
>
> preprocess {
> huntgroups = ${confdir}/huntgroups
> hints = ${confdir}/hints
> with_ascend_hack = no
> ascend_channels_per_line = 23
> with_ntdomain_hack = no
> with_specialix_jetstream_hack = no
> ######### to get only VSA value on database ##########
> with_cisco_vsa_hack = yes
> #########################
> }
>
> best regards,
>
> ...... Yudhi Kukuh
> PT Satya Digital Integrasi
> Ph +62 21 70772543 / 7992977
> Fax +62 21 86901650 / 7992977
> Mobile +62 818781616
> E-Mail [EMAIL PROTECTED]
> Visit www.satyadigital.com
> 'A New Style of Data Integration'
> ----- Original Message -----
> From: "Fabio Viracao" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 14, 2004 11:11 AM
> Subject: Re: Freeradius for Voip
>
>
> > Hi
> >
> > Using VSA_HACK I can remove the "h323-xxxxx-time=" from my db , now how
> can
> > I insert the date in a "good" format to the DB
> >
> > , any sugestion ?
> >
> > 03:44:37.370 GMT Mon Jun 14 2004
> >
> > Thanks
> > Fabio
> >
> >
> > ----- Original Message -----
> > From: "Fabio Viracao" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, June 13, 2004 11:50 PM
> > Subject: Re: Freeradius for Voip
> >
> >
> > > Hi Folks;
> > >
> > > Can someone help-me how to insert the following to mysql ??, I do not
> want
> > > to insert " h323-xxxx-time" only the date.
> > >
> > > h323-connect-time = "h323-connect-time=01:14:40.329 GMT Sat Jun 12
> > 2004"
> > > h323-disconnect-time = "h323-disconnect-time=01:14:40.329 GMT Sat
Jun
> > 12
> > > 2004"
> > >
> > > Thanks
> > > Fabio
> > >
> > >
> > > ----- Original Message -----
> > > From: "ROY" <[EMAIL PROTECTED]>
> > > To: "freeradius-users" <[EMAIL PROTECTED]>
> > > Sent: Friday, March 12, 2004 5:14 PM
> > > Subject: Re: Freeradius for Voip
> > >
> > >
> > > > are you using a cisco box?
> > > >
> > > > if you are.. then.. cisco usually sends date/time in the ff format:
> > > >
> > > > 04:07:39.631 HKG Sat Mar 13 2004
> > > >
> > > > Note that NAS text timezone is set at HKG (which is +0800)..
> > > > unfortunately.. Postgresql doesn't support the 'HKG' as a standard
> text
> > > > timezone.. hence.. had to change it to a recognized +0800 which is
> CCT.
> > > >
> > > > See the link below..
> > > > http://developer.postgresql.org/docs/postgres/datetime-keywords.html
> > > >
> > > >
> > > > hence.. the function
> > > >
> > > > CREATE OR REPLACE FUNCTION mychg_tz (VARCHAR) RETURNS TEXT AS '
> > > > DECLARE
> > > > date_tz ALIAS FOR $1;
> > > > BEGIN
> > > > return translate(date_tz,''HKG'',''CCT'');
> > > > END;
> > > > ' LANGUAGE 'plpgsql';
> > > >
> > > >
> > > >
> > > > On Fri, 2004-03-12 at 17:30, Costin Manda wrote:
> > > > > ----- Original Message -----
> > > > > From: "ROY" <[EMAIL PROTECTED]>
> > > > > To: "freeradius-users" <[EMAIL PROTECTED]>
> > > > > Sent: Friday, March 12, 2004 4:52 AM
> > > > > Subject: Re: Freeradius for Voip
> > > > >
> > > > >
> > > > > > I think I've ran into this too..
> > > > > > The problem was with text timezone not being recognized by
> Postgres.
> > > > > >
> > > > > > Here's what I've done:
> > > > >
> > > > > > NAS_TZ = NAS timezone text (not recognized by Postgres)
> > > > > > SQL_TZ = equivalent timezone text recognized by Postgres
> > > > >
> > > > > Can you give me an example? how would NAS_TZ and SQL_TZ look
like?
> > > > >
> > > > > > strip_dot(mychg_tz('%{h323-disconnect-time}'))
> > > > >
> > > > > I get the same errors, even if I used "<NAS_TZ>" in the function
> as
> > I
> > > > > didn't know what you meant :)
> > > > >
> > > > > BTW, I have looked into the SQL trace, all the calls to the
> > strip_dot
> > > > > functions look like strip_dot(''). There is nothing between the
> > > parantesae.
> > > > >
> > > > >
> > > > > -
> > > > > List info/subscribe/unsubscribe? See
> > > http://www.freeradius.org/list/users.html
> > > > >
> > > >
> > > >
> > > > -
> > > > List info/subscribe/unsubscribe? See
> > > http://www.freeradius.org/list/users.html
> > > >
> > > >
> > >
> > >
> > >
> > > -
> > > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
> > >
> >
> >
> >
> > -
> > List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
> >
> >
> >
> > ---
> >
> >
>
>
>
> -
> List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
>
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
