آنلاین SHA512 ژنراتور هش

does anybody know why an INSERT with sha512 is working without any problem:

String query = " insert into user (username, password, surname, lastname, email, admin)"            + " values (?, sha2(?, 512), ?, ?, ?, ?)";    System.out.println("query: " + query);    // create the java statement    PreparedStatement ps = conn.prepareStatement(query);    ps.setString(1, newUser.getUsername());    ps.setString(2, getPsw());    ps.setString(3, newUser.getSurename());    ps.setString(4, newUser.getLastname());    ps.setString(5, newUser.getEmail());............

and an UPDATE query not:

String query = "update user set password = sha2(?, 512) where id = "+getId()+")";    System.out.println("query: " + query);    // create the java statement    PreparedStatement ps = conn.prepareStatement(query);    ps.setString(1, psw_edit);

I get the following MySQLSyntaxErrorException:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1

I have my code down to the essentials for testing access, but am receiving the good old error(403) from the server, I have verified for double-sure I am using the correct API Key/Secret pair. My Code (C# via Unity 3D) is as follows:

using System.Collections;using System.Collections.Generic;using UnityEngine;using System;using System.Security.Cryptography;using System.IO;using System.Text;using System.Net;public class PolonScript : MonoBehaviour{        public TextMesh OutputText;        const string _apiKey = "---apiKey---";    const string _apiSecret = "---apiSecret---";    void Start()    {           string nonce = DateTime.Now.ToString ("HHmmss");              const string WEBSERVICE_URL = "https://poloniex.com/tradingApi";        try         {            var webRequest = System.Net.WebRequest.Create (WEBSERVICE_URL);            if (webRequest != null)             {                webRequest.Method = "POST";                //webRequest.Timeout = 12000;                webRequest.ContentType = "application/x-www-form-urlencoded";                    byte[] dataStream =                     Encoding.UTF8.GetBytes("command=returnBalances&nonce=" + nonce);                    webRequest.Headers.Add("Key", _apiKey);                webRequest.Headers.Add("Sign", genHMAC (dataStream));                   Stream newStream = webRequest.GetRequestStream();                newStream.Write(dataStream, 0, dataStream.Length);                newStream.Close();                    using (System.IO.Stream s =                         webRequest.GetResponse().GetResponseStream())                 {                    using (System.IO.StreamReader sr = new System.IO.StreamReader(s))                     {                        var jsonResponse = sr.ReadToEnd();                        OutputText.text = jsonResponse.ToString();                    }                }            }        }         catch (WebException ex)         {            OutputText.text = ex.ToString();        }               }    //end-of-start()    private string genHMAC(byte[] dataStreamInput)    {            byte [] APISecret_Bytes =                System.Text.Encoding.UTF8.GetBytes(_apiSecret);        HMACSHA512 hmac = new HMACSHA512(APISecret_Bytes);            var signBytes = hmac.ComputeHash(dataStreamInput);            string HexDecString = string.Empty;        for (int i = 0; i < signBytes.Length; i++)        {            HexDecString += signBytes[i].ToString("X2");        }        return HexDecString;        }}

So why am I receiving the (403) Forbidden using accurate credentials?

I tried this to see the reason:

catch (WebException ex) {               OutputText.text = ex.Response.Headers.ToString ();}

and receive the following

//Date: Sat, 14 Apr 2018 15:34:56 GMT//Content-Type: application/json//Transfer-Encoding: chunked//Connection: keep-alive//Set-Cookie: __cfduid=dd1b32592915674669120afbf8181141b1523720096; expires=Sun, 14-Apr-19 15:34:56 GMT; path=/; domain=.poloniex.com; HttpOnly//Cache-Control: private//Expect-CT: max-age=604800, report-uri="https://report-//uri.cloudflare.com/cdn-cgi/beacon/expect-ct"//Server: cloudflare//CF-RAY: 40b73d4b8c98552e-ORD

What am I doing wrong here? I think something is wrong with my HMAC but am not fluent, no answers to other questions answer my problem here always getting error(403) unauthorized.

I am attempting to connect to polonium and get by current balances...

void Start(){    string nonce = DateTime.Now.ToString("HHmmss");    NonceText.text = nonce;    const string WEBSERVICE_URL = "https://poloniex.com/tradingApi";    try    {        var webRequest = System.Net.WebRequest.Create(WEBSERVICE_URL);        if (webRequest != null)        {            webRequest.Method = "POST";            //webRequest.Timeout = 12000;            webRequest.ContentType = "application/x-www-form-urlencoded";            byte[] dataStream =                Encoding.UTF8.GetBytes("command=returnBalances&nonce=" + nonce);            webRequest.Headers.Add("Key", _apiKey);            webRequest.Headers.Add("Sign", genHMAC(dataStream));            Stream newStream = webRequest.GetRequestStream();            newStream.Write(dataStream, 0, dataStream.Length);            newStream.Close();            SignText.text = genHMAC(dataStream).ToString();            using (System.IO.Stream s =                    webRequest.GetResponse().GetResponseStream())            {                using (System.IO.StreamReader sr = new System.IO.StreamReader(s))                {                    var jsonResponse = sr.ReadToEnd();                    OutputText.text = jsonResponse.ToString();                }            }        }    }    catch (WebException ex)    {        OutputText.text = ex.ToString();    }}//end-of-start()private string genHMAC(byte[] dataStreamInput){    byte[] APISecret_Bytes =           System.Text.Encoding.UTF8.GetBytes(_apiSecret);    HMACSHA512 hmac = new HMACSHA512(APISecret_Bytes);    var signBytes = hmac.ComputeHash(dataStreamInput);    string HexDecString = string.Empty;    for (int i = 0; i < signBytes.Length; i++)    {        HexDecString += signBytes[i].ToString("X2");    }    return HexDecString;}

Also am I only having 1 problem here or multiple problems, have been on this code for months.

I try to create a certificate signing request with openssl:

openssl req -key my.key -out out.csr -new -subj "XXXXXXX" -config openssl-san.cnf

but get this error:

req: Unknown digest sha-512req: Use -help for summary.

I'm working under Ubuntu 18.04, all files are there and are autogenerated, so I don't think the config or the key files are the problem.

For some reason using the crypt module uses the 13 char hash rather than sha-512 no matter what I try. I have seen countless questions about problems, but none of them match mine. Is there simply no way to change the crypt method?

>>> import crypt>>> print(crypt.crypt("password", salt="$6$saltsalt"))$6FMi11BJFsAc>>> print(crypt.crypt("password", crypt.METHOD_SHA512))$6FMi11BJFsAc>>> 

Not sure exactly what is going on. If this is a case-specific thing, are there alternatives to crypt that have the same crypt(3) functionality?

Thanks in advance!