Anope IRC Services

Anope Support => 2.0.x/1.9.x Support => Topic started by: Cory Melth on January 22, 2014, 04:37:16 AM

Title: Encryption MySQL live
Post by: Cory Melth 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 ?

Title: Re: Encryption MySQL live
Post by: Taylor on January 22, 2014, 04:42:26 AM

enc_none base64 the password in the db.

Title: Re: Encryption MySQL live
Post by: Adam on January 22, 2014, 04:43:37 AM

It is base64 encoded, just un-base64 it.

Title: Re: Encryption MySQL live
Post by: Cory Melth on January 22, 2014, 04:44:46 AM

Can you quicly explain me how to un-base ?

thanks !

Title: Re: Encryption MySQL live
Post by: Adam on January 22, 2014, 04:46:14 AM

http://us2.php.net/manual/en/function.base64-decode.php

Title: Re: Encryption MySQL live
Post by: Cory Melth 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

Title: Re: Encryption MySQL live
Post by: Cory Melth 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;