Migration To New Platform and Login

Razuna v2 Legacy Self-Hosted
1

I have migrated from a working Windows installation over to an Ubuntu server installation. When I first installed this on Windows, I applied many customization to make things work, such as moving the dam to another drive, changing the root url, etc.

I followed the migration guide, and everything seemed to go ok. I ran a custom install on the new server, and ran the restore from my old server, which completed successfully. I was then able to reach the new server, but my login credentials do not work. Password reset does not work, and I ran both of the reset scripts from /admin/maintenance and can not see any change.

What could have gone wrong, and how can I get into my installation to see if it actually did migrate successfully or not?

2

Hi Chris, Can you check the users table in the razuna database to see if all the data got imported properly in that? Also what razuna version are you using and what database?

BestHarkirat

3

I am on Version 1,7 and H2.

I will try to get into the DB now

4

Check your bluedragon.xml file for the path to the H2 database manually. Stop Tomcat, edit this file and start Tomcat again in order to apply the change.

5

Ok, and how do I find what I am looking for? Searching “password” and “Administrator” yield many results!

6

Ok, so I think I found my areas… I actually did a search for what I knew my password to be, and it came up. Two records of it, one of the records has a 2 on the end. The strings are surrounded by gibberish, and also the username is my domain credentials for the Windows domain, so I am not sure this is the right area.

7

Did you look into the bluedragon.xml file and that the path to the H2 database is correct?

Looking into the database directly won’t help you with your password as the passwords are encrypted.

8

The Path to my H2 database in bluedragons.xml is /opt/razuna/tomcat/webapps/razuna/db/razuna.h2.db

I am not sure if this is correct- when I did the migration I copied over my backup files into my new server, and then the First Run Wizard I restored them:

“To do so, move the “razuna_backup.h2.db”, “razuna_backup.trace.db” and the folder “razuna_backup.lobs” to the “/razuna/admin/backup” folder of the new Razuna instance. (Make sure that your new Razuna instance is shutdown)”

They did complete successfully and import correctly I believe. If I run a ln -l on that directory, my database is big, which leads me to believe the import did work.

root@razuna:/opt/razuna/tomcat/webapps/razuna/db# ls -l
total 172044
-rw-r–r-- 1 root root 175921152 Nov 24 10:20 razuna.h2.db
-rw-r–r-- 1 root root 207276 Nov 23 23:43 razuna.trace.db
-rw-r–r-- 1 root root 30720 Nov 24 10:20 razuna_default.h2.db

Despite what you said about encryption, if I nano the razuna.h2.db file and search for my admin password, it does come up:

