Re: use existing sql table for user-password

Hello, I just solved it with sql trigger. When a new user is created on other table, same user/password is inserted in radcheck table with auth-Type and other static variables. If password change occurs in other table, it updates radcheck table password field too. Thank you all for help. On

use existing sql table for user-password

Hello, I want to use freeradius for wireless authentication. I got an already installed mysql server, and some tables including usernames and passwords. I want to use this user/passwords with freeradius. How can it be possible? I will create a radius table to keep logs etc, but just to use

Re: use existing sql table for user-password

On Thursday, December 02, 2010 08:39:18 am Alan DeKok wrote: Oguzhan Kayhan wrote: Hello, I want to use freeradius for wireless authentication. I got an already installed mysql server, and some tables including usernames and passwords. I want to use this user/passwords with freeradius

Re: pptp + perl + freeradius???

The documents i mentioned above was about pptp installation not freeradius itself. Sure i read docs about freeradius also. Even your main README file.!! If you did read it, why did you do this: There were some other virtual servers running on that freeradius server, Just removed them for

pptp + perl + freeradius???

Hello, I am using a perl script to authenticate my users for hotspots with freeradius. I got no problem regarding to it. Now i planned to move my existing vpn server to freeradius also.. Read some howtos about it (with poptop mostly) Here is how my perl script works.. When it gets a username/pass

Re: pptp + perl + freeradius???

Ok, I am updating my question. I tried to make vpn work with inner-tunnel and it works via mysql without any problems. As i understand ms-chap asks the username to mysql. So, how can i use perl script instead of using mysql to authenticate??? Hello, I am using a perl script to authenticate my

Re: pptp + perl + freeradius???

Hello, I am using a perl script to authenticate my users for hotspots with freeradius. I got no problem regarding to it. Now i planned to move my existing vpn server to freeradius also.. Read some howtos about it (with poptop mostly) Perhaps reading freeradius documentation if you are to

delayed update on sql logging

Hi, I am checking simultaneous-use information, logged users etc on sql server. The problem is, if a user logges in, nearly after a minute later i can see the logged on user on mysql tables. But i can see the same user with radlast command in the same second the user logs in. So it seems like

Re: delayed update on sql logging

I am checking simultaneous-use information, logged users etc on sql server. The problem is, if a user logges in, nearly after a minute later i can see the logged on user on mysql tables. But i can see the same user with radlast command in the same second the user logs in. So it seems like

Re: delayed update on sql logging

I am checking simultaneous-use information, logged users etc on sql server. The problem is, if a user logges in, nearly after a minute later i can see the logged on user on mysql tables. But i can see the same user with radlast command in the same second the user logs in. So it seems like

Re: delayed update on sql logging

At the first try of sql i see the error rlm_sql (sql_lojnet): Couldn't insert SQL accounting START record - Column 'AcctStopTime' cannot be null Maybe that might be causing this... So how can i fix that??? Something is wrong with your schema. Default is: acctstoptime datetime NULL

Received radius reply from wrong address

Hi, i have 2 virtual servers with 2 ip addresses on same subnet.. For ex for virtserver1 192.168.1.10 virtserver2 192.168.1.11 I have a NAS Server (on a different ip subnet) with 2 different configs running on 2 different interfaces also. But as i see i got the msg Received radius reply from

Re: Received radius reply from wrong address

. Oguzhan Kayhan wrote: But as i see i got the msg Received radius reply from wrong address from them whenever i try to send a req to radius for authentication. You need to put the real IP addresses into the listen section. Don't use ipaddr = * It seems like radius answers back to the nas from

using nasid instead of client ip..

Hello, I have a server with mutliple ethernets working on. I need to run an authentication server(called chilli or coova) on 2 different ethernets which needed to authenticate with different radius servers. I am currently running my radius with virtual servers. The problem is, I created virtual

Re: using nasid instead of client ip..

And now when i try to run second different client software on same server, because the client ip still 192.168.0.15 it uses same virtual server on radius. Is there any other way to use different virtual server according to nasip for example??? You mean NAS-Identifier? Yes. Create two

Re: using nasid instead of client ip..

Ignore previous msg..Problem solved.my mistake.. :)) I just forgot the config.bck file on sites-enabled directory..so even i reconfigure the file it was still reading from the old one... And now when i try to run second different client software on same server, because the client ip still

priority in radcheck and radgroupcheck

Hi, I have a simultaneous-use information belongs to a users radgropcheck.. What i want is, if i enter a value to users radcheck, it should bypass the radgroupcheck value..how it is possible?? For now, whatever i make the simultaneous use value for user, it uses the default settings from the

RE: priority in radcheck and radgroupcheck

Message- From: freeradius-users-bounces+tnt=kalik@lists.freeradius.org [mailto:freeradius-users-bounces+tnt=kalik@lists.freeradius.org] On Behalf Of Oguzhan Kayhan Sent: 15 April 2009 12:50 To: freeradius-users@lists.freeradius.org Subject: priority in radcheck and radgroupcheck Hi

