Hi all,
Just trying to get a cron job running so it feeds back the temp every minute. Im new to this so im not sure if im doing it right. The error i got was that the database is locked. If you need anymore info just let me know.
Request Method: POST
Request URL: https://10.0.0.66/admin/system/cronjob/add/
Software Version: FreeNAS-9.2.0-RELEASE-x64 (ab098f4)
Exception Type: DatabaseError
Exception Value:
database is locked
Exception Location: /usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 362
Server time: Mon, 13 Jan 2014 11:52:29 +1000
Traceback
Environment:
Software Version: FreeNAS-9.2.0-RELEASE-x64 (ab098f4)
Request Method: POST
Request URL: https://10.0.0.66/admin/system/cronjob/add/
Traceback:
File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
109. response = middleware_method(request, callback, callback_args, callback_kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/middleware.py" in process_view
159. return login_required(view_func)(request, *view_args, **view_kwargs)
File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
25. return view_func(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/options.py" in wrapper
209. return self._admin.admin_view(view)(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapped_view
91. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
89. response = view_func(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/site.py" in inner
144. return view(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/options.py" in add
338. mf.save()
File "/usr/local/www/freenasUI/../freenasUI/system/forms.py" in save
834. super(CronJobForm, self).save()
File "/usr/local/lib/python2.7/site-packages/django/forms/models.py" in save
370. fail_message, commit, construct=False)
File "/usr/local/lib/python2.7/site-packages/django/forms/models.py" in save_instance
87. instance.save()
File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py" in save
546. force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py" in save_base
650. result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py" in _insert
215. return insert_query(self.model, objs, fields, **kwargs)
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in insert_query
1675. return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
943. cursor.execute(sql, params)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
366. six.reraise(utils.DatabaseError, utils.DatabaseError(*tuple(e.args)), sys.exc_info()[2])
File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
362. return Database.Cursor.execute(self, query, params)
Exception Type: DatabaseError at /admin/system/cronjob/add/
Exception Value: database is locked
Request information
GET
No GET data
POST
VariableValue
cron_month u'12'
__all__ u''
__form_id u'dialogForm_Cron Job'
cron_hour u'*'
cron_enabled u'on'
cron_user u'root'
cron_minute u'*'
cron_command u' #! /bin/bash adastat () { echo -n `camcontrol cmd $1 -a "E5 00 00 00 00 00 00 00 00 00 00 00" -r - | awk \'{print $10 " " ; }\'` " " ; } echo echo System Temperatures - `date` cat /etc/version.freenas uptime | awk \'{ print "\\nSystem Load:",$8,$9,$10,"\\n" }\' echo "CPU Temperature:" sysctl -a | egrep -E "cpu\\.[0-9]+\\.temp" echo echo "Drive Activity Status" for i in $(sysctl -n kern.disks | awk \'{for (i=NF; i!=0 ; i--) if (match($i, \'/ada/\')) print $i }\'); do echo -n $i:; adastat $i; done; echo ; echo echo "HDD Temperature:" for i in $(sysctl -n kern.disks | awk \'{for (i=NF; i!=0 ; i--) if (match($i, \'/ada/\')) print $i }\') do echo $i `smartctl -a /dev/$i | awk \'/Temperature_Celsius/{DevTemp=$10;} /Serial Number:/{DevSerNum=$3}; /Device Model:/{DevName=$3} END { print DevTemp,DevSerNum,DevName }\'` done echo'
cron_daymonth u'*'
cron_dayweek u'7'
cron_description u'Temp check'
FILES
No FILES data
COOKIES
VariableValue
csrftoken 'XnauEz1iHVPOnJL6UJ170Qn47loXfDlD'
sessionid 'f30lpgr0hwbb6i3n4rr8912o2ang112q'
fntreeSaveStateCookie 'root%2Croot%2F8%2F12%2Croot%2F8%2F9%2Croot%2F8%2F24%2Croot%2F78%2Croot%2F78%2F110%2F112%2Croot%2F51%2F55%2Croot%2F51%2F52%2Croot%2F51%2F58%2Croot%2F51%2F58%2F59%2Croot%2F73%2F80%2Croot%2F84%2Croot%2F51%2F69%2Croot%2F73%2Croot%2F90%2Croot%2F90%2F122%2Croot%2F90%2F122%2F124%2Croot%2F95%2Croot%2F139%2Croot%2F1%2Croot%2F158%2Croot%2F161%2Croot%2F10%2F34%2Croot%2F10%2F30%2Croot%2F10%2F26%2Croot%2F10%2F14%2Croot%2F10%2Croot%2F10%2F17%2Croot%2F56%2Croot%2F56%2F63%2F64%2Croot%2F40%2Croot%2F1%2F2%2Croot%2F1%2F5%2Croot%2F8%2Croot%2F8%2F32%2Croot%2F8%2F28%2Croot%2F8%2F15%2Croot%2F53%2Croot%2F53%2F67'
META
VariableValue
wsgi.multiprocess False
HTTP_REFERER 'https://10.0.0.66/'
REDIRECT_STATUS '200'
SERVER_SOFTWARE 'nginx/1.4.3'
SCRIPT_NAME u''
HTTP_X_CSRFTOKEN 'XnauEz1iHVPOnJL6UJ170Qn47loXfDlD'
REQUEST_METHOD 'POST'
PATH_INFO u'/admin/system/cronjob/add/'
SERVER_PROTOCOL 'HTTP/1.1'
QUERY_STRING ''
CONTENT_LENGTH '1782'
HTTP_USER_AGENT 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0'
HTTP_CONNECTION 'keep-alive'
HTTP_COOKIE 'csrftoken=XnauEz1iHVPOnJL6UJ170Qn47loXfDlD; sessionid=f30lpgr0hwbb6i3n4rr8912o2ang112q; fntreeSaveStateCookie=root%2Croot%2F8%2F12%2Croot%2F8%2F9%2Croot%2F8%2F24%2Croot%2F78%2Croot%2F78%2F110%2F112%2Croot%2F51%2F55%2Croot%2F51%2F52%2Croot%2F51%2F58%2Croot%2F51%2F58%2F59%2Croot%2F73%2F80%2Croot%2F84%2Croot%2F51%2F69%2Croot%2F73%2Croot%2F90%2Croot%2F90%2F122%2Croot%2F90%2F122%2F124%2Croot%2F95%2Croot%2F139%2Croot%2F1%2Croot%2F158%2Croot%2F161%2Croot%2F10%2F34%2Croot%2F10%2F30%2Croot%2F10%2F26%2Croot%2F10%2F14%2Croot%2F10%2Croot%2F10%2F17%2Croot%2F56%2Croot%2F56%2F63%2F64%2Croot%2F40%2Croot%2F1%2F2%2Croot%2F1%2F5%2Croot%2F8%2Croot%2F8%2F32%2Croot%2F8%2F28%2Croot%2F8%2F15%2Croot%2F53%2Croot%2F53%2F67'
SERVER_NAME 'localhost'
REMOTE_PORT '50505'
wsgi.url_scheme 'https'
SERVER_PORT '443'
SERVER_ADDR '10.0.0.66'
DOCUMENT_ROOT '/usr/local/etc/nginx/html'
HTTP_PRAGMA 'no-cache'
HTTP_CONTENT_LENGTH '1782'
HTTP_X_REQUESTED_WITH 'XMLHttpRequest'
DOCUMENT_URI '/admin/system/cronjob/add/'
wsgi.input <flup.server.fcgi_base.InputStream object at 0x818faad10>
HTTP_HOST '10.0.0.66'
HTTPS 'on'
wsgi.multithread True
HTTP_CACHE_CONTROL 'no-cache'
HTTP_CONTENT_TYPE 'application/x-www-form-urlencoded; charset=UTF-8'
REQUEST_URI '/admin/system/cronjob/add/'
HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
wsgi.version (1, 0)
GATEWAY_INTERFACE 'CGI/1.1'
wsgi.run_once False
wsgi.errors <flup.server.fcgi_base.TeeOutputStream object at 0x8151d65d0>
REMOTE_ADDR '10.0.0.10'
HTTP_ACCEPT_LANGUAGE 'en-US,en;q=0.5'
CONTENT_TYPE 'application/x-www-form-urlencoded; charset=UTF-8'
CSRF_COOKIE u'XnauEz1iHVPOnJL6UJ170Qn47loXfDlD'
HTTP_ACCEPT_ENCODING 'gzip, deflate'
Just trying to get a cron job running so it feeds back the temp every minute. Im new to this so im not sure if im doing it right. The error i got was that the database is locked. If you need anymore info just let me know.
Request Method: POST
Request URL: https://10.0.0.66/admin/system/cronjob/add/
Software Version: FreeNAS-9.2.0-RELEASE-x64 (ab098f4)
Exception Type: DatabaseError
Exception Value:
database is locked
Exception Location: /usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 362
Server time: Mon, 13 Jan 2014 11:52:29 +1000
Traceback
Environment:
Software Version: FreeNAS-9.2.0-RELEASE-x64 (ab098f4)
Request Method: POST
Request URL: https://10.0.0.66/admin/system/cronjob/add/
Traceback:
File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response
109. response = middleware_method(request, callback, callback_args, callback_kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/middleware.py" in process_view
159. return login_required(view_func)(request, *view_args, **view_kwargs)
File "/usr/local/lib/python2.7/site-packages/django/contrib/auth/decorators.py" in _wrapped_view
25. return view_func(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/options.py" in wrapper
209. return self._admin.admin_view(view)(*args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/django/utils/decorators.py" in _wrapped_view
91. response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
89. response = view_func(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/site.py" in inner
144. return view(request, *args, **kwargs)
File "/usr/local/www/freenasUI/../freenasUI/freeadmin/options.py" in add
338. mf.save()
File "/usr/local/www/freenasUI/../freenasUI/system/forms.py" in save
834. super(CronJobForm, self).save()
File "/usr/local/lib/python2.7/site-packages/django/forms/models.py" in save
370. fail_message, commit, construct=False)
File "/usr/local/lib/python2.7/site-packages/django/forms/models.py" in save_instance
87. instance.save()
File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py" in save
546. force_update=force_update, update_fields=update_fields)
File "/usr/local/lib/python2.7/site-packages/django/db/models/base.py" in save_base
650. result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
File "/usr/local/lib/python2.7/site-packages/django/db/models/manager.py" in _insert
215. return insert_query(self.model, objs, fields, **kwargs)
File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in insert_query
1675. return query.get_compiler(using=using).execute_sql(return_id)
File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
943. cursor.execute(sql, params)
File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
366. six.reraise(utils.DatabaseError, utils.DatabaseError(*tuple(e.args)), sys.exc_info()[2])
File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute
362. return Database.Cursor.execute(self, query, params)
Exception Type: DatabaseError at /admin/system/cronjob/add/
Exception Value: database is locked
Request information
GET
No GET data
POST
VariableValue
cron_month u'12'
__all__ u''
__form_id u'dialogForm_Cron Job'
cron_hour u'*'
cron_enabled u'on'
cron_user u'root'
cron_minute u'*'
cron_command u' #! /bin/bash adastat () { echo -n `camcontrol cmd $1 -a "E5 00 00 00 00 00 00 00 00 00 00 00" -r - | awk \'{print $10 " " ; }\'` " " ; } echo echo System Temperatures - `date` cat /etc/version.freenas uptime | awk \'{ print "\\nSystem Load:",$8,$9,$10,"\\n" }\' echo "CPU Temperature:" sysctl -a | egrep -E "cpu\\.[0-9]+\\.temp" echo echo "Drive Activity Status" for i in $(sysctl -n kern.disks | awk \'{for (i=NF; i!=0 ; i--) if (match($i, \'/ada/\')) print $i }\'); do echo -n $i:; adastat $i; done; echo ; echo echo "HDD Temperature:" for i in $(sysctl -n kern.disks | awk \'{for (i=NF; i!=0 ; i--) if (match($i, \'/ada/\')) print $i }\') do echo $i `smartctl -a /dev/$i | awk \'/Temperature_Celsius/{DevTemp=$10;} /Serial Number:/{DevSerNum=$3}; /Device Model:/{DevName=$3} END { print DevTemp,DevSerNum,DevName }\'` done echo'
cron_daymonth u'*'
cron_dayweek u'7'
cron_description u'Temp check'
FILES
No FILES data
COOKIES
VariableValue
csrftoken 'XnauEz1iHVPOnJL6UJ170Qn47loXfDlD'
sessionid 'f30lpgr0hwbb6i3n4rr8912o2ang112q'
fntreeSaveStateCookie 'root%2Croot%2F8%2F12%2Croot%2F8%2F9%2Croot%2F8%2F24%2Croot%2F78%2Croot%2F78%2F110%2F112%2Croot%2F51%2F55%2Croot%2F51%2F52%2Croot%2F51%2F58%2Croot%2F51%2F58%2F59%2Croot%2F73%2F80%2Croot%2F84%2Croot%2F51%2F69%2Croot%2F73%2Croot%2F90%2Croot%2F90%2F122%2Croot%2F90%2F122%2F124%2Croot%2F95%2Croot%2F139%2Croot%2F1%2Croot%2F158%2Croot%2F161%2Croot%2F10%2F34%2Croot%2F10%2F30%2Croot%2F10%2F26%2Croot%2F10%2F14%2Croot%2F10%2Croot%2F10%2F17%2Croot%2F56%2Croot%2F56%2F63%2F64%2Croot%2F40%2Croot%2F1%2F2%2Croot%2F1%2F5%2Croot%2F8%2Croot%2F8%2F32%2Croot%2F8%2F28%2Croot%2F8%2F15%2Croot%2F53%2Croot%2F53%2F67'
META
VariableValue
wsgi.multiprocess False
HTTP_REFERER 'https://10.0.0.66/'
REDIRECT_STATUS '200'
SERVER_SOFTWARE 'nginx/1.4.3'
SCRIPT_NAME u''
HTTP_X_CSRFTOKEN 'XnauEz1iHVPOnJL6UJ170Qn47loXfDlD'
REQUEST_METHOD 'POST'
PATH_INFO u'/admin/system/cronjob/add/'
SERVER_PROTOCOL 'HTTP/1.1'
QUERY_STRING ''
CONTENT_LENGTH '1782'
HTTP_USER_AGENT 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0'
HTTP_CONNECTION 'keep-alive'
HTTP_COOKIE 'csrftoken=XnauEz1iHVPOnJL6UJ170Qn47loXfDlD; sessionid=f30lpgr0hwbb6i3n4rr8912o2ang112q; fntreeSaveStateCookie=root%2Croot%2F8%2F12%2Croot%2F8%2F9%2Croot%2F8%2F24%2Croot%2F78%2Croot%2F78%2F110%2F112%2Croot%2F51%2F55%2Croot%2F51%2F52%2Croot%2F51%2F58%2Croot%2F51%2F58%2F59%2Croot%2F73%2F80%2Croot%2F84%2Croot%2F51%2F69%2Croot%2F73%2Croot%2F90%2Croot%2F90%2F122%2Croot%2F90%2F122%2F124%2Croot%2F95%2Croot%2F139%2Croot%2F1%2Croot%2F158%2Croot%2F161%2Croot%2F10%2F34%2Croot%2F10%2F30%2Croot%2F10%2F26%2Croot%2F10%2F14%2Croot%2F10%2Croot%2F10%2F17%2Croot%2F56%2Croot%2F56%2F63%2F64%2Croot%2F40%2Croot%2F1%2F2%2Croot%2F1%2F5%2Croot%2F8%2Croot%2F8%2F32%2Croot%2F8%2F28%2Croot%2F8%2F15%2Croot%2F53%2Croot%2F53%2F67'
SERVER_NAME 'localhost'
REMOTE_PORT '50505'
wsgi.url_scheme 'https'
SERVER_PORT '443'
SERVER_ADDR '10.0.0.66'
DOCUMENT_ROOT '/usr/local/etc/nginx/html'
HTTP_PRAGMA 'no-cache'
HTTP_CONTENT_LENGTH '1782'
HTTP_X_REQUESTED_WITH 'XMLHttpRequest'
DOCUMENT_URI '/admin/system/cronjob/add/'
wsgi.input <flup.server.fcgi_base.InputStream object at 0x818faad10>
HTTP_HOST '10.0.0.66'
HTTPS 'on'
wsgi.multithread True
HTTP_CACHE_CONTROL 'no-cache'
HTTP_CONTENT_TYPE 'application/x-www-form-urlencoded; charset=UTF-8'
REQUEST_URI '/admin/system/cronjob/add/'
HTTP_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
wsgi.version (1, 0)
GATEWAY_INTERFACE 'CGI/1.1'
wsgi.run_once False
wsgi.errors <flup.server.fcgi_base.TeeOutputStream object at 0x8151d65d0>
REMOTE_ADDR '10.0.0.10'
HTTP_ACCEPT_LANGUAGE 'en-US,en;q=0.5'
CONTENT_TYPE 'application/x-www-form-urlencoded; charset=UTF-8'
CSRF_COOKIE u'XnauEz1iHVPOnJL6UJ170Qn47loXfDlD'
HTTP_ACCEPT_ENCODING 'gzip, deflate'
