Log message #4174473

# At Username Text
# Jan 21st 2019, 10:38 neon1024 Plus it keeps the encryption in the application, rather than in the database
# Jan 21st 2019, 10:38 neon1024 Yeah, this is the first time I’ve had to tackle it, so figured a custom data type would be easiest and most obvious
# Jan 21st 2019, 10:37 josbeir so overthinking stuff...
# Jan 21st 2019, 10:37 josbeir because you can do encryption on db lvl too :P
# Jan 21st 2019, 10:37 neon1024 :P
# Jan 21st 2019, 10:37 josbeir yup
# Jan 21st 2019, 10:37 neon1024 Coffee for @josbeir!
# Jan 21st 2019, 10:37 josbeir mondays..
# Jan 21st 2019, 10:37 josbeir :)
# Jan 21st 2019, 10:37 josbeir would v been better
# Jan 21st 2019, 10:36 josbeir "Ah, perhaps because my content in the db isn’t encrypted yet!"
# Jan 21st 2019, 10:36 neon1024 > I’ll write a shell to manually encrypt my fields first
# Jan 21st 2019, 10:36 neon1024 > Ah, perhaps because my db isn’t encrypted yet!
# Jan 21st 2019, 10:36 josbeir i'm a developer..
# Jan 21st 2019, 10:36 josbeir i'm probably overthinking the issue at hand :P
# Jan 21st 2019, 10:36 neon1024 Exactly
# Jan 21st 2019, 10:36 josbeir errr, it will just return nothing interesting... :P
# Jan 21st 2019, 10:35 neon1024 :slightly_smiling_face:
# Jan 21st 2019, 10:35 neon1024 How does decrypt respond to being given a string which is not encrypted?
# Jan 21st 2019, 10:35 josbeir uhu, still a string :P
# Jan 21st 2019, 10:35 neon1024 Yes, an encrypted string
# Jan 21st 2019, 10:35 josbeir ?
# Jan 21st 2019, 10:35 josbeir ok but the thing you pass to that function is just a string no
# Jan 21st 2019, 10:34 neon1024 `Security::decrypt('@josbeir', $key)`
# Jan 21st 2019, 10:34 neon1024 This
# Jan 21st 2019, 10:34 josbeir what else would it be
# Jan 21st 2019, 10:34 neon1024 I’ll write a shell to manually encrypt my fields first
# Jan 21st 2019, 10:34 neon1024 `Security::encrypt` says that it returns a string
# Jan 21st 2019, 10:27 neon1024 I don’t want to use blob, I’m not about to refactor my whole database
# Jan 21st 2019, 10:24 mocelle @neon1024 u should use blob type to Save into db(MySQL)
# Jan 21st 2019, 10:22 josbeir i mean.. its encryption lvl in your app, not your db..
# Jan 21st 2019, 10:22 josbeir should it be ?
# Jan 21st 2019, 10:17 neon1024 Ah, perhaps because my db isnt’ encrypted yet!
# Jan 21st 2019, 10:17 neon1024 I’m also seeing `Error: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xC0\xBE\x89o\xF5\xF6...' for column 'first_name' at row 1`
# Jan 21st 2019, 10:16 neon1024 Soo, is that actually a string? I’m a bit confused
# Jan 21st 2019, 10:16 slackebot1 <neon1024>
# Jan 21st 2019, 09:32 steinkel we're using the Router itself to extract URL params, so it supports all the available routes the Router could generate
# Jan 21st 2019, 09:18 mocelle I have It allready(custom Data Type). But this is strange. I debug It and Post my result here. Thanks
# Jan 21st 2019, 09:17 neon1024 Which would mean as soon as the data is read out of the database, it’s automatically decrypted
# Jan 21st 2019, 09:17 neon1024 I’m going to implement a custom data type
# Jan 21st 2019, 09:17 neon1024 Well that’s because it’s an entity, so presumably whatever code you have which is doing the encryption and decryption is doing that before the entity is composed