Re:
body: - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
(no subject)
= Love, Kiran Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Freeradius+MySql (Authorization Query) - regexp
Hi
I am using the following query for authorization and I
am getting the error 1064 from MySql (PARSE ERROR).
But when I am giving the same query replacing the
variables with values, I am getting the output. Can
someone explain me why.
(select id,UserName,Attribute,Value,op from
${authreply_table} where username='%{SQL-User-Name}')
union (select id,UserName, Attribute,
concat('h323-credit-time=',round(substring(value,20)/(tas_rate+charge))*60)
Value,op from ${authreply_table}, pb_tariffs,surcharge
where \%{Called-Station-Id}\ regexp
concat(^,de_prefix) and value like
'h323-credit-amount=%' and username='%{SQL-User-Name}'
and dnis='%{Calling-Station-Id}' order by de_prefix
desc limit 1)
I am getting the error after adding 'regexp' to the
query.
Thanks,
Kiran
Yahoo! Messenger - Communicate instantly...Ping
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
PEAP and MS-CHAPv2
I have written a week ago about the problem that with PEAP and MS-CHAPv2 authentication the authentication is repeated every minute and that Windows XP (with Service Pack 1) never gets the Accept back. I am using the included X Supplicant from Windows XP. When I use the Aegeis Client it works. Now I tried the same thing with Radiator and there it works like it should. Knows someone about this problem, or is there maybe a problem with the PEAP code in freeradius? Thanks Berndt - TGM - Die Schule der Technik IT-Service A-1200 Wien, Wexstr. 19-23 Tel. +43(1)33126/316 Fax: +43(1)33126/154 E-Mail: [EMAIL PROTECTED] - - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Easy User Interface?
I've installed dialup admin although the it keeps looking for tables that we not created from the sql dump files That were included with it? Did I miss some ... It came with 4 sql files When I try to add a group it says this... Usergroup is not a table that is setup .. But how does dialup admin want the table to be setup?usually this would be defined in a sql file and make all the correct tables.. Database query failed: Table 'radius.usergroup' doesn't exist When I try to add a user it says this. Database query failed: Table 'radius.radcheck' doesn't exist - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
rlm_sql_mysql problem
dear all, i got message from my radius (freeradius-0.9.1) like this : rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. any suggest for this case ? Thanks, Andrés - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql problem
The driver should be installed into /usr/local/lib with the filename rlm_sql.la first check if the file exists there, and then check configure log, in the directory where U compiled the module, probably U are missing a library or any other required file, and that's why U couldn't compile the driver Pozdrawiam Przemek Bozek 33-25-564 - Original Message - From: Andrés de Barros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 3:52 PM Subject: rlm_sql_mysql problem dear all, i got message from my radius (freeradius-0.9.1) like this : rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. any suggest for this case ? Thanks, Andrés - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RES: rlm_sql_mysql problem
Check if you have all of the mysql's libraries on your system and if they are on the correct place. What's your system ( Linux / FreeBSD ) ?? Sergio Jose Ferreira WGO Internet Brazil -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nome de Przemek Bozek Enviada em: segunda-feira, 22 de dezembro de 2003 13:03 Para: [EMAIL PROTECTED] Assunto: Re: rlm_sql_mysql problem The driver should be installed into /usr/local/lib with the filename rlm_sql.la first check if the file exists there, and then check configure log, in the directory where U compiled the module, probably U are missing a library or any other required file, and that's why U couldn't compile the driver Pozdrawiam Przemek Bozek 33-25-564 - Original Message - From: Andrés de Barros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 3:52 PM Subject: rlm_sql_mysql problem dear all, i got message from my radius (freeradius-0.9.1) like this : rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. any suggest for this case ? Thanks, Andrés - 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
Dialup_admin Postgresql
Hi All, does anyone know if Dialup_admin works with PostgreSQL 7.3.4 ? I'm using RH9b with Freeradius 0.9.3. Thanks in advance. Roberto Fichera. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Dialup_admin Postgresql
Hi I did a bunch of work on Dialup Admin, and it works with PostgreSQL in CVS, I have just put up a patch site for the dialup_admin/bin scripts, but they have not been approved yet. This is where you can find the patch for the dialup_admin/bin scripts against the cvs : http://sphinx.incentre.net/ The instructions to get the cvs are at : http://www.freeradius.org/development.html#cvs Have a nice day Roberto Fichera wrote: Hi All, does anyone know if Dialup_admin works with PostgreSQL 7.3.4 ? I'm using RH9b with Freeradius 0.9.3. Thanks in advance. Roberto Fichera. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html -- 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
Limiting Users
How/Can freeradius limit the number of users logged into a certain NAS? Lets say I have 2 NASs with 120 ports apiece that I resell ports to other ISPs. I have one ISP that wants 24 ports at each location, and a second ISP that wants 24 ports at each location, how can I keep one ISP from spilling over their 24 ports? Anson Rinesmith Internet Operations Manager Big River Telephone Company 800-455-1608 x106 573-382-0555 www.bigrivertelephone.com Real People. Real Service. Real Simple. image001.jpg
Limit Ports used
How/Can freeradius limit the number of users logged into a certain NAS? Lets say I have 2 NASs with 120 ports apiece that I resell ports to other ISPs. I have one ISP that wants 24 ports at each location, and a second ISP that wants 24 ports at each location, how can I keep one ISP from spilling over their 24 ports? Anson Rinesmith
errors creating certificates
I am
trying to create some certificates and having problems. I am using Redhat 8.0
and openssl .9.7c. I am using the CA.all script found http://www.missl.cs.umd.edu/wireless/eaptls/doc/CA.all.
It seems to create the first certificate fine, then when it goes to create the
client and then the server I get the following error after I enter "y" to sign
the certificate. Can someone please help me figure this out?
Thanks!
Sign the certificate?
[y/n]:y-passin: No such file or directory14554:error:02001002:system
library:fopen:No such file or
directory:bss_file.c:276:fopen('-passin','r')14554:error:20074002:BIO
routines:FILE_CTRL:system lib:bss_file.c:278:No certificate matches private
key14556:error:0D07207B:asn1 encoding routines:ASN1_get_object:header too
long:asn1_lib.c:140:unable to load certificate14557:error:0906D06C:PEM
routines:PEM_read_bio:no start line:pem_lib.c:632:Expecting: TRUSTED
CERTIFICATE
freeradius sql accounting/simultaeneous use
I am running FreeRadius 0.9.3 and I currently have it
configured for Postgresql support. I want to make
Sure that it logs currently connected users as well as past
users who logged in into a SQL database.
I also want to make sure it correctly only allows a username
to connect only once. I have attached
a few lines from my configuration and make sure it is
correct.
session {
sql
}
accounting {
acct_unique
sql
}
Would having the above sections in my radiusd.conf be what I
am looking for to make this happen? I currently
have my accounting set to use radutmp which I think is why
it is saving the currently connected users into
the radutmp file instead of sql, plus I think with my
current config I probably have the simultaneous use feature
broken.
Any comments on this would be appreciated.
Devin Atencio
Re: Limiting Users
rlm_counter can be configured to limit things other than time. It should be possible to limit the number of calls that match some parameters. The parameter that should match would likely be Called-Station-Id or Realm to determine an ISP. Check the Archives there are probably some examples, I seem to recall this question being answered before. Anson Rinesmith wrote: How/Can freeradius limit the number of users logged into a certain NAS? Lets say I have 2 NASs with 120 ports apiece that I resell ports to other ISPs. I have one ISP that wants 24 ports at each location, and a second ISP that wants 24 ports at each location, how can I keep one ISP from spilling over their 24 ports? Anson Rinesmith Internet Operations Manager Big River Telephone Company 800-455-1608 x106 573-382-0555 www.bigrivertelephone.com http://www.bigrivertelephone.com - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[ADMIN] REMINDER: mailinglist address change
As was announced last week, the addresses of the mailinglists will change today. I'll change it after this message (with the old addresses in the headers) is queued to all list members. Original announcement below: From: Miquel van Smoorenburg [EMAIL PROTECTED] Date: Thu, 18 Dec 2003 16:14:10 +0100 Subject: [ADMIN] IMPORTANT: List address change Message-ID: [EMAIL PROTECTED] Next monday, the addresses of the freeradius lists will change. The lists will migrate to the freeradius.org domain. This means that instead of mailing to [EMAIL PROTECTED] you then need to mail to [EMAIL PROTECTED] Mail you receive from the list is now sent with the envelope-sender address [EMAIL PROTECTED], that will change to [EMAIL PROTECTED] And the webinterface that now runs at http://lists.cistron.nl/ will move to http://lists.freeradius.org/ Same goes for the freeradius-devel and freeradius-announce lists. As you can see, it's a simple matter of s/cistron.nl/freeradius.org/g The old [EMAIL PROTECTED] (etc) addresses will remain working for the forseeable future. The most important thing is that if you filter your mail into folders based on the To:/Cc: or Return-Path: headers, you need to update your filter rules to also filter correctly for the new addresses. Also, please whitelist the new addresses in any spam/TDMA like systems if you're running something like that. Your listmaster, Mike. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: freeradius without libtool
Arindam Roy [EMAIL PROTECTED] wrote: I know the question might sound silly, but do you know of any way of compiling freeradius without libtool, with all the modules as static modules. ./configure --disable-shared ? It still needs libtool, though. The API's used to link the modules are supplied by libtool. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: Freeradius+MySql (Authorization Query) - regexp
=?iso-8859-1?q?Kiran?= [EMAIL PROTECTED] wrote:
I am using the following query for authorization and I
am getting the error 1064 from MySql (PARSE ERROR).
But when I am giving the same query replacing the
variables with values, I am getting the output. Can
someone explain me why.
Look at the SQL debug log file. It will have the queries with the
variables replaced by values.
(select id,UserName,Attribute,Value,op from
${authreply_table} where username='%{SQL-User-Name}')
union (select id,UserName, Attribute,
concat('h323-credit-time=',round(substring(value,20)/(tas_rate+charge))*60)
Value,op from ${authreply_table}, pb_tariffs,surcharge
where \%{Called-Station-Id}\ regexp
concat(^...
A double quote inside of a double-quoted string?
I am getting the error after adding 'regexp' to the
query.
Then what you added is the source of the problem.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: rlm_sql_mysql problem
RedHat 8.0 work ok, thanks Andrés de Barros - Original Message - From: Sérgio José Ferreira [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 12:08 PM Subject: RES: rlm_sql_mysql problem Check if you have all of the mysql's libraries on your system and if they are on the correct place. What's your system ( Linux / FreeBSD ) ?? Sergio Jose Ferreira WGO Internet Brazil -Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nome de Przemek Bozek Enviada em: segunda-feira, 22 de dezembro de 2003 13:03 Para: [EMAIL PROTECTED] Assunto: Re: rlm_sql_mysql problem The driver should be installed into /usr/local/lib with the filename rlm_sql.la first check if the file exists there, and then check configure log, in the directory where U compiled the module, probably U are missing a library or any other required file, and that's why U couldn't compile the driver Pozdrawiam Przemek Bozek 33-25-564 - Original Message - From: Andrés de Barros [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 22, 2003 3:52 PM Subject: rlm_sql_mysql problem dear all, i got message from my radius (freeradius-0.9.1) like this : rlm_sql (sql): Could not link driver rlm_sql_mysql: file not found rlm_sql (sql): Make sure it (and all its dependent libraries!) are in the search path of your system's ld. radiusd.conf[14]: sql: Module instantiation failed. any suggest for this case ? Thanks, Andrés - 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
rlm_sqlcounter problem
dear all, I got message from my radius (freeradius-0.9.1), RedHat 8.0, like this : rlm_sqlcounter: coult not find check item value pair. any suggest for this case ? - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
