Anope IRC Services

Anope Support => 1.8.x/1.7.x Support (Read Only) => Topic started by: ambta on January 19, 2013, 12:31:40 AM

Title: *.db files and MySQL
Post by: ambta on January 19, 2013, 12:31:40 AM
Hi folks.

I've lost all my chan founder passwords, and I can't even update the topics now. I've tried the combination UseRDB and MySQL (stopping Anope and set a new MD5 raw password in the table). But this doesn't work. Instead I got a error message:

"Error: MySQL password are encrypted using method in MysqlSecure disabling UseRDB"

And Anope loads the data from the *.db files (again and reset all previous changes in the MySQL DB).

Is there another way the reset the passwords (e.g. edit the .db files or fix the error message)?

versions:
Anope 1.8.5
Unreal 3.2.8.1
denora-1.4.4.330
MySQL 5.1.44

regards
ambta
Title: Re: *.db files and MySQL
Post by: Adam on January 19, 2013, 12:36:44 AM
If you have the passwords encrypted with MysqlSecure there is no way to load them back in to Anope because the encryption is one-way.

You know that you can change channel passwords without knowing the old password though right?
Title: Re: *.db files and MySQL
Post by: ambta on January 19, 2013, 12:38:49 AM
No, I'm not familiar with this option. How do I do that?
Title: Re: *.db files and MySQL
Post by: Adam on January 19, 2013, 12:39:39 AM
/cs set #channel password newpass
Title: Re: *.db files and MySQL
Post by: ambta on January 19, 2013, 12:49:06 AM
Damn it, how could I miss this.

Thank you :)