Victor Vrantchan

@znb @sunilkal I just provisioned a Ubuntu 16.04 server on DigitalOcean and installed mysql with https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-16-04 then followed the instructions on the docs page https://github.com/kolide/fleet/blob/63d60d5f6a0ec3239279250aa0a103f93d74b4ae/docs/infrastructure/fleet-on-ubuntu.md ``` root@ubuntu-1gb-nyc3-01:~# mysqld --version mysqld...

The error happens https://github.com/kolide/fleet/blob/63d60d5f6a0ec3239279250aa0a103f93d74b4ae/server/datastore/mysql/migrations/tables/20161118212641_CreateTablePasswordResetRequests.go#L17 because of strict mode in mysql, although we're in the range specified by the [documentation](https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date) You can try to see if changing the `1970-01-01 00:00:01` value...

mind sharing the mysql config you have? Is `strict_mode` enabled?

`docker pull mysql:5.7` The config for that mysql instance works, as does ubuntu on digital ocean. I'm not really sure how your distro is different, or whether the issue is...

☂️ If you're using a specific cloud provider/ubuntu image it would be helpful to give us detailed steps that we could use to reproduce the error with.

A diff of the two mysql configs and mysql version numbers would be extremely helpful.

Another thing here with password resets is that the update timestamps are set by the datastore, but here they're being setup in service. Won't they be overridden by mysql? Question...

I personally prefer the strategy used in invites because it doesn't add an extra field and we already have timestamps we should be relying on for each object. But I...

The functional difference is that if you change a config value, the invite token will be considered expired/not expired depending on the config duration. This might be a pro or...

1. would be nice but right now it requires external tooling to complete, and we can't really make those assumptions about the host that kolide is running on. I think...