Log Reports Not Working
Posted: Fri Oct 12, 2012 3:04 pm
Hi,
I search on the forum but I find nothing about the dbalog script:
I can't have any reports from my log reports section.
I try with the script dbalog --csv, here is the return:
root@openvpnas:/usr/local/openvpn_as/scripts# ./logdba --csv
Node,Username,Start Time,Duration,Service,Active,Auth,Real Ip,Vpn Ip,Proto,Port,Bytes Total,Error
ERROR: None: (OperationalError) no such column: log.timestamp u'SELECT log.session_id AS log_session_id, log.node AS log_node, log.username AS log_username, log.common_name AS log_common_name, log.start_time AS log_start_time, log.duration AS log_duration, log.service AS log_service, log.api_method AS log_api_method, log.active AS log_active, log.auth AS log_auth, log.real_ip AS log_real_ip, log.vpn_ip AS log_vpn_ip, log.proto AS log_proto, log.port AS log_port, log.bytes_in AS log_bytes_in, log.bytes_out AS log_bytes_out, log.bytes_total AS log_bytes_total, log.error AS log_error, log.extra AS log_extra, log.timestamp AS log_timestamp \nFROM log ORDER BY log.start_time' (): util/options:79,log/logdb_admin:152,orm/query:1922,orm/query:2032,orm/query:2047,engine/base:1399,engine/base:1532,engine/base:1640,engine/base:1633,engine/default:330 (sqlalchemy.exc.OperationalError)
what can i do to have log again ?
thank's in advance !
I search on the forum but I find nothing about the dbalog script:
I can't have any reports from my log reports section.
I try with the script dbalog --csv, here is the return:
root@openvpnas:/usr/local/openvpn_as/scripts# ./logdba --csv
Node,Username,Start Time,Duration,Service,Active,Auth,Real Ip,Vpn Ip,Proto,Port,Bytes Total,Error
ERROR: None: (OperationalError) no such column: log.timestamp u'SELECT log.session_id AS log_session_id, log.node AS log_node, log.username AS log_username, log.common_name AS log_common_name, log.start_time AS log_start_time, log.duration AS log_duration, log.service AS log_service, log.api_method AS log_api_method, log.active AS log_active, log.auth AS log_auth, log.real_ip AS log_real_ip, log.vpn_ip AS log_vpn_ip, log.proto AS log_proto, log.port AS log_port, log.bytes_in AS log_bytes_in, log.bytes_out AS log_bytes_out, log.bytes_total AS log_bytes_total, log.error AS log_error, log.extra AS log_extra, log.timestamp AS log_timestamp \nFROM log ORDER BY log.start_time' (): util/options:79,log/logdb_admin:152,orm/query:1922,orm/query:2032,orm/query:2047,engine/base:1399,engine/base:1532,engine/base:1640,engine/base:1633,engine/default:330 (sqlalchemy.exc.OperationalError)
what can i do to have log again ?
thank's in advance !