userman database is not accesible

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.

oh my God, really? no one knows? not even admin/mod ?

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

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.

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

/tool user-manager database set db-path=user-manager1

yup its working. Cool .thanx a lot

/tool user-manager database set db-path=user-manager1

helps me by this problem, i had exat the same before.

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

I can’t run this script
the word (set) is unknown to mikrotik terminal
is there any alternate word or script
thanks

Any one experienced such problem, please help me
the script didn’t run with me

/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

1- Download sqlite3.exe from http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080100.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

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.

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

This also save me. I use ROS v7 and update to this command instead.

/user-manager/database/ set db-path=path/to/my/user-manager/folder