Adjusting log levels #468

Activity

1. gabrielpoca commented on Jan 4, 2018

   

   gabrielpoca

   on Jan 4, 2018

   Contributor

   More actions

   You are referring to the database logs, right? Can you explain the issue? I did a quick research and I cannot find anything in the code that allows that, but it should be possible.
2. xuhcc commented on Jan 4, 2018

   

   xuhcc

   on Jan 4, 2018

   Author

   More actions

   Yes, I'm referring to the database logs. These messages are shown in system logs when stringer is running as systemd service (I've installed stringer on my own server). It would be convenient if logging level could be configured using environment variable in a way similar to database settings (DATABASE_URL).

   👍React with 👍1Reacted by Scott Hansen
3. firecat53 commented on Jul 23, 2018

   

   firecat53

   on Jul 23, 2018

   More actions

   Has anyone figured out how to disable the debug logging yet? I don't know Ruby/Rails at all. Stuff I've tried so far hasn't worked, but I feel like I'm just groping in the dark!
4. maxmeyer commented on Aug 7, 2018

   

   maxmeyer

   on Aug 7, 2018

   Last edited by maxmeyer

   Contributor

   More actions

   Please have a look at: f3d6280 in #460
5. firecat53 commented on Aug 7, 2018

   

   firecat53

   on Aug 7, 2018

   More actions

   Well, that apparently doesn't work. I still get debug messages like:

   D, [2018-08-07T13:29:24.214322 #37] DEBUG -- :   SQL (5.5ms)  DELETE FROM "delayed_jobs"
   D, [2018-08-07T13:29:24.216086 #37] DEBUG -- :   Delayed::Backend::ActiveRecord::Job Load (0.2ms)  SELECT  "delayed_jobs".* FROM "delayed_jobs" WHERE ((run_at <= '2018-08-07 20:29:24.214766' AND (locked_at IS NULL OR locked_at < '2018-08-07 16:29:24.214774') OR locked_by = 'host:49cf339bf718 pid:37') AND failed_at IS NULL)  ORDER BY priority ASC, run_at ASC LIMIT 5
   

   I tried just using the ActiveRecord::Base.logger.level = Logger::INFO line without the rest of the case statement, but still am getting a constant stream of debug notices.

   Any ideas?
6. firecat53 commented on Aug 7, 2018

   

   firecat53

   on Aug 7, 2018

   More actions

   This seems to work for now. It doesn't allow setting the log level via env variables, but close enough until someone who actually knows Ruby can propose a better fix 😄

   diff --git a/app.rb b/app.rb
   index 1169a3b..d5919bf 100644
   --- a/app.rb
   +++ b/app.rb
   @@ -36,6 +36,7 @@ class Stringer < Sinatra::Base
        enable :sessions
        set :session_secret, ENV["SECRET_TOKEN"] || SecureRandom.hex(32)
        enable :logging
   +    ActiveRecord::Base.logger.level = Logger::INFO
        enable :method_override
    
        ActiveRecord::Base.include_root_in_json = false