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