User table is empty after a DB restore

I ran a backup of our old Razuna version 1.6.2 using an H2 DB and restored it to a new Razuna version 1.6.5 using MySQL. The backup and restore both stated “successful” but the user table appears to be empty. I have referenced this ticket as it is very similar RAZ-858. I ran through the reset wizard as well. After the wizard is there a default P/W for Administrator. I had no options. Thanks

Please attach any corresponding error logs that can be found under
/tomcat/webapps/razuna/WEB-INF/bluedragon/work/temp/rtelogs
to help us debug any issues.

Also for what it’s worth, here is the output that the restore was successful. I’ve successfully gone through this process several times leading up to a cut over.

Starting the Restore

Checking consistency of records…

Database setup…

Currently cleaning up cache
Currently cleaning up ct_groups_permissions
Currently cleaning up ct_groups_users
Currently cleaning up ct_labels
Currently cleaning up ct_plugins_hosts
Currently cleaning up ct_users_hosts
Currently cleaning up ct_users_remoteusers
Currently cleaning up file_types
Currently cleaning up groups
Currently cleaning up hosts
Currently cleaning up log_actions
Currently cleaning up modules
Currently cleaning up news
Currently cleaning up options
Currently cleaning up permissions
Currently cleaning up plugins
Currently cleaning up plugins_actions
Currently cleaning up raz1_additional_versions
Currently cleaning up raz1_assets_temp
Currently cleaning up raz1_audios
Currently cleaning up raz1_audios_text
Currently cleaning up raz1_cart
Currently cleaning up raz1_collections
Currently cleaning up raz1_collections_ct_files
Currently cleaning up raz1_collections_groups
Currently cleaning up raz1_collections_text
Currently cleaning up raz1_comments
Currently cleaning up raz1_custom
Currently cleaning up raz1_custom_fields
Currently cleaning up raz1_custom_fields_text
Currently cleaning up raz1_custom_fields_values
Currently cleaning up raz1_files
Currently cleaning up raz1_files_desc
Currently cleaning up raz1_files_xmp
Currently cleaning up raz1_folders
Currently cleaning up raz1_folders_desc
Currently cleaning up raz1_folders_groups
Currently cleaning up raz1_images
Currently cleaning up raz1_images_text
Currently cleaning up raz1_import_templates
Currently cleaning up raz1_import_templates_val
Currently cleaning up raz1_labels
Currently cleaning up raz1_languages
Currently cleaning up raz1_log_assets
Currently cleaning up raz1_log_folders
Currently cleaning up raz1_log_search
Currently cleaning up raz1_log_users
Currently cleaning up raz1_schedules
Currently cleaning up raz1_schedules_log
Currently cleaning up raz1_settings
Currently cleaning up raz1_settings_2
Currently cleaning up raz1_share_options
Currently cleaning up raz1_smart_folders
Currently cleaning up raz1_smart_folders_prop
Currently cleaning up raz1_temp
Currently cleaning up raz1_upload_templates
Currently cleaning up raz1_upload_templates_val
Currently cleaning up raz1_users_accounts
Currently cleaning up raz1_users_favorites
Currently cleaning up raz1_versions
Currently cleaning up raz1_videos
Currently cleaning up raz1_videos_text
Currently cleaning up raz1_widgets
Currently cleaning up raz1_wm_templates
Currently cleaning up raz1_wm_templates_val
Currently cleaning up raz1_xmp
Currently cleaning up rfs
Currently cleaning up search_reindex
Currently cleaning up tools
Currently cleaning up users
Currently cleaning up users_comments
Currently cleaning up users_login
Currently cleaning up webservices
Currently cleaning up wisdom
Database setup done. Continuing…

The database is now empty. Starting to import data…
Importing to tables… (please wait)

