# |
Jan 21st 2019, 10:38 |
josbeir |
would also go for that |
# |
Jan 21st 2019, 10:38 |
josbeir |
yup |
# |
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 |