search

Pilothouse-App / Pilothouse

A command line app for managing a LEMP local development environment based on Docker.
http://pilothouse-app.org
GNU General Public License v2.0
98 stars 17 forks source link

Pilothouse Up breaks trying to load MySql #107

Closed march23 closed 6 years ago

march23 commented 6 years ago

Hi When I try to install Pilothouse it complains trying to load/connect MySql, not sure why since docker compose is using Mariadb

check screenshot below

screen shot 2018-06-26 at 2 51 44 pm
philipnewcomer commented 6 years ago

In this case the name "MySQL" is hard-coded, but it refers to the database server Docker container in general whether that happens to be MySQL or MariaDB. But that's beside the point.

So the MySQL container could not be started. Open up Kitematic (which should have been installed along with Docker) and look at the logs for the pilothouse_mysql_1 container. That should indicate why the MySQL container could not be started. The most common cause of this issue is that something on your system is already listening on port 3306. Perhaps you already have MySQL installed locally, or you have another local development environment installed that is listening on port 3306. Assuming this is the issue, shut down whatever it is that is listening on port 3306 and restart Pilothouse.

march23 commented 6 years ago

Hi @philipnewcomer I check the logs on Kitematic and I found:

mysqld: unknown variable 'innodb_file_format=barracuda'

I read a post regarding this

"innodb_file_format was deprecated in MariaDB 10.2 and removed in MariaDB 10.3. Since MariaDB 10.2.2 the default is Barracuda, so there is no need to set this variable"

I guess a fix is coming on your last closed issue

philipnewcomer commented 6 years ago

Yes, I just released a fix for this in version 0.14.1. You can update to the latest version with this command: npm update -g pilothouse