SSL works but Database is blocked

[falken76]

How do I fix this?  I have SSL working, but it blocks the database so none of the pictures show up and clicking on any existing link will lead to a "The requested URL was not found on this server".  For some reason when I try to go to localhost it redirects to https weather I enter the ip address or localhost and :80.  I've had this issue before.  If I could get this to view through http instead of https the database would show when this happened on another server.  Is there a config somewhere in mariaDB that needs to know where the ssl .crt and key files are?  This is what the site looks like when on https.  If you click any image under products it goes to a URL not found page.

[ComGrafPL]

Check ps_shop_url table in database. If url for SSL is correct.

[endriu107]

Did you enable ssl in your shop backoffice or only you force it from server side?

[falken76]

On 8/28/2022 at 12:07 AM, ComGrafPL said:

Check ps_shop_url table in database. If url for SSL is correct.

Thank you for your response.  Yes I just checked it and it is correct.

[falken76]

On 8/28/2022 at 1:50 AM, endriu107 said:

Did you enable ssl in your shop backoffice or only you force it from server side?

Thank you for responding.  At first I did not, what this did is make the server respond saying the page wasn't redirecting properly, an error occurred and it might have something to do with cookies.  When I went to the backoffice pm the local vm, the link that said "Check to see if your server supports SSL" was no longer there, I could just turn on SSL.  This made the site work, but what is actually happening now is you can't view any of the listings, they all go to a not found page.  It's coming from my server directly.  If I turn off friendly URL it works.  I have rewrite enabled on apache2.  So it's not an SSL issue now.  It is a friendly url issue with rewrite already enabled on the server.

[Prestachamps]

Hi @falken76,

have you tried to contact the server/hosting team and ask them this rewrite issue? they can doublecheck if the mod_rewrite is working fine on server.

Also try to rename the .htaccess file and cgenerate a new one from the Seo&url spage , save the settings there, and the htaccess will be regenerated.

Have a nice day, Leo.
 

[falken76]

Thank you for the quick response.  The server is sitting on my dresser so I have nobody to call.  I'm going to move this to a host later, right now I'm just learning about servers on my own and getting lost constantly, but I'm hoping I can eventually get a job related to the server side because I like it.  I don't know how this differs from a host, but the server is running Vmware ESXi and I created an Ubuntu Linux vm for this, I installed ubuntu 20.04  I installed LAMP.  I did "sudo a2enmod rewrite" but it was already enabled.  I can see under mods-enabled that "rewrite.load" is there. 

I did recreate the .htaccess file and I looked at what was generated and it was all the re-write stuff in there.  When I re-load the webpage after reloading apache2 it still doesn't show images and can't says it can't find the link.  If I go in and just turn friendly links off, the images start working again.  Is there anything else that could cause this?  I normally wouldn't care, but I do believe having this enabled is better for SEO.

[falken76]

I found a solution for this issue.  I am not sure if this will make a website vulnerable or not though.

 

I changed /etc/apache2/apache2.conf.  I changed "AllowOverride" under /var/www to "All", restarted apache2 and now I can access the listings with friendly url enabled.

 

Edited September 6, 2022 by falken76 (see edit history)