Problems with SSL

[JoseZabaleta]

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

[Nobbie]

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.

[JoseZabaleta]

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?

[Nobbie]

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.

[JoseZabaleta]

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

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

[Nobbie]

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.

[JoseZabaleta]

Resolved... Thanke...

[Altrea]

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.