Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Usiluje skonfigurowac Freeradius + mt + pppoe
(freeradius gentoo)
Zawartosc bazy danych:
radius=> SELECT username, attribute, op, value FROM radcheck; username | attribute | op | value ----------+--------------------+----+------------------- test | Calling-Station-Id | == | 00:0E:8E:2E:CD:4B test | User-Password | == | test (2 rows) radius=> SELECT username, attribute, op, value FROM radreply; username | attribute | op | value ----------+-------------------+----+-------------- test | Framed-IP-Address | := | 192.168.1.10 test | Auth-Type | := | ACCEPT (2 rows) radius=> SELECT nasname, shortname, secret, ports FROM nas; nasname | shortname | secret | ports -------------+-----------+--------+------- 172.22.11.4 | kamikadze | dupa | 1 (1 row) radius=> SELECT UserName, GroupName FROM radusergroup; username | groupname ----------+----------- test | static (1 row) radius=> SELECT GroupName, Attribute, Value, op FROM radgroupcheck; groupname | attribute | value | op -----------+-----------+--------+---- static | Auth-Type | mschap | := (1 row) radius=> SELECT GroupName, Attribute, Value, Op FROM radgroupreply; groupname | attribute | value | op -----------+--------------------+---------------------+---- static | Service-Type | Login-User | := static | Framed-Compression | Van-Jacobsen-TCP-IP | == static | Framed-Protocol | PPP | == static | Framed-MTU | 1500 | == static | Service-Type | Framed-User | == (5 rows)
Log z debu'a radius'a
rad_recv: Access-Request packet from host 172.22.11.4 port 48996, id=43, length=171 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 19 NAS-Port-Type = Ethernet User-Name = "test" Calling-Station-Id = "00:0E:8E:20:CD:4B" Called-Station-Id = "mt" NAS-Port-Id = "wlan1" MS-CHAP-Challenge = 0xda3eca481470e312 MS-CHAP-Response = 0x0101000000000000000000000000000000000000000000000000c87163cbd9c7e4b6ba82a172e653311e4e09e87b7ebf26a2 NAS-Identifier = "kamikadze" NAS-IP-Address = 172.22.11.4 +- entering group authorize ++[preprocess] returns ok rlm_mschap: Found MS-CHAP attributes. Setting 'Auth-Type = mschap' ++[mschap] returns ok rlm_realm: No '@' in User-Name = "test", looking up realm NULL rlm_realm: No such realm "NULL" ++[suffix] returns noop rlm_eap: No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound expand: %{User-Name} -> test rlm_sql (sql): sql_set_user escaped user --> 'test' rlm_sql (sql): Reserving sql socket id: 3 expand: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = 'test' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: query affected rows = 2 , fields = 5 WARNING: Found User-Password == "...". WARNING: Are you sure you don't mean Cleartext-Password? WARNING: See "man rlm_pap" for more information. rlm_sql (sql): User found in radcheck table expand: SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username = 'test' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: query affected rows = 2 , fields = 5 expand: SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}' ORDER BY priority -> SELECT GroupName FROM radusergroup WHERE UserName='test' ORDER BY priority rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: query affected rows = 1 , fields = 1 expand: SELECT id, GroupName, Attribute, Value, op FROM radgroupcheck WHERE GroupName = '%{Sql-Group}' ORDER BY id -> SELECT id, GroupName, Attribute, Value, op FROM radgroupcheck WHERE GroupName = 'static' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: query affected rows = 1 , fields = 5 rlm_sql (sql): User found in group static expand: SELECT id, GroupName, Attribute, Value, op FROM radgroupreply WHERE GroupName = '%{Sql-Group}' ORDER BY id -> SELECT id, GroupName, Attribute, Value, op FROM radgroupreply WHERE GroupName = 'static' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: query affected rows = 5 , fields = 5 rlm_sql (sql): Released sql socket id: 3 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop rlm_pap: Found existing Auth-Type, not changing it. ++[pap] returns noop rad_check_password: Found Auth-Type mschap !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! Replacing User-Password in config items with Cleartext-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!! Please update your configuration so that the "known good" !!! !!! clear text password is in Cleartext-Password, and not in User-Password. !!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! auth: type "MSCHAP" +- entering group MS-CHAP rlm_mschap: Told to do MS-CHAPv1 with NT-Password ++[mschap] returns ok +- entering group post-auth ++[exec] returns noop Sending Access-Accept of id 43 to 172.22.11.4 port 48996 Framed-IP-Address := 192.168.1.10 Service-Type := Login-User Framed-Compression == Van-Jacobson-TCP-IP Framed-Protocol == PPP Framed-MTU == 1500 Service-Type == Framed-User Finished request 0. Going to the next request Waking up in 4.9 seconds. rad_recv: Accounting-Request packet from host 172.22.11.4 port 54796, id=44, length=137 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 19 NAS-Port-Type = Ethernet User-Name = "test" Calling-Station-Id = "00:0E:8E:20:CD:4B" Called-Station-Id = "mt" NAS-Port-Id = "wlan1" Acct-Session-Id = "8190000e" Framed-IP-Address = 192.168.1.10 Acct-Authentic = RADIUS Event-Timestamp = "Jan 1 1970 01:53:37 CET" Acct-Status-Type = Start NAS-Identifier = "kamikadze" NAS-IP-Address = 172.22.11.4 Acct-Delay-Time = 0 +- entering group preacct ++[preprocess] returns ok rlm_acct_unique: Hashing 'NAS-Port = 19,Client-IP-Address = 172.22.11.4,NAS-IP-Address = 172.22.11.4,Acct-Session-Id = "8190000e",User-Name = "test"' rlm_acct_unique: Acct-Unique-Session-ID = "241460af86565bdd". ++[acct_unique] returns ok rlm_realm: No '@' in User-Name = "test", looking up realm NULL rlm_realm: No such realm "NULL" ++[suffix] returns noop ++[files] returns noop +- entering group accounting expand: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radius/radacct/172.22.11.4/detail-20091214 rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/172.22.11.4/detail-20091214 expand: %t -> Mon Dec 14 20:00:10 2009 ++[detail] returns ok ++[unix] returns ok expand: /var/log/radius/radutmp -> /var/log/radius/radutmp expand: %{User-Name} -> test ++[radutmp] returns ok expand: %{User-Name} -> test rlm_sql (sql): sql_set_user escaped user --> 'test' expand: %{NAS-Port} -> 19 expand: %{Acct-Delay-Time} -> 0 expand: INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic, ConnectInfo_start, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, XAscendSessionSvrKey) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', NULLIF('%{Realm}', ''), '%{NAS-IP-Address}', %{%{NAS-Port}:-NULL}::integer, '%{NAS-Port-Type}', ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), '%{Acct-Authentic}', '%{Connect-Info}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', NULLIF('%{Framed-IP-Address}', '')::inet, 0, '%{X-Ascend-Session-Svr-Key}') -> INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic, ConnectInfo_start, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, XAscendSessionSvrKey) VALUES('8190000e', '241460af86565bdd', 'test', NULLIF('', ''), '172.22.11.4', 19::integer, 'Ethernet', ('2009-12-14 20:00:10'::timestamp - '0'::interval), 'RADIUS', '', 'mt', '00:0E:8E:20:CD:4B', 'Framed-User', 'PPP', NULLIF('192.168.1.10', '')::inet, 0, '') rlm_sql (sql): Reserving sql socket id: 2 rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: query affected rows = 1 rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok expand: %{User-Name} -> test attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 44 to 172.22.11.4 port 54796 Finished request 1. Cleaning up request 1 ID 44 with timestamp +12 Going to the next request Waking up in 4.9 seconds. rad_recv: Accounting-Request packet from host 172.22.11.4 port 39735, id=45, length=185 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 19 NAS-Port-Type = Ethernet User-Name = "test" Calling-Station-Id = "00:0E:8E:20:CD:4B" Called-Station-Id = "mt" NAS-Port-Id = "wlan1" Acct-Session-Id = "8190000e" Framed-IP-Address = 192.168.1.10 Acct-Authentic = RADIUS Event-Timestamp = "Jan 1 1970 01:53:38 CET" Acct-Session-Time = 1 Acct-Input-Octets = 141 Acct-Input-Gigawords = 0 Acct-Input-Packets = 7 Acct-Output-Octets = 105 Acct-Output-Gigawords = 0 Acct-Output-Packets = 7 Acct-Status-Type = Stop Acct-Terminate-Cause = NAS-Error NAS-Identifier = "kamikadze" NAS-IP-Address = 172.22.11.4 Acct-Delay-Time = 0 +- entering group preacct ++[preprocess] returns ok rlm_acct_unique: Hashing 'NAS-Port = 19,Client-IP-Address = 172.22.11.4,NAS-IP-Address = 172.22.11.4,Acct-Session-Id = "8190000e",User-Name = "test"' rlm_acct_unique: Acct-Unique-Session-ID = "241460af86565bdd". ++[acct_unique] returns ok rlm_realm: No '@' in User-Name = "test", looking up realm NULL rlm_realm: No such realm "NULL" ++[suffix] returns noop ++[files] returns noop +- entering group accounting expand: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/radius/radacct/172.22.11.4/detail-20091214 rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/172.22.11.4/detail-20091214 expand: %t -> Mon Dec 14 20:00:12 2009 ++[detail] returns ok ++[unix] returns ok expand: /var/log/radius/radutmp -> /var/log/radius/radutmp expand: %{User-Name} -> test ++[radutmp] returns ok expand: %{User-Name} -> test rlm_sql (sql): sql_set_user escaped user --> 'test' expand: %{Acct-Delay-Time} -> 0 expand: %{Acct-Delay-Time} -> 0 expand: %{Acct-Input-Gigawords} -> 0 expand: %{Acct-Input-Octets} -> 141 expand: %{Acct-Output-Gigawords} -> 0 expand: %{Acct-Output-Octets} -> 105 expand: UPDATE radacct SET AcctStopTime = ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), AcctSessionTime = CASE WHEN '%{Acct-Session-Time}' = '' THEN (EXTRACT(EPOCH FROM ('%S'::TIMESTAMP WITH TIME ZONE - AcctStartTime::TIMESTAMP WITH TIME ZONE - '%{%{Acct-Delay-Time}:-0}'::INTERVAL)))::BIGINT ELSE '%{Acct-Session-Time}' END, AcctInputOctets = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), AcctOutputOctets = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = 0, FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime IS NULL -> UPDATE radacct SET AcctStopTime = ('2009-12-14 20:00:12'::timestamp - '0'::interval), AcctSessionTime = CASE WHEN '1' = '' THEN (EXTRACT(EPOCH FROM ('2009-12-14 20:00:12'::TIMESTAMP WITH TIME ZONE - AcctStartTime::TIMESTAMP WITH TIME ZONE - '0'::INTERVAL)))::BIGINT ELSE '1' END, AcctInputOctets = (('0'::bigint << 32) + '141'::bigint), AcctOutputOctets = (('0'::bigint << 32) + '105'::bigint), AcctTerminateCause = 'NAS-Error', AcctStopDelay = 0, FramedIPAddress = NULLIF('192.168.1.10', '')::inet, ConnectInfo_stop = '' WHERE AcctSessionId = '8190000e' AND UserName = 'test' AND NASIPAddress = '172.22.11.4' AND AcctStopTime IS NULL rlm_sql (sql): Reserving sql socket id: 1 rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: query affected rows = 1 rlm_sql (sql): Released sql socket id: 1 ++[sql] returns ok expand: %{User-Name} -> test attr_filter: Matched entry DEFAULT at line 12 ++[attr_filter.accounting_response] returns updated Sending Accounting-Response of id 45 to 172.22.11.4 port 39735 Finished request 2. Cleaning up request 2 ID 45 with timestamp +14 Going to the next request Waking up in 3.9 seconds. Cleaning up request 0 ID 43 with timestamp +12 Ready to process requests.
log /var/log/radius/radacct/172.22.11.4/detail-20091214
Mon Dec 14 20:00:10 2009 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 19 NAS-Port-Type = Ethernet User-Name = "test" Calling-Station-Id = "00:0E:8E:20:CD:4B" Called-Station-Id = "mt" NAS-Port-Id = "wlan1" Acct-Session-Id = "8190000e" Framed-IP-Address = 192.168.1.10 Acct-Authentic = RADIUS Event-Timestamp = "Jan 1 1970 01:53:37 CET" Acct-Status-Type = Start NAS-Identifier = "kamikadze" NAS-IP-Address = 172.22.11.4 Acct-Delay-Time = 0 Acct-Unique-Session-Id = "241460af86565bdd" Timestamp = 1260817210 Request-Authenticator = Verified Mon Dec 14 20:00:12 2009 Service-Type = Framed-User Framed-Protocol = PPP NAS-Port = 19 NAS-Port-Type = Ethernet User-Name = "test" Calling-Station-Id = "00:0E:8E:20:CD:4B" Called-Station-Id = "mt" NAS-Port-Id = "wlan1" Acct-Session-Id = "8190000e" Framed-IP-Address = 192.168.1.10 Acct-Authentic = RADIUS Event-Timestamp = "Jan 1 1970 01:53:38 CET" Acct-Session-Time = 1 Acct-Input-Octets = 141 Acct-Input-Gigawords = 0 Acct-Input-Packets = 7 Acct-Output-Octets = 105 Acct-Output-Gigawords = 0 Acct-Output-Packets = 7 Acct-Status-Type = Stop Acct-Terminate-Cause = NAS-Error NAS-Identifier = "kamikadze" NAS-IP-Address = 172.22.11.4 Acct-Delay-Time = 0 Acct-Unique-Session-Id = "241460af86565bdd" Timestamp = 1260817212 Request-Authenticator = Verified
Log z mikrotika'a
00:53:37 pppoe,info PPPoE connection established from 00:0E:8E:20:CD:4B 00:53:37 pppoe,ppp,info <pppoe-0>: waiting for call... 00:53:37 radius,debug new request 1b:42 code=Access-Request service=ppp called-id=mt 00:53:37 radius,debug sending 1b:42 to 172.22.11.10:1812 00:53:37 radius,debug,packet sending Access-Request with id 43 to 172.22.11.10:1812 00:53:37 radius,debug,packet Signature = 0x18b543766e72e8bc21c38a10a5568a0f 00:53:37 radius,debug,packet Service-Type = 2 00:53:37 radius,debug,packet Framed-Protocol = 1 00:53:37 radius,debug,packet NAS-Port = 19 00:53:37 radius,debug,packet NAS-Port-Type = 15 00:53:37 radius,debug,packet User-Name = "test" 00:53:37 radius,debug,packet Calling-Station-Id = "00:0E:8E:20:CD:4B" 00:53:37 radius,debug,packet Called-Station-Id = "mt" 00:53:37 radius,debug,packet NAS-Port-Id = "wlan1" 00:53:37 radius,debug,packet MS-CHAP-Challenge = 0xda3eca481470e312 00:53:37 radius,debug,packet MS-CHAP-Response = 0x01010000000000000000000000000000 00:53:37 radius,debug,packet 00000000000000000000c87163cbd9c7 00:53:37 radius,debug,packet e4b6ba82a172e653311e4e09e87b7ebf 00:53:37 radius,debug,packet 26a2 00:53:37 radius,debug,packet NAS-Identifier = "kamikadze" 00:53:37 radius,debug,packet NAS-IP-Address = 172.22.11.4 00:53:37 radius,debug,packet received Access-Accept with id 43 from 172.22.11.10:1812 00:53:37 radius,debug,packet Signature = 0x58df46c9054b43d5bea6516e60650e48 00:53:37 radius,debug,packet Framed-IP-Address = 192.168.1.10 00:53:37 radius,debug,packet Service-Type = 1 00:53:37 radius,debug,packet Framed-Compression = 1 00:53:37 radius,debug,packet Framed-Protocol = 1 00:53:37 radius,debug,packet Framed-MTU = 1500 00:53:37 radius,debug,packet Service-Type = 2 00:53:37 radius,debug received reply for 1b:42 00:53:37 pppoe,ppp,info <pppoe-0>: authenticated 00:53:37 radius,debug new request 1b:00 code=Accounting-Request service=ppp called-id=mt 00:53:37 radius,debug sending 1b:00 to 172.22.11.10:1813 00:53:37 radius,debug,packet sending Accounting-Request with id 44 to 172.22.11.10:1813 00:53:37 radius,debug,packet Signature = 0x60d000e3a2c2902462d510f55e1c4c2c 00:53:37 radius,debug,packet Service-Type = 2 00:53:37 radius,debug,packet Framed-Protocol = 1 00:53:37 radius,debug,packet NAS-Port = 19 00:53:37 radius,debug,packet NAS-Port-Type = 15 00:53:37 radius,debug,packet User-Name = "test" 00:53:37 radius,debug,packet Calling-Station-Id = "00:0E:8E:20:CD:4B" 00:53:37 radius,debug,packet Called-Station-Id = "mt" 00:53:37 radius,debug,packet NAS-Port-Id = "wlan1" 00:53:37 radius,debug,packet Acct-Session-Id = "8190000e" 00:53:37 radius,debug,packet Framed-IP-Address = 192.168.1.10 00:53:37 radius,debug,packet Acct-Authentic = 1 00:53:37 radius,debug,packet Event-Timestamp = 3217 00:53:37 radius,debug,packet Acct-Status-Type = 1 00:53:37 radius,debug,packet NAS-Identifier = "kamikadze" 00:53:37 radius,debug,packet NAS-IP-Address = 172.22.11.4 00:53:37 radius,debug,packet Acct-Delay-Time = 0 00:53:37 radius,debug,packet received Accounting-Response with id 44 from 172.22.11.10:1813 00:53:37 radius,debug,packet Signature = 0x1f2007f0cc9fbdd29adfd375de9a3b21 00:53:37 radius,debug received reply for 1b:00 00:53:37 radius,debug request 1b:00 processed 00:53:38 radius,debug new request 1b:00 code=Accounting-Request service=ppp called-id=mt 00:53:38 radius,debug sending 1b:00 to 172.22.11.10:1813 00:53:38 radius,debug,packet sending Accounting-Request with id 45 to 172.22.11.10:1813 00:53:38 radius,debug,packet Signature = 0xcfb4ab401e2bd4c536fe9e15f1864657 00:53:38 radius,debug,packet Service-Type = 2 00:53:38 radius,debug,packet Framed-Protocol = 1 00:53:38 radius,debug,packet NAS-Port = 19 00:53:38 radius,debug,packet NAS-Port-Type = 15 00:53:38 radius,debug,packet User-Name = "test" 00:53:38 radius,debug,packet Calling-Station-Id = "00:0E:8E:20:CD:4B" 00:53:38 radius,debug,packet Called-Station-Id = "mt" 00:53:38 radius,debug,packet NAS-Port-Id = "wlan1" 00:53:38 radius,debug,packet Acct-Session-Id = "8190000e" 00:53:38 radius,debug,packet Framed-IP-Address = 192.168.1.10 00:53:38 radius,debug,packet Acct-Authentic = 1 00:53:38 radius,debug,packet Event-Timestamp = 3218 00:53:38 radius,debug,packet Acct-Session-Time = 1 00:53:38 radius,debug,packet Acct-Input-Octets = 141 00:53:38 radius,debug,packet Acct-Input-Gigawords = 0 00:53:38 radius,debug,packet Acct-Input-Packets = 7 00:53:38 radius,debug,packet Acct-Output-Octets = 105 00:53:38 radius,debug,packet Acct-Output-Gigawords = 0 00:53:38 radius,debug,packet Acct-Output-Packets = 7 00:53:38 radius,debug,packet Acct-Status-Type = 2 00:53:38 radius,debug,packet Acct-Terminate-Cause = 9 00:53:38 radius,debug,packet NAS-Identifier = "kamikadze" 00:53:38 radius,debug,packet NAS-IP-Address = 172.22.11.4 00:53:38 radius,debug,packet Acct-Delay-Time = 0 00:53:38 pppoe,ppp,info <pppoe-0>: terminating... - could not determine remote IP address 00:53:38 radius,debug,packet received Accounting-Response with id 45 from 172.22.11.10:1813 00:53:38 radius,debug,packet Signature = 0x4a7bb93717e582556c176a31170e33eb 00:53:38 radius,debug received reply for 1b:00 00:53:38 radius,debug request 1b:00 processed 00:53:38 pppoe,ppp,info <pppoe-0>: disconnected
Offline
ja mam tak:
Calling-Station-Id == Simultaneous-Use := User-Password := Framed-IP-Netmask = Framed-IP-Address = mschap2
mschap1 nie obsluguja zadne nowe windowsy !
Ostatnio edytowany przez bolos_11 (2009-12-14 23:39:48)
Offline
Time (s) | Query |
---|---|
0.00009 | SET CHARSET latin2 |
0.00004 | SET NAMES latin2 |
0.00129 | SELECT u.*, g.*, o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='18.221.93.167' WHERE u.id=1 |
0.00066 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '18.221.93.167', 1732960375) |
0.00051 | SELECT * FROM punbb_online WHERE logged<1732960075 |
0.00059 | SELECT topic_id FROM punbb_posts WHERE id=136579 |
0.00075 | SELECT id FROM punbb_posts WHERE topic_id=15734 ORDER BY posted |
0.00087 | SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=15734 AND t.moved_to IS NULL |
0.00005 | SELECT search_for, replace_with FROM punbb_censoring |
0.00214 | SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=15734 ORDER BY p.id LIMIT 0,25 |
0.00078 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=15734 |
Total query time: 0.00777 s |