Unable to access Services webpage

esiu69

Cadet
Joined
Feb 1, 2017
Messages
3
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:
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.
 

Ericloewe

Server Wrangler
Moderator
Joined
Feb 15, 2014
Messages
20,175
Start by not running a version that is more than two years old.

installing a clean 9.10) causes a continuous server reboot
Even if you don't use the old config? If so, it's most likely a hardware issue.
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.
That's the wrong reason. The OS is clearly in bad shape.
I'm unable to ping my FreeNAS box by NetBIOS name from a Virtualbox-jailed Windows 7 guest
That is perfectly normal if the VM is using NAT. NetBIOS does not work across NAT.
 

esiu69

Cadet
Joined
Feb 1, 2017
Messages
3
Start by not running a version that is more than two years old.
As I said, it does not upgrade and the new version doesn't work.

Even if you don't use the old config? If so, it's most likely a hardware issue.
Installs fine but never boots up, just continuous reboot. What do you mean by "hardware issue"? All other OSes (virtual/physical) work fine, same as FreeNAS 9.3. One of the updates out there breaks it though so I don't do updates any more. I think this is a compatibility issue, nothing wrong with my hardware. Maybe one of the million BIOS options is not supported by FreeNAS or something. This server is not the latest out there but has been stable for years and continues to be stable on the current 9.3 installation. The motherboard is Asus Z9PE-D8, 2 processors E5-2620 V2 and 8 memory chips Kingston KVR16E11/8 8GB DDR3 1600Mhz ECC (64GB).

That's the wrong reason. The OS is clearly in bad shape.
Yeah, that's my question really. I didn't mess with it in ways I wasn't supposed to. I guess I'll reburn the 9.3 clean image and see what happens. But I expect the error to reoccur. I also expect the problem to go away when I disconnect all disk drives. Have a strange feeling that the OS put something in there that it can't cope with now.

That is perfectly normal if the VM is using NAT. NetBIOS does not work across NAT.
I know, I'm not stupid :) Also mentioned that it used to work. The guest OS is on a bridged adapter.

The line that makes me think that the 2 issues are related is this one:
Code:
no such column: directoryservice_activedirectory.ad_netbiosname

Although I could be completely wrong on this one.
 

esiu69

Cadet
Joined
Feb 1, 2017
Messages
3
OK, more info, if anyone is able to help...
I connected a physical Windows PC to the network and I can happily ping both the FreeNAS box and the guest Windows PC by netbios name. I can also ping the physical Windows from the guest Windows by name. Still unable to ping the FreeNAS box from the guest. Any ideas anyone?
 

diversity

Contributor
Joined
Dec 4, 2018
Messages
128
Have you found a solution?
I am having the same issue now after one of my drives failed in a mirrored pool of 3 drives
same freenas version
now windows CIFS does not work anymore and services tab is showing the mentioned error
 

diversity

Contributor
Joined
Dec 4, 2018
Messages
128
When reading back my own post I see that the freenas version I had configured when signing up (FreeNAS-9.3-STABLE-201602031011 ) is not the same as the freenas version (FreeNAS-9.3-STABLE-201412090314 ) I have recently installed after my boot drive failed. I am going to see if that is of influence.
 

anodos

Sambassador
iXsystems
Joined
Mar 6, 2014
Messages
9,543
When reading back my own post I see that the freenas version I had configured when signing up (FreeNAS-9.3-STABLE-201602031011 ) is not the same as the freenas version (FreeNAS-9.3-STABLE-201412090314 ) I have recently installed after my boot drive failed. I am going to see if that is of influence.

Looks like a botched db migration. Possibly a version mis-match between what's in the db and the OS version. Try installing the same version of FreeNAS that you used to have.
 

diversity

Contributor
Joined
Dec 4, 2018
Messages
128
Updating to FreeNAS-9.3-STABLE-201602031011 indeed resolved the issue with the services tab.
The update failed though with a critical message. /data/update.failed should have more info but I dont know where to find that
 
Top