Page 1 of 1
userman database is not accesible
Posted: Mon Dec 15, 2014 12:47 am
by winet
running on routeros v6.23.1 x86
[admin@mikrotik] > tool user-manager database print
database is not acceseble, yet
[admin@mikrotik] > /tool user-manager database print
database is not acceseble, yet
[admin@mikrotik] > /tool user-manager database rebuild
Can take a while. Console may not respond while in progress. Rebuild user-manager
database? [y/N]:
y
Rebuilding user-manager database
File does not exist!
[admin@mikrotik] /tool user-manager database> clear
Dangerous! Reset whole user-manager database (except logs)? [y/N]:
y
Resetting user-manager database
Failed to reset user-manager database
File does not exist!
[admin@mikrotik] /tool user-manager database>
i can't even load backup data
[admin@mikrotik] /tool user-manager database> load name=external.umb
Restore user-manager database? [y/N]:
y
Loading user-manager database backup
Failed to load user-manager database backup
failed to open file for writing: No such file or directory
[admin@mikrotik] /tool user-manager database>
i already tried, un-install, reboot, re-install again, reboot, many times over and over, still the same.
other userman on routeros v6.22 mipsbe running well.
help please, i need the user manager.
Re: userman database is not accesible
Posted: Fri Dec 19, 2014 5:18 pm
by winet
oh my God, really? no one knows? not even admin/mod ?
Re: userman database is not accesible
Posted: Fri Dec 26, 2014 6:33 am
by winet
i'm sorry if i miss something on my post causing nobody(no mods) can help me fix this issue, but please tell me what others information do i have to supply more?
Re: userman database is not accesible
Posted: Fri Dec 26, 2014 2:43 pm
by bax
i'm sorry if i miss something on my post causing nobody(no mods) can help me fix this issue, but please tell me what others information do i have to supply more?
well i never see problems like this ... but it look me that you have problems with disk ...
try to put some usb disk , format then swich userman to this usb disk ... and try again
Re: userman database is not accesible
Posted: Fri Dec 26, 2014 8:13 pm
by winet
i'm sorry if i miss something on my post causing nobody(no mods) can help me fix this issue, but please tell me what others information do i have to supply more?
well i never see problems like this ... but it look me that you have problems with disk ...
try to put some usb disk , format then swich userman to this usb disk ... and try again
no longer can do such thing, /store has been removed since 6.20
Re: userman database is not accesible
Posted: Fri Dec 26, 2014 8:25 pm
by mousa1983
Hi
probably after upgrade to new version this problem occurred.yes?
new version have problem with userman.
you can downdrage to older version to solve this problem.
copy older version in Files,then go to system and select downgrage.
i have this problem too with new version.
Re: userman database is not accesible
Posted: Fri Dec 26, 2014 10:33 pm
by bax
Change related to your usb disk ...
/tool user-manager database set db-path=disk1/user-manager3
Re: userman database is not accesible
Posted: Sat Dec 27, 2014 10:35 am
by winet
Change related to your usb disk ...
/tool user-manager database set db-path=disk1/user-manager3
cool, thanks, this fixed it. except that, without disk1 (because it fails to create new directory after disk1)
/tool user-manager database set db-path=user-manager1
Re: userman database is not accesible
Posted: Mon Aug 31, 2015 10:35 pm
by aguntukk
/tool user-manager database set db-path=user-manager1
yup its working. Cool .thanx a lot
Re: userman database is not accesible
Posted: Fri Sep 18, 2015 12:24 pm
by Lordi
/tool user-manager database set db-path=user-manager1
helps me by this problem, i had exat the same before.
Re: userman database is not accesible
Posted: Fri Jan 08, 2016 12:28 am
by nspotorno
Happened to me after upgrading to 6.33.3 on X86.....
This kind of bugs unresolved are kind of embarrassing
applying /tool user-manager database set db-path=user-manager1
solved the issue, thanks Lordi
Re: userman database is not accesible
Posted: Mon Oct 03, 2016 12:28 am
by sakretayer
/tool user-manager database set db-path=user-manager1
helps me by this problem, i had exat the same before.
I can't run this script
the word (set) is unknown to mikrotik terminal
is there any alternate word or script
thanks
Re: userman database is not accesible
Posted: Mon Oct 03, 2016 12:39 am
by sakretayer
Happened to me after upgrading to 6.33.3 on X86.....
This kind of bugs unresolved are kind of embarrassing
applying /tool user-manager database set db-path=user-manager1
solved the issue, thanks Lordi
Any one experienced such problem, please help me
the script didn't run with me
Re: userman database is not accesible
Posted: Mon Oct 03, 2016 10:27 am
by freemannnn
/tool user-manager database set db-path=user-manager1
for me is working. try to type it....
1. by copy paste
2. or type it letter by letter by yourself
Re: userman database is not accesible
Posted: Sat Oct 08, 2016 12:32 am
by abdrzj1989
1- Download sqlite3.exe from
http://www.sqlite.org/2013/sqlite-shell ... 080100.zip
2- Copy sqlite3.exe from downloaded ZIP file to C:\SQLRepair
3- open cmd (Command prompt) and go to C:\SQLRepair
4- type following in command prompt (or copy-paste these commands into cmd ):
sqlite3 sqldb
pragma integrity_check;
5- If you see an error message then:
exit sqlite3.exe with CTRL+C
type following in command prompt (or copy-paste these commands into cmd) : A and B
A- echo .dump | sqlite3.exe sqldb > ff1.sql
B- sqlite3.exe -init ff1.sql sqldb-new
echo .dump | sqlite3.exe sqldb > ff1.sql
sqlite3.exe -init ff1.sql sqldb-new
" sqldb-new " This is a new database file for usermanager
https://youtu.be/Z5DQa-zxj18
Best Regards
ِAbdulkader Alrazj
Re: userman database is not accesible
Posted: Mon Oct 23, 2017 10:18 pm
by abdulmuha
/tool user-manager database set db-path=user-manager1
yup its working. Cool .thanx a lot
Yeah! this works for me too. But not Immediately , I have to wait for the router to settle for some days because initially the Router was like a kind of busy, asking to try again. I decided not give up and alas! it worked
Thank you guys.
Re: userman database is not accesible
Posted: Sat Jan 11, 2020 8:06 pm
by ojenma
I have a hap RB951Ui-2nD for which i have connected a flash drive and directed user-manager database onto the flash drive but my problem is, when I i put the Hap off and put it on the next day userman doesn't automatically go onto the flash drive. i will have to redirect it again.
My question is, how do I get user-manager path to automatically go onto the flash drive when I it put on?
Thank..
Please Help