diff --git a/jtserv/jtserv.rb b/jtserv/jtserv.rb index b99f990..52de6da 100755 --- a/jtserv/jtserv.rb +++ b/jtserv/jtserv.rb @@ -18,12 +18,16 @@ class UserDB def initialize() - @db = SQLite3::Database.new("users.sq3") + sq3 = "users.sq3" + @db = SQLite3::Database.new(sq3) ### @db.results_as_hash = true - @expireskey = '+3 days' + #### @expireskey = '+3 days' + @expireskey = '+3 hours' @expiretmpkey = '+1 hour' @from = 'postmaster@koeki-prj.org' @rank = %w(必須 標準 目標 一流 超一流 頂点) + File.chmod(0600, sq3) + File.chmod(0700, File.dirname(sq3)) dbinit end def dbinit() @@ -113,6 +117,7 @@ skey end def authKey(user, skey) + expire r = @db.execute("SELECT user FROM skey WHERE user=? AND skey=?", user, skey) if r && r[0] && r[0].length==1