Resolve all Chronicle issues in MySQL

vzool commented 6 years ago

Hi,

I tested Chronicle in MySQL connection and I have some issues, I resolved two of them. But, there are many more needs to collaboration with some guidance.

The current known issues are:

[x] issue mentioned here #32. Resolved by made datetime fields filled automatically by MySQL.
[x] issue ERROR 1048 (23000): Column 'prevhash' cannot be null. Resolved at database level by swapping foreign key rule prevhash with currhash.
[ ] When Chronicle use MySQL should ignore values for datetime fields. [Not-Resolved]
[ ] Revise replica functions. [Not-Resolved]

Thanks

vzool commented 6 years ago

Publish data is working now after I commented this line and the Sapient response has an error:

No valid signature given for this HTTP response

🤔

vzool commented 6 years ago

Lock UPDATE for all fields on the chain, make it immutable 🤓

vzool commented 6 years ago

I messed things up, I will close this and create new clear one.

paragonie / chronicle

Resolve all Chronicle issues in MySQL #33