Anonymous | Login | Signup for a new account | 2019-12-13 07:11 CAT | ![]() |
My View | View Issues | Roadmap | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0001473 | Anope Development (1.9.x series) | Operserv | public | 2013-01-25 17:15 | 2013-01-27 07:51 | ||||
Reporter | Nita | ||||||||
Assigned To | Adam | ||||||||
Priority | high | Severity | major | Reproducibility | always | ||||
Status | resolved | Resolution | fixed | ||||||
Platform | x64 | OS | Debian | OS Version | Squeeze | ||||
Product Version | |||||||||
Target Version | Fixed in Version | ||||||||
Summary | 0001473: Exception list does not added to the SQL database (GIT-devel) | ||||||||
Description | I would like to add a session exception to services via OperServ. It looks like that exception is added but it is gone when I restart services. Version: current devel, 1.9, origin/1.9, ed7c4dc2e17a4616b0242d79ad80466970889fa0 Using: SQL Live | ||||||||
Steps To Reproduce | /msg OperServ EXCEPTION LIST /msg OperServ EXCEPTION ADD +0 0::1 8 Services /msg OperServ EXCEPTION ADD +0 127.0.0.1 8 Services /msg OperServ Update Stop services process and restart it. /msg OperServ EXCEPTION LIST | ||||||||
Additional Information | [Jan 25 15:00:04.777926 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :exception list [Jan 25 15:00:04.778467 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1359125996) OR `timestamp` IS NULL) [Jan 25 15:00:04.778818 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1359125996) OR `timestamp` IS NULL) [Jan 25 15:00:04.779048 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :The session exception list is empty. [Jan 25 15:00:46.832710 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :EXCEPTION ADD +0 0::1 10 Services [Jan 25 15:00:46.833242 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1359126004) OR `timestamp` IS NULL) [Jan 25 15:00:46.833561 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1359126004) OR `timestamp` IS NULL) [Jan 25 15:00:46.833835 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :Session limit for 0::1 set to 10. [Jan 25 15:00:46.834018 2013] Debug: m_mysql: Fetching columns for svs_Exception [Jan 25 15:00:46.834683 2013] Debug: m_mysql: Column #0 for svs_Exception: id [Jan 25 15:00:46.834722 2013] Debug: m_mysql: Column 0000001 for svs_Exception: timestamp [Jan 25 15:00:46.834752 2013] Debug: m_mysql: Column 0000002 for svs_Exception: expires [Jan 25 15:00:46.834779 2013] Debug: m_mysql: Column 0000003 for svs_Exception: limit [Jan 25 15:00:46.834807 2013] Debug: m_mysql: Column 0000004 for svs_Exception: mask [Jan 25 15:00:46.834835 2013] Debug: m_mysql: Column 0000005 for svs_Exception: reason [Jan 25 15:00:46.834862 2013] Debug: m_mysql: Column 0000006 for svs_Exception: time [Jan 25 15:00:46.834889 2013] Debug: m_mysql: Column 0000007 for svs_Exception: who [Jan 25 15:00:46.841599 2013] Debug: SQL-live got 0 rows for INSERT INTO `svs_Exception` (`id`,`expires`,`limit`,`mask`,`reason`,`time`,`who`) VALUES (0,'0','10','0::1','Services','1359126046','Anita') ON DUPLICATE KEY UPDATE `expires`=VALUES(`expires`),`limit`=VALUES(`limit`),`mask`=VALUES(`mask`),`reason`=VALUES(`reason`),`time`=VALUES(`time`),`who`=VALUES(`who`) [Jan 25 15:00:46.857724 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :EXCEPTION ADD +0 127.0.0.1 10 Services [Jan 25 15:00:46.858275 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :Session limit for 127.0.0.1 set to 10. [Jan 25 15:00:46.858925 2013] Debug: SQL-live got 0 rows for INSERT INTO `svs_Exception` (`id`,`expires`,`limit`,`mask`,`reason`,`time`,`who`) VALUES (0,'0','10','127.0.0.1','Services','1359126046','Anita') ON DUPLICATE KEY UPDATE `expires`=VALUES(`expires`),`limit`=VALUES(`limit`),`mask`=VALUES(`mask`),`reason`=VALUES(`reason`),`time`=VALUES(`time`),`who`=VALUES(`who`) RESTARTING SERVICES... [Jan 25 15:02:27.851483 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :Password accepted. [Jan 25 15:02:41.175975 2013] Debug: Received: :001AAAAAQ PRIVMSG 002AAAAAG :exception list [Jan 25 15:02:41.176719 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1359126147) OR `timestamp` IS NULL) [Jan 25 15:02:41.177182 2013] Debug: SQL-live got 0 rows for SELECT * FROM `svs_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1359126147) OR `timestamp` IS NULL) [Jan 25 15:02:41.177535 2013] Debug: Sent: :002AAAAAG NOTICE 001AAAAAQ :The session exception list is empty. | ||||||||
Tags | No tags attached. | ||||||||
Attached Files | |||||||||
![]() |
|
(0006336) Adam (administrator) 2013-01-27 07:51 |
fixed in 50a42d2cbf2ff00ecab6bd432e88c8ca17a47219 |
![]() |
|||
Date Modified | Username | Field | Change |
2013-01-25 17:15 | Nita | New Issue | |
2013-01-27 07:51 | Adam | Note Added: 0006336 | |
2013-01-27 07:51 | Adam | Status | new => resolved |
2013-01-27 07:51 | Adam | Resolution | open => fixed |
2013-01-27 07:51 | Adam | Assigned To | => Adam |
Copyright © 2000 - 2019 MantisBT Team |