freeradius crashes if can not connect to mysql

Hello, I noticed that..if a network error or another connection problem occurs between freeradius and mysql server, freeradius service just exits... And sure service stops automatically. Is there any way to give a timeout value or retry number for mysql in freeradius configuration that prevents

Auth User update time on mysql

Hello i am keeping session information in mysql only.. What i notice is, when a user logs in, only after a few mins i see the sql tables are updated about this user. So, if i check max-session number via sql too, user can log in a few times because, the user can not be found as online on sql

sim-use check via perl

Hello, I am using a perl script to check the user-password couple. And also managed to add radreply. But i cant figure out where to add simultaneous-check. I mean it is checking sim. use but by default always only 1 usage. Even i add it to users data in mysql, it does not effect. By the way, do i

authentication delay in virtual servers

Hello, I have two virtual servers on my freeradius installation with one is made via mysql and other is via a perl script which is checking an xml page for user/pass control. What i noticed is, when the xml server is down if somebody tries to login from this virtual server, the other virtual

snmp problem

Hi, I am trying snmp on debian 32 bit. With freeradius 2.0.5. and net-snmp 5.4.1 I did all just like on http://wiki.freeradius.org/SNMP_HOWTO. Changed radiusd.conf as snmp= yes $INCLUDE snmp.con and remove comment on line smux_password = verysecret and added the line on snmpd.conf of

Re: snmp problem

Oguzhan Kayhan wrote: Hi, I am trying snmp on debian 32 bit. With freeradius 2.0.5. and net-snmp 5.4.1 Why are you running 2.0.5? It was the default package for debian. Ok we will recompile the new version and give a try. Thank you. I did all just like on http://wiki.freeradius.org

Strange Problem with chap.

Hello, I am using chilli-coova as hotspot and making its authentication via freeradius. I dont know if you have any experience with this software but, It has 2 kind of login pages. One is a cgi page with clean password, other is a java script making chap authentication. here is the problem. On

Re: Strange Problem with chap.

I am using chilli-coova as hotspot and making its authentication via freeradius. I dont know if you have any experience with this software but, It has 2 kind of login pages. One is a cgi page with clean password, other is a java script making chap authentication. here is the problem. On

freeradius- update radacct

Hello, I have freeradius virtual configurations. Until today all were working without a problem. But today i created a new one and i have a tiny problem about it. It doesnt update sql queries until the user logs off. SO i can not track the statistics of online users and transferred data etc via

Re: freeradius- update radacct

I have freeradius virtual configurations. Until today all were working without a problem. But today i created a new one and i have a tiny problem about it. It doesnt update sql queries until the user logs off. SO i can not track the statistics of online users and transferred data etc via mysql.

Re: freeradius- update radacct

I have freeradius virtual configurations. Until today all were working without a problem. But today i created a new one and i have a tiny problem about it. It doesnt update sql queries until the user logs off. SO i can not track the statistics of online users and transferred data etc via mysql.

Re: using radtest as a different client..

I just wonder if i can use radtest command as testing from a different client? Such as, Assume i have a client conf for 1.1.1.1 ip add. in my freeradius(2.2.2.2) server. And from 3.3.3.3 client(lets call client3) i am trying to test the connection.like radtest user pass 2.2.2.2 10 secret ??

using radtest as a different client..

Hello , I just wonder if i can use radtest command as testing from a different client? Such as, Assume i have a client conf for 1.1.1.1 ip add. in my freeradius(2.2.2.2) server. And from 3.3.3.3 client(lets call client3) i am trying to test the connection.like radtest user pass 2.2.2.2 10 secret

mod_radius error

Hello I am trying to use mod_radius on ubuntu. But i am getting error: Invalid command 'AddModule', perhaps misspelled or defined by a module not included in the server configuration. When i comment out the line with AddModule from httpd.conf i got the following error message. Invalid command

simultaneous-use check via sql

Hello I am trying to run Simultaneous-Use parameter on freeradius 2.0.5 which i have 2 virtual servers on. There can be same usernames on both virtual servers, so im not sure about how it works but i prefer to use sql instead of radutmp file for simultaneous check. Anyway, I added the following

Re: simultaneous-use check via sql

Oguzhan Kayhan wrote: I am trying to run Simultaneous-Use parameter on freeradius 2.0.5 which i have 2 virtual servers on. There can be same usernames on both virtual servers, so im not sure about how it works but i prefer to use sql instead of radutmp file for simultaneous check

Re: No authenticate method (Auth-Type)??

Oguzhan Kayhan wrote: But i got the following error when i test the config. auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user If you want to force authentication via the Perl module, you have to set that manually. Isn't the line

