Can any experienced HTTPS/MySQL user help build webservice.

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

sphere
Posts: 1145
Joined: Sat Sep 27, 2014 10:32 am
Location: Earth, Except when i Jump

Re: Can any experienced HTTPS/MySQL user help build webservice.

Post by sphere » Tue Jan 09, 2018 7:50 pm

To send it encrypted from LC to the DB i did:
Encrypt --> then base64encode -->send to DB

do not encrypt the id of the row of course

to read back in LC, get the data with a PHP file from the DB:
read from DB-->then Base64Decode --> then Decrypt

LC versions before LC9 have also encrypt and decrypt but limited to SHA1 and this is already cracked.
There are websites where you can enter a encoded SHA1 string and will be decoded in no time, just to prove it is cracked.
So to use more secure encrypting, use LC9.
Last edited by sphere on Mon Jan 22, 2018 10:24 am, edited 1 time in total.

teriibi
Posts: 254
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: Can any experienced HTTPS/MySQL user help build webservice.

Post by teriibi » Tue Jan 09, 2018 8:04 pm

Great, thanks for you taking time to detail the steps...willl be very usefull.
Ok, will check whatever SHA version is still worth..for a while :D
Very clear !
Tks

PS:

Post Reply

Return to “Databases”