Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Borja]

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.

[Charles Kingsley]

Show us /ns info alex

[Borja]

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

[Charles Kingsley]

Hm, that's kind of odd ...

I don't have an answer sorry.

Someone more experienced with this will turn up soon hopefully.

[Borja]

thanks charles,

I think the problem is in this line:

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

[Adam]

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

[Borja]

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



[Adam]

Run "describe anope_db_NickCore;" on mysql

[Borja]

Resolved.

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

Thanks for all.

[Adam]

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.

[Borja]

I have the field last_quit longtext instead of text.