How to convert userman3.x to userman5.x ??

RouterOS Beginner Basics
1

How to convert userman3.x to userman5.x ??
thx

2

It should automatically transfer as you upgrade the router.

3

All I know to do, but failed.

http://forum.mikrotik.com/t/5-20-userman-database-load-umb-cpu100/60469/1

http://forum.mikrotik.com/t/5-20-userman-database-load-umb-cpu100/60469/1

4

Don’t post supout on the forum, only send them to support@mikrotik.com

Your database may be corrupted. You may need to export it (if you still can) and then import it to 5.x.

I’m saying export/import (text), not database backup/restore.

5

I do not give a warranty that my solution is correct. But i’ve solved it as folows:
Note: First do it on Test-RB

  1. Save your database v3
    /tool user-manager database save name=…umb

  2. Remove your database v3
    /tool user-manager database clear-log
    /tool user-manager database clear

  3. Upgrade ROS v3 to v5

  4. Load old database on v5
    /tool user-manager database load name=..umb

  5. Open database
    http:/ip/userman

  6. Check name of profile

  7. Add limitations for these profiles

  8. Check settings of payments

6

I think that’s basically what he tried already. Did you read that thread he referenced? I think something in the database is corrupted (not uncommon with usermanager… i’ve had several get corrupt).

7

you’re right partially - databases are different.
But some information on GUI by new version of user manager is wrong and it is so since v4. (In this case, does not matter whether something needs to be converted)
I think, that dataset of database is correct. Problem is with reading data from database and showing on GUI.
As an example test ist with v6.0rc2. Add new users, try log in and log out with these user accounts. Then see informations by
“userlist”, “sessionlist” etc. (Note: please add more attribute for these tables to see GUI-errors throuth UM → Settings → Appeance)
I’ve tested and here are my results

\

  1. So i add new user “bab01”. See pict 1

  2. The user “bab01” logged in by hotspot and used the session.
    Then i add with “batch” button six new users. Now see “users” table - some informations for user “bab01” are missing. See pict 2

  3. Then i logged in and logged out by user manager. What does user manager now show? Here see that. See pict 3

  4. Now the user “ab6j7” log in and we look the “users” table of user manager. See pict 4
    um_1teil.JPG

  5. No we look the user “ab6j7” in detail - something is missing. See pict 1

  6. That is view of “sessions” table as soon as the user “bab01” logged in. See pict 2

  7. View of “sessions” table after logged the user “ab6j7” und the user “bab02”. Here there are no informations about users “ab6j7” and “bab02” See pict 3.

  8. View of “users” table as result. See pict 4

um_2teil.JPG