search

hammackj / risu

Risu is Nessus parser, that converts the generated reports into a ActiveRecord database, this allows for easy report generation and vulnerability verification.
http://hammackj.github.io/risu
MIT License
63 stars 20 forks source link

risu's graphs template fails to generate, sqllite error #73

Closed emory closed 9 years ago

emory commented 10 years ago

I haven't tried to resolve this on my own yet, but I'm getting an error when I request a graphs template report.

% risu -t graphs -o graphs.file.pdf                                                                                    
/Users/me/.rvm/gems/ruby-2.1.0/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:91:in `initialize': SQLite3::SQLException: near
"*": syntax error: SELECT  COUNT(items.*, count(*) as count_all) AS count_items_all_count_all_as_count_all, host_id AS host_id FROM "items" INNER JOIN "hosts" ON "hosts"."id" = "items"."host_id" WHERE (plugin_id != 1) AND "items"."severity" = 4 GROUP
BY host_id  ORDER BY count_all DESC LIMIT 1864 (ActiveRecord::StatementInvalid)
       from /Users/me/.rvm/gems/ruby-2.1.0/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:91:in `new'
hammackj commented 10 years ago

I have been able to recreate the issue. Seems to work on older versions of Rails, if you roll back to 4.0.0 it might work. I am still trying to figure out a better solution. I am not exactly sure why it breaks building reports but using the console works just fine.

Thanks for reporting the issue.

hammackj commented 9 years ago

Are you still having this issue? It seems using Rails4.0.0 solved it on my end. I haven't had a chance to test with the newer versions of rails.

hammackj commented 9 years ago

Closing. Reopen if you have an update.