I am sorry I mean that I can't find the problem. the detaild of sending packets are here. Is there any problem? rad_recv: Access-Request packet from host 10.10.10.3:11857, id=216, length=207 Acct-Session-Id = "118382" NAS-IP-Address = 10.10.10.3 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 4 MS-RAS-Vendor = 311 MS-RAS-Version = "MSRASV5.20" NAS-Port-Type = Virtual Tunnel-Type:0 = PPTP Tunnel-Medium-Type:0 = IP Calling-Station-Id = "192.168.201.59" Tunnel-Client-Endpoint:0 = "192.168.201.59" Microsoft-Attr-35 = 0x4d5352415356352e3130 Microsoft-Attr-34 = 0x4d535241532d302d312d34304432454332364243374334 User-Name = "school" User-Password = "123456" rlm_ldap: - authorize rlm_ldap: performing user authorization for school rlm_ldap: ldap_get_conn: Checking Id: 0 rlm_ldap: ldap_get_conn: Got Id: 0 rlm_ldap: (re)connect to 192.168.1.21:389, authentication 0 rlm_ldap: could not set LDAP_OPT_X_TLS_REQUIRE_CERT option to allow rlm_ldap: bind as / to 192.168.1.21:389 rlm_ldap: waiting for bind result ... rlm_ldap: Bind was successful rlm_ldap: checking if remote access for school is allowed by vpnAccess rlm_ldap: Adding radiusSimultaneousUse as Simultaneous-Use, value 1 & op=21 rlm_ldap: extracted attribute Max-Monthly-Session from generic item Max-Monthly-Session := 0 rlm_ldap: Adding radiusIdleTimeout as Idle-Timeout, value 1200 & op=11 rlm_ldap: extracted attribute Acct-Interim-Interval from generic item Acct-Interim-Interval := 300 rlm_ldap: Adding radiusSimultaneousUse as Simultaneous-Use, value 1 & op=21 rlm_ldap: extracted attribute Max-Monthly-Session from generic item Max-Monthly-Session := 360000 rlm_ldap: Adding radiusIdleTimeout as Idle-Timeout, value 1200 & op=11 rlm_ldap: extracted attribute Acct-Interim-Interval from generic item Acct-Interim-Interval := 300 rlm_ldap: looking for check items in directory... rlm_ldap: looking for reply items in directory... rlm_ldap: user school authorized to use remote access rlm_ldap: ldap_release_conn: Release Id: 0 radius_xlat: Running registered xlat function of module sql-Vpn for string 'SELECT SUM(AcctSessionTime - GREATEST((1228077000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='school' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > 1228077000 ' rlm_sql (sql-Vpn): - sql_xlat rlm_sql (sql-Vpn): Reserving sql socket id: 4 rlm_sql (sql-Vpn): row[0] returned NULL rlm_sql (sql-Vpn): Released sql socket id: 4 rlm_ldap: - authenticate rlm_ldap: login attempt by "school" with password "123456" rlm_ldap: user DN: uid=school,ou=TEMP,ou=organisations,dc=iut,dc=ac,dc=ir rlm_ldap: (re)connect to 192.168.1.21:389, authentication 1 rlm_ldap: could not set LDAP_OPT_X_TLS_REQUIRE_CERT option to allow rlm_ldap: bind as uid=school,ou=TEMP,ou=organisations,dc=iut,dc=ac,dc=ir/123456 to 192.168.1.21:389 rlm_ldap: waiting for bind result ... rlm_ldap: Bind was successful rlm_ldap: user school authenticated succesfully rlm_sql (sql-Vpn): Reserving sql socket id: 3 rlm_sql (sql-Vpn): Released sql socket id: 3 Login OK: [school] (from client VPN port 4 cli 192.168.201.59) rlm_sql (sql-Vpn): Processing sql_postauth rlm_sql (sql-Vpn): Reserving sql socket id: 2 rlm_sql (sql-Vpn): Released sql socket id: 2 Sending Access-Accept of id 216 to 62.60.198.18 port 11857 Service-Type = Framed-User Framed-Protocol = PPP Framed-Compression = Van-Jacobson-TCP-IP Acct-Interim-Interval := 300 Idle-Timeout = 1200 Session-Timeout = 389554 rad_recv: Accounting-Request packet from host 10.10.10.3:11858, id=133, length=260 Acct-Status-Type = Start Acct-Delay-Time = 0 NAS-IP-Address = 10.10.10.3 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 4 MS-RAS-Vendor = 311 MS-RAS-Version = "MSRASV5.20" NAS-Port-Type = Virtual Tunnel-Type:0 = PPTP Tunnel-Medium-Type:0 = IP Calling-Station-Id = "192.168.201.59" Tunnel-Client-Endpoint:0 = "192.168.201.59" Microsoft-Attr-35 = 0x4d5352415356352e3130 Microsoft-Attr-34 = 0x4d535241532d302d312d34304432454332364243374334 Acct-Session-Id = "118382" User-Name = "school" Framed-IP-Address = 10.10.10.4 Framed-MTU = 1400 Session-Timeout = 389554 Idle-Timeout = 1200 Acct-Multi-Session-Id = "953" Acct-Link-Count = 1 Event-Timestamp = "Dec 31 2008 15:45:03 IRST" Acct-Authentic = RADIUS MS-MPPE-Encryption-Types = 0x00000000 Sending Accounting-Response of id 133 to 10.10.10.3 port 11858
Message: 2 Date: Tue, 30 Dec 2008 12:40:27 +0100 From: <tnt@kalik.net> Subject: Re: freeradius doesn't sent information to mysql To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Message-ID: <DShqoEOi.1230637227.0700950.tnt@kalik.net> Content-Type: text/plain; charset=ISO-8859-2
Are we suposed to use a crystal ball or are you going to post the debug?
Ivan Kalik Kalik Informatika ISP
Dana 30/12/2008, "Eric" <bbahar3@gmail.com> pi?e:
Hi, My freeradius server was working properly and it's tables in mysql had all the logs and online users. now the informations of users couldn't be intered in tables . what may be the reason?