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

sql error #57

Closed drewbrunson closed 11 years ago

drewbrunson commented 12 years ago

Any idea why this would occur. I've been running various reports to try out the flexibility of the risu templates and this is the first time I've seen this....

risu --config-file ../FL.cfg -t notable_detailed -o notable.pdf Error: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'real)' at line 1: SELECT COUNT(*) AS count_all, plugin_id AS plugin_id FROM items INNER JOIN plugins ON plugins.id = items.plugin_id WHERE items.severity = 4 GROUP BY plugin_id ORDER BY cast(plugins.cvss_base_score as real) /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/mysql_adapter.rb:346:in prepare' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/mysql_adapter.rb:346:inexec_stmt' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/mysql_adapter.rb:286:in exec_query' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:280:inlog' /usr/lib/ruby/gems/1.8/gems/activesupport-3.2.3/lib/active_support/notifications/instrumenter.rb:20:in instrument' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:275:inlog' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/mysql_adapter.rb:285:in exec_query' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/mysql_adapter.rb:415:inselect' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in select_all' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract/query_cache.rb:63:inselect_all' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/relation/calculations.rb:279:in execute_grouped_calculation' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/relation/calculations.rb:206:inperform_calculation' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/relation/calculations.rb:159:in calculate' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/relation/calculations.rb:151:incalculate' /usr/lib/ruby/gems/1.8/gems/activerecord-3.2.3/lib/active_record/relation/calculations.rb:58:in count' /usr/lib/ruby/gems/1.8/gems/risu-1.5.0/bin/../lib/risu/models/item.rb:348:intop_10_sorted_raw' /usr/lib/ruby/gems/1.8/gems/risu-1.5.0/bin/../lib/risu/templates/notable_detailed.rb:41:in render' /usr/lib/ruby/gems/1.8/gems/risu-1.5.0/bin/../lib/risu/base/templater.rb:29:ingenerate' /usr/lib/ruby/gems/1.8/gems/prawn-0.12.0/lib/prawn/document.rb:212:in []' /usr/lib/ruby/gems/1.8/gems/prawn-0.12.0/lib/prawn/document.rb:212:ininitialize' /usr/lib/ruby/gems/1.8/gems/prawn-0.12.0/lib/prawn/document.rb:121:in new' /usr/lib/ruby/gems/1.8/gems/prawn-0.12.0/lib/prawn/document.rb:121:ingenerate' /usr/lib/ruby/gems/1.8/gems/risu-1.5.0/bin/../lib/risu/base/templater.rb:26:in generate' /usr/lib/ruby/gems/1.8/gems/risu-1.5.0/bin/../lib/risu/cli/application.rb:366:inrun' /usr/lib/ruby/gems/1.8/gems/risu-1.5.0/bin/risu:12 /usr/bin/risu:19:in `load' /usr/bin/risu:19

hammackj commented 12 years ago

Let me look into this. Might be a issue with the query I use on mysql.

Honestly I use sqlite for all my tests, so I might have missed this.

hammackj commented 12 years ago

Are you still having this issue? I haven't been able to recreate it.