Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: killprotect and kill_quick with m_sql_authentication  (Read 7010 times)

0 Members and 1 Guest are viewing this topic.

Borja

  • Anope User
  • Offline Offline
  • Posts: 17
killprotect and kill_quick with m_sql_authentication
« on: February 10, 2014, 12:58:04 PM »

I have instaled m_sql_authentication and everything works fine with my drupal site.

I am using killprotect and kill_quick in my network, but these option dont work.

Code: [Select]
defaults = "killprotect kill_quick ns_secure ns_private hide_email hide_mask autoop"
I do:
/nick alex
/msg nickserv identify alexdrupalpassword

Code: [Select]
-NickServ- Your account alex has been successfully created.
-NickServ- Your email has been updated to alex@example.net.
-NickServ- Password accepted - you are now recognized.
* alex!alex@192.168.0.1 alex :You are now logged in as alex
* NickServ establece modo +r alex

Then I close the session.

Later I connect with alex unauthenticated and the killprotect dont work.


nickserv.conf
https://pastebin.anope.org/index.php?page=viewpaste&id=35f6540019


Thanks.
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: killprotect and kill_quick with m_sql_authentication
« Reply #1 on: February 10, 2014, 01:04:54 PM »

Show us /ns info alex
Logged

Borja

  • Anope User
  • Offline Offline
  • Posts: 17
Re: killprotect and kill_quick with m_sql_authentication
« Reply #2 on: February 10, 2014, 01:13:05 PM »

When I do a nick info nickserv remove the mode -r and delete alex in Table anope_db_NickCore and anope_db_NickAlias.

I am using 2.0 RC3

