Nach dem ersten Start des Emonitor unter 32bit Linux mit mysql erhalte ich folgende Fehlermeldung:
ERROR:emonitor.communication:error telegram INFO:emonitor.communication:2 Communicator(s) loaded: telegram, mail INFO:emonitor.observer:observe folder ./data/income/ with watchdog observer Traceback (most recent call last): File "run.py", line 5, in <module> from emonitor import app File "/home/tobiby/eMonitor/emonitor/__init__.py", line 8, in <module> app = create_app() File "/home/tobiby/eMonitor/emonitor/app.py", line 84, in create_app configure_blueprints(app, DEFAULT_BLUEPRINTS) File "/home/tobiby/eMonitor/emonitor/app.py", line 225, in configure_blueprints blueprint.init_app(app) File "/home/tobiby/eMonitor/emonitor/modules/__init__.py", line 82, in init_app m = eval('m.%sModule' % str(name).title())(app) File "/home/tobiby/eMonitor/emonitor/modules/messages/__init__.py", line 51, in __init__ Messages.initMessageTrigger() File "/home/tobiby/eMonitor/emonitor/modules/messages/messages.py", line 182, in initMessageTrigger job = scheduler.add_job(Messages.doMessageTrigger, name="messages", id="messages", trigger=MessageTrigger(Messages.getActiveMessages(), minutes=60)) File "/home/tobiby/eMonitor/emonitor/modules/messages/messages.py", line 175, in getActiveMessages return Messages.query.filter(Messages.state > 0).filter(Messages.startdate <= datetime.datetime.now()).filter(Messages.enddate >= datetime.datetime.now()).order_by(Messages.startdate.asc()).all() File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2398, in all return list(self) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2515, in __iter__ return self._execute_and_instances(context) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2530, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception exc_info File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorvalue sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'emonitor.messages' doesn't exist") [SQL: u'SELECT messages.monitors AS messages_monitors, messages.type AS messages_type, messages.attributes AS messages_attributes, messages.id AS messages_id, messages.name AS messages_name, messages.remark AS messages_remark, messages.startdate AS messages_startdate, messages.enddate AS messages_enddate, messages.state AS messages_state \nFROM messages \nWHERE messages.state > %s AND messages.startdate <= %s AND messages.enddate >= %s ORDER BY messages.startdate ASC'] [parameters: (0, datetime.datetime(2016, 6, 26, 21, 53, 41, 987084), datetime.datetime(2016, 6, 26, 21, 53, 41, 987182))]
Nachdem ich die Tabelle manuell erzeugt habe funktioniert der Emonitor einwandfrei.
Nach dem ersten Start des Emonitor unter 32bit Linux mit mysql erhalte ich folgende Fehlermeldung:
ERROR:emonitor.communication:error telegram INFO:emonitor.communication:2 Communicator(s) loaded: telegram, mail INFO:emonitor.observer:observe folder ./data/income/ with watchdog observer Traceback (most recent call last): File "run.py", line 5, in <module> from emonitor import app File "/home/tobiby/eMonitor/emonitor/__init__.py", line 8, in <module> app = create_app() File "/home/tobiby/eMonitor/emonitor/app.py", line 84, in create_app configure_blueprints(app, DEFAULT_BLUEPRINTS) File "/home/tobiby/eMonitor/emonitor/app.py", line 225, in configure_blueprints blueprint.init_app(app) File "/home/tobiby/eMonitor/emonitor/modules/__init__.py", line 82, in init_app m = eval('m.%sModule' % str(name).title())(app) File "/home/tobiby/eMonitor/emonitor/modules/messages/__init__.py", line 51, in __init__ Messages.initMessageTrigger() File "/home/tobiby/eMonitor/emonitor/modules/messages/messages.py", line 182, in initMessageTrigger job = scheduler.add_job(Messages.doMessageTrigger, name="messages", id="messages", trigger=MessageTrigger(Messages.getActiveMessages(), minutes=60)) File "/home/tobiby/eMonitor/emonitor/modules/messages/messages.py", line 175, in getActiveMessages return Messages.query.filter(Messages.state > 0).filter(Messages.startdate <= datetime.datetime.now()).filter(Messages.enddate >= datetime.datetime.now()).order_by(Messages.startdate.asc()).all() File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2398, in all return list(self) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2515, in __iter__ return self._execute_and_instances(context) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py", line 2530, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute return meth(self, multiparams, params) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement compiled_sql, distilled_params File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context context) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1332, in _handle_dbapi_exception exc_info File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause reraise(type(exception), exception, tb=exc_tb) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context context) File "/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute cursor.execute(statement, parameters) File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute self.errorhandler(self, exc, value) File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler raise errorvalue sqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, "Table 'emonitor.messages' doesn't exist") [SQL: u'SELECT messages.monitors AS messages_monitors, messages.type AS messages_type, messages.attributes AS messages_attributes, messages.id AS messages_id, messages.name AS messages_name, messages.remark AS messages_remark, messages.startdate AS messages_startdate, messages.enddate AS messages_enddate, messages.state AS messages_state \nFROM messages \nWHERE messages.state > %s AND messages.startdate <= %s AND messages.enddate >= %s ORDER BY messages.startdate ASC'] [parameters: (0, datetime.datetime(2016, 6, 26, 21, 53, 41, 987084), datetime.datetime(2016, 6, 26, 21, 53, 41, 987182))]Nachdem ich die Tabelle manuell erzeugt habe funktioniert der Emonitor einwandfrei.