I’m trying to setup a multi-site installation using OpenEMR 7.0.0. My default site has already been fully configured and works fine.
I’ve followed the instructions and the proper settings have been applied to the setup.php file, but for some reason I can’t get past the “Optional Site ID Selection” page. After selecting ‘Continue’ I just see a blank page.
Should also note that when I first installed OpenEMR, there were no acl_setup.php or gacl/setup.php files anywhere. The multi-site instructions mention having the proper permissions in place for both files, so I’m wondering if their absence is the cause of this issue.
Thanks for the suggestion. I normally use notepad ++
I tried replacing the setup.php file with the appropriate settings from my previous comment, but still experience the same issue.
Below is line 298 (right after “//set up new blank session and csrf mechanism”) from setup.php with previous lines for context:
// This will effectively only allow entry into the setup.php script at the first step and will bar entry to the
// script if openemr has already been installed.
// 2 mechanisms are also in place to ensure go through script in chronological order
// - a session variable tracks the next state expected and kills script is not correct
// - only the next state csrf is handed out in the form
if (empty($state)) {
// ensure not already installed
if (!empty($config)) {
SessionUtil::setupScriptSessionStart();
SessionUtil::setupScriptSessionCookieDestroy();
error_log("OpenEMR has already been installed. If you wish to force re-installation, then edit " . errorLogEscape($installer->conffile) . " (change the 'config' variable to 0), and re-run the setup.php script.");
die("OpenEMR has already been installed. If you wish to force re-installation, see log for details.<br />\n");
}
// set up new blank session and csrf mechanism
SessionUtil::setupScriptSessionStart();
session_regenerate_id(true);
$_SESSION = [];
CsrfUtils::setupCsrfKey();
After adding that line before line 298 I received this error when going to localhost/openemr/admin.php:
Fatal error: Uncaught mysqli_sql_exception: No connection could be made because the target machine actively refused it in C:\xampp\htdocs\openemr\admin.php:116 Stack trace: #0 C:\xampp\htdocs\openemr\admin.php(116): mysqli_connect('localhost', 'openemr', 'mypassword', 'openemr', '3306') #1 {main} thrown in C:\xampp\htdocs\openemr\admin.php on line 116
Im not sure its a bug. I just set up a test environment in a windows 11 laptop with xampp php8.1 (or 8.0) 4 days ago, using multisite. I was able to set up default and 2 more sites. Then I patched the install.
Is it possible you have a corrupted download? Did you do checksum verification?
I set $allow_cloning_setup to true so I can clone an existing database for the new site. I tried setting it back to false to see if that made any difference, but no luck.
And no, did not do checksum verification. I should have! At this point, wondering if I should reinstall and start fresh. Luckily this is a test environment.
Thanks for that link Stephen. I found the acl_setup.php file in that repo, but no gacl/setup.php
However, when adding acl_setup.php to my openemr directory with the proper permissions, I receive the same error message from my Nov 23 comment (uncaught mysqli_sql_execution) when accessing localhost/openemr/admin.php
So turns out the MySQL credential error was because I didn’t enter my existing root password during the previous step (foolish mistake on my part). But now there’s another issue when trying to create the database and first user:
