My Personal Tech Notes

Received an error when accessing mysql & mariadb containers on WSL in windows 10. Found the solution to the error here 

;tldr version - 

Cause - Basically the winnat service is hoarding/blocking the mysql port 3306

Solution - As an admin follow these steps - 

1) net stop winnat

2) Restart Docker engine

The styling of your pagination links might be messed up when using Bootstrap in your Laravel app. 

This function (ref) will give error in regular docker image of php-fpm

Solution - Build the image with “calendar” installed and enabled 

Issue - how to call resources on one container from another -

After setting up a new Laravel app (laravel new myapp), do this from the app root folder - 

composer require laravel/ui

php artisan ui vue

Mac OS Catalina has started giving this error when doing an npm install -

"gyp: No Xcode or CLT version detected!"

To fix -

This no longer works - artisan make:auth

so now you have to do this - 

composer require laravel/ui --dev php artisan ui bootstrap --auth npm install npm run dev 

This is explained in detail here -

CLI:

brew update

brew install mysql-client

echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.bash_profile

GUI client:

Received This error “Illuminate\Database\QueryException  : SQLSTATE[HY000] [2002] php_network_getaddresses:”

Solution:

Setup hosts file to map docker mysql container to localhost address (127.0.0.1)