sursangam

[sursangam]

Access error when using Docker on Windows (WSL)

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

3) net start winnat

[sursangam]

Pagination Links Messed Up in Laravel

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

Solution - Set your pagination to use bootstrap as explained here 

[sursangam]

Use “jddayofweek($day, $mode)” to get Day of Week

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

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

RUN docker-php-ext-install calendar && docker-php-ext-enable calendar

[sursangam]

Azure Multi-container deploy

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

Azure multi-conatiner app ignores container_name directive in the docker-compose file and instead uses the service name. I simply changed my service name to be the same as the container_name - SOLVED

[sursangam]

artisan tinker stopped working

If “artisan tinker” starts kicks you out into the shell on every command make sure you upgrade to php version >= 7.3.11

[sursangam]

How to enable Vue.js on a fresh Laravel Application

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

npm install && npm run dev

[sursangam]

npm install error after updating MacOS

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

"gyp: No Xcode or CLT version detected!"

To fix -

sudo xcode-select --reset

[sursangam]

Setting up auth in new Laravel app

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 -

https://laravelarticle.com/larave-6-make-auth

[sursangam]

MySQL Client on Mac OS

CLI:

brew update

brew install mysql-client

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

GUI client:

MySQL Workbench - https://www.mysql.com/products/workbench/

[sursangam]

Seeding Error on Laravel

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)

I needed to make sure my docker mysql instance was available by it’s container name instead of localhost/127.0.0.1. The .env file also  uses the docker container