razuna.com^N^Call^N^F7 days^N^@^N^@^N^@^N^@^N^@^N^@^N^@^N^@0^N^Cjpg^E^?^C^E^?^C
R*********^E^Y^N^Efalse^N^Efalse^N^@^N^@^N^@^E|^E?^A^N^@^N^H00:00:20^N^H00:00:0
SET_ID VARCHAR_IGNORECASE(500) NOT NULL,
SET_PREF VARCHAR_IGNORECASE(2000),
HOST_ID BIGINT,
REC_UUID VARCHAR_IGNORECASE(100) NOT NULL
)^D^?^A %^M{ALTER TABLE PUBLIC.RAZ1_LOG_SEARCH ADD CONSTRAINT PUBLIC.RAZ1_LOG_S
2 2^H2^G2^F2^E2^D2^C2^B2^V1^U1^T1^S1^R1^Q1^P1^A1^T?^^^@^@^@^@^?^A^@^V^G?^
^N#A733EC51-2225-4319-BA2E127D9FDB95E5^U^N#9C89B421-A914-4A49-9A8C25111AA8E854^
^E^P^K^D?^L^Dv^M^D;^N^D^A^O^C?^P^Cm^Q^C,^R^B?^S^B?^T^Bu^U^B5^V^A?^@^@^@^@^@^@^@
R*********2^N#FFA33E88-AC0E-472B-AF28BDC19904AA85^N^Rad_server_username^N^XDILL
^@^@?^H^T^@^@?^F^^^@^@?^E(^@^@?^D2^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^
LOG_ID VARCHAR_IGNORECASE(100) NOT NULL,
LOG_USER VARCHAR_IGNORECASE(100),
LOG_DATE DATE,
LOG_TIME TIMESTAMP,
LOG_SEARCH_FOR VARCHAR_IGNORECASE(2000),
LOG_FOUNDITEMS BIGINT,
LOG_SEARCH_FROM VARCHAR_IGNORECASE(50),

  • I have modified characters for protection. Also, the 2 on the end is not a part of my password, not sure if it is a bogus character or somehow during the import it got added. Anyhow, I tried to use that password and it did not work.
9

Just wondering if I should dump the server and start over… Then completely setup the new Razuna instance, including the password and DB, then perform the migration? This would allow me to double check I have an administrator account created on the new server instead of relying in the import. The only downside is that building out the server and installing everything takes a few hours.

10

Ok. I rebuilt the machine, and this time I setup Razuna, new user, etc. I then switched it to NGINX, moved the DAM, symlinks, etc. Everything is working great. Then I copied over the DAM assets folder and ran the database restore. The database restore had 2 errors which popped up in the languanges table, private key constraints.

After the restore finished, I can still browse my site, but I am once again unable to log in- I cannot log in using the credentials I made on the new server or the old credentials. Default credentials also do not work.

I WISELY made a machine snapshot prior to the restore- so now I can reset everything back to working without the rebuild. So let me know things I can try!

Here is the restore log- at schedules_log it just sits there and doesn’t proceed, and the progress icon stop spinning.

NOTE: The previous server is running on 1.6X and is still functional.

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_export_template
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_folder_subscribe
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_export_template
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_folder_subscribe
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
Error during import on table raz1_languages!
Database reported: Unique index or primary key violation: “HOSTID_LANGID_INDEX_C ON PUBLIC.RAZ1_LANGUAGES(HOST_ID, LANG_ID) VALUES ( /* key:3 */ 1, null, null, 1, null)”; SQL statement: INSERT INTO raz1_languages (HOST_ID, LANG_ACTIVE, LANG_ID, LANG_NAME, REC_UUID) VALUES( ? , ? , ? , ? , ? ) [23505-174]
INSERT INTO raz1_languages (HOST_ID, LANG_ACTIVE, LANG_ID, LANG_NAME, REC_UUID) VALUES( ? , ? , ? , ? , ? )

Error during import on table raz1_languages!
Database reported: Unique index or primary key violation: “HOSTID_LANGID_INDEX_C ON PUBLIC.RAZ1_LANGUAGES(HOST_ID, LANG_ID) VALUES ( /* key:4 */ 1, null, null, 2, null)”; SQL statement: INSERT INTO raz1_languages (HOST_ID, LANG_ACTIVE, LANG_ID, LANG_NAME, REC_UUID) VALUES( ? , ? , ? , ? , ? ) [23505-174]
INSERT INTO raz1_languages (HOST_ID, LANG_ACTIVE, LANG_ID, LANG_NAME, REC_UUID) VALUES( ? , ? , ? , ? , ? )

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

11

From which version are you upgrading from?

12

From version 1.6.5 on a Windows server 2012 R2 physical machine to version 1.7 on an Ubuntu VM.

13

Nitai,

Any more troubleshooting we can do? Here is my exact scenario in summary:

I have a working Razuna 1.6.5 system running on Windows. I can access it as normal.
I have a working Razuna 1.7 system running on Linux, which I can also access.
Both databases are H2.
Both are setup in a similar manner, and both have the same tenent setup.
When I run a backup and restore to the new server, the restore completes and the database upgrades but I am unable to login. I attempt the credentials from the OLD server and also the NEW server, and also the password reset and none of it works.

14

Chris,

I really don’t know how else to help here, i.e. without access to server to see exactly what is going, etc. But we don’t provide this support on the free open source edition. However, if you like us to support you, you can either buy support hours or sign up for a subscription plan ( http://razuna.org/support/subscriptions ). We are a small company and in order keep Razuna open source and going forward we rely on support plans, too.

That said, we’ve tested Razuna under all circumstances and with all upgrades. I’m surprised you run into those issues, as I’ve personally upgraded many systems from 1.6.2 to 1.7. As a last resort I would recommend that you migrate your 1.6.2 install to run with MySQL, then you can simply install Razuna 1.7 and do a mysqldump and import, thus bypassing the internal backup/import procedure.

15

I will probably try that first, and if it does not work I will purchase the support. I am more comfortable with MySQL anyhow, thanks!

16

Thank you, your support is really appreciated and keeps us going :wink:

17

I have worked around this- I saw another user complaining of this same problem, not sure if it is a bug or not.

Anyhow, I migrated my existing Razuna instance to MySQL. I exported the database via a dump. I setup the new Razuna entirely. I then connected Razuna into a new MySQL database which was empty. I then imported the MySQL database on top of the new database, and all my assets popped up.

Thanks!