systemd: logind: prevent lid close suspension

closes #2952
sqlite: always use memory for tempfiles.

credits to @bavison for the MAP_POPULATE patch