Модуль перенаправления клиента

[0xbad0c0d3]

Да сегодня заметил опечатку. Но все равно скрипт не отрабатывает всех:

29.10.2014 09:11:09 Автоматической рассылкой отправлено 99 сообщений о потенциальной задолженности

вернул как делал ранее:

29.10.2014 09:19:35 Автоматической рассылкой отправлено 290 сообщений о потенциальной задолженности

Опыт мне подсказывает, что Вы совершенно не знаете что делаете...
Я Вам показал лишь упрощенную версию Вашей записи. А что она должна была сделать - понятия не имею и угадывать не желаю

[Cell]

Может еще целиком тут скрипты выложим?
Регалс. К кому относится, я думаю, все поняли.

[ale-x]

После рассылки сообщений MySQL начинает жрать проц на полную, отваливаются сессии PPPoE. Раньше такого не наблюдалось.
show full processlist:

Код:

Id	User	Host	db	Command	Time	State	Info
2	root	localhost	bill	Query	5	Locked	INSERT into dblogin (mid,act,time) VALUES ( NAME_CONST('usr_id',2335),47,unix_timestamp())
3	root	localhost	bill	Query	3	Locked	INSERT into dblogin (mid,act,time) VALUES\n    ((SELECT id FROM users WHERE name= NAME_CONST('login',_cp1251'andrey' COLLATE 'cp1251_general_ci') LIMIT 1),47,unix_timestamp())
4	root	localhost	bill	Query	5	Copying to tmp table	SELECT SQL_CALC_FOUND_ROWS field_value INTO usrAdvID FROM dopdata WHERE\n        revision IN (SELECT rev FROM rev_users WHERE template_num=1 AND\n                     id IN (SELECT id FROM users WHERE id= NAME_CONST('_mid',668) OR mid= NAME_CONST('_mid',668))) AND\n        field_alias= NAME_CONST('alias_name',_cp1251'_mac' COLLATE 'cp1251_general_ci') AND field_value= NAME_CONST('stationId',_cp1251'00:e0:4d:56:87:14' COLLATE 'cp1251_general_ci')
5	root	localhost	bill	Query	5	statistics	SELECT id,ip INTO usr_id,usr_ip FROM users WHERE name= NAME_CONST('login',_cp1251'pst' COLLATE 'cp1251_general_ci')
6	root	localhost	bill	Query	5	update	INSERT into dblogin (mid,act,time) VALUES ( NAME_CONST('usr_id',1351),47,unix_timestamp())
19	bill_kernel	localhost	bill	Sleep	8		NULL
23	bill_kernel	localhost	bill	Query	6	statistics	SELECT field_alias,field_value FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1464 AND revision=(SELECT MAX(revision) FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1464)
24	bill_kernel	localhost	bill	Query	6	Sending data	SELECT field_alias,field_value FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1489 AND revision=(SELECT MAX(revision) FROM dopdata WHERE parent_type=0 AND template_num=1 AND parent_id=1489)
25	bill_kernel	localhost	bill	Sleep	4		NULL
29	bill_kernel	localhost	bill	Query	5	Locked	UPDATE users SET auth='on' WHERE id=547 LIMIT 1
56285	bill_kernel	localhost	bill	Sleep	155		NULL
56360	bill_kernel	localhost	bill	Sleep	156		NULL
56362	bill_kernel	localhost	bill	Sleep	148		NULL
58766	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58767	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58769	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58770	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58771	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58772	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58773	bill_www	localhost	bill	Query	19	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58774	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1629' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1629' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58775	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58776	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58777	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58778	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58779	bill_www	localhost	bill	Query	17	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58780	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58781	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58782	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58783	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58784	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58786	bill_www	localhost	bill	Query	16	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58788	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58789	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58790	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58791	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58792	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58794	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58795	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2281' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2281' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58796	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58797	bill_www	localhost	bill	Query	15	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58798	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58799	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '2123' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='2123' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58800	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58801	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58802	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58803	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58804	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58805	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58807	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58808	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58810	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58811	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58812	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58813	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58815	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58816	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58817	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
58819	bill_www	localhost	bill	Query	14	Sending data	SELECT pays.id AS pid, time, coment, category  FROM `pays`, `m_confirm` WHERE (pays.mid = '1648' && category = 490 || `category` =496) && (SELECT COUNT(m_confirm.id) FROM `m_confirm` WHERE m_confirm.Mid='1648' && mess=pays.id )=0 GROUP BY pays.id LIMIT 1
........лимит 20000 знаков.......
59047	root	localhost	NULL	Query	0	NULL	show full processlist

Что можно предпринять?

UPD: Как один из вариантов можно почистить m_confirm в которой 11000 строк?

[Cell]

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

[Hasard]

как убрать с ЛК сообщение те которые уведомляют пользователя о минусовом балансе чтоб они там не плодились ?

[sl]

На днях заметил интересную штуку. Отправлял многоадресное сообщение двум группам, а получили три группы. При чём в той группе которой сообщение не адресовалось в личном кабинете сообщения не было (только заворот). Может кто сталкивался?

[sl]

И ещё. Было бы не плохо заворачивать не только с HTTP но и с HTTPS.
dst-port 80,443 in - не помогло

[0xbad0c0d3]

И ещё. Было бы не плохо заворачивать не только с HTTP но и с HTTPS.
dst-port 80,443 in - не помогло

А еще, было бы неплохо знать что завернуть 443 порт не так просто, по той причине, что это называется MITM-атака. Соответственно абоны будут видеть, в лучшем случае, предупреждение браузера о том, что сертификат не является доверенным, и в 99% абон скажет: у меня не работает антарнеты! И начнет звонить в ТП.

[sl]

Собственно так и получилось, что ничего не получилось.

[rusol]

И ещё. Было бы не плохо заворачивать не только с HTTP но и с HTTPS.
dst-port 80,443 in - не помогло

Я тоже имею желание иметь данную функцию, готов за её доплатить.

[Cell]

какую функцию?  заворачивать SSL соединения? в своем уме?