View Issue Details
| 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 | ||
| 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. | ||||
