verification.log

[glazkow]

день всем добрый. В verification.log сыпет ошибки


- Verificator
-- You have to backup UTM5 database!
-- Affected tables list at the end of file

-- ERROR record with downloaded_id=368 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='368' AND tclass_id='30';

-- ERROR record with downloaded_id=694 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='694' AND tclass_id='30';

-- ERROR record with downloaded_id=687 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='687' AND tclass_id='30';

-- ERROR record with downloaded_id=634 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='634' AND tclass_id='30';

-- ERROR record with downloaded_id=615 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='615' AND tclass_id='30';

-- ERROR record with downloaded_id=704 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='704' AND tclass_id='30';

-- ERROR record with downloaded_id=723 in downloaded refers to tclass 30 which not exist
-- SQL DESC delete record
DELETE FROM downloaded WHERE downloaded_id='723' AND tclass_id='30';


подскажите что делать плз

[glazkow]

причем некоторые люди могут подключиться а некоторые нет, и те кто не может большинство

[glazkow]

1(

[Wishmaster]

.... refers to tclass 30 which not exist ...

Ясно ж написано, что не существует класс трафика '30'. Проверьте.

А на коннекты пользователей это вряд ли влияет, скорее всего ядро офигевает от потока неклассифицированного трафика и, как следствие, не авторизует часть абонентов. Впрочем, это мои домыслы, так как нет конкретики.

[glazkow]

Warn : Jun 18 00:47:22 b730fb70 AuthServer: Unable to claim IP from Named Pool VPN: No such file or directory
вот что еще в дебаге


точнее вот так полностью
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: User <216000309> connecting
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: Session for sessionid <216000309> not found in <192.168.0.234> cache
?Debug : Jun 18 00:47:22 b730fb70 RADIUS DBA: Info for login <216000309> found. type <2>
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: Auth scheme: MS-CHAPv2
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: MS-CHAPv2: Authorized user <216000309>
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: MS-CHAPv2: MPPE Keys send
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: Dialup session limit:1 session count:0 for user:216000309
?Debug : Jun 18 00:47:22 b730fb70 UT: slink_id 2105 tarif_key_common 1
Info : Jun 18 00:47:22 b730fb70 UT: calc timeout
Info : Jun 18 00:47:22 b730fb70 UT: t 1339969642, left money 35414.624495
Info : Jun 18 00:47:22 b730fb70 UT: tr_id 1, mult 0.000000, next 1340053200
Info : Jun 18 00:47:22 b730fb70 UT: quantity 83558 for borders
Info : Jun 18 00:47:22 b730fb70 UT: border 0 cost 0.000000
Info : Jun 18 00:47:22 b730fb70 UT: after borders q=83558, downloaded=83558, downed_as_prepaid=0 cost_info size <1>
Info : Jun 18 00:47:22 b730fb70 UT: added entire 83558
Info : Jun 18 00:47:22 b730fb70 UT: i==cost_info->end()
Info : Jun 18 00:47:22 b730fb70 UT: session_timeout <83558> session_limit <86400> old_session_timeout <0>
Info : Jun 18 00:47:22 b730fb70 UT: t 1340053200, left money 35414.624495
Info : Jun 18 00:47:22 b730fb70 UT: tr_id 1, mult 0.000000, next 1340139600
Info : Jun 18 00:47:22 b730fb70 UT: quantity 86400 for borders
Info : Jun 18 00:47:22 b730fb70 UT: border 0 cost 0.000000
Info : Jun 18 00:47:22 b730fb70 UT: after borders q=86400, downloaded=169958, downed_as_prepaid=0 cost_info size <1>
Info : Jun 18 00:47:22 b730fb70 UT: added entire 86400
Info : Jun 18 00:47:22 b730fb70 UT: i==cost_info->end()
Info : Jun 18 00:47:22 b730fb70 UT: session_timeout <169958> session_limit <86400> old_session_timeout <83558>
Info : Jun 18 00:47:22 b730fb70 UT: session_timeout > session_limit or session_timeout - old_session_timeout too small. Breaking ...
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: Calculated maximum session time: 86400
Warn : Jun 18 00:47:22 b730fb70 AuthServer: Unable to claim IP from Named Pool VPN: No such file or directory
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: Calling fill radius attributes for NAS. Attr storage size <0>
Notice: Jun 18 00:47:22 b730fb70 AuthServer: Login incorrect <216000309> from NAS <192.168.0.234> CLID <192.168.0.234> Calling-station <192.168.5.3>
?Debug : Jun 18 00:47:22 b730fb70 AuthServer: Auth reply: RPacket:
Code: 3; ID: 197

[Wishmaster]

Warn : Jun 18 00:47:22 b730fb70 AuthServer: Unable to claim IP from Named Pool VPN: No such file or directory
вот что еще в дебаге

Ну, тут несколько вариантов, либо не существует IP Pool "VPN", либо не хватает IP адресов в этом пуле. Либо что-то еще. Я с подобным не сталкивался, может кто-то еще подскажет.

А вообще, проанализируйте, после чего проблема появилась. Само собой оно сломаться не могло.

[glazkow]

Спасибо увеличил pool все заработало