Multisite installation issue

Alan · January 3, 2021, 9:18am

Hi All,
i have ran into an issue when i try and add a new site.
i already have installed the default site successfully, when i try and install a new site on a “win10” machine, i get the below error messages in apache error logs:

the default site is installed on a win 10 machine
machines reach each other
from the new site machine i go to http://<IP_address>/openemr/admin.php
allows me to give a new site name, and when i click continue it doesn’t do anything. i tried edge and chrome browser.
not sure this is a permission issue as i have added everyone full read/write access to the XAMPP for now.

i have XAMPP installed on the new site machine with mysql running

any help is appreciated
Alan

[Sat Jan 02 14:01:05.658193 2021] [php7:warn] [pid 8592:tid 1912] [client 192.168.1.65:56717] PHP Warning: include_once(C:\xampp\htdocs\ehospital\library\classes/…/…/sites/sarchnar/sqlconf.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ehospital\setup.php on line 225, referer: http://192.168.1.48:81/ehospital/setup.php
[Sat Jan 02 14:01:05.658193 2021] [php7:warn] [pid 8592:tid 1912] [client 192.168.1.65:56717] PHP Warning: include_once(): Failed opening ‘C:\xampp\htdocs\ehospital\library\classes/…/…/sites/sarchnar/sqlconf.php’ for inclusion (include_path=‘C:\xampp\htdocs\ehospital\vendor/pear/archive_tar;C:\xampp\htdocs\ehospital\vendor/pear/console_getopt;C:\xampp\htdocs\ehospital\vendor/pear/pear-core-minimal/src;C:\xampp\htdocs\ehospital\vendor/pear/pear_exception;C:\xampp\php\PEAR’) in C:\xampp\htdocs\ehospital\setup.php on line 225, referer: http://192.168.1.48:81/ehospital/setup.php
[Sat Jan 02 14:48:31.251370 2021] [php7:warn] [pid 8592:tid 1920] [client 192.168.1.65:56825] PHP Warning: include_once(C:\xampp\htdocs\ehospital\library\classes/…/…/sites/sarchnar/sqlconf.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ehospital\setup.php on line 225, referer: http://192.168.1.48:81/ehospital/setup.php
[Sat Jan 02 14:48:31.251370 2021] [php7:warn] [pid 8592:tid 1920] [client 192.168.1.65:56825] PHP Warning: include_once(): Failed opening ‘C:\xampp\htdocs\ehospital\library\classes/…/…/sites/sarchnar/sqlconf.php’ for inclusion (include_path=‘C:\xampp\htdocs\ehospital\vendor/pear/archive_tar;C:\xampp\htdocs\ehospital\vendor/pear/console_getopt;C:\xampp\htdocs\ehospital\vendor/pear/pear-core-minimal/src;C:\xampp\htdocs\ehospital\vendor/pear/pear_exception;C:\xampp\php\PEAR’) in C:\xampp\htdocs\ehospital\setup.php on line 225, referer: http://192.168.1.48:81/ehospital/setup.php
[Sat Jan 02 20:57:58.087614 2021] [php7:warn] [pid 8592:tid 1880] [client ::1:56967] PHP Warning: session_destroy(): Session object destruction failed in C:\xampp\htdocs\ehospital\src\Common\Session\SessionUtil.php on line 141, referer: http://localhost:81/ehospital/interface/main/tabs/timeout_iframe.php
[Sat Jan 02 21:02:33.796919 2021] [php7:warn] [pid 8592:tid 1880] [client 192.168.1.65:57165] PHP Warning: include_once(C:\xampp\htdocs\ehospital\library\classes/…/…/sites/sarchnar/sqlconf.php): failed to open stream: No such file or directory in C:\xampp\htdocs\ehospital\setup.php on line 225, referer: http://192.168.1.48:81/ehospital/setup.php
[Sat Jan 02 21:02:33.796919 2021] [php7:warn] [pid 8592:tid 1880] [client 192.168.1.65:57165] PHP Warning: include_once(): Failed opening ‘C:\xampp\htdocs\ehospital\library\classes/…/…/sites/sarchnar/sqlconf.php’ for inclusion (include_path=‘C:\xampp\htdocs\ehospital\vendor/pear/archive_tar;C:\xampp\htdocs\ehospital\vendor/pear/console_getopt;C:\xampp\htdocs\ehospital\vendor/pear/pear-core-minimal/src;C:\xampp\htdocs\ehospital\vendor/pear/pear_exception;C:\xampp\php\PEAR’) in C:\xampp\htdocs\ehospital\setup.php on line 225, referer: http://192.168.1.48:81/ehospital/setup.php

stephenwaite · January 3, 2021, 2:55pm

hi @Alan, there’s a multisite variable that has to be manually turned on in setup.php

Change the false in $allow_multisite_setup = false; to true;

Alan · January 3, 2021, 4:33pm

Hi Stephen,

i did that part as per the installation document, i think i have problem with path to files and directories
is there a way to explain (if you can of course) how multisites does work in terms of architecture please.
the scenario i want to implement is to have each local site independently working - as i don’t have reliable internet at every site. i also want the main site “in the cloud” where i could see data from every local site.

would appreciate any help with this

thanks
Alan

stephenwaite · January 3, 2021, 4:38pm

ok, so you saw this too?

Alan · January 3, 2021, 4:49pm

yes, that is the doc i followed, please see the screenshots uploaded.

stephenwaite · January 3, 2021, 4:51pm

is that a space in the site name?

Alan · January 3, 2021, 4:52pm

nope, “site1” is one word in this case.

stephenwaite · January 3, 2021, 4:53pm

ok, did you turn checkPermissions off in setup.php?

Alan · January 3, 2021, 4:54pm

sorry should i have said, yes, i have turned checkpermission off

do you know if i need to run mysql, php and apache on the site1 machine?
and also if i need to do anything special on there

stephenwaite · January 3, 2021, 5:01pm

ok, this should help, there was a little bug in the setup script

Alan · January 3, 2021, 5:10pm

thanks Stephen
do i need to replace the whole setup.php with the one you have sent?

Ta
Alan

stephenwaite · January 3, 2021, 5:13pm

no, just the part after the else at the bottom
so replace

                            echo "<br />Click to continue installation.<br />\n";
                        }

with

                            $form = <<<FRM
                                        <br />
                                        <p class='p-1 bg-warning'>$caution: Permisssions checking has been disabled. All required files and directories have NOT been verified, please manually verify sites/$site_id .</p>
                                        <p class='mark'>Click <b>Proceed to Step 1</b> to continue with a new installation.</p>
                                        <p class='p-1 bg-warning'>$caution: If you are upgrading from a previous version, <strong>DO NOT</strong> use this script. Please read the <strong>'Upgrading'</strong> section found in the <a href='Documentation/INSTALL' rel='noopener' target='_blank'><span style='text-decoration: underline;'>'INSTALL'</span></a> manual file.</p>
                                        <br />
                                        <form method='post'>
                                            <input name='state' type='hidden' value='1'>
                                            <input name='site' type='hidden' value='$site_id'>
                                            <button type='submit' value='Continue'><b>Proceed to Step 1</b></button>
                                        </form>
FRM;
                            echo $form . "\r\n";                        }
                }

Alan · January 3, 2021, 5:41pm

good stuff will test and update you

Thanks Stephen

Alan

Alan · January 3, 2021, 9:52pm

hi Stephen,

i completed that stage, i seem to have an issue connecting to mysql server (step 3) i do believe sql server IP and credentials are correct - i checked in sqlconfig.php yet i get error message: connecting to MySQL server ERROR check your login credentials. unable to connect to database…

could this be a bug as well?
will investigate more in the morning, thought i ask the question just in case

Thanks in advance

Alan