Problems with SSL

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Problems with SSL

Postby JoseZabaleta » 21. July 2019 20:59

Hi people...

I have imported my site to Xampp but the following error occurs:

ERR_SSL_SERVER_CERT_BAD_FORMAT

Do I need to install the SSL certificate in Xampp?

Thanke
JoseZabaleta
 
Posts: 5
Joined: 21. July 2019 20:31
XAMPP version: v3.2.
Operating System: Windows 10

Re: Problems with SSL

Postby Nobbie » 21. July 2019 23:14

If you want to use https instead of http, then you have to install a valid certificate for SSL. Xampp does not come with SSL certificate.
Nobbie
 
Posts: 11149
Joined: 09. March 2008 13:04

Re: Problems with SSL

Postby JoseZabaleta » 22. July 2019 08:22

Nobbie wrote:If you want to use https instead of http, then you have to install a valid certificate for SSL. Xampp does not come with SSL certificate.


Thanke... I use an SSL certificate on my online site but I do not need SSL to work locally. Since my online site uses https, do I need to install the certificate in Xampp to be able to work locally?
JoseZabaleta
 
Posts: 5
Joined: 21. July 2019 20:31
XAMPP version: v3.2.
Operating System: Windows 10

Re: Problems with SSL

Postby Nobbie » 22. July 2019 11:08

JoseZabaleta wrote:Since my online site uses https, do I need to install the certificate in Xampp to be able to work locally?


Actually, you dont need a certificate and you dont need to run it in https: protocoll.

If you start it via http:// but you get the error message from above, i think that your app is doing a redirect to https: (usually for safety reasons, but these do not apply for local development). This is mostly done in .htaccess with Rewrite or Redirect (should be easyly to find), or it is done in the PHP script via Location Header (not so easy to find, but i dont think that this is the case, because mostly it is done with .htaccess or with Apache configuration). Anyway, you have to find the redirect to https: and delete it. The app itself should run as http: as well as https:, as this only affects the traffic between the browser and the server, but not the app itself.

First of all, simply start your app via http:// - maybe it already works.
Nobbie
 
Posts: 11149
Joined: 09. March 2008 13:04

Re: Problems with SSL

Postby JoseZabaleta » 22. July 2019 13:27

Nobbie wrote:
JoseZabaleta wrote:Since my online site uses https, do I need to install the certificate in Xampp to be able to work locally?


Actually, you dont need a certificate and you dont need to run it in https: protocoll.

If you start it via http:// but you get the error message from above, i think that your app is doing a redirect to https: (usually for safety reasons, but these do not apply for local development). This is mostly done in .htaccess with Rewrite or Redirect (should be easyly to find), or it is done in the PHP script via Location Header (not so easy to find, but i dont think that this is the case, because mostly it is done with .htaccess or with Apache configuration). Anyway, you have to find the redirect to https: and delete it. The app itself should run as http: as well as https:, as this only affects the traffic between the browser and the server, but not the app itself.

First of all, simply start your app via http:// - maybe it already works.


Ok, but now I can not start MySQL :roll:

Error: MySQL shutdown unexpectedly.
9:06:29 [mysql] This may be due to a blocked port, missing dependencies,
9:06:29 [mysql] improper privileges, a crash, or a shutdown by another method.
9:06:29 [mysql] Press the Logs button to view error logs and check
9:06:29 [mysql] the Windows Event Viewer for more clues
9:06:29 [mysql] If you need more help, copy and post this
9:06:29 [mysql] entire log window on the forums

Error log:

2019-07-22 9:06:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-22 9:06:27 0 [Note] InnoDB: Uses event mutexes
2019-07-22 9:06:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-22 9:06:27 0 [Note] InnoDB: Number of pools: 1
2019-07-22 9:06:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-22 9:06:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-22 9:06:27 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-22 9:06:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=4367262
2019-07-22 9:06:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-22 9:06:29 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-22 9:06:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-22 9:06:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-22 9:06:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-22 9:06:29 0 [Note] InnoDB: Waiting for purge to start
2019-07-22 9:06:29 0 [Note] InnoDB: 10.3.16 started; log sequence number 4367271; transaction id 410
2019-07-22 9:06:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-22 9:06:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-22 9:06:29 0 [Note] Server socket created on IP: '::'.

Thanke
JoseZabaleta
 
Posts: 5
Joined: 21. July 2019 20:31
XAMPP version: v3.2.
Operating System: Windows 10

Re: Problems with SSL

Postby Nobbie » 22. July 2019 16:16

I cannot help you with that. This mostly happens, when MySQL has not been closed and shutdown properly, but instead the PC simply has been switched off. Try to re-install the database (or whole Xampp and App) again.
Nobbie
 
Posts: 11149
Joined: 09. March 2008 13:04

Re: Problems with SSL

Postby JoseZabaleta » 24. July 2019 21:20

Resolved... Thanke...
JoseZabaleta
 
Posts: 5
Joined: 21. July 2019 20:31
XAMPP version: v3.2.
Operating System: Windows 10

Re: Problems with SSL

Postby Altrea » 24. July 2019 21:28

No information about how you have solved your problem?
Well, that is the single best way to not get any help from a community driven board next time, great.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 9803
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 42 guests