NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
CRPearce
May 24, 2016Aspirant
RN 2120 Active Directory "Import Error"
I have two office locations, each of which has a ReadyNAS 2120 set up for storing location-based backups as well as serving up home folders for users. Both devices have been live for over a year and...
badpatch
Jun 03, 2016Aspirant
Hi
I fixed this issue on my Ultra2-plus (unofficially running OS6). I upgraded from 6.4.2 to 6.5 last week and had the same import error.
On checking some of the posts in this thread it was mentioned about purging the contents on the db.sq3 database. On my system when I ran a select from the $home_folder table I found I had 1 entry which didn't match the $users table.
cd /var/readynasd/
sqlite3
sqlite> .open db.sq3
sqlite> select * from "$home_folder";
I had 4 entries of which one didn't match - the first field is user_id
32768|0|0||1
I confirmed that by using
sqlite> select * from "$user" where id = 32768;
if you have a dodgy entry or 2 then just use sql delete
sqlite> delete from "$home_folder" where user_id = <dodgy_id>;
ctrl-d exits the sqlite3
restart readynasd process using the commands from a previous post.
SCP
Jun 03, 2016Guide
It's the same of
"sqlite3 /var/readynasd/db.sq3 'delete from "$home_folder";'"
but more specific.
And it does not work for me.
Did you try to reboot your nas, or try a manual synchronisation after?
Has i said, it'works "ones" but if you try after or reboot the nas, it never work again until you do again
sqlite3 /var/readynasd/db.sq3 'delete from "$home_folder";' (or your command)
That's the case for me. And i made a select i only have:
select * from "$home_folder";
32768|0|0||0
That do not exist in $user.
but after a restart or a time, it go back again.
So it does not solve the "source" of the problem but the result. :/
Related Content
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!