Code: [Select]
[Feb 10 13:10:53.867881 2014] Debug: Received: :186AAAAAG PRIVMSG 00AAAAAAF :info alex
[Feb 10 13:10:53.871619 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392037846) OR `timestamp` IS NULL)
[Feb 10 13:10:53.874669 2014] Debug: SQL-live got 1 rows for SELECT * FROM `anope_db_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1392037846) OR `timestamp` IS NULL)
[Feb 10 13:10:53.877131 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_ChannelInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392037771) OR `timestamp` IS NULL)
[Feb 10 13:10:53.877660 2014] Debug: Deleting nickname group alex
[Feb 10 13:10:53.877905 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :
[Feb 10 13:10:53.878398 2014] USERS: alex!ping@192.168.0.1 is no longer identified as alex
[Feb 10 13:10:53.880696 2014] Debug: SQL-live got error Table 'apichatea.anope_db_Memo' doesn't exist for SELECT * FROM `anope_db_Memo` WHERE (`timestamp` > FROM_UNIXTIME(1392037771) OR `timestamp` IS NULL)
[Feb 10 13:10:53.886593 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickCore` WHERE `id` = 13
[Feb 10 13:10:53.889752 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickCore` WHERE `timestamp` IS NULL
[Feb 10 13:10:53.892159 2014] Debug: SQL-live got error Table 'apichatea.anope_db_ForbidData' doesn't exist for SELECT * FROM `anope_db_ForbidData` WHERE (`timestamp` > FROM_UNIXTIME(1392037771) OR `timestamp` IS NULL)
[Feb 10 13:10:53.894592 2014] Debug: SQL-live got 1 rows for SELECT * FROM `anope_db_NickAlias` WHERE (`timestamp` > FROM_UNIXTIME(1392037846) OR `timestamp` IS NULL)
[Feb 10 13:10:53.895039 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :
[Feb 10 13:10:53.902141 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickAlias` WHERE `id` = 13
[Feb 10 13:10:53.904995 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickAlias` WHERE `timestamp` IS NULL
[Feb 10 13:10:53.905393 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Nick alex isn't registered.
[Feb 10 13:10:53.906245 2014] Debug: Sent: :00AAAAAAF MODE 186AAAAAG -r

>nickserv< info alex
-NickServ- Nick alex isn't registered.
* NickServ set mode -r alex
Logged

Charles Kingsley

  • Contributor
  • *
  • Offline Offline
  • Posts: 1405
Re: killprotect and kill_quick with m_sql_authentication
« Reply #3 on: February 10, 2014, 01:27:53 PM »

Hm, that's kind of odd ...

I don't have an answer sorry.

Someone more experienced with this will turn up soon hopefully.
Logged

Borja

  • Anope User
  • Offline Offline
  • Posts: 17
Re: killprotect and kill_quick with m_sql_authentication
« Reply #4 on: February 10, 2014, 01:42:45 PM »

thanks charles,

I think the problem is in this line:

[Feb 10 13:40:06.913883 2014] Debug: Deleting nickname group alex.




Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: killprotect and kill_quick with m_sql_authentication
« Reply #5 on: February 10, 2014, 02:50:43 PM »

Get debug logs of the original /ns id that creates your account and include them.
Logged

Borja

  • Anope User
  • Offline Offline
  • Posts: 17
Re: killprotect and kill_quick with m_sql_authentication
« Reply #6 on: February 10, 2014, 03:42:08 PM »

First I log my account:

/nick alex
/msg nickserv identifiy password123

Code: [Select]
[Feb 10 15:35:40.786281 2014] Debug: Received: :186 PING 186 00A
[Feb 10 15:35:40.786600 2014] Debug: Sent: :00A PONG 00A 186
[Feb 10 15:35:55.001743 2014] Debug: Received: :186AAAAAG PRIVMSG 00AAAAAAF :identify 123
[Feb 10 15:35:55.166223 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:35:55.169367 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_NickAlias` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:35:55.169885 2014] Debug: m_sql_authentication: Checking authentication for alex
[Feb 10 15:35:55.172571 2014] Debug: m_sql_authentication: Successful authentication for alex
[Feb 10 15:35:55.175407 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:35:55.176203 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Your account alex has been successfully created.
[Feb 10 15:35:55.176473 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Your email has been updated to alex@example.net.
[Feb 10 15:35:55.176778 2014] COMMAND: alex!ping@192.168.0.1 used IDENTIFY and identified for account alex
[Feb 10 15:35:55.177023 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Password accepted - you are now recognized.
[Feb 10 15:35:55.177273 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :alex
[Feb 10 15:35:55.177735 2014] USERS: alex!ping@192.168.0.1 is now identified as alex
[Feb 10 15:35:55.186025 2014] Debug: SQL-live got 0 rows for INSERT INTO `anope_db_NickCore` (`id`,`AUTOOP`,`HIDE_EMAIL`,`HIDE_MASK`,`KILLPROTECT`,`KILL_QUICK`,`MEMO_RECEIVE`,`MEMO_SIGNON`,`NS_PRIVATE`,`NS_SECURE`,`access`,`display`,`email`,`greet`,`language`,`memomax`,`pass`) VALUES (0,'1','1','1','1','1','','','1','1','ping@192.* ','alex','alex@example.net','','','0','') ON DUPLICATE KEY UPDATE `AUTOOP`=VALUES(`AUTOOP`),`HIDE_EMAIL`=VALUES(`HIDE_EMAIL`),`HIDE_MASK`=VALUES(`HIDE_MASK`),`KILLPROTECT`=VALUES(`KILLPROTECT`),`KILL_QUICK`=VALUES(`KILL_QUICK`),`MEMO_RECEIVE`=VALUES(`MEMO_RECEIVE`),`MEMO_SIGNON`=VALUES(`MEMO_SIGNON`),`NS_PRIVATE`=VALUES(`NS_PRIVATE`),`NS_SECURE`=VALUES(`NS_SECURE`),`access`=VALUES(`access`),`display`=VALUES(`display`),`email`=VALUES(`email`),`greet`=VALUES(`greet`),`language`=VALUES(`language`),`memomax`=VALUES(`memomax`),`pass`=VALUES(`pass`)
[Feb 10 15:35:55.192399 2014] Debug: SQL-live got 0 rows for INSERT INTO `anope_db_NickAlias` (`id`,`last_quit`,`last_realhost`,`last_realname`,`last_seen`,`last_usermask`,`nc`,`nick`,`time_registered`) VALUES (0,'','ping@192.168.0.1','ping','1392046555','ping@192.168.0.1','alex','alex','1392046555') ON DUPLICATE KEY UPDATE `last_quit`=VALUES(`last_quit`),`last_realhost`=VALUES(`last_realhost`),`last_realname`=VALUES(`last_realname`),`last_seen`=VALUES(`last_seen`),`last_usermask`=VALUES(`last_usermask`),`nc`=VALUES(`nc`),`nick`=VALUES(`nick`),`time_registered`=VALUES(`time_registered`)
[Feb 10 15:35:55.192833 2014] Debug: Sent: :00AAAAAAF MODE 186AAAAAG +r

Anope insert user alex into table anope_db_NickAlias and anope_db_NickCore

Then I do

/msg nickserv info alex
or /msg nickserv info other_user


And anope remove alex.

Code: [Select]
[Feb 10 15:38:11.827180 2014] Debug: Received: :186AAAAAG PRIVMSG 00AAAAAAF :info alex
[Feb 10 15:38:11.832811 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392046555) OR `timestamp` IS NULL)
[Feb 10 15:38:11.835874 2014] Debug: SQL-live got 1 rows for SELECT * FROM `anope_db_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1392046555) OR `timestamp` IS NULL)
[Feb 10 15:38:11.838563 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_ChannelInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:38:11.838901 2014] Debug: Deleting nickname group alex
[Feb 10 15:38:11.839106 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :
[Feb 10 15:38:11.839273 2014] USERS: alex!ping@192.168.0.1 is no longer identified as alex
[Feb 10 15:38:11.842081 2014] Debug: SQL-live got error Table 'apichatea.anope_db_Memo' doesn't exist for SELECT * FROM `anope_db_Memo` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:38:11.848970 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickCore` WHERE `id` = 7
[Feb 10 15:38:11.852243 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickCore` WHERE `timestamp` IS NULL
[Feb 10 15:38:11.854782 2014] Debug: SQL-live got error Table 'apichatea.anope_db_ForbidData' doesn't exist for SELECT * FROM `anope_db_ForbidData` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:38:11.859524 2014] Debug: SQL-live got 1 rows for SELECT * FROM `anope_db_NickAlias` WHERE (`timestamp` > FROM_UNIXTIME(1392046555) OR `timestamp` IS NULL)
[Feb 10 15:38:11.860225 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :
[Feb 10 15:38:11.867239 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickAlias` WHERE `id` = 7
[Feb 10 15:38:11.870260 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickAlias` WHERE `timestamp` IS NULL
[Feb 10 15:38:11.870738 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Nick alex isn't registered.
[Feb 10 15:38:11.871473 2014] Debug: Sent: :00AAAAAAF MODE 186AAAAAG -r



Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: killprotect and kill_quick with m_sql_authentication
« Reply #7 on: February 10, 2014, 03:45:17 PM »

Run "describe anope_db_NickCore;" on mysql
Logged

Borja

  • Anope User
  • Offline Offline
  • Posts: 17
Re: killprotect and kill_quick with m_sql_authentication
« Reply #8 on: February 10, 2014, 03:46:33 PM »

Resolved.

I have changed the table structure anope_db_NickAlias and it fails. It was my fault. Sorry.

Thanks for all.
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: killprotect and kill_quick with m_sql_authentication
« Reply #9 on: February 10, 2014, 03:48:05 PM »

For users in the future reading:

The output should look similar to this:

mysql> describe anope_db_NickCore;
+-------------------------+------------------+------+-----+-------------------+-----------------------------+
| Field                   | Type             | Null | Key | Default           | Extra                       |
+-------------------------+------------------+------+-----+-------------------+-----------------------------+
| id                      | int(10) unsigned | NO   | PRI | NULL              | auto_increment              |
| timestamp               | timestamp        | YES  | MUL | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |


I believe he altered his and removed the default CURRENT_TIMESTAMP as well as the on update CURRENT_TIMESTAMP. They are important.
Logged

Borja

  • Anope User
  • Offline Offline
  • Posts: 17
Re: killprotect and kill_quick with m_sql_authentication
« Reply #10 on: February 10, 2014, 03:49:19 PM »

I have the field last_quit longtext instead of text.
Logged
Pages: [1]   Go Up