NETGEAR is aware of a growing number of phone and online scams. To learn how to stay safe click here.
Forum Discussion
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...
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.
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 againsqlite3 /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||0That 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. :/The line 32768 was the example from my ReadyNAS. I just outlined how I fixed mine.
I can now import the AD accounts and all is looking good for me.
I have got the same line 32768 that do not exist in $USER.
But has i said, if i delete, it come back again.If i delete the line, i could made only ONE import of ad, and all seems to look normally.
But then, if i reboot the nas, or if i just go into setting and make an manual update ===> same problem.
In fact, even if i do nothing, it will automatically try to do it again on some time, and will result in the same.
That's why i ask you if you reboot your nas, it works again?
NETGEAR Academy
Boost your skills with the Netgear Academy - Get trained, certified and stay ahead with the latest Netgear technology!
Join Us!
