« first day (10 days earlier)      last day (624 days later) » 

01:21
so my raw key is in a file named key
and my config looks like:
from base64 import b64encode
with open("key", "rb") as keyfile:
    key = b64encode(keyfile.read())

db_config = {
    'user': 'downgoat',
    'password': key,
    'host': '72.48.166.68',
    'port': 3306,
    'database': 'ppcg'
}
but it gives me 'access denied' for some reaosn
 
3 hours later…
Anonymous
04:35
Do you have a trailing newline in the key file?
04:50
nope, it has the same checksum
Anonymous
Weird
Anonymous
Lemme check if I messed up the perms
Anonymous
Try again
Anonymous
SHA256 of b64 is 475000aaf0cef74be61a8bf76af422a04c66adf75876a88144ec0cfc1c9a1f8b
yeah
weird still not working
> Access denied for user 'downgoat'@'c-73-189-52-223.hsd1.ca.comcast.net' (using password: YES)
Anonymous
04:58
One more try?
yeah still :(
Anonymous
05:14
Can you ping the IP?
Anonymous
Oh wait that's a mysql error
Anonymous
So it's not a firewall issue
Anonymous
I just completely nuked the user and readded - try again
Anonymous
I have no idea what is going on. I can't even connect from the command line as you
Anonymous
And I can't log in as Pavel either
Anonymous
05:28
WTF MySQL
Anonymous
@Downgoat I think it works now
Anonymous
13:38
@Downgoat Are your changes on add-posts ready for merging? Everything looks good to me, and I need to merge in order to work on answers, but I'm not sure if you are done working on it.
15:26
is the password same for redis?
@Mego yeah, it is ready to merge
I'm using this as the redis config but it gives me a 'invalid password' redis exception
redis_config = {
    'host': '72.48.166.68',
    'password': key,
    'port': 6379,
    'db': 0
}
Anonymous
I'll look at it in a bit
Anonymous
15:44
You're using the right key, right? Not the auth key we set up, but the key I sent you guys (using those keys)
Anonymous
Hash of redis password is 32fb999e11b6efd1999a3d031dd19295befe53c2130986c843042206431fccf7
@Mego a couple of suggestions: 1) Make answers use spoiler formatting except for the language and the length, so that people can continue to work on their answer without having other answers distract/affect them. 2) (Maybe not the best idea, but...) Allow the challenge author to limit competing answers to certain languages, such as Python, Ruby, C etc.
Anonymous
Those are things to think about and discuss
@Mego is it this:
yesterday, by Mego
The AUTH key for Redis is GhKqzFLEzs7hBkZXuUM8c0ij6Ds= (base64 encoded, AES CFB encrypted with the first 16 bytes of your auth key, using IV 81vEPBoDvo7GR+JBQt3tOw== (also base64 encoded)).
Anonymous
16:00
Yes, but that's specifically for Pavel
oh :|
Anonymous
I suppose I should redo it with your key
Anonymous
For you: lu9UE5ic8xVshsgUYVNF5dIVqIU=, IV is 48fVGWmr9BIaqonQityUig==
Anonymous
python3 -c "from Crypto.Cipher import AES; import base64; iv = base64.b64decode(b'48fVGWmr9BIaqonQityUig=='); msg = base64.b64decode(b'lu9UE5ic8xVshsgUYVNF5dIVqIU='); key = open('PPCGv2-key', 'rb').read(16); cipher = AES.new(key, AES.MODE_CFB, iv); print(cipher.decrypt(msg))"
Anonymous
Use pip3 install pycryptodome for the Crypto module
Anonymous
16:04
Replace PPCGv2-key with whatever file you stored your (raw) key in
@Mego and is the password the base64 of the resultant key?
Anonymous
Nope, it's the actual key
Anonymous
The text that gets printed (except the b'' quoting) is the key
I get a binary string, putting that in directly 'password': b'foo' and it gives my the same redis.exceptions.ResponseError: invalid password, should I .encode it?
Anonymous
Drop the b in front of 'foo' - it should be pure ASCII
16:08
it has some unprintablnes like \x8e
Anonymous
It shouldn't. Make sure you're using your actual (raw bytes) auth key, and not the base64 version
yeah, it is the raw, un-base64'd key
Anonymous
Raw != base64'd
Anonymous
Ok
checksum of key seems to match what I sent you too
Anonymous
16:12
And you're using the exact invocation above? I edited it because I forgot to replace Pavel's encrypted msg and IV with yours
Anonymous
Because I see unprintables using Pavel's details :P
Oh :|
 
5 hours later…
Anonymous
21:28
@Downgoat Were you able to connect?
23:27
@Mego yes, I was able to :D

« first day (10 days earlier)      last day (624 days later) »