When I first did a docker-compose up on Ubuntu 20.04 LTS to install openemr 7.0.0 via docker, I was able to log in. Then, when I imported my existing 6.0.0 database,
I encountered maximum row size errors and had to modify some tables to get them to import (mostly):
mysql_1 | 2022-07-21 0:09:35 35 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 0:31:50 40 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 0:46:19 41 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:46:19 42 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:46:19 43 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:46:59 44 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 0:51:14 45 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:51:14 46 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:51:14 47 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:51:38 48 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 0:57:35 51 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:57:35 52 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:57:35 53 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:57:53 54 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 0:59:10 55 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:59:10 56 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:59:10 57 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 0:59:31 58 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:01:30 59 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:01:30 60 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:01:30 61 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:01:53 63 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:02:26 64 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:02:26 65 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:02:26 66 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:02:43 67 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:05:55 68 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:05:55 69 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:05:55 70 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:06:12 71 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:08:01 72 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:08:01 73 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:08:01 74 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:08:24 75 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:08:24 76 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:08:24 77 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:08:42 78 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:13:47 80 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:13:47 81 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:13:47 82 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:14:11 83 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:16:46 84 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:16:46 85 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:16:46 86 [Warning] Access denied for user ‘root’@‘localhost’ (using password: NO)
mysql_1 | 2022-07-21 1:17:05 87 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:20:13 88 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:24:12 89 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:34:20 90 [ERROR] InnoDB: Cannot add field usertext20
in table openemr
.history_data
because after adding it, the row size is 8168 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
mysql_1 | 2022-07-21 1:40:13 93 [ERROR] InnoDB: Cannot add field homeless
in table openemr
.patient_data
because after adding it, the row size is 8334 which is greater than maximum allowed size (8126 bytes) for a record on index leaf page.
I could upgrade my 6.0.0 database without incident to 7.0.0 (had to copy the latest sql_upgrade.php file into my openemr container). However, I only saw a white screen when I tried to log in.
I looked at the error.log.1:
[Thu Jul 21 02:23:56.278208 2022] [php:notice] [pid 161] [client 184.105.yyy.xxx:16054] OpenEMR Error : Decryption failed authentication., referer: http://openemr/
[Thu Jul 21 02:23:56.278249 2022] [php:notice] [pid 161] [client 184.105.247.194:16054] OpenEMR Error : Key in drive is not compatible (ie. can not be decrypted) with key in database - Exiting., referer: http://openemr/
How can I get the decryption working?