Anope IRC Services

Anope Support => 2.0.x/1.9.x Support => Topic started by: bobby brown on March 08, 2018, 05:08:49 AM

Title: mysql not saving registered nicks
Post by: bobby brown on March 08, 2018, 05:08:49 AM
hi,  I setup mysql on my Anope-2.0.7 service and it doesnt seem to save the nicks anywhere. I cant find a sqlite file and its not in the mysql db either
Title: Re: mysql not saving registered nicks
Post by: Jon on March 08, 2018, 05:30:56 AM
It could be a few things.  First I would try running it in debug mode and see what kind of error it regurgitates back at you.

  Did you activate m_mysql using ./extras before compiling, can you access your database using the mysql command line tool?  Unfortunately your question is a bit too broad for anyone to help, if you could perhaps supply a bit more information such as what error messages (if any) you get in debug mode and such that'd help to narrow what the issue might be related to.

Title: Re: mysql not saving registered nicks
Post by: bobby brown on March 08, 2018, 04:19:38 PM
It could be a few things.  First I would try running it in debug mode and see what kind of error it regurgitates back at you.

  Did you activate m_mysql using ./extras before compiling, can you access your database using the mysql command line tool?  Unfortunately your question is a bit too broad for anyone to help, if you could perhaps supply a bit more information such as what error messages (if any) you get in debug mode and such that'd help to narrow what the issue might be related to.
mysql.cpp is enables yes, im not able to see any errors in the log related to mysql, and im able to login using the cli
Title: Re: mysql not saving registered nicks
Post by: The Myth Lives on March 08, 2018, 08:50:31 PM
1) do you have a database created in MySQL with the right permissions?
2) did you enabled it in services.conf in here: https://github.com/anope/anope/blob/2.0/data/example.conf#L1134 ?
3) did you loaded the module in here: https://github.com/anope/anope/blob/2.0/data/modules.example.conf#L361 and edited it to fit your needs?
4) did you reloaded your configuration?
5) did you tried /os modlist to see if the module was loaded?
6) if all those steps were done and you still don't see the module, try /os modlist m_mysql
Title: Re: mysql not saving registered nicks
Post by: bobby brown on March 09, 2018, 05:57:16 AM
1) Yes
2) Yes
3) Yes
4) did you reloaded your configuration?
5) I am unable to do this even though I have Service Root
6) Same as above
carl is a Services Operator of type Services Root
Title: Re: mysql not saving registered nicks
Post by: The Myth Lives on March 09, 2018, 09:51:43 AM
Quote
4) did you reloaded your configuration?
5) I am unable to do this even though I have Service Root
6) Same as above
carl is a Services Operator of type Services Root

You can always reload your configuration file from command line, in /services/bin folder with
Code: [Select]
./anoperc rehash
When you try to do /os reload, what's the error you get?
By any chance do you have https://github.com/anope/anope/blob/2.0/data/example.conf#L898 enabled in your oper block? If you do you need to do the following command after oper up
Code: [Select]
/os login password