Database errors

[K T]

I've been trying to set up Trillian+CTFE (as advised here). But although I set up my database as instructed in the Trillian README and also granted full privileges to 'test'@'localhost', I'm getting the following error when running certificate-transparency-go/trillian/integration/demo-script.sh:

W0723 15:28:42.047124 8336 tree_storage.go:81] Failed to set strict mode on mysql db: Error 1045: Access denied for user 'test'@'localhost' (using password: YES)

Also (on a possibly related note?), running trillian/scripts/resetdb.sh for a second time (or running other scripts that call it) results in this error:

ERROR 1051 (42S02) at line 1: Unknown table 'test.trees,test.mapleaf,test.treecontrol,test.maphead,test.sequencedleafdata,test.treehead,test.leaf'

This error also occurs when I try to delete the database manually. The only way to get rid of the database is to delete the tables one by one (they do exist, in spite of errors insisting otherwise). There's nothing in the schema that indicates to me why this would be happening.

I posted both of these issues on the GitHub repo, but have not gotten a reply.

Any thoughts or suggestions on these issues?

[K T]

Oh, also, I'm using MySQL 5.6 on MacOS.

[K T]

I guess you can disregard my second error. I found drop_storage.sql script in the storage directory, which successfully drops all the tables, and incorporated it into resetdb.sh, which fixed the issue.

[K T]

Turns out the first issue was caused by my having deleted the password `zaphod` in resetdb.sh for some reason, possibly while trying to debug the second issue.

Case closed.