<div>To Mr. Alan.</div>
<div>i'v heard about what's called SLACKWARE </div>
<div>so is it better than REDHAT or what?<br><br> </div>
<div><span class="gmail_quote">On 2/12/07, <b class="gmail_sendername"><a href="mailto:freeradius-users-request@lists.freeradius.org">freeradius-users-request@lists.freeradius.org</a></b> <<a href="mailto:freeradius-users-request@lists.freeradius.org">
freeradius-users-request@lists.freeradius.org</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Send Freeradius-Users mailing list submissions to<br> <a href="mailto:freeradius-users@lists.freeradius.org">
freeradius-users@lists.freeradius.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.freeradius.org/mailman/listinfo/freeradius-users">http://lists.freeradius.org/mailman/listinfo/freeradius-users
</a><br>or, via email, send a message with subject or body 'help' to<br> <a href="mailto:freeradius-users-request@lists.freeradius.org">freeradius-users-request@lists.freeradius.org</a><br><br>You can reach the person managing the list at
<br> <a href="mailto:freeradius-users-owner@lists.freeradius.org">freeradius-users-owner@lists.freeradius.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Freeradius-Users digest..."
<br><br><br>Today's Topics:<br><br> 1. need a help.... (silvia bogos)<br> 2. Error: Ignoring request from unknown client IP:1645<br> (Davide Molteni)<br> 3. Re: need a help.... (Alan DeKok)<br> 4. Re: Error: Ignoring request from unknown client IP:1645
<br> (Alan DeKok)<br> 5. Re: rlm_eap_tls: No SSL info available. Waiting for more SSL<br> data (Norbert Wegener)<br> 6. Re: rlm_eap_tls: No SSL info available. Waiting for more SSL<br> data (Alan DeKok)<br> 7. Segmentation fault (core dumped) -
freeradius-1.1.4<br> (adreas Polyxronopoulos)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 12 Feb 2007 13:56:35 +0200<br>From: "silvia bogos" <
<a href="mailto:silvia.bogos@gmail.com">silvia.bogos@gmail.com</a>><br>Subject: need a help....<br>To: <a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a><br>Message-ID:<br>
<<a href="mailto:13e227190702120356j6667c2b9vceee567ff3864939@mail.gmail.com">13e227190702120356j6667c2b9vceee567ff3864939@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>
Hi list.<br>im so happy that im now one of this list members<br>so can any one from u help me in freeradius installation and config.<br>coz im new in this domain and i will b so thankfull<br><br>silvia<br>-------------- next part --------------
<br>An HTML attachment was scrubbed...<br>URL: <a href="https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070212/949ef475/attachment-0001.html">https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070212/949ef475/attachment-0001.html
</a><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 12 Feb 2007 12:58:43 +0100<br>From: Davide Molteni <<a href="mailto:d.molteni@ntsitalia.com">d.molteni@ntsitalia.com</a>><br>Subject: Error: Ignoring request from unknown client IP:1645
<br>To: <a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a><br>Message-ID: <1171281523.12482.19.camel@PRT-TOSHIBA><br>Content-Type: text/plain<br><br>I made this very simple environmet for testing purpuse but I can't get
<br>it work...<br><br>I have a cisco 1750 router with IOS 12.1(5)IB4 and configured it to<br>access a radius server made with phpRADmin livecd (fedora5+freeradius)<br><br>On the cisco I configured:<br>radius-server host ipmyradius auth-port 1812 acct-port 1813
<br>and the other aaa commands needed<br><br>If I look at the radius.log file I always see<br><br>Error: Ignoring request from unknown client ipmycisco:1645<br><br>The Cisco router keeps always trying to connect to radius using port
<br>1645 even if I specified to use 1812... I have tried to configure radius<br>server to listen on port 1645 but is the same.<br>Obviously the shared key is the same on both sides.<br><br>I even tried with a clean installation of freeradius on a plain debian
<br>but I get the same error in the logs...<br><br>The microsoft radius integration(server 2003) worked at first try with<br>this cisco config...<br><br>Please any help?<br><br><br><br>------------------------------<br><br>
Message: 3<br>Date: Mon, 12 Feb 2007 13:33:49 +0100<br>From: Alan DeKok <<a href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>><br>Subject: Re: need a help....<br>To: FreeRadius users mailing list
<br> <<a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>><br>Message-ID: <<a href="mailto:45D05EAD.9060308@deployingradius.com">45D05EAD.9060308@deployingradius.com
</a>><br>Content-Type: text/plain; charset=ISO-8859-1<br><br>silvia bogos wrote:<br>> Hi list.<br>> im so happy that im now one of this list members<br>> so can any one from u help me in freeradius installation and config.
<br><br>The documentation exists, and covers these topics.<br><br>Do you have *specific* questions about something that's going wrong,<br>or something you don't understand?<br><br>Alan DeKok.<br>--<br><a href="http://deployingradius.com">
http://deployingradius.com</a> - The web site of the book<br><a href="http://deployingradius.com/blog/">http://deployingradius.com/blog/</a> - The blog<br><br><br>------------------------------<br><br>Message: 4<br>
Date: Mon, 12 Feb 2007 13:35:48 +0100<br>From: Alan DeKok <<a href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>><br>Subject: Re: Error: Ignoring request from unknown client IP:1645<br>To: <a href="mailto:d.molteni@ntsitalia.com">
d.molteni@ntsitalia.com</a>, FreeRadius users mailing list<br> <<a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>><br>Message-ID: <<a href="mailto:45D05F24.4060505@deployingradius.com">
45D05F24.4060505@deployingradius.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1<br><br>Davide Molteni wrote:<br><br>> On the cisco I configured:<br>> radius-server host ipmyradius auth-port 1812 acct-port 1813
<br>> and the other aaa commands needed<br>><br>> If I look at the radius.log file I always see<br>><br>> Error: Ignoring request from unknown client ipmycisco:1645<br><br>Did you configure the server to have that IP in "
clients.conf"?<br><br>> The Cisco router keeps always trying to connect to radius using port<br>> 1645 even if I specified to use 1812...<br><br>That's a bug in the Cisco router.<br><br>> I have tried to configure radius
<br>> server to listen on port 1645 but is the same.<br><br>Listening on port 1645 won't make the server believe that "ipmycisco"<br>is a known client.<br><br>> The microsoft radius integration(server 2003) worked at first try with
<br>> this cisco config...<br><br>Really. Did you configure the Cisco box as a client in the MS RADIUS<br>server?<br><br>Alan DeKok.<br>--<br><a href="http://deployingradius.com">http://deployingradius.com</a> - The web site of the book
<br><a href="http://deployingradius.com/blog/">http://deployingradius.com/blog/</a> - The blog<br><br><br>------------------------------<br><br>Message: 5<br>Date: Mon, 12 Feb 2007 13:51:54 +0100<br>From: Norbert Wegener <
<a href="mailto:norbert.wegener@siemens.com">norbert.wegener@siemens.com</a>><br>Subject: Re: rlm_eap_tls: No SSL info available. Waiting for more SSL<br> data<br>To: FreeRadius users mailing list<br> <<a href="mailto:freeradius-users@lists.freeradius.org">
freeradius-users@lists.freeradius.org</a>><br>Message-ID: <<a href="mailto:45D062EA.1090403@siemens.com">45D062EA.1090403@siemens.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br><br>Alan DeKok wrote:
<br>> Norbert Wegener wrote:<br>><br>>> I have setup freeradius-1.1.4 for 802.1x authentication and tested it<br>>> successfully using eapol_test.<br>>> When I try to authenticate a voip phone, that uses the same certificate
<br>>> as I used before with eapol_test, authentication fails.<br>>><br>><br>> Different implementations, different issues...<br>><br>><br>>> 'Waiting for more SSL data' seems to be the interesting point.
<br>>> freeradius is obviously waiting for some data from the client.<br>>><br>><br>> And the client is probably waiting for more data from FreeRADIUS.<br>><br>><br>>> Is there anything I can configure on the server side or is this a
<br>>> problem with the switch/ the voip phone?<br>>><br>><br>> I would label it a bug with the client. But I'm biases.<br>><br>Is there anything I can do on the freeradius side to prove,<br>that the voip phone's
802.1x implementation is broken?<br>Up to now I could not convince the vendor's salesperson, that there is a<br>problem with his phone.<br>Norbert Wegener<br><br><br><br>> My worry is that "fixing" it on the server could mean breaking
802.1x<br>> for other clients. That's a non-starter.<br>><br><br>> Alan DeKok.<br>> --<br>> <a href="http://deployingradius.com">http://deployingradius.com</a> - The web site of the book<br>>
<a href="http://deployingradius.com/blog/">http://deployingradius.com/blog/</a> - The blog<br>> -<br>> List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html
</a><br>><br><br><br><br><br>------------------------------<br><br>Message: 6<br>Date: Mon, 12 Feb 2007 14:27:43 +0100<br>From: Alan DeKok <<a href="mailto:aland@deployingradius.com">aland@deployingradius.com</a>>
<br>Subject: Re: rlm_eap_tls: No SSL info available. Waiting for more SSL<br> data<br>To: FreeRadius users mailing list<br> <<a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org
</a>><br>Message-ID: <<a href="mailto:45D06B4F.5010900@deployingradius.com">45D06B4F.5010900@deployingradius.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1<br><br>Norbert Wegener wrote:<br>> Is there anything I can do on the freeradius side to prove,
<br>> that the voip phone's 802.1x implementation is broken?<br><br>Well, FreeRADIUS works with every *other* 802.1x client out there,<br>including Vista. This means MAC OSX, all versions of Windows, Linux,<br>FreeBSD, NetBSD, Solaris, etc.
<br><br>> Up to now I could not convince the vendor's salesperson, that there is a<br>> problem with his phone.<br><br>Point him at the survey page on the FreeRADIUS web site. Ask him if<br>he's going to intentionally sell a product that doesn't work with the #1
<br>RADIUS server on the planet. Ask him why his phone won't work with 1/3<br>or more of the installed RADIUS server market. Ask him why he doesn't<br>want his phone to work with for major telecom companies. Ask him why
<br>there are customers with 10-million users that he's ignoring.<br><br>The problem is likely that the server *could* send more data at a<br>certain point, and instead just sends an "ack". If the client just
<br>sends an "ack" back (like everyone else does), then the server sends<br>more data.<br><br>His phone, on the other hand, expects to see data. Rather than<br>sending an "ack", which means "please give me more data", it just dies.
<br><br>Alan DeKok.<br>--<br><a href="http://deployingradius.com">http://deployingradius.com</a> - The web site of the book<br><a href="http://deployingradius.com/blog/">http://deployingradius.com/blog/</a> - The blog
<br><br><br>------------------------------<br><br>Message: 7<br>Date: Mon, 12 Feb 2007 14:27:23 +0000 (GMT)<br>From: adreas Polyxronopoulos <<a href="mailto:apolyxrono@yahoo.co.uk">apolyxrono@yahoo.co.uk</a>><br>Subject: Segmentation fault (core dumped) -
freeradius-1.1.4<br>To: freeradius users-list <<a href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</a>><br>Message-ID: <<a href="mailto:166716.89084.qm@web25711.mail.ukl.yahoo.com">
166716.89084.qm@web25711.mail.ukl.yahoo.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Hi list,<br><br>I use freeradius 1.1.4 and I face the following problem. Freeradius runs ok but whenever a user tries to connect to the network freeradius crashes and I get the following message.
<br><br>Starting - reading configuration files ...<br>reread_config: reading radiusd.conf<br>Config: including file: /usr/local/etc/raddb/proxy.conf<br>Config: including file: /usr/local/etc/raddb/clients.conf<br>Config: including file: /usr/local/etc/raddb/snmp.conf
<br>Config: including file: /usr/local/etc/raddb/eap.conf<br>Config: including file: /usr/local/etc/raddb/sql.conf<br>main: prefix = "/usr/local"<br>main: localstatedir = "/usr/local/var"<br>main: logdir = "/usr/local/var/log/radius"
<br>main: libdir = "/usr/local/lib"<br>main: radacctdir = "/usr/local/var/log/radius/radacct"<br>main: hostname_lookups = no<br>main: snmp = no<br>main: max_request_time = 30<br>main: cleanup_delay = 5
<br>main: max_requests = 1024<br>main: delete_blocked_requests = 0<br>main: port = 0<br>main: allow_core_dumps = no<br>main: log_stripped_names = no<br>main: log_file = "/usr/local/var/log/radius/radius.log"<br>
main: log_auth = no<br>main: log_auth_badpass = no<br>main: log_auth_goodpass = no<br>main: pidfile = "/usr/local/var/run/radiusd/radiusd.pid"<br>main: bind_address = <a href="http://150.140.188.218">150.140.188.218
</a> IP address [<a href="http://150.140.188.218">150.140.188.218</a>]<br>main: user = "(null)"<br>main: group = "(null)"<br>main: usercollide = no<br>main: lower_user = "no"<br>main: lower_pass = "no"
<br>main: nospace_user = "no"<br>main: nospace_pass = "no"<br>main: checkrad = "/usr/local/sbin/checkrad"<br>main: proxy_requests = yes<br>proxy: retry_delay = 5<br>proxy: retry_count = 3<br>
proxy: synchronous = no<br>proxy: default_fallback = yes<br>proxy: dead_time = 120<br>proxy: post_proxy_authorize = no<br>proxy: wake_all_if_all_dead = no<br>security: max_attributes = 200<br>security: reject_delay = 1<br>
security: status_server = no<br>main: debug_level = 0<br>read_config_files: reading dictionary<br>read_config_files: reading naslist<br>Using deprecated naslist file. Support for this will go away soon.<br>read_config_files: reading clients
<br>read_config_files: reading realms<br>radiusd: entering modules setup<br>Module: Library search path is /usr/local/lib<br>Module: Loaded exec<br>exec: wait = yes<br>exec: program = "(null)"<br>exec: input_pairs = "request"
<br>exec: output_pairs = "(null)"<br>exec: packet_type = "(null)"<br>rlm_exec: Wait=yes but no output defined. Did you mean output=none?<br>Module: Instantiated exec (exec)<br>Module: Loaded expr<br>Module: Instantiated expr (expr)
<br>Module: Loaded CHAP<br>Module: Instantiated chap (chap)<br>Module: Loaded MS-CHAP<br>mschap: use_mppe = no<br>mschap: require_encryption = yes<br>mschap: require_strong = yes<br>mschap: with_ntdomain_hack = yes<br>mschap: passwd = "(null)"
<br>mschap: ntlm_auth = "(null)"<br>Module: Instantiated mschap (mschap)<br>Module: Loaded System<br>unix: cache = no<br>unix: passwd = "(null)"<br>unix: shadow = "(null)"<br>unix: group = "(null)"
<br>unix: radwtmp = "/usr/local/var/log/radius/radwtmp"<br>unix: usegroup = no<br>unix: cache_reload = 600<br>Module: Instantiated unix (unix)<br>Module: Loaded eap<br>eap: default_eap_type = "peap"<br>
eap: timer_expire = 60<br>eap: ignore_unknown_eap_types = no<br>eap: cisco_accounting_username_bug = no<br>tls: rsa_key_exchange = no<br>tls: dh_key_exchange = yes<br>tls: rsa_key_length = 512<br>tls: dh_key_length = 512<br>
tls: verify_depth = 0<br>tls: CA_path = "(null)"<br>tls: pem_file_type = yes<br>tls: private_key_file = "/usr/local/etc/raddb/certs/server_keycert.pem"<br>tls: certificate_file = "/usr/local/etc/raddb/certs/server_keycert.pem"
<br>tls: CA_file = "/usr/local/etc/raddb/certs/cacert.pem"<br>tls: private_key_password = "whatever"<br>tls: dh_file = "/usr/local/etc/raddb/certs/dh"<br>tls: random_file = "/usr/local/etc/raddb/certs/random"
<br>tls: fragment_size = 1024<br>tls: include_length = yes<br>tls: check_crl = no<br>tls: check_cert_cn = "(null)"<br>tls: cipher_list = "(null)"<br>tls: check_cert_issuer = "(null)"<br>rlm_eap_tls: Loading the certificate file as a chain
<br>rlm_eap: Loaded and initialized type tls<br>peap: default_eap_type = "mschapv2"<br>peap: copy_request_to_tunnel = yes<br>peap: use_tunneled_reply = no<br>peap: proxy_tunneled_request_as_eap = yes<br>rlm_eap: Loaded and initialized type peap
<br>mschapv2: with_ntdomain_hack = no<br>rlm_eap: Loaded and initialized type mschapv2<br>Module: Instantiated eap (eap)<br>Module: Loaded preprocess<br>preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"
<br>preprocess: hints = "/usr/local/etc/raddb/hints"<br>preprocess: with_ascend_hack = no<br>preprocess: ascend_channels_per_line = 23<br>preprocess: with_ntdomain_hack = no<br>preprocess: with_specialix_jetstream_hack = no
<br>preprocess: with_cisco_vsa_hack = no<br>preprocess: with_alvarion_vsa_hack = no<br>Module: Instantiated preprocess (preprocess)<br>Module: Loaded realm<br>realm: format = "suffix"<br>realm: delimiter = "@"
<br>realm: ignore_default = no<br>realm: ignore_null = no<br>Module: Instantiated realm (suffix)<br>Module: Loaded SQL<br>sql: driver = "rlm_sql_mysql"<br>sql: server = "localhost"<br>sql: port = ""
<br>sql: login = "root"<br>sql: password = ""<br>sql: radius_db = "radius"<br>sql: nas_table = "nas"<br>sql: sqltrace = no<br>sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
<br>sql: readclients = yes<br>sql: deletestalesessions = yes<br>sql: num_sql_socks = 5<br>sql: sql_user_name = "%{User-Name}"<br>sql: default_user_profile = ""<br>sql: query_on_not_found = no<br>sql: authorize_check_query = "SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = BINARY '%{SQL-User-Name}' ORDER BY id"
<br>sql: authorize_reply_query = "SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = BINARY '%{SQL-User-Name}' ORDER BY id"<br>sql: authorize_group_check_query = "SELECT
<a href="http://radgroupcheck.id">radgroupcheck.id</a>,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = BINARY '%{SQL-User-Name}' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY <a href="http://radgroupcheck.id">radgroupcheck.id</a>"<br>sql: authorize_group_reply_query = "SELECT <a href="http://radgroupreply.id">radgroupreply.id</a>
,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = BINARY '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName
ORDER BY <a href="http://radgroupreply.id">radgroupreply.id</a>"<br>sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
<br>sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress = '%{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}'"
<br>sql: accounting_update_query_alt = "INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0')"
<br>sql: accounting_start_query = "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('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{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')"
<br>sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"
<br>sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}'"
<br>sql: accounting_stop_query_alt = "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('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S', INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
<br>sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'"<br>sql: connect_failure_retry_delay = 60<br>sql: simul_count_query = ""<br>sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
<br>sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', NOW())"<br>
sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked<br>rlm_sql (sql): Attempting to connect to
root@localhost:/radius<br>rlm_sql (sql): starting 0<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #0<br>rlm_sql_mysql: Starting connect to MySQL server for #0<br>rlm_sql (sql): Connected new DB handle, #0<br>rlm_sql (sql): starting 1
<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #1<br>rlm_sql_mysql: Starting connect to MySQL server for #1<br>rlm_sql (sql): Connected new DB handle, #1<br>rlm_sql (sql): starting 2<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
<br>rlm_sql_mysql: Starting connect to MySQL server for #2<br>rlm_sql (sql): Connected new DB handle, #2<br>rlm_sql (sql): starting 3<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #3<br>rlm_sql_mysql: Starting connect to MySQL server for #3
<br>rlm_sql (sql): Connected new DB handle, #3<br>rlm_sql (sql): starting 4<br>rlm_sql (sql): Attempting to connect rlm_sql_mysql #4<br>rlm_sql_mysql: Starting connect to MySQL server for #4<br>rlm_sql (sql): Connected new DB handle, #4
<br>rlm_sql (sql): - generate_sql_clients<br>rlm_sql (sql): Query: SELECT * FROM nas<br>rlm_sql (sql): Reserving sql socket id: 4<br>rlm_sql (sql): Read entry nasname=<a href="http://150.140.188.254">150.140.188.254</a>,shortname=myAP,secret=apolyxrono
<br>rlm_sql (sql): Adding client <a href="http://150.140.188.254">150.140.188.254</a> (myAP) to clients list<br>rlm_sql (sql): Released sql socket id: 4<br>Module: Instantiated sql (sql)<br>Listening on authentication <a href="http://150.140.188.218:1812">
150.140.188.218:1812</a><br>Listening on accounting <a href="http://150.140.188.218:1813">150.140.188.218:1813</a><br>Ready to process requests.<br>rad_recv: Accounting-Request packet from host <a href="http://150.140.188.220:1039">
150.140.188.220:1039</a>, id=10, length=166<br> Acct-Status-Type = Interim-Update<br> Acct-Session-Id = "000475925b2a-000d54fdb5ea-004f"<br> NAS-IP-Address = <a href="http://150.140.188.220">150.140.188.220
</a><br> Acct-Input-Octets = 667<br> Acct-Output-Octets = 140<br> Acct-Input-Packets = 9<br> Acct-Output-Packets = 3<br> User-Name = "not available"<br> Vendor-Specific = 0x564c414e2049442069733a2030
<br> Vendor-Specific = 0x4553534944203d206d794150<br> Vendor-Specific = 0x45415020547970652069733a206e6f7420617661696c61626c65<br> Acct-Session-Time = 213<br>Finished request 0<br>Going to the next request
<br>--- Walking the entire request list ---<br>Cleaning up request 0 ID 10 with timestamp 45d07357<br>Nothing to do. Sleeping until we see a request.<br>rad_recv: Accounting-Request packet from host <a href="http://150.140.188.220:1039">
150.140.188.220:1039</a>, id=10, length=166<br> Acct-Status-Type = Interim-Update<br> Acct-Session-Id = "000475925b2a-000d54fdb5ea-004f"<br> NAS-IP-Address = <a href="http://150.140.188.220">150.140.188.220
</a><br> Acct-Input-Octets = 667<br> Acct-Output-Octets = 140<br> Acct-Input-Packets = 9<br> Acct-Output-Packets = 3<br> User-Name = "not available"<br> Vendor-Specific = 0x564c414e2049442069733a2030
<br> Vendor-Specific = 0x4553534944203d206d794150<br> Vendor-Specific = 0x45415020547970652069733a206e6f7420617661696c61626c65<br> Acct-Session-Time = 213<br>Finished request 1<br>Going to the next request
<br>--- Walking the entire request list ---<br>Cleaning up request 1 ID 10 with timestamp 45d0735c<br>Nothing to do. Sleeping until we see a request.<br>rad_recv: Accounting-Request packet from host <a href="http://150.140.188.220:1040">
150.140.188.220:1040</a>, id=11, length=166<br> Acct-Status-Type = Interim-Update<br> Acct-Session-Id = "000475925b2a-000d54fdb5ea-004f"<br> NAS-IP-Address = <a href="http://150.140.188.220">150.140.188.220
</a><br> Acct-Input-Octets = 746<br> Acct-Output-Octets = 140<br> Acct-Input-Packets = 10<br> Acct-Output-Packets = 3<br> User-Name = "not available"<br> Vendor-Specific = 0x564c414e2049442069733a2030
<br> Vendor-Specific = 0x4553534944203d206d794150<br> Vendor-Specific = 0x45415020547970652069733a206e6f7420617661696c61626c65<br> Acct-Session-Time = 238<br>Finished request 2<br>Going to the next request
<br>--- Walking the entire request list ---<br>Cleaning up request 2 ID 11 with timestamp 45d07367<br>Nothing to do. Sleeping until we see a request.<br>rad_recv: Accounting-Request packet from host <a href="http://150.140.188.220:1040">
150.140.188.220:1040</a>, id=12, length=172<br> Acct-Status-Type = Stop<br> Acct-Session-Id = "000475925b2a-000d54fdb5ea-004f"<br> NAS-IP-Address = <a href="http://150.140.188.220">150.140.188.220
</a><br> Acct-Input-Octets = 939<br> Acct-Output-Octets = 177<br> Acct-Input-Packets = 13<br> Acct-Output-Packets = 4<br> User-Name = "not available"<br> Vendor-Specific = 0x564c414e2049442069733a2030
<br> Vendor-Specific = 0x4553534944203d206d794150<br> Vendor-Specific = 0x45415020547970652069733a206e6f7420617661696c61626c65<br> Acct-Session-Time = 242<br> Acct-Terminate-Cause = NAS-Request<br>
Finished request 3<br>Going to the next request<br>--- Walking the entire request list ---<br>Cleaning up request 3 ID 12 with timestamp 45d0736b<br>Nothing to do. Sleeping until we see a request.<br>rad_recv: Accounting-Request packet from host
<a href="http://150.140.188.220:1040">150.140.188.220:1040</a>, id=11, length=166<br> Acct-Status-Type = Interim-Update<br> Acct-Session-Id = "000475925b2a-000d54fdb5ea-004f"<br> NAS-IP-Address =
<a href="http://150.140.188.220">150.140.188.220</a><br> Acct-Input-Octets = 746<br> Acct-Output-Octets = 140<br> Acct-Input-Packets = 10<br> Acct-Output-Packets = 3<br> User-Name = "not available"
<br> Vendor-Specific = 0x564c414e2049442069733a2030<br> Vendor-Specific = 0x4553534944203d206d794150<br> Vendor-Specific = 0x45415020547970652069733a206e6f7420617661696c61626c65<br> Acct-Session-Time = 238
<br>Finished request 4<br>Going to the next request<br>--- Walking the entire request list ---<br>Cleaning up request 4 ID 11 with timestamp 45d0736c<br>Nothing to do. Sleeping until we see a request.<br>rad_recv: Access-Request packet from host
<a href="http://150.140.188.220:1044">150.140.188.220:1044</a>, id=5, length=168<br> NAS-IP-Address = <a href="http://150.140.188.220">150.140.188.220</a><br> NAS-Port-Type = Wireless-802.11<br> NAS-Port = 1
<br> Framed-MTU = 1400<br> User-Name = "OEM-AWQCRU94F8J\\pitsioris"<br> Calling-Station-Id = "000475925b2a"<br> Called-Station-Id = "000d545c4190"<br> NAS-Identifier = "3Com Access Point"
<br> EAP-Message = 0x0201001e014f454d2d415751435255393446384a5c70697473696f726973<br> Message-Authenticator = 0xd94d0d9df4c650def97ab37c7713c95a<br>Processing the authorize section of radiusd.conf<br>modcall: entering group authorize for request 5
<br>Segmentation fault (core dumped)<br><br>Could anyone please help me to fix this? Thank you very much.<br><br><br>Adreas Polyxronopoulos<br><br><br>---------------------------------<br>The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider.
<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070212/87e4d6f8/attachment.html">https://lists.freeradius.org/pipermail/freeradius-users/attachments/20070212/87e4d6f8/attachment.html
</a><br><br>------------------------------<br><br>-<br>List info/subscribe/unsubscribe? See <a href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a><br><br><br>End of Freeradius-Users Digest, Vol 22, Issue 52
<br>************************************************<br></blockquote></div><br>