search for: aes_decrypt

...9; at: http://wiki2.dovecot.org/AuthDatabase/SQL trying to modify it to work with my encrypted passwords in the DB. Im using the following which isnt working: password_query = SELECT NULL AS password, \ 'Y' as nopassword, userid AS user \ FROM users WHERE userid='%u' AND AES_DECRYPT(password, 'mykey')=password 1. Is it even possible to do this via 'password_query'? 2. If so, what am I doing wrong? Thanks, Jeff /mf/home/jeep/shell/.signature

...he database. There are several ways that it could be done. I could make an Encrypter class and use before_update, etc. Or I could set up an updatable VIEW in mySql. (I guess triggers might be another possibility.) However, what I would really LIKE to do is use the handy AES_ENCRYPT and AES_DECRYPT functions in mySql. If I were doing this with straight sql, I would just use INSERT INTO myTable VALUES( null, ''user name'', AES_ENCRYPT (''user_email'' , ''password'' ). Since ActiveRecord handles all this for me, it is not clear if I can o...

...oot 5199389 Feb 24 07:01 core_owtnmncccm0cnmo_ssh_0_0_1267016512_6729 # pstack core_owtnmncccm0cnmo_ssh_0_0_1267016512_6729 core 'core_owtnmncccm0cnmo_ssh_0_0_1267016512_6729' of 6729: /usr/local/bin/ssh root at server0-unit1 rm -f /etc/init.d/staticroutes ff1ee314 AES_decrypt (3c, d1, aaa5d0a5, 314, 74, 3b0) + 2f4 ff1ee66c AES_cbc_encrypt (74490, 774a8, 10, 6a358, 61fb8, 61fb8) +2c ff238abc aes_128_cbc_cipher (1, 774a8, 74490, 10, f0, ff2d9a18) + 1c ff23dfb8 EVP_Cipher (61f98, 774a8, 74490, 10, 61800, 62400) + 18 0002f3e4 cipher_crypt (61f94, 774a8, 7449...

...AS gid, "/var/mail/vhosts/%d/%n" AS home, concat("maildir:storage=", floor(m.quota/1024)) AS quota FROM vmailboxes m, vhosts h WHERE `m`.`username` = '%n' AND `m`.`domain` = `h`.`UUID` AND `h`.`vhost` = '%d' default_pass_scheme = PLAIN password_query = SELECT aes_decrypt(`m`.`password`, <snip>) AS password FROM vmailboxes m, vhosts h WHERE `m`.`username` = '%n' AND `m`.`domain` = `h`.`UUID` AND `h`.`vhost` = '%d'

Hi all, Does any one know of any encryption/decryption algorithms in R? I'm not looking for anything robust - I want some way of printing output to the screen that the user can't read immediately, but can decrypt a little later. The main thing I don't want to the user to see is a number, so (e.g.) ROT13 isn't appropriate. Hadley -- Assistant Professor / Dobelman Family Junior

...key-read(""); if( ${LEN(${abckey})} == 0 ) { // Must have a key to decrypt the data with. return; } if( ${LEN(${ext_})} == 0 ) { // Must have an extension number. return; } Set(LOCAL(egps)=${DB(pngnpbx/abc/egps/${ext_})}); Set(dgps=${AES_DECRYPT(${abckey},${egps})}); Set(abcdlat=${CUT(dgps, ,1)}); Set(abcdlon=${CUT(dgps, ,2)}); Set(abcdelv=${CUT(dgps, ,3)}); return; } /* The "geohdrs" macro is only utilized in tandem with "gps" macro. */ macro pngnpbx-abc-geohdrs(abcid_) { // TODO: check if this is...