Currently restoring table cache
Currently restoring table ct_groups_permissions
Currently restoring table ct_groups_users
Currently restoring table ct_labels
Currently restoring table ct_plugins_hosts
Currently restoring table ct_users_hosts
Currently restoring table ct_users_remoteusers
Currently restoring table file_types
Currently restoring table groups
Currently restoring table hosts
Currently restoring table log_actions
Currently restoring table modules
Currently restoring table news
Currently restoring table options
Currently restoring table permissions
Currently restoring table plugins
Currently restoring table plugins_actions
Currently restoring table raz1_additional_versions
Currently restoring table raz1_assets_temp
Currently restoring table raz1_audios
Currently restoring table raz1_audios_text
Currently restoring table raz1_cart
Currently restoring table raz1_collections
Currently restoring table raz1_collections_ct_files
Currently restoring table raz1_collections_groups
Currently restoring table raz1_collections_text
Currently restoring table raz1_comments
Currently restoring table raz1_custom
Currently restoring table raz1_custom_fields
Currently restoring table raz1_custom_fields_text
Currently restoring table raz1_custom_fields_values
Currently restoring table raz1_files
Currently restoring table raz1_files_desc
Currently restoring table raz1_files_xmp
Currently restoring table raz1_folders
Currently restoring table raz1_folders_desc
Currently restoring table raz1_folders_groups
Currently restoring table raz1_images
Currently restoring table raz1_images_text
Currently restoring table raz1_import_templates
Currently restoring table raz1_import_templates_val
Currently restoring table raz1_labels
Currently restoring table raz1_languages
Currently restoring table raz1_log_assets
Currently restoring table raz1_log_folders
Currently restoring table raz1_log_search
Currently restoring table raz1_log_users
Currently restoring table raz1_schedules
Currently restoring table raz1_schedules_log
Currently restoring table raz1_settings
Currently restoring table raz1_settings_2
Currently restoring table raz1_share_options
Currently restoring table raz1_smart_folders
Currently restoring table raz1_smart_folders_prop
Currently restoring table raz1_temp
Currently restoring table raz1_upload_templates
Currently restoring table raz1_upload_templates_val
Currently restoring table raz1_users_accounts
Currently restoring table raz1_users_favorites
Currently restoring table raz1_versions
Currently restoring table raz1_videos
Currently restoring table raz1_videos_text
Currently restoring table raz1_widgets
Currently restoring table raz1_wm_templates
Currently restoring table raz1_wm_templates_val
Currently restoring table raz1_xmp
Currently restoring table rfs
Currently restoring table search_reindex
Currently restoring table tools
Currently restoring table users
Currently restoring table users_comments
Currently restoring table users_login
Currently restoring table webservices
Currently restoring table wisdom

Restore done! You can close this window now.

This error does not look like it corresponds to your issue.
I would rerun the restore and look again in the errors log to see if it threw any corresponding errors.

Do all the other tables have the data populated properly apart from the users table?

Unfortunately I can’t login to the GUI console as it thinks there are no users.

I can get into the MySQL DB via command line on the server or through PHPMyAdmin. Can I create an Admin user so I can get back into the GUI console and try another restore? Is that possible?

I should clarify that it’s the raz1_users_accounts table that is empty.

Can you open the H2 back up db you have and look in the users table to see if the users are there. If so just copy them manually into the MySQL db.
The backupdb is located at /tomcat/webapps/razuna/admin/backup/razuna_backup.h2.db

You are looking in the wrong table then. Its the ‘Users’ table not the ‘raz1_users_accounts’ table.

ok, sorry. I was looking at that table as well (Users) and it’s empty. I will see if I can get into the backup and copy the users over.

Harkirat,

We are trying to get into the H2 DB. What is the Login ID and P/W when this is created from the Razuna build?

Thanks

We were able to get into the original h2 DB using DB visualizer but there is nothing there but the default tables. No actual data that we can see. The old system is functioning just fine so it has to be a valid DB.

Also, is there a way to manually restore the h2 DB into the new MySQL DB without using the Admin GUI.