I was able to reproduce that error by deleting my certificates. I’m not sure when/how those were deletec from your computer.
I have asked our developers for a quickfix for this. We basically just need to manually create the ssl certificate. I will contact you once they tell me. Thank you for your patience here @jarno. We’ve never anyone run into this so it’s a brand new error.
Hi @jarno, this is the process the Developers gave me to generate a new certificate so that NGINX can start:
cd ~/DevKinsta/sslopenssl genrsa 2048 > odonna-1.local.keyopenssl req -new -x509 -nodes -sha256 -days 365 -key odonna-1.local.key -out odonna-1.local.crt- Answer anything to the prompt questions until you are asked for the “Common Name”. For this you enter
odonna-1.local - With those files created you should delete
devkinsta_nginxagain before reopening DevKinsta.
It should now get past that error, if it doesn’t please share the logs. Once you get back into DevKinsta, please make sure the site still works without issues. You can also go to that specific site’s page and disable SSL
After it is disabled, you can delete the SSL certificate that you manually created. Enabling SSL and HTTPS again should allow DevKinsta to create the certificate for you.
Yes, that worked. Now, I’m encountering the next issue, related to the database. When trying to delete a site, I get a DK0051 error.
I’ve tried to install mysql with Docker:
sudo docker pull mysql/mysql-server:latest
I get this error when I open database manager:
Warning
: Cannot modify header information - headers already sent by (output started at /var/www/html/adminer.php:181) in
/var/www/html/adminer.php
on line
1528
Warning
: Cannot modify header information - headers already sent by (output started at /var/www/html/adminer.php:181) in
/var/www/html/adminer.php
on line
1436
Devkinsta uses Mariadb and not Mysql. You could try deleting the mariadb container and letting DevKinsta recreate it but you will need to send me the main.log for the DK0051 error.
[main.log|attachment]
Do you know why this is happening? Did you change anything with your computer before this started?
Cannot select database The database server could be connected to (which means your username and password is okay) but the database could not be selected.
All of your database connections say “Unknown database.” Did you delete the kinsta database or something? Does your database manager show your databases?
Also, are you trying to delete all of your websites to start over? Or are you only deleting some of them?
One of my sites got stuck on pulling from Kinsta. I tried to delete that site and start the process again, but that led to all of the issues I’m having now.
When I open my database manager, I see the error from the message I sent before the main.log.
Hmm, a single site failing shouldn’t cause this but this might be something new. Can you update to DevKinsta 2.7.0?
Once done please private message your config.json file to me. I’ll see if the database connection information is still correct. You’re config.json will be here for Mac:
User/Library/Application Support/DevKinsta
I just updated to 2.7.0. The issue is in the databases. I still have a full_backup.sql file, containing database info of all my sites. Where can I import this file, so that my databases are restored?
Okay perfect; so you can use the database manager to import the SQL
You can import to specific sites
Or just the entire database depending on what your backup SQL contains.
Or if you have a database management application/program you can use the credentials under “Site Info > Database” to connect to your DevKinsta database. It will work the same way as the Database Manager.
Click on the dropdown and select the blank option. What does that do?
The URL will be something like this: http://127.0.0.1:15200/?server=devkinsta_db&username=root&import=
Yes it should be possible. I’m not on Mac but the command should be the same. Something like this:
docker exec -i devkinsta_db bash -l -c "mysql -uroot -p{thepasswordnospace} < /path/to/backup.sql"
There is a thread here with ideas if you run into issues.
The plain command for accessing the mysql container is exec -it devkinsta_db bash