Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: Encryption MySQL live  (Read 5545 times)

0 Members and 1 Guest are viewing this topic.

Cory Melth

  • Anope User
  • Offline Offline
  • Posts: 7
Encryption MySQL live
« on: January 22, 2014, 04:37:16 AM »

Hi !

I run anope services perfectly without major problems ..

I have put the "enc_none" for encryption, so basicly the system suposed to save the password in plain text in my Database table ..

For exemple:
I'm connected to my irc ...
Register new account with /nickserv register test test@me.com

and when i'm trying to retreive it, my DB show me " plain:dGVzdA== "

Any ideas ?
Logged

Taylor

  • Contributor
  • *
  • Offline Offline
  • Posts: 100
Re: Encryption MySQL live
« Reply #1 on: January 22, 2014, 04:42:26 AM »

enc_none base64 the password in the db.
Logged
Cronus
irc.cncirc.net
http://CnCIRC.net

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: Encryption MySQL live
« Reply #2 on: January 22, 2014, 04:43:37 AM »

It is base64 encoded, just un-base64 it.
Logged

Cory Melth

  • Anope User
  • Offline Offline
  • Posts: 7
Re: Encryption MySQL live
« Reply #3 on: January 22, 2014, 04:44:46 AM »

Can you quicly explain me how to un-base ?

thanks !
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Logged

Cory Melth

  • Anope User
  • Offline Offline
  • Posts: 7
Re: Encryption MySQL live
« Reply #5 on: January 22, 2014, 04:52:50 AM »

Okay, I know I can execute a PHP code sound like this

Code: [Select]
<?php
$str 
'VGhpcyBpcyBhbiBlbmNvZGVkIHN0cmluZw==';
echo 
base64_decode($str);
?>


But, I have any way to modify the table as send to MySQL to be not on a base64 format ?

Thanks
« Last Edit: January 22, 2014, 05:06:08 AM by Cory Melth »
Logged

Cory Melth

  • Anope User
  • Offline Offline
  • Posts: 7
Re: Encryption MySQL live
« Reply #6 on: January 22, 2014, 05:43:03 AM »

Okay, finally I got it !

For the person can be interrested by this post,

I have create my own query in the "modules.exemple.conf", and I command to anope to check password in another table (in my own table user already exist)

and after fews tests, it run like a charm ! ^^

Geatly appreciate your help !

(by the way, I dont want to keep password as clear, It was only for a test step.. I'm not stupid)

Best regards;
Logged
Pages: [1]   Go Up