DEV Community: David

How to run SQL Server on M1/M2 with Docker

David — Fri, 05 Jul 2024 09:20:29 +0000

Pull the image by opening up a terminal and running the command

docker pull mcr.microsoft.com/azure-sql-edge`

docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=1' -e 'MSSQL_SA_PASSWORD=your_strong_password' -p 1433:1433 --name azuresqledge -d -v sqlvolume:/var/opt/mssql mcr.microsoft.com/azure-sql-edge

–cap-add SYS_PTRACE – here is Microsoft’s note on this line: The --cap-add SYS_PTRACE flag is required for non-root SQL Server containers to generate dumps for troubleshooting purposes

-e ‘ACCEPT_EULA=1’ is an environment variable, which is saying that we will accept the End User License Agreement.

-e ‘MSSQL_SA_PASSWORD=your_strong_password’ – this is setting the password for the sa (the system administrator) user. This is how you will log into the database. By default the username is ‘sa’.

-p 1433:1433 is mapping ports. The left side of the colon is the port on the host (your mac). The right side is the port used inside the container

–name azuresqledge is just giving the container a more user-friendly name after it starts running

-d is detached mode. This means that the terminal won’t attach to the process, which means it’ll start the container up and then give you terminal control back, so you can run other commands.

-v sqlvolume:/var/opt/mssql is to persist the data

mcr.microsoft.com/azure-sql-edge is last and it’s the name of the image. This is the same name used in the docker pull command

How to use NVM in Laravel Forge

David — Fri, 05 Jul 2024 09:18:19 +0000

SSH to forge server and run this command

curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.39.5/install.sh | bash

In forge site deployment script. add this script to install and change the version

echo 'configuring nvm...';
. ~/.nvm/nvm.sh
nvm install v20.0.0
nvm use v20.0.0

echo 'Running > npm install';
npm install

echo 'Running > npm run build';
npm run build

How to Validate Array Data in Laravel Using Request Classes

David — Fri, 05 Jul 2024 09:13:40 +0000

Create a Request Class:

As before, create a request class with your validation rules.

php artisan make:request StoreUserRequest

Define your validation rules in the generated request class (StoreUserRequest):

<?php

namespace App\Http\Requests;

use Illuminate\Foundation\Http\FormRequest;

class StoreUserRequest extends FormRequest
{
    public function authorize()
    {
        return true;
    }

    public function rules()
    {
        return [
            'name' => 'required|string|max:255',
            'email' => 'required|email|unique:users,email',
            'password' => 'required|string|min:8',
        ];
    }
}

Validate the Array Data in the Controller:

In your controller, you can validate the array data using the validation rules from the request class and additional rules if needed.

namespace App\Http\Controllers;

use App\Http\Requests\StoreUserRequest;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Validator;

class UserController extends Controller
{
    public function store(Request $request)
    {
        // Example array data (in real use-case, this might come from another source)
        $data = [
            'name' => 'John Doe',
            'email' => 'john.doe@example.com',
            'password' => 'secret1234',
            'age' => 25,
            'terms' => true,
        ];

        // Retrieve rules from the request class
        $requestClass = new StoreUserRequest();
        $rulesFromRequestClass = $requestClass->rules();

        // Additional validation rules
        $additionalRules = [
            'age' => 'required|integer|min:18',
            'terms' => 'accepted',
        ];

        // Combine rules from the request class and additional rules
        $combinedRules = array_merge($rulesFromRequestClass, $additionalRules);

        // Validate the data array with the combined rules
        $validator = Validator::make($data, $combinedRules);

        if ($validator->fails()) {
            return response()->json(['errors' => $validator->errors()], 422);
        }

        // Use the validated data for further processing
        $validatedData = $validator->validated();

        // Example: Create a new user
        $user = User::create($validatedData);

        return response()->json(['message' => 'User created successfully', 'user' => $user], 201);
    }
}

Customize Validation Messages (Optional):

You can customize the validation messages in the request class as needed.

public function messages()
{
    return [
        'name.required' => 'The name field is required.',
        'email.required' => 'The email field is required.',
        'email.email' => 'The email must be a valid email address.',
        'password.required' => 'The password field is required.',
        'age.required' => 'The age field is required.',
        'terms.accepted' => 'You must accept the terms and conditions.',
    ];
}

By following these steps, you can validate array data using the validation rules defined in a request class, combined with additional rules, in your Laravel controller.

A Step-by-Step Guide to Setting Up Supervisord for Laravel in Ubuntu

David — Thu, 16 Mar 2023 08:19:42 +0000

Supervisord is a process management tool that can help you manage processes in your Ubuntu system. It's especially useful if you need to run long-running processes, such as those involved in background tasks, cron jobs, or queue workers. Laravel, a popular PHP framework, relies heavily on background tasks and queue workers to handle tasks such as sending emails, processing uploaded files, and more. In this article, we'll guide you through the process of setting up Supervisord in Ubuntu for Laravel.

Step 1: Install Supervisord

The first step is to install Supervisord on your Ubuntu system. You can do this using the apt package manager:

> sudo apt-get update
> sudo apt-get install supervisor

This will install Supervisord and its dependencies on your system.

Step 2: Create a Supervisor Configuration File

Next, you need to create a configuration file for Supervisor. This file will contain information about the processes that you want to manage with Supervisord.

Create a new configuration file with the following command:

> sudo nano /etc/supervisor/conf.d/laravel-worker.conf

This will open a new file in the Nano text editor. In this file, you can specify the configuration for the Laravel worker process. Here's an example configuration:

[program:laravel-worker]
process_name=%(program_name)s_%(process_num)02d
command=php /var/www/your_project/artisan queue:work --sleep=3 --tries=3
autostart=true
autorestart=true
user=www-data
numprocs=1
redirect_stderr=true
stdout_logfile=/var/log/laravel-worker.log

This configuration sets up a Laravel worker process that will run the queue:work command with a sleep time of 3 seconds and a maximum of 3 retries. It will run as the www-data user and write its logs to /var/log/laravel-worker.log.

You can adjust these settings to fit your needs. Make sure to replace /var/www/your_project/artisan with the actual path to your Laravel application's artisan command.

Save and close the file by pressing Ctrl + X, then Y, then Enter.

Step 3: Reload Supervisor

Now that you've created your Supervisor configuration file, you need to reload Supervisor to apply the changes:

> sudo supervisorctl reread
> sudo supervisorctl update

This will read your new configuration file and update Supervisor's configuration.

Step 4: Start the Laravel Worker

Finally, you can start the Laravel worker process using the following command:

> sudo supervisorctl start laravel-worker:*

This will start the Laravel worker process and any child processes that it spawns.

You can check the status of the Laravel worker process using the following command:

> sudo supervisorctl status

This will show you the status of all processes that Supervisor is managing, including your Laravel worker process.

Conclusion

In this article, we've shown you how to set up Supervisord in Ubuntu for Laravel. By following these steps, you can manage your Laravel worker processes with ease and ensure that they run reliably and consistently. Remember to update your configuration file and reload Supervisor whenever you make changes to your Laravel worker process.

How To Secure Nginx with Let's Encrypt on Ubuntu

David — Thu, 16 Mar 2023 07:05:56 +0000

Certbot is a command-line tool that can be used to obtain and manage SSL/TLS certificates for your website. In order to use Certbot with Nginx on Ubuntu, you can follow these steps:

Install Certbot:

sudo apt-get update
sudo apt-get install certbot

Install the Nginx plugin for Certbot:

sudo apt-get install python3-certbot-nginx

Verify that your Nginx server blocks are set up correctly by running:

sudo nginx -t

If the configuration test passes, reload Nginx:

sudo systemctl reload nginx

Use Certbot to obtain a new SSL/TLS certificate for your domain:

sudo certbot --nginx -d example.com -d www.example.com

Replace example.com and www.example.com with your actual domain name(s).

Certbot will guide you through the process of obtaining a new SSL/TLS certificate. You will be prompted to enter your email address and agree to the terms of service. Certbot will then communicate with Let's Encrypt to obtain and install the certificate.

Once the certificate is installed, Certbot will update your Nginx configuration to use HTTPS. You can verify this by running:

sudo nginx -t

If the configuration test passes, reload Nginx:

sudo systemctl reload nginx

Congratulations, your Nginx server should now be configured to use HTTPS with a valid SSL/TLS certificate!

CRONTab Setup for Laravel in Ubuntu

David — Thu, 16 Mar 2023 06:15:37 +0000

Crontab is a useful tool that can help you automate repetitive tasks in Laravel. With crontab, you can schedule specific commands to run at specified intervals. In this article, we will explore how to set up crontab for Laravel.

Step 1: Open crontab editor
To begin, open the crontab editor by typing the following command in your terminal:

> crontab -e

This will open the crontab editor, allowing you to schedule your commands.

Step 2: Add Laravel command
Next, add the Laravel command that you want to run. For example, if you want to run the Laravel scheduler every minute, add the following line to your crontab file:

* * * * * cd /path/to/laravel-app && php artisan schedule:run >> /dev/null 2>&1

Here, the asterisks represent the schedule interval, which is set to run every minute. You can adjust this to run at different intervals as needed.

Step 3: Save and exit crontab
Once you have added your Laravel command to the crontab file, save and exit the editor by pressing 'ctrl + X' and 'Y + Enter'. Your changes will be automatically saved and scheduled to run at the specified intervals.

Step 4: Verify crontab is running
To verify that your crontab is running, you can check the crontab log file by running the following command:

> grep CRON /var/log/syslog

This will display a log of all the cron jobs that have run on your system, including the Laravel command you just added.

In conclusion, setting up crontab for Laravel can help you automate repetitive tasks and streamline your development workflow. By following the steps outlined in this article, you can easily schedule Laravel commands to run at specified intervals using crontab.