Hello,
I was wondering if anyone experienced this issue before. When I click on Services in the top menu bar after logging in to FreeNAS, I'm getting the following message:
This used to work but does not any more. Also broken after replacing the system USB drive with a backup one (where it worked).
I'm unable to upgrade to a newer version as installing any updates (or installing a clean 9.10) causes a continuous server reboot, which is a separate issue I also don't understand.
System info, in case if relevant:
The real reason why I want this fixed is that I'm unable to ping my FreeNAS box by NetBIOS name from a Virtualbox-jailed Windows 7 guest. This also used to work and I think it broke down at the same time as the Services page. One solution I found online was to disable and reenable the CIFS service but I don't know how to do it without the Services page working. Rebooting the FreeNAS box does't help here. Any help appreciated.
I was wondering if anyone experienced this issue before. When I click on Services in the top menu bar after logging in to FreeNAS, I'm getting the following message:
Code:
Request Method: GET Request URL: https://192.168.1.50/services/core/?dojo.preventCache=1485982608225 Software Version: FreeNAS-9.3-STABLE-201412090314 Exception Type: OperationalError Exception Value: no such column: directoryservice_activedirectory.ad_netbiosname Exception Location: /usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py in execute, line 452 Server time: Wed, 1 Feb 2017 20:56:48 +0000 Traceback Environment: Software Version: FreeNAS-9.3-STABLE-201412090314 Request Method: GET Request URL: https://192.168.1.50/services/core/?dojo.preventCache=1485982608225 Traceback: File "/usr/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response 105. response = middleware_method(request, callback, callback_args, callback_kwargs) File "/usr/local/www/freenasUI/../freenasUI/freeadmin/middleware.py" in process_view 156. 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 22. return view_func(request, *args, **kwargs) File "/usr/local/www/freenasUI/../freenasUI/services/views.py" in core 71. ds_status = get_directoryservice_status() File "/usr/local/www/freenasUI/../freenasUI/directoryservice/views.py" in get_directoryservice_status 142. if ad and ad[0]: File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in __nonzero__ 100. self._fetch_all() File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all 857. self._result_cache = list(self.iterator()) File "/usr/local/lib/python2.7/site-packages/django/db/models/query.py" in iterator 220. for row in compiler.results_iter(): File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in results_iter 713. for rows in self.execute_sql(MULTI): File "/usr/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in execute_sql 786. cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 53. return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/utils.py" in __exit__ 99. six.reraise(dj_exc_type, dj_exc_value, traceback) File "/usr/local/lib/python2.7/site-packages/django/db/backends/util.py" in execute 53. return self.cursor.execute(sql, params) File "/usr/local/lib/python2.7/site-packages/django/db/backends/sqlite3/base.py" in execute 452. return Database.Cursor.execute(self, query, params) Exception Type: OperationalError at /services/core/ Exception Value: no such column: directoryservice_activedirectory.ad_netbiosname Request information GET Variable Value dojo.preventCache u'1485982608225' POST No POST data FILES No FILES data COOKIES Variable Value sessionid 'cr00a9tjo7pskjgfe90m7sax8ejtipua' csrftoken 'LORYMUtnNYsUnY6IRfDDqLbYbHC3NCJT' fntreeSaveStateCookie 'root%2Croot%2F11%2F18%2Croot%2F192%2Croot%2F41%2Croot%2F154%2F164%2Croot%2F1%2Croot%2F192%2F202%2Croot%2F192%2F202%2F204%2Croot%2F11%2Croot%2F214' META Variable Value HTTP_ACCEPT_LANGUAGE 'en-US,en;q=0.8,pl;q=0.6,sk;q=0.4' GATEWAY_INTERFACE 'CGI/1.1' SERVER_PORT '443' wsgi.run_once False HTTP_REFERER 'https://192.168.1.50/' DOCUMENT_URI '/services/core/' REQUEST_METHOD 'GET' REMOTE_PORT '51203' wsgi.input <flup.server.fcgi_base.InputStream object at 0x81616ea50> HTTP_X_REQUESTED_WITH 'XMLHttpRequest' wsgi.url_scheme 'https' CONTENT_TYPE 'application/x-www-form-urlencoded' PATH_INFO u'/services/core/' wsgi.errors <flup.server.fcgi_base.TeeOutputStream object at 0x81616ebd0> REMOTE_ADDR '192.168.1.2' SERVER_SOFTWARE 'nginx/1.6.2' wsgi.multithread True DOCUMENT_ROOT '/usr/local/etc/nginx/html' HTTP_HOST '192.168.1.50' HTTP_ACCEPT_ENCODING 'gzip, deflate, sdch, br' HTTP_COOKIE 'sessionid=cr00a9tjo7pskjgfe90m7sax8ejtipua; csrftoken=LORYMUtnNYsUnY6IRfDDqLbYbHC3NCJT; fntreeSaveStateCookie=root%2Croot%2F11%2F18%2Croot%2F192%2Croot%2F41%2Croot%2F154%2F164%2Croot%2F1%2Croot%2F192%2F202%2Croot%2F192%2F202%2F204%2Croot%2F11%2Croot%2F214' QUERY_STRING 'dojo.preventCache=1485982608225' SERVER_NAME 'localhost' REDIRECT_STATUS '200' wsgi.version (1, 0) SCRIPT_NAME u'' wsgi.multiprocess False HTTP_CONTENT_TYPE 'application/x-www-form-urlencoded' HTTP_ACCEPT '*/*' HTTP_USER_AGENT 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36' CONTENT_LENGTH '' SERVER_ADDR '192.168.1.50' SERVER_PROTOCOL 'HTTP/1.1' HTTP_CONNECTION 'keep-alive' CSRF_COOKIE u'LORYMUtnNYsUnY6IRfDDqLbYbHC3NCJT' REQUEST_URI '/services/core/?dojo.preventCache=1485982608225' HTTPS 'on' FreeNAS® © 2014 iXsystems, Inc.
This used to work but does not any more. Also broken after replacing the system USB drive with a backup one (where it worked).
I'm unable to upgrade to a newer version as installing any updates (or installing a clean 9.10) causes a continuous server reboot, which is a separate issue I also don't understand.
System info, in case if relevant:
Code:
System Information Hostname zeus.local Build FreeNAS-9.3-STABLE-201412090314 Platform Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz (there are 2 of these on the motherboard) Memory 65459MB System Time Wed Feb 01 21:08:10 GMT 2017 Uptime 9:08PM up 5 days, 6:19, 0 users Load Average 3.11, 2.89, 2.70
The real reason why I want this fixed is that I'm unable to ping my FreeNAS box by NetBIOS name from a Virtualbox-jailed Windows 7 guest. This also used to work and I think it broke down at the same time as the Services page. One solution I found online was to disable and reenable the CIFS service but I don't know how to do it without the Services page working. Rebooting the FreeNAS box does't help here. Any help appreciated.