Freeradius-Users Digest, Vol 44, Issue 140

[Eric]

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 at kalik.net>
> Subject: Re: freeradius doesn't sent information to mysql
> To: "FreeRadius users mailing list"
>        <freeradius-users at lists.freeradius.org>
> Message-ID: <DShqoEOi.1230637227.0700950.tnt at 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 at 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?
> >
> >
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20081231/f5eb2936/attachment.html>