bang star !* operator fixed?

2003-11-29 Thread Joe Maimon
Hello all,

I seem to recall that the !* operator was known to not be working. Not 
that I know much about the code, but this patch seems to activate the 
operator.

Joe
--- freeradius-0.9.0/src/main/valuepair.c   Thu Apr 10 14:09:03 2003
+++ freeradius-0.9.0-jm/src/main/valuepair.cWed Sep  3 21:36:31 2003
@@ -276,8 +276,14 @@
 *  Not found, it's not a match.
 */
if (auth_item == NULL) {
-   return -1;
+   if(check_item->operator == T_OP_CMP_FALSE)
+   return(0);
+   else
+   return -1;
}
+
+   if(check_item->operator == T_OP_CMP_FALSE)
+   return(-1);
 
/*
 *  We've got to xlat the string before doing


Problem with Proxying

2003-11-29 Thread Wichit Ngamsomhan
Proxying not work with prefix and suffix realm?
I proxy realm 'helloworld' to radius server,
But it forward to DEFAULT server only.

Wichit N.
--
modcall: entering group authorize for request 9
  modcall[authorize]: module "preprocess" returns ok for request 9
  modcall[authorize]: module "chap" returns noop for request 9
rlm_realm: No '/' in User-Name = "[EMAIL PROTECTED]", looking up realm
NULL
rlm_realm: Found realm "NULL"
rlm_realm: Proxying request from user [EMAIL PROTECTED] to realm NULL
rlm_realm: Adding Realm = "NULL"
rlm_realm: Preparing to proxy authentication request to realm "NULL"
  modcall[authorize]: module "realmslash" returns updated for request 9
rlm_realm: Request already proxied.  Ignoring.
  modcall[authorize]: module "suffix" returns noop for request 9
users: Matched DEFAULT at 152
  modcall[authorize]: module "files" returns ok for request 9
  modcall[authorize]: module "mschap" returns noop for request 9
modcall: group authorize returns updated for request 9
Sending Access-Request of id 7 to


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Error line 770 declaring No acceptable cc found in $PATH

2003-11-29 Thread Alex Redden
I have attempted to install the freeradius-0.9.3 onto a RH9.0 server and
have the following errors at ./configure:

No acceptable cc found in $PATH

When looking at the config.log I see:  Configure:770: checking for cc

I apologize for being somewhat of a newbie but I have googled, searched
and cannot find any related entries that will let me make sense of how
to proceed with this error. Of course it exits with a 1.

sh -x ./configure seems to have stopped at the line listed below:

+ test -z ''

I would be grateful for your assistance. Thank you in advance.

Alex

___
Alex F. Redden, MCSE, CCNA/CCAI, CCA
Senior Network Systems Engineer
Professional Network Administrators



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Event-Timestamp shows as string date when proxied

2003-11-29 Thread James Nedila
Shouldn't this be a long integer value?


  Why?  Doesn't it look like a date to you?

  Alan DeKok.

Yes, it does look like a date, but why the conversion from a fine 
grained timestamp, to a coarse date value?
Why not keep it the original value?

And where does the conversion happen, before it's proxied, or after it's 
received on the other side?

Thanks,
James


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Event-Timestamp shows as string date when proxied

2003-11-29 Thread Alan DeKok
James Nedila <[EMAIL PROTECTED]> wrote:
> I've noticed that Event-Timestamp is a date type, and requires a unix 
> timestamp.

  Sort of.

> But when I check my other radius servers to see what what proxied over, 
> radiusd in debug mode prints something like this:
> 
>  Event-Timestamp = "Nov 29 2003"
> 
> Is this correct?

  Yes.

> Shouldn't this be a long integer value?

  Why?  Doesn't it look like a date to you?

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Event-Timestamp shows as string date when proxied

2003-11-29 Thread James Nedila
I'm trying to send an Event-Timestamp attribute in my accounting 
requests, when proxying to other radius servers.

I've noticed that Event-Timestamp is a date type, and requires a unix 
timestamp.

But when I check my other radius servers to see what what proxied over, 
radiusd in debug mode prints something like this:

Event-Timestamp = "Nov 29 2003"

Is this correct?
Shouldn't this be a long integer value?
Thanks,
James


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


date type attribute not added to accounting request using attr_rewrite

2003-11-29 Thread James Nedila
freeradius-0.9.3

First, my rewrite config:

 attr_rewrite addEventTimestamp
  attribute = Event-Timestamp
  searchfor = NULL
  searchin = packet
  replacewith = "%l"
  new_attribute = yes
  max_matches = 1
  append = no
  }
This module is called in the pre-acct block of radiusd.conf.

radiusd in debug mode says:

modcall: entering group preacct for request 0
  modcall[preacct]: module "preprocess" returns noop for request 0
radius_xlat:  '1070149333'
rlm_attr_rewrite: Added attribute Event-Timestamp with value '1070149333'
  modcall[preacct]: module "addEventTimestamp" returns ok for request 0
So this returns correctly, but the attribute is never added to the request.

If I modify the dictionary entry for Event-Timestamp to integer, the 
attribute is added correctly.

Any ideas?
Thanks,
James




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Dialup Admin with PostgreSQL and NetSNMP support

2003-11-29 Thread Kostas Kalevras
On Fri, 28 Nov 2003, Guy Fraser wrote:

> Hmm...
>
> The updated version of dialup admin I sent in didn't seem to show
> up on the list.
>
> The attachment was 70kB, I presume thats why.
>
> Where should I send this updated source, so it can be tested, and
> put into the main source?

I 'd rather prefer a patch to the current CVS version rather than the whole
thing. Either put it on a web page somewhere, or send it to me directly. Though
i don't use postgresql

>
> --
> Guy Fraser
> Network Administrator
> The Internet Centre
> 780-450-6787 , 1-888-450-6787
>
> There is a fine line between genius and lunacy, fear not, walk the
> line with pride. Not all things will end up as you wanted, but you
> will certainly discover things the meek and timid will miss out on.
>
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]   National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Confusion over attribute types (date & integer)

2003-11-29 Thread Kostas Kalevras
On Sat, 29 Nov 2003, James Nedila wrote:

> I'm trying to add an attr_rewrite rule to add an Event-Timestamp
> attribute to outgoing accounting requests.
>
> I've tried this in 0.7.1, and now 0.9.3.
>
> This attribute is listed as a 'date' type in the dictionary.
> The date type looks just like an integer...  but what is the difference?
>
> Here's what i've got in my radiusd.conf:
>
>  attr_rewrite addEventTimestamp {
>  attribute = Event-Timestamp
>  searchfor = NULL
>  searchin = packet
>  replacewith = "%l"
>  new_attribute = yes
>  max_matches = 1
>  append = no
>  }
>
>
>
> When I send an accounting request, this module is called, and then
> segfaults.
>
> Here's what debug says:
>
> rad_recv: Accounting-Request packet from host 216.187.77.178:32804,
> id=159, length=174
>  NAS-Port-Type = Virtual
>  Service-Type = Framed-User
>  Framed-Protocol = PPP
>  Acct-Session-Id = "445864c128c9a6f5989600ea2d05f10b"
>  Acct-Status-Type = Stop
>  Acct-Authentic = RADIUS
>  NAS-Identifier = "FP_44"
>  User-Name = "some user name"
>  NAS-IP-Address = XXX.XXX.XXX.XXX
>  Called-Station-Id = "00:00:00:00:00:00"
>  Acct-Input-Octets = 0
>  Acct-Output-Octets = 0
>  Framed-IP-Address = 10.0.1.254
>  Calling-Station-Id = "00:00:00:00:00:00"
> modcall: entering group preacct for request 0
>modcall[preacct]: module "preprocess" returns noop for request 0
> radius_xlat:  '1070138162'
> Segmentation fault
>
>
>
> I've done some digging on this, and if I modify the dictionary entry for
> Event-Timestamp to integer, the segfaults go away.
>
> Also, gdb says this is dying on line 344 of rlm_attr_rewrite.c, which is
> a debug line.

Fixed, thanks

>
> So my questions are: how are dates different from integers?
> And how are they treated differently than integers?
>
> Thanks,
> James
>
>
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>

--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED]   National Technical University of Athens, Greece
Work Phone: +30 210 7721861
'Go back to the shadow' Gandalf

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Confusion over attribute types (date & integer)

2003-11-29 Thread James Nedila
I'm trying to add an attr_rewrite rule to add an Event-Timestamp 
attribute to outgoing accounting requests.

I've tried this in 0.7.1, and now 0.9.3.

This attribute is listed as a 'date' type in the dictionary.
The date type looks just like an integer...  but what is the difference?
Here's what i've got in my radiusd.conf:

attr_rewrite addEventTimestamp {
attribute = Event-Timestamp
searchfor = NULL
searchin = packet
replacewith = "%l"
new_attribute = yes
max_matches = 1
append = no
}


When I send an accounting request, this module is called, and then 
segfaults.

Here's what debug says:

rad_recv: Accounting-Request packet from host 216.187.77.178:32804, 
id=159, length=174
NAS-Port-Type = Virtual
Service-Type = Framed-User
Framed-Protocol = PPP
Acct-Session-Id = "445864c128c9a6f5989600ea2d05f10b"
Acct-Status-Type = Stop
Acct-Authentic = RADIUS
NAS-Identifier = "FP_44"
User-Name = "some user name"
NAS-IP-Address = XXX.XXX.XXX.XXX
Called-Station-Id = "00:00:00:00:00:00"
Acct-Input-Octets = 0
Acct-Output-Octets = 0
Framed-IP-Address = 10.0.1.254
Calling-Station-Id = "00:00:00:00:00:00"
modcall: entering group preacct for request 0
  modcall[preacct]: module "preprocess" returns noop for request 0
radius_xlat:  '1070138162'
Segmentation fault



I've done some digging on this, and if I modify the dictionary entry for 
Event-Timestamp to integer, the segfaults go away.

Also, gdb says this is dying on line 344 of rlm_attr_rewrite.c, which is 
a debug line.

So my questions are: how are dates different from integers?
And how are they treated differently than integers?
Thanks,
James


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


ACTUALIZACION TRIBUTARIA Y LABORAL

2003-11-29 Thread JORNADA
Title: Documento sin título








  
  






  
  
ATENCION:


DIRECTORES
  DE CONTABILIDAD, DE RECURSOS HUMANOS, REVISORES FISCALES Y CONTADORES. 

  
  



  
  






  
  
JORNADA
DE ACTUALIZACION
LABORAL Y TRIBUTARIA AÑO 2003
 
  
  
 
 
 



  
  



  1.
  ACTUALIZACION LABORAL AÑO 2003


  CONTRATACIÓN,
  LIQUIDACIONES LABORALES Y RETENCIÓN EN LA FUENTE.
  


   Conferencistas:
Dra. María Cristina Moreno
  y Dr. Eliécer Bello. 


  
  


  Fecha
  :
  Diciembre
  2, 3, 4 y 5 de 2003 


  Horario
  :
  De
  4:00 pm a 8:00 pm. 


  Lugar
  :
  Hotel
  Cosmos 100


  $260.000
  + IVA


  
  


    
    


  
  

  




  2.
  PLANEACION TRIBUTARIA AÑO 2003 
  


  QUE
  EL CIERRE CONTABLE SEA EL ADECUADO 
  PARA LA PRESENTACIÓN DE SU DECLARACIÓN 
  DE RENTA DEL AÑO 2003.
  


  
  
  
  
  


    Conferencista:
Dr. Henry Oswaldo Carvajal, 
   contador público con especialización
en impuestos. 
  


  
  
  
  
  


  Fecha
  :
  Diciembre
  3 y 4 de 2003 
  


  
  
  
  


  Horario
  :
  De
  4:00 pm a 8:00 pm. 
  


  Lugar
  :
  
  Hotel Cosmos 100 
  


  $170.000
  + IVA
  


  
  
  
  
  
  
  


  
  
   
  
  
  


  
  
  
  
  

  
  
  



  
  
 
 
 
 
 
 
  
  



  3.
  INFORMACION EXOGENA EN MEDIOS MAGNETICOS AÑO 2003


  
  
  
  
  
  
  
  
  
  


  Conferencista:
Dra. María del Pilar Roa, Directora
de información exógena de la 
DIAN y autora del Libro información exógena en medios
magnéticos para el año 2003. 
  
  
  
  
  


  
  
  Precio:
  $35.000 
   


  
  
  
  
  
  
  
  


  Fecha
  :
  Diciembre
  5 de 2003 
  
  
  
  
  
  


  $100.000
  + IVA
  
  
  


  
  
  
  
  


  Horario
  :
  De
  4:00 pm a 8:00 pm. 
  
  
  
  
  


  
  
  
  
  
  
  
  


  Lugar
  :
  Hotel
  Cosmos 100
  
  
  
  
  
  
  
  


  
    
   
  
  
  Incluye
  Libro
  
  


  
  
  
  
  
  
  


  
  
  
  
  
  
  
  
  


  
  
  
  
  
  
  
  
  
  

  
  
  
 
 
 
 
 
 
  
  
 INFORMES
:
259 04 35 - 526 54 85 - 481 76 07
[EMAIL PROTECTED]
www.rymrein.com 
  
  






  




- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: script to move account flat files to MySQL

2003-11-29 Thread Peter Nixon
[EMAIL PROTECTED] wrote:

Hello,

I am working on getting the radius account logs to write to
MySQL, in the mean time I am still logging accounting information
to flat files.
I am looking for a script that will take my daily accounting flat
files and insert them into MySQL.  Does anyone know of
any scripts that will do this?  I have been looking around and
have not found any. 
there is a script in src/accounting that can do this. It is currently 
h323 specific, although you can trivially modify it to work with the 
standard database schema.

Let me know if you have trouble with it..

Regards

Peter



- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Using deprecated naslist

2003-11-29 Thread Alan DeKok
"Anil Kumar" <[EMAIL PROTECTED]> wrote:
>   when i run my radius server its giving the following message in 
> the log file
> using deprecated naslist: support fo this will go away soon
>   is this an error.

  No.  It's clearly labelled as informational, and not an error.

>  and also please tell me how to specify the type field in naslist
>  my NAS client is procera switch

  You don't.  The switch isn't supported.  Submit patches to
checkrad.pl

  Alan DeKok.

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Postgresql Traffic Accounting Update

2003-11-29 Thread Peter Nixon
Didi Rieder wrote:

--On Friday, November 28, 2003 06:13:30 PM +0200 Peter Nixon 
<[EMAIL PROTECTED]> wrote:

In any case I have added your suggested changes to sql.conf in the
mainline cvs. However can you please double check your suggestions and
compare with Arthur's patch for postgres. His patch does some checks that
yours does not.. If you come up with a revised patch feel free to mail it
to me directly and I will commit it.


we use now the following query with freeradius 0.93, an Oracle database 
and Cisco NASes:

accounting_update_query = "UPDATE ${acct_table1} \
SET FramedIPAddress = NULLIF('%{Framed-IP-Address}', ''), \
AcctSessionTime = '%{Acct-Session-Time}', \
AcctInputOctets = '%{Acct-Input-Octets}', \
AcctOutputOctets = '%{Acct-Output-Octets}' \
WHERE \
AcctSessionId = '%{Acct-Session-Id}' AND \
UserName = '%{SQL-User-Name}' AND \
NASIPAddress= '%{NAS-IP-Address}' AND \
AcctStopTime IS NULL"
It works just fine since a few weeks.
OK. I have commited it to mainline cvs.

If you have time can you please compare the rest of the oracle queries 
to the ones in postgresql.conf and see if any of them can be used also. 
I believe they should pretty much "just work" on oracle, but I do not 
have an oracle box :-(

You may need to have a look at the postgres schema too..

Thanks

Peter

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Dialup Admin with PostgreSQL and NetSNMP support

2003-11-29 Thread Peter Nixon
Guy Fraser wrote:

Hmm...

The updated version of dialup admin I sent in didn't seem to show
up on the list.
The attachment was 70kB, I presume thats why.

Where should I send this updated source, so it can be tested, and
put into the main source?
Mail it to me directly..

Peter

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Using deprecated naslist

2003-11-29 Thread Anil Kumar

Hello,
  when i run my radius server its giving the following message in 
the log file
using deprecated naslist: support fo this will go away soon
  is this an error.
 and also please tell me how to specify the type field in naslist
 my NAS client is procera switch
Thanks in advance
  


- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html