Re: No authenticate method (Auth-Type)??

} perl } 2008/8/4 Oguzhan Kayhan [EMAIL PROTECTED]: Oguzhan Kayhan wrote: But i got the following error when i test the config. auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user If you want to force

Re: No authenticate method (Auth-Type)??

} perl } 2008/8/4 Oguzhan Kayhan [EMAIL PROTECTED]: Oguzhan Kayhan wrote: But i got the following error when i test the config. auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user If you want to force

No authenticate method (Auth-Type)??

Hello, Im trying to use virtual server config for the freeradius. But i got the following error when i test the config. auth: No authenticate method (Auth-Type) configuration found for the request: Rejecting the user My config for the sites-enables is: --- listen {

RE: Perl_Tstack_sp_ptr

if you have different versions of perl and libperl installed on your system. Best Regards, Boian Jordanov SNE Orbitel - Next Generation Telecom tel. +359 2 4004 723 tel. +359 2 4004 002 On Aug 1, 2008, at 11:56 AM, Oguzhan Kayhan wrote: Hello, Im trying to install a server with debian

Perl_Tstack_sp_ptr

Hello, Im trying to install a server with debian with perl module. When i enable rlm_perl i got the following error. modules { Module: Checking authenticate {...} for more modules to load Module: Linked to module rlm_perl Module: Instantiating perl perl { module =

unix auth with mysql radreply

Hello, I setup a freeradius for chilli-coova. It uses both unix accounting (which main users are there) and mysql at the same time for accounting and logging. Just i have a little problem. If i create a user on mysql and give an attribute in radreply, it works

Re: Group Expiration Date

Hello, Try adding WISPr-Session-Terminate-Time parameter to radgroupreply. It should work, normally it works with radreply no reason for not working with group reply i think. Hi, I was try to find an answer for my question, but without success.. I wanted to ask if it is possible to set

Re: gigawords how to?

Opps..Sorry I just missed to type a , after outputoctets line. Problem solved. Hello, i tried to add gigawords for freeradius 2.0 And added the gigawords lines as i seen on web and final version was like this.. accounting_update_query = UPDATE ${acct_table1} \ SET FramedIPAddress

perl and ldap at the same time??

Hello, I wonder if i can make a dual authentication check via freeradius. I am using rlm_perl right now for our accounting needs. What i want is to add LDAP auth. Ofcourse i can add this function to perl script that i write but, it is better to use freeradius ldap function. So, is it possible to

error running perl

Hello, I am getting such an error when i try to run perl. symbol lookup error: /usr/lib/perl5/auto/DBI/DBI.so: undefined symbol: Perl_Tstack_sp_ptr Where should i check for debugging this error? What might be the possible reasons for that ? freeradius -X Starting - reading configuration files

using freeradius-failover with 2 servers

Hello, I am wondering if such scenario is possible. I want to use 2 freeradius servers for failover. It seems it wont be a problem if i use mysql backend for logging etc. But, I wonder what will happen about multiple login check. Because as i know freeradius also checks radutmp file if the user is

Re: segmentation fault over perl script.

hello i am trying to install freeradius over debian with perl support. I am running the same config with same perl script over ubuntu. I compiled 1.1.7 version, copied config files and script to same folder. and when i try to run it i get the folllowing output. Starting - reading

segmentation fault over perl script.

hello i am trying to install freeradius over debian with perl support. I am running the same config with same perl script over ubuntu. I compiled 1.1.7 version, copied config files and script to same folder. and when i try to run it i get the folllowing output. Starting - reading configuration

Re: radwho radzap problem

Hi again, I think i found a solution I dont know why but i had to give -d parameter to show the default config path, my config path is under freeradius but it searches for radiusd so..it made the problem. So is there a way to change default path for radzap/radwho etc? Hello, I am using rlm_perl

radwho radzap problem

Hello, I am using rlm_perl script for authentication. And logging radacct in sql. But it is strange that, i couldnt use radwho radzap radlast etc for a while.. had the error file not found etc.. So i manually created the files with touch. Now i can see theres records inside files, but still i cant

[no subject]

Hello, I just managed to authenticate with rlm_perl and logging via sql. But i got a few problems which i can not slove yet. First of all when i run freeradius with -x parameter.. I see some error messages as : rlm_sql_log (sql_log): Processing sql_log_accounting perl_pool: item 0x801243e0

[no subject]

Hello all, I am trying to figure out how to use rlm_perl module for authentication purposes. Whats in my mind is to use my existing IMAP server to check if account exists or not. On the wiki page of rlm_perl i see an example script as : # Function to handle accounting sub accounting { #

Re: rlm_exec and authentication

On Monday 03 December 2007 12:56:07 Alan DeKok wrote: Oguzhan Kayhan wrote: I wanna write an authentication script which will control the usernamepassword pair from an IMAP server. Acutally the script is about ready but, i couldt find a way to execute from radius. scripts/exec-program