ru.unix.bsd

 
 - RU.UNIX.BSD ------------------------------------------------------------------
 From : Rostislav Podgorniy                  2:4635/83.1    28 Dec 2003  12:31:24
 To : All
 Subject : Radius
 -------------------------------------------------------------------------------- 
 

 
   Какая максимальная длина запроса acct_stop_query?
   У меня есть следующее:
 
 acct_stop_query  UPDATE stat \
                     SET tm = '%C{Acct-Session-Time}', \
                         uppdate = '%D', \
                         stop = '%D', \
                         inp = '%C{Acct-Input-Octets}', \
                         out = '%C{Acct-Output-Octets}'  \
                  WHERE user_name = '%u' AND acct_s_id = '%C{Acct-Session-Id}'; \
                  UPDATE users_attribute \
                  SET param = CAST(param as SIGNED) - %C{Acct-Input-Octets} -
 %C{Acct-Output-Octets}  \
                  WHERE user_name = '%u' AND attr = 'Traffic-Limit'; \
                  UPDATE users as t1, users_attribute as t2 \
                     SET t1.active = '0' \
                  WHERE t1.user_name='%u' and t2.user_name='%u' and
 t2.attr='Traffic-Limit' and CAST(t2.param as SIGNED)
 <= t1.dopustdolg; \
                  UPDATE users_attribute as t2, stat as t3 \
                  SET t3.stop=t3.uppdate, \
                      t2.param=CAST(t2.param as SIGNED)-t3.inp-t3.out \
                  WHERE t3.user_name='%u' and t3.stop is NULL and NOW() >
 DATE_ADD(t3.uppdate, INTERVAL 20 minute) and \
                        t2.user_name='%u' and t2.attr='Traffic-Limit'; \
                  UPDATE users as t1, users_attribute as t2 SET t1.active='0'
 WHERE t1.user_name=t2.user_name and
 t2.attr='Traffic-Limit' and CAST(t2.param as SIGNED) <= t1.dopustdolg;
 
   Радиус ругается на этот запрос:
 
 дек 28 10:42:27 Acct.error: [MYSQL] You have an error in your SQL syntax.  Check
 the manual that corresponds to your
 MySQL server version for the right syntax to use near '; UPDATE users_attribute 
 SET param = CAST(param as SIGNED) - 10
 дек 28 10:42:27 Acct.error: Hеудачным запросом был:: UPDATE stat SET tm = '6',
 uppdate = '2003-12-28 10:42:27', stop =
 '2003-12-28 10:42:27', inp = '1082', out = '0'  WHERE user_name = 'rost' AND
 acct_s_id = '91207-rost1072600941'; UPDATE
 users_attribute SET param = CAST(param as SIGNED) - 1082 - 0  WHERE user_name = 
 'rost' AND attr = 'Traffic-Limit';
 UPDATE users as t1, users_attribute as t2 SET t1.active = '0' WHERE
 t1.user_name='rost' and t2.user_name='rost' and
 t2.attr='Traffic-Limit' and CAST(t2.param as SIGNED) <= t1.dopustdolg; UPDATE
 users_attribute as t2, stat as t3 SET
 t3.stop=t3.uppdate, t2.param=CAST(t2.param as SIGNED)-t3.inp-t3.out WHERE
 t3.user_name='rost' and t3.stop is NULL and
 
 NOW() > DATE_ADD(t3.uppdate, INTERVAL 20 minute) and t2.user_name='rost'
 NOW() > and t2.attr='Traffic-Limit'; UPDATE users as
 
 t1, users_attribute as t2 SET t1.active='0' WHERE t1.user_name=t2.user_name and 
 t2.attr='Traffic-Limit' and
 CAST(t2.param as SIGNED) <= t1.dopustdolg;
 
   Беру этот запрос, копирую буфер, тупо выполняю в MySQL через
   PHPMyAdmin и он нормально выполняется. В чём может быть причина того, что
 радиус ругается??? Единственное
   что мне кажется, это его длина... Как быть?
 
 --
 WBR, Rostislav Podgorniy      rostislav[ @ ]podgorniy.com      icq #709057
 
 ... Подпись к рисунку: Жопа - вид спереди...
 --- GoldED+ 1.1.4.7 (WinNT 5.1.2600-Service_Pack_1 i686)
  * Origin: MailSMS.net - Service for cellular phones owners (2:4635/83.1)
 
 

Вернуться к списку тем, сортированных по: возрастание даты  уменьшение даты  тема  автор