Patient Portal Document Page not found

On the server, the portal documents were working before enabling SSL. Mod rewrite is enabled. This is version v6.0.0 (2) PHP 7.4.2. In the error log shows.

[Thu Jul 08 23:44:40.960361 2021] [php7:notice] [pid 27773] [client 70.184.171:56867] SQL Error with statement:query failed: SELECT * FROM `lists` WHERE `uuid` = ?--Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='==>/var/www/html/mindful_v6/src/Common/Uuid/UuidRegistry.php at 121:sqlQueryNoLog, referer: http://54/mindful_v6/interface/main/tabs/main.php?token_main=9kfcKtQ1cHC3g1usLdnHFTiLuPhhYNV5giuVHaYZ
[Thu Jul 08 23:56:17.816929 2021] [php7:notice] [pid 28458] [client 70.184.171:59038] PHP Notice:  session_start(): A session had already been started - ignoring in /var/www/html/mindful_v6/src/Common/Session/SessionUtil.php on line 144, referer: https://dev.a.com/mindful_v6/portal/home.php

What am I missing? I cleared the browser cache.

 [Fri Jul 09 00:05:23.184415 2021] [php7:notice] [pid 28521] [client 70.184.171:63756] PHP Notice:  Undefined index: site_id in /var/www/html/mindful_v6/portal/verify_session.php on line 29, referer: https://dev.a.com/mindful_v6/portal/index.php?site=default&logout
 [Fri Jul 09 00:05:36.798010 2021] [php7:notice] [pid 28538] [client 70.184.171:51486] PHP Notice:  session_start(): A session had already been started - ignoring in /var/www/html/mindful_v6/src/Common/Session/SessionUtil.php on line 144, referer: https://dev.a.com/mindful_v6/portal/home.php

<Directory /var/www/html/>
   Options Indexes FollowSymLinks
    AllowOverride All
    Require all granted
</Directory>

To answer my own question.

This is where I found the clue. I had to go to the apache2.conf file and change the Override All there.

<Directory /var/www/>
   Options Indexes FollowSymLinks
   AllowOverride All
   Require all granted
</Directory>
1 Like

This is really odd. I did not need to mess with that file at all when I put my own SSL certificates in the system … but you probably enabled more portal features … maybe it’s a particular portal feature that is to blame here.
–Ralf

@Ralf_Lukner
I can agree with you. But it really depends on how the domain is associated to the directory. If I had associated my directory directly to the domain. I would not have had to do what I posted. But because the domain was to cover a lot of different sub folders. I had to go one level higher to get the AllowOverride to work. This is my working theory. I checked a few of my other sites where I had associated the directory like this

  DocumentRoot /var/www/html/openemr

In this case when the AllowOverride is applied it worked. But in the situation I am in on the dev server. My document root was much higher up.

 DocumentRoot /var/www/html

Now, on this server there are many installs of openemr for different development purposes. So my guess is that Apache needed to cover them all with the override.

I have no evidence of what I am writing other than that is what worked to get the page back running. Because prior to adding the domain and SSL. The site worked fine with just the IP address.

1 Like