Proxim AP-700 AcctUniqueId
Hello i have a Problem with the Proxim AP700 to get a Unique Session ID or AcctUniqueId There only MAC Authentication. Has anyone Experience with the AP-700. To avoidance that more than one record for a session in the radacct-table i have made Username and AcctUniqueID Unique. The Problem is that the AP-700 deliver only this Information : As rad_recv: Access-Request packet from host 192.168.0.232:6001, id=9, length=125 User-Name = "001195-0942e8" User-Password = "secret" NAS-IP-Address = 192.168.0.232 Called-Station-Id = "00-20-a6-56-38-ff:wireless-people-AP002" Calling-Station-Id = "00-11-95-09-42-e8" NAS-Port = 0 Processing the authorize section of radiusd.conf There missing the Framed-IP-Adress and the Acctsession-ID is the MAC from the Calling Station with this Information the Unique session Id is alway for this User the same and after a separation the Radius write in the same record. So i get 1 record per User and Month but only for the latest session. I hope you can help me. Sorry for this long posting and my english As Start from the AP comes User-Name = "000f3d-47ba87" Acct-Session-Id = "000f3d-47ba87" NAS-Identifier = "Wireless-People-AP001" NAS-IP-Address = 192.168.0.231 NAS-Port = 2 NAS-Port-Type = Wireless-802.11 Acct-Authentic = RADIUS Acct-Status-Type = Start Acct-Input-Octets = 0 Acct-Output-Octets = 0 Acct-Session-Time = 0 Acct-Input-Packets = 0 Acct-Output-Packets = 0 Acct-Terminate-Cause = 0 Acct-Delay-Time = 0 As Alive comes User-Name = "001195-0a21d8" Acct-Session-Id = "001195-0a21d8" NAS-Identifier = "Wireless-People-AP001" NAS-IP-Address = 192.168.0.231 NAS-Port = 2 NAS-Port-Type = Wireless-802.11 Acct-Authentic = RADIUS Acct-Status-Type = Alive Acct-Input-Octets = 0 Acct-Output-Octets = 0 Acct-Session-Time = 608 Acct-Input-Packets = 0 Acct-Output-Packets = 0 Acct-Terminate-Cause = 999 Acct-Delay-Time = 0 With this Information the freeradius don't create a UniqueSessionId, so i think i make the unique by mysql with this statement: accounting_start_query = "select @sesid := MD5(Concat(count(*),'%{Calling-Station-Id}', '%{NAS-IP-Address}',now())) FROM ${acct_table1};INSERT into ${acct_table1}(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId,CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('%{Acct-Session-Id}', @sesid, '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')" In MySQL the Statement with filled values is write a correct record, from FreeRadius i get fail, the same Statement in MySQL brings OK and the data insert in the Table. I not see what is wrong rlm_sql (sql): sql_set_user escaped user --> '001195-0942e8' radius_xlat: 'select @sesid := MD5(Concat(count(*),'', '192.168.0.232',now())) FROM radacct;INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('001195-0942e8', @sesid, '001195-0942e8', '', '192.168.0.232', '2', 'Wireless-802.11', '2005-07-26 02:03:20', '0', '0', 'RADIUS', '', '', '0', '0', '', '', '', '', '', '', '0', '0')' radius_xlat: '/var/log/freeradius/sqltrace.sql' rlm_sql (sql): Reserving sql socket id: 5 rlm_sql_mysql: query: select @sesid := MD5(Concat(count(*),'', '192.168.0.232',now())) FROM radacct;INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime,AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('001195-0942e8', @sesid, '001195-0942e8', '', '192.168.0.232', '2', 'Wireless-802.11', '2005-07-26 02:03:20', '0', '0', 'RADIUS', '', '', '0', '0', '', '', '', '', '', '', '0', '0') rlm_sql_mysql: MYSQL check_error: 1064 received rlm_sql (sql): Couldn't insert SQL accounting START record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Rea radius_xlat: 'select @sesid := AcctUniqueId, @matime :=max(AcctStartTime) from radacct Where UserName = '001195-0942e8' and A
AW: Proxim AP-700 AcctUniqueId
> "Uwe Driessen" <[EMAIL PROTECTED]> wrote: > > There missing the Framed-IP-Adress and the Acctsession-ID > is the MAC > > from the Calling Station with this Information the Unique > session Id > > is alway for this User the same and after a separation the Radius > > write in the same record. > > The packet you quoted is an Access-Request, and doesn't > contain Accounting-Session-Id. The FreeRADIUS "unique" id > doesn't apply here, either. > > Alan DeKok. My Problem is that there is nothing Acct-Session-Id comming from the AP700. As Acct-Session-Id this AP sends the MAC off the Client no counter or other unique's for this Session. I quotet a Start and a Alive Paket how Radius -X it gives out on the screen. Is there anyone who has AP-700 in Hotspot with accounting? Can anyone tell me what i can do to use this AP as Hotspot? From Proxim i get anser that there is no unique Acct-Sesion-ID and no Framed-IP-Adress to deliver from AP to Radius. I thought could generate the Acct-Unique-Id with MySQL and select before the update write to the table. How can i do 2 sql Statements in one Radius funktion to do so. Thanks for the ansers. Mit freundlichen Grüßen Uwe Drießen - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AW: sementation fault
> -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von vicky > It tries to insert to a table 'radpostauth' that doesn't > exist and further more there are no tables at all in the > database. Is that normal? > > Please help me shed some light on this, > Generate the Database and make sure the rigth connect infos in the sql.conf Read : http://www.frontios.com/freeradius.html Setting up the RADIUS database in MySQL First, you should a new empty 'radius' database in MySQL and login user with permissions to that database. You could of course call the database and the user anything you like but we'll stick to 'radius' for both for the purposes of this discussion Next up, you need to create the schema for the database. There is a file which describes this and is actually a SQL script file. It can be found at /src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql where you untar'd FreeRadius. This is the bit that, at least at the time I originally wrote these notes, wasn't really documented anywhere and was the thing most people seemed to be asking. How you run that script is up to you and how you like to admin MySQL. The easiest way is to: mysql -uroot -prootpass radius < db_mysql.sql ...where 'root' and 'rootpass' are your mysql root name and password respectively. Mit freundlichen Grüßen Drießen Es liegt was in der Luft www.feilbingert.net Uwe Drießen Software & Computer Lembergstraße 33 67824 Feilbingert Tel.: 06708 660045 Fax 06708 661397 www.edv-driessen.de - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AW: segmentation fault
> > > >Please post the gdb output. Follow the instructions at: > >http://www.freeradius.org/radiusd/doc/bugs > > > > > Nicolas, > > Here is the output of gdb. Thanks a lot for your help! > > --Vicky > Hello Vicky Look at your database that the user you have in your sql.conf is right to your database Make a new User "Radius" with password and right of select,insert,update on the database Radius. Put the data from this User in your sql.conf and test it too. Control that your Mysql is running at the ip and port you say in the conf (3330???)(I think that the port is not korrekt) If that not correct the problem I Think you have an Compiler failer there are a lot of dokuments when you google about "mysql Program received signal SIGSEGV, Segmentation fault" Mit freundlichen Grüßen Drießen Es liegt was in der Luft www.feilbingert.net Uwe Drießen Software & Computer Lembergstraße 33 67824 Feilbingert Tel.: 06708 660045 Fax 06708 661397 www.edv-driessen.de - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AW: Using a database schema other than the one created by db_mysql.sql
> Auftrag von Ana Bizarro > Gesendet: Dienstag, 2. August 2005 22:35 > An: freeradius-users@lists.freeradius.org > Betreff: Using a database schema other than the one created > by db_mysql.sql > > Hi, > > We have a (mysql) database where we have usernames and > passwords and I recently installed freeradius on our server. > I would like the freeradius server to authenticate using the > database but, obviously, our database schema is completely > different than the one created by db_mysql.sql. > > All the documentation (and examples) I've seen so far mention > the db_mysql.sql script (even in the RADIUS book) and I was > wondering, if it's possible to use our own database, how do I > tell RADIUS that "uid" in the users table is the username and > "pwd" is the password? > For the tables names, I'm assuming I can just change the > sql.conf file and replace whatever is inside " " by our own > table names > Like: > usergroup_table = "usergroup" > replace by > usergroup_table = "users" > > > Thanks, > -Ana And for all the Other you write the SQL Statements to your Tablefields you have For a update like Tablefield = '%s' for date and Time in this field for the AcctstopTime and so on where is the Problem, The Statements in the sql.conf are pure SQL. And the Insert's as so too Mit freundlichen Grüßen Drießen Es liegt was in der Luft www.feilbingert.net Uwe Drießen Software & Computer Lembergstraße 33 67824 Feilbingert Tel.: 06708 660045 Fax 06708 661397 www.edv-driessen.de - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AW: Authentication problem
Post the output from starting Radius -X perhaps there we can see what is the Problem Mit freundlichen Grüßen Drießen Es liegt was in der Luft www.feilbingert.net Uwe Drießen Software & Computer Lembergstraße 33 67824 Feilbingert Tel.: 06708 660045 Fax 06708 661397 www.edv-driessen.de > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von Hamid Salim > Gesendet: Mittwoch, 3. August 2005 15:39 > An: freeradius-users@lists.freeradius.org > Betreff: Authentication problem > > Hi all, > i was wondering if anyone has successfully implemented the > following setup and/or had any issues. this is my second > post. your help will be greatly appreciated. > > > I have a setup as follows: > > Fedora core 3 > FreeRadius 1.0.4 > openssl .098 > Dell TrueMobile 1170 Access Pointv2.3.3 > 802.11b/g cards for AP and supplicant > Windows XP SP2 > > FreeRadius is not authenticating, there are no messages on > the screen or the logfile. The AP does not see the FreeRadius server! > > I think this is a configuration issue outside of FreeRadius. > > Has anyone had similar problem. > > Any help will be greatly appreciated as i have hit a wall > here and i am on a deadline! > > thanks > Hamid. > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
AW: freeradius with auth Mac addresses
Betreff: freeradius with auth Mac addresses and in users 000F20-93DD75 Auth-TYPE := Local, User-Password == "passecret" Write your MAC as 00-0f-20-93-dd-75 and the letters in smal Thats all Mit freundlichen Grüßen Drießen Es liegt was in der Luft www.feilbingert.net Uwe Drießen Software & Computer Lembergstraße 33 67824 Feilbingert Tel.: 06708 660045 Fax 06708 661397 www.edv-driessen.de - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html