Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: *.db files and MySQL  (Read 5391 times)

0 Members and 1 Guest are viewing this topic.

ambta

  • Anope User
  • Offline Offline
  • Posts: 4
*.db files and MySQL
« 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
« Last Edit: January 19, 2013, 12:37:36 AM by ambta »
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: *.db files and MySQL
« Reply #1 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?
Logged

ambta

  • Anope User
  • Offline Offline
  • Posts: 4
Re: *.db files and MySQL
« Reply #2 on: January 19, 2013, 12:38:49 AM »

No, I'm not familiar with this option. How do I do that?
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: *.db files and MySQL
« Reply #3 on: January 19, 2013, 12:39:39 AM »

/cs set #channel password newpass
Logged

ambta

  • Anope User
  • Offline Offline
  • Posts: 4
Re: *.db files and MySQL
« Reply #4 on: January 19, 2013, 12:49:06 AM »

Damn it, how could I miss this.

Thank you :)
Logged
Pages: [1]   Go Up