{"action":"closed","issue":{"url":"https://api.github.com/repos/letsencrypt/boulder/issues/1955","repository_url":"https://api.github.com/repos/letsencrypt/boulder","labels_url":"https://api.github.com/repos/letsencrypt/boulder/issues/1955/labels{/name}","comments_url":"https://api.github.com/repos/letsencrypt/boulder/issues/1955/comments","events_url":"https://api.github.com/repos/letsencrypt/boulder/issues/1955/events","html_url":"https://github.com/letsencrypt/boulder/issues/1955","id":161629649,"number":1955,"title":"Test errors from a new installation","user":{"login":"weppos","id":5387,"avatar_url":"https://avatars.githubusercontent.com/u/5387?v=3","gravatar_id":"","url":"https://api.github.com/users/weppos","html_url":"https://github.com/weppos","followers_url":"https://api.github.com/users/weppos/followers","following_url":"https://api.github.com/users/weppos/following{/other_user}","gists_url":"https://api.github.com/users/weppos/gists{/gist_id}","starred_url":"https://api.github.com/users/weppos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/weppos/subscriptions","organizations_url":"https://api.github.com/users/weppos/orgs","repos_url":"https://api.github.com/users/weppos/repos","events_url":"https://api.github.com/users/weppos/events{/privacy}","received_events_url":"https://api.github.com/users/weppos/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":22,"created_at":"2016-06-22T09:07:44Z","updated_at":"2016-06-23T21:13:05Z","closed_at":"2016-06-23T21:13:05Z","body":"I've just installed boulder following the instructions in the README and here's the failing tests:\r\n\r\n```\r\n➜  boulder git:(master) ✗ ./test.sh\r\n[             vet] Starting\r\ngo vet github.com/letsencrypt/boulder/akamai github.com/letsencrypt/boulder/bdns github.com/letsencrypt/boulder/ca github.com/letsencrypt/boulder/cdr github.com/letsencrypt/boulder/cmd github.com/letsencrypt/boulder/cmd/admin-revoker github.com/letsencrypt/boulder/cmd/boulder-ca github.com/letsencrypt/boulder/cmd/boulder-publisher github.com/letsencrypt/boulder/cmd/boulder-ra github.com/letsencrypt/boulder/cmd/boulder-sa github.com/letsencrypt/boulder/cmd/boulder-va github.com/letsencrypt/boulder/cmd/boulder-wfe github.com/letsencrypt/boulder/cmd/caa-checker github.com/letsencrypt/boulder/cmd/caa-checker/proto github.com/letsencrypt/boulder/cmd/caa-checker/test-client github.com/letsencrypt/boulder/cmd/cert-checker github.com/letsencrypt/boulder/cmd/contact-exporter github.com/letsencrypt/boulder/cmd/expiration-mailer github.com/letsencrypt/boulder/cmd/expired-authz-purger github.com/letsencrypt/boulder/cmd/notify-mailer github.com/letsencrypt/boulder/cmd/ocsp-responder github.com/letsencrypt/boulder/cmd/ocsp-updater github.com/letsencrypt/boulder/cmd/orphan-finder github.com/letsencrypt/boulder/cmd/rabbitmq-setup github.com/letsencrypt/boulder/cmd/single-ocsp github.com/letsencrypt/boulder/cmd/single-ocsp/test github.com/letsencrypt/boulder/core github.com/letsencrypt/boulder/core/proto github.com/letsencrypt/boulder/csr github.com/letsencrypt/boulder/goodkey github.com/letsencrypt/boulder/grpc github.com/letsencrypt/boulder/grpc/creds github.com/letsencrypt/boulder/log github.com/letsencrypt/boulder/mail github.com/letsencrypt/boulder/metrics github.com/letsencrypt/boulder/mocks github.com/letsencrypt/boulder/nonce github.com/letsencrypt/boulder/policy github.com/letsencrypt/boulder/probs github.com/letsencrypt/boulder/publisher github.com/letsencrypt/boulder/publisher/proto github.com/letsencrypt/boulder/ra github.com/letsencrypt/boulder/ratelimit github.com/letsencrypt/boulder/reloader github.com/letsencrypt/boulder/rpc github.com/letsencrypt/boulder/sa github.com/letsencrypt/boulder/sa/satest github.com/letsencrypt/boulder/test github.com/letsencrypt/boulder/test/ct-test-srv github.com/letsencrypt/boulder/test/dns-test-srv github.com/letsencrypt/boulder/test/mail-test-srv github.com/letsencrypt/boulder/test/vars github.com/letsencrypt/boulder/va github.com/letsencrypt/boulder/va/proto github.com/letsencrypt/boulder/wfe\r\n[             vet] Done\r\n[             fmt] Starting\r\ncheck_gofmt\r\n[             fmt] Done\r\n[      migrations] Starting\r\n./test/test-no-outdated-migrations.sh\r\n[      migrations] Done\r\ngo test -p 1 github.com/letsencrypt/boulder/akamai github.com/letsencrypt/boulder/bdns github.com/letsencrypt/boulder/ca github.com/letsencrypt/boulder/cdr github.com/letsencrypt/boulder/cmd github.com/letsencrypt/boulder/cmd/admin-revoker github.com/letsencrypt/boulder/cmd/boulder-ca github.com/letsencrypt/boulder/cmd/boulder-publisher github.com/letsencrypt/boulder/cmd/boulder-ra github.com/letsencrypt/boulder/cmd/boulder-sa github.com/letsencrypt/boulder/cmd/boulder-va github.com/letsencrypt/boulder/cmd/boulder-wfe github.com/letsencrypt/boulder/cmd/caa-checker github.com/letsencrypt/boulder/cmd/caa-checker/proto github.com/letsencrypt/boulder/cmd/caa-checker/test-client github.com/letsencrypt/boulder/cmd/cert-checker github.com/letsencrypt/boulder/cmd/contact-exporter github.com/letsencrypt/boulder/cmd/expiration-mailer github.com/letsencrypt/boulder/cmd/expired-authz-purger github.com/letsencrypt/boulder/cmd/notify-mailer github.com/letsencrypt/boulder/cmd/ocsp-responder github.com/letsencrypt/boulder/cmd/ocsp-updater github.com/letsencrypt/boulder/cmd/orphan-finder github.com/letsencrypt/boulder/cmd/rabbitmq-setup github.com/letsencrypt/boulder/cmd/single-ocsp github.com/letsencrypt/boulder/cmd/single-ocsp/test github.com/letsencrypt/boulder/core github.com/letsencrypt/boulder/core/proto github.com/letsencrypt/boulder/csr github.com/letsencrypt/boulder/goodkey github.com/letsencrypt/boulder/grpc github.com/letsencrypt/boulder/grpc/creds github.com/letsencrypt/boulder/log github.com/letsencrypt/boulder/mail github.com/letsencrypt/boulder/metrics github.com/letsencrypt/boulder/mocks github.com/letsencrypt/boulder/nonce github.com/letsencrypt/boulder/policy github.com/letsencrypt/boulder/probs github.com/letsencrypt/boulder/publisher github.com/letsencrypt/boulder/publisher/proto github.com/letsencrypt/boulder/ra github.com/letsencrypt/boulder/ratelimit github.com/letsencrypt/boulder/reloader github.com/letsencrypt/boulder/rpc github.com/letsencrypt/boulder/sa github.com/letsencrypt/boulder/sa/satest github.com/letsencrypt/boulder/test github.com/letsencrypt/boulder/test/ct-test-srv github.com/letsencrypt/boulder/test/dns-test-srv github.com/letsencrypt/boulder/test/mail-test-srv github.com/letsencrypt/boulder/test/vars github.com/letsencrypt/boulder/va github.com/letsencrypt/boulder/va/proto github.com/letsencrypt/boulder/wfe\r\nok  \tgithub.com/letsencrypt/boulder/akamai\t0.020s\r\nok  \tgithub.com/letsencrypt/boulder/bdns\t0.228s\r\nok  \tgithub.com/letsencrypt/boulder/ca\t0.130s\r\nok  \tgithub.com/letsencrypt/boulder/cdr\t0.036s\r\nok  \tgithub.com/letsencrypt/boulder/cmd\t0.023s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/admin-revoker\t0.022s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/boulder-ca\t0.021s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/boulder-publisher\t0.027s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/boulder-ra\t0.024s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/boulder-sa\t0.022s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/boulder-va\t0.023s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/boulder-wfe\t0.020s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/caa-checker\t0.021s\r\n?   \tgithub.com/letsencrypt/boulder/cmd/caa-checker/proto\t[no test files]\r\n?   \tgithub.com/letsencrypt/boulder/cmd/caa-checker/test-client\t[no test files]\r\nI110436 cert-checker.test loading hostname policy, sha256: 3ddc932620e3f59623af52971fcc3cf38c9759f64575fd018a7097875427ea5e\r\n\tmain_test.go:207: Couldn't add certificate: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestGetAndProcessCerts (0.36s)\r\n{\r\n  \"good-certs\": 2,\r\n  \"bad-certs\": 1,\r\n  \"entries\": {\r\n    \"020000000000004b475da49b91da5c17\": {\r\n      \"valid\": true\r\n    },\r\n    \"020000000000004d1613e581432cba7e\": {\r\n      \"valid\": true\r\n    },\r\n    \"020000000000004e402bc21035c6634a\": {\r\n      \"valid\": false,\r\n      \"problems\": [\r\n        \"None really...\"\r\n      ]\r\n    }\r\n  }\r\n}\r\nFAIL\r\nFAIL\tgithub.com/letsencrypt/boulder/cmd/cert-checker\t0.536s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/contact-exporter\t0.181s\r\n\tmain_test.go:357: Couldn't add fqdnStatusD: Error 1146: Table 'boulder_sa_test.fqdnsets' doesn't exist\r\n--- FAIL: TestFindExpiringCertificates (0.12s)\r\n\tmain_test.go:506: Couldn't add fqdnStatus 000000000000000000000000000000000538: Error 1146: Table 'boulder_sa_test.fqdnsets' doesn't exist\r\n--- FAIL: TestCertIsRenewed (0.07s)\r\nFAIL\r\nFAIL\tgithub.com/letsencrypt/boulder/cmd/expiration-mailer\t0.532s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/expired-authz-purger\t0.115s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/notify-mailer\t0.033s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/ocsp-responder\t0.034s\r\n\tmain_test.go:107: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestGenerateAndStoreOCSPResponse (0.06s)\r\n\tmain_test.go:135: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestGenerateOCSPResponses (0.06s)\r\n\tmain_test.go:162: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestFindStaleOCSPResponses (0.06s)\r\n\tmain_test.go:190: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestGetCertificatesWithMissingResponses (0.06s)\r\n\tmain_test.go:205: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestFindRevokedCertificatesToUpdate (0.07s)\r\n\tmain_test.go:227: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestNewCertificateTick (0.07s)\r\n\tmain_test.go:246: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestOldOCSPResponsesTick (0.05s)\r\n\tmain_test.go:266: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestMissingReceiptsTick (0.05s)\r\n\tmain_test.go:346: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestRevokedCertificatesTick (0.05s)\r\n\tmain_test.go:372: Couldn't add test-cert.pem: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestStoreResponseGuard (0.07s)\r\nFAIL\r\nFAIL\tgithub.com/letsencrypt/boulder/cmd/ocsp-updater\t0.689s\r\nok  \tgithub.com/letsencrypt/boulder/cmd/orphan-finder\t0.027s\r\n?   \tgithub.com/letsencrypt/boulder/cmd/rabbitmq-setup\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/cmd/single-ocsp\t0.020s\r\n?   \tgithub.com/letsencrypt/boulder/cmd/single-ocsp/test\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/core\t4.645s\r\n?   \tgithub.com/letsencrypt/boulder/core/proto\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/csr\t0.132s\r\nok  \tgithub.com/letsencrypt/boulder/goodkey\t10.000s\r\nok  \tgithub.com/letsencrypt/boulder/grpc\t0.528s\r\nok  \tgithub.com/letsencrypt/boulder/grpc/creds\t0.083s\r\nok  \tgithub.com/letsencrypt/boulder/log\t0.117s\r\nok  \tgithub.com/letsencrypt/boulder/mail\t0.024s\r\nok  \tgithub.com/letsencrypt/boulder/metrics\t0.013s\r\n?   \tgithub.com/letsencrypt/boulder/mocks\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/nonce\t0.015s\r\nok  \tgithub.com/letsencrypt/boulder/policy\t0.026s\r\nok  \tgithub.com/letsencrypt/boulder/probs\t0.011s\r\nok  \tgithub.com/letsencrypt/boulder/publisher\t5.096s\r\n?   \tgithub.com/letsencrypt/boulder/publisher/proto\t[no test files]\r\n\tra_test.go:818: Failed to store certificate: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestTotalCertRateLimit (0.05s)\r\n\tra_test.go:929: [100000] != [99999]\r\n--- FAIL: TestRateLimitLiveReload (2.07s)\r\nFAIL\r\nFAIL\tgithub.com/letsencrypt/boulder/ra\t2.986s\r\nok  \tgithub.com/letsencrypt/boulder/ratelimit\t0.022s\r\nfatal error: all goroutines are asleep - deadlock!\r\n\r\ngoroutine 1 [chan receive]:\r\ntesting.RunTests(0x1d09b8, 0x25dc40, 0x6, 0x6, 0x27cf01)\r\n\t/usr/local/Cellar/go/1.6.2/libexec/src/testing/testing.go:583 +0x8d2\r\ntesting.(*M).Run(0xc82003def8, 0x1991a0)\r\n\t/usr/local/Cellar/go/1.6.2/libexec/src/testing/testing.go:515 +0x81\r\nmain.main()\r\n\tgithub.com/letsencrypt/boulder/reloader/_test/_testmain.go:64 +0x117\r\n\r\ngoroutine 11 [chan receive]:\r\ngithub.com/letsencrypt/boulder/reloader.TestReload(0xc820084240)\r\n\t/Users/weppos/go/src/github.com/letsencrypt/boulder/reloader/reloader_test.go:129 +0xc0b\r\ntesting.tRunner(0xc820084240, 0x25dca0)\r\n\t/usr/local/Cellar/go/1.6.2/libexec/src/testing/testing.go:473 +0x98\r\ncreated by testing.RunTests\r\n\t/usr/local/Cellar/go/1.6.2/libexec/src/testing/testing.go:582 +0x892\r\n\r\ngoroutine 12 [select]:\r\ngithub.com/letsencrypt/boulder/reloader.New.func2()\r\n\t/Users/weppos/go/src/github.com/letsencrypt/boulder/reloader/reloader.go:51 +0x365\r\ncreated by github.com/letsencrypt/boulder/reloader.New\r\n\t/Users/weppos/go/src/github.com/letsencrypt/boulder/reloader/reloader.go:82 +0x36e\r\nFAIL\tgithub.com/letsencrypt/boulder/reloader\t0.031s\r\nok  \tgithub.com/letsencrypt/boulder/rpc\t0.023s\r\n\tsa_test.go:378: Couldn't add www.eff.org.der: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestAddCertificate (0.04s)\r\n\tsa_test.go:439: Couldn't add test-cert.der: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestCountCertificatesByNames (0.04s)\r\n\tsa_test.go:532: Couldn't add www.eff.org.der: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestMarkCertificateRevoked (0.05s)\r\n\tsa_test.go:573: Couldn't add www.eff.org.der: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestCountCertificates (0.03s)\r\n\tsa_test.go:670: Failed to add name set: Error 1142: INSERT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestFQDNSets (0.04s)\r\n\tsa_test.go:721: Failed to check FQDN set existence: Error 1142: SELECT command denied to user 'sa'@'localhost' for table 'fqdnsets'\r\n--- FAIL: TestFQDNSetsExists (0.04s)\r\nFAIL\r\nFAIL\tgithub.com/letsencrypt/boulder/sa\t0.821s\r\n?   \tgithub.com/letsencrypt/boulder/sa/satest\t[no test files]\r\n?   \tgithub.com/letsencrypt/boulder/test\t[no test files]\r\n?   \tgithub.com/letsencrypt/boulder/test/ct-test-srv\t[no test files]\r\n?   \tgithub.com/letsencrypt/boulder/test/dns-test-srv\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/test/mail-test-srv\t0.011s\r\n?   \tgithub.com/letsencrypt/boulder/test/vars\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/va\t15.156s\r\n?   \tgithub.com/letsencrypt/boulder/va/proto\t[no test files]\r\nok  \tgithub.com/letsencrypt/boulder/wfe\t0.249s\r\n[!] FAILURE: go test -p 1 github.com/letsencrypt/boulder/akamai github.com/letsencrypt/boulder/bdns github.com/letsencrypt/boulder/ca github.com/letsencrypt/boulder/cdr github.com/letsencrypt/boulder/cmd github.com/letsencrypt/boulder/cmd/admin-revoker github.com/letsencrypt/boulder/cmd/boulder-ca github.com/letsencrypt/boulder/cmd/boulder-publisher github.com/letsencrypt/boulder/cmd/boulder-ra github.com/letsencrypt/boulder/cmd/boulder-sa github.com/letsencrypt/boulder/cmd/boulder-va github.com/letsencrypt/boulder/cmd/boulder-wfe github.com/letsencrypt/boulder/cmd/caa-checker github.com/letsencrypt/boulder/cmd/caa-checker/proto github.com/letsencrypt/boulder/cmd/caa-checker/test-client github.com/letsencrypt/boulder/cmd/cert-checker github.com/letsencrypt/boulder/cmd/contact-exporter github.com/letsencrypt/boulder/cmd/expiration-mailer github.com/letsencrypt/boulder/cmd/expired-authz-purger github.com/letsencrypt/boulder/cmd/notify-mailer github.com/letsencrypt/boulder/cmd/ocsp-responder github.com/letsencrypt/boulder/cmd/ocsp-updater github.com/letsencrypt/boulder/cmd/orphan-finder github.com/letsencrypt/boulder/cmd/rabbitmq-setup github.com/letsencrypt/boulder/cmd/single-ocsp github.com/letsencrypt/boulder/cmd/single-ocsp/test github.com/letsencrypt/boulder/core github.com/letsencrypt/boulder/core/proto github.com/letsencrypt/boulder/csr github.com/letsencrypt/boulder/goodkey github.com/letsencrypt/boulder/grpc github.com/letsencrypt/boulder/grpc/creds github.com/letsencrypt/boulder/log github.com/letsencrypt/boulder/mail github.com/letsencrypt/boulder/metrics github.com/letsencrypt/boulder/mocks github.com/letsencrypt/boulder/nonce github.com/letsencrypt/boulder/policy github.com/letsencrypt/boulder/probs github.com/letsencrypt/boulder/publisher github.com/letsencrypt/boulder/publisher/proto github.com/letsencrypt/boulder/ra github.com/letsencrypt/boulder/ratelimit github.com/letsencrypt/boulder/reloader github.com/letsencrypt/boulder/rpc github.com/letsencrypt/boulder/sa github.com/letsencrypt/boulder/sa/satest github.com/letsencrypt/boulder/test github.com/letsencrypt/boulder/test/ct-test-srv github.com/letsencrypt/boulder/test/dns-test-srv github.com/letsencrypt/boulder/test/mail-test-srv github.com/letsencrypt/boulder/test/vars github.com/letsencrypt/boulder/va github.com/letsencrypt/boulder/va/proto github.com/letsencrypt/boulder/wfe\r\n--------------------------------------------------\r\n---        A unit test or tool failed.         ---\r\n--- Stopping before running integration tests. ---\r\n--------------------------------------------------\r\n```\r\n\r\nIt is worth to mention I previously installed it months ago but the setup should be fresh, as I cleared the database before restarting. Also, the setup went successfull (no errors).\r\n\r\nPS. Congrats, the setup went much nicer than the experience I had the first time. \r\n\r\n/cc @jsha "}}
{"actor":{"display_login":"jsha"}}