monicahq/docker

docker-compose setup does not work: Access denied for user 'monica'@...

ablx opened this issue · 1 comments

ablx commented

Hi, I followed this instructions to set up monica with docker-compose: https://github.com/monicahq/docker#apache-version

However, on start up, I get the error:

app_1  | In Connection.php line 671:
app_1  |                                                                                
app_1  |   [Illuminate\Database\QueryException (1045)]                                  
app_1  |   SQLSTATE[HY000] [1045] Access denied for user 'usermonica'@'172.21.0.3' (us  
app_1  |   ing password: YES) (SQL: select * from information_schema.tables where tabl  
app_1  |   e_schema = monica and table_name = cache and table_type = 'BASE TABLE')      
app_1  |                                                                                
app_1  | 
app_1  | Exception trace:
app_1  |   at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
app_1  |  Illuminate\Database\Connection->runQueryCallback() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:631
app_1  |  Illuminate\Database\Connection->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:339
app_1  |  Illuminate\Database\Connection->select() at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php:18
app_1  |  Illuminate\Database\Schema\MySqlBuilder->hasTable() at /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
app_1  |  Illuminate\Support\Facades\Facade::__callStatic() at /var/www/html/app/Console/Commands/Update.php:66
app_1  |  App\Console\Commands\Update->handle() at n/a:n/a
app_1  |  call_user_func_array() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:37
app_1  |  Illuminate\Container\BoundMethod::Illuminate\Container\{closure}() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php:37
app_1  |  Illuminate\Container\Util::unwrapIfClosure() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95
app_1  |  Illuminate\Container\BoundMethod::callBoundMethod() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:39
app_1  |  Illuminate\Container\BoundMethod::call() at /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php:596
app_1  |  Illuminate\Container\Container->call() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php:134
app_1  |  Illuminate\Console\Command->execute() at /var/www/html/vendor/symfony/console/Command/Command.php:258
app_1  |  Symfony\Component\Console\Command\Command->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php:121
app_1  |  Illuminate\Console\Command->run() at /var/www/html/vendor/symfony/console/Application.php:916
app_1  |  Symfony\Component\Console\Application->doRunCommand() at /var/www/html/vendor/symfony/console/Application.php:264
app_1  |  Symfony\Component\Console\Application->doRun() at /var/www/html/vendor/symfony/console/Application.php:140
app_1  |  Symfony\Component\Console\Application->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Application.php:93
app_1  |  Illuminate\Console\Application->run() at /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:129
app_1  |  Illuminate\Foundation\Console\Kernel->handle() at /var/www/html/artisan:37
app_1  | 

Apparently you tried to access your mysql on docker host from your container ... which I don't know how to do it.

See example here of how to create a mysql container and use it in your monica container.