Blog - Page 2 of 5 - Cerena Tech Team

Generate temporary signed URL from s3 in Laravel

Leave a Comment / AWS, Laravel / Moh / September 28, 2023

To create temporary files, you can use temporaryUrl method from the IlluminateSupportFacadeStorage facade. You can use the method on the following syntax. use IlluminateSupportFacadesStorage;$temporarySignedUrl = Storage::disk(‘s3’)->temporaryUrl(“filepath.pdf”, now()->addMinutes(10)); temporaryUrl method accepts two parameters as follows, Path: This parameter accepts the full path of the file in the s3 bucket Expiry Time: You can set the date for the expiry […]

Generate temporary signed URL from s3 in Laravel Read More »

Laravel `.env`, system-level, and server-level environment variables

Leave a Comment / Laravel / Moh / September 28, 2023

I was curious about this as well. Here’s your answer: System Level Env Variables: These are set on the actual operating system themselves. For example, in Windows, system level variables can be configured in: Control Panel System Properties Click Environment Variables You will see all the system level variables Windows contains Not sure where env variables

Laravel `.env`, system-level, and server-level environment variables Read More »

What is provisioning?

Leave a Comment / Computer Science, IT Terms / Moh / September 20, 2023

Provisioning is the process of creating and setting up IT infrastructure, and includes the steps required to manage user and system access to various resources. Provisioning is an early stage in the deployment of servers, applications, network components, storage, edge devices, and more. Provisioning is not the same thing as configuration management, but they are both

What is provisioning? Read More »

How to solve “Error: MySQL shutdown unexpectedly”?

Leave a Comment / MySQL / Moh / September 20, 2023

Solve “Error: MySQL shutdown unexpectedly: Rename folder mysql/data to mysql/data_old Make a copy of mysql/backup folder and name it as mysql/data Copy all your database folders from mysql/data_old into mysql/data (except mysql, performance_schema, and phpmyadmin folders) Copy mysql/data_old/ibdata1 file into mysql/data folder Start MySQL from XAMPP control panel https://stackoverflow.com/questions/18022809/how-to-solve-error-mysql-shutdown-unexpectedly

How to solve “Error: MySQL shutdown unexpectedly”? Read More »

How do I return a value from a call to Laravel DB::transaction(function () use() { … } );

Leave a Comment / Laravel / Moh / September 18, 2023

Actually the DB::transaction(…) returns whatever is returned from the callback. So you could simplify it to: $result = DB::transaction(function () { // …logic here return someGetResult(); }); dd($result);

How do I return a value from a call to Laravel DB::transaction(function () use() { … } ); Read More »

Connect MySQL Workbench to LightSail Instance

Leave a Comment / Uncategorized / Moh / September 13, 2023

Connect MySQL Workbench to EC2 Instance In addition, we need to confirm that the instance can connect to the internet using its public IP address from the local machine. Moving ahead: 1. Initially, we open the MySQL Workbench. 2. Then we select MySQL New Connection and enter a connection name. 3. Here we can

Connect MySQL Workbench to LightSail Instance Read More »

Increase file upload size limit in php-Nginx

Leave a Comment / Linux, PHP / Moh / September 12, 2023

To show line numbers in nano, and they are as follows: Method 1: You can directly use the following command to display line numbers in Nano: nano –linenumbers [filename] As below: nano –linenumbers testfile.txt Method 2: You can press Alt +Shift + 3 key combinations to display line numbers quickly. Method 3: You can

Increase file upload size limit in php-Nginx Read More »

Show Line Numbers in Nano Editor

Leave a Comment / Linux / Moh / September 12, 2023

To Increase file upload size limit in php-Nginx: use follow the following steps to increase or set PHP file upload limit with PHP FPM and Nginx: Step 1 – Edit php.ini file Step 2 – Edit Nginx conf file Step 3 – Restart Nginx Server , php service Step 1 – Edit php.ini file First of all, open terminal or command prompt

Show Line Numbers in Nano Editor Read More »

How to query Json objects in MySQL?

Leave a Comment / Uncategorized / Moh / August 28, 2023

not all databases and programming languages natively support JSON data type. In MySQL, for example, JSON data is stored as strings, and there are no built-in functions to query or manipulate JSON data. Is it possible to directly query a JSON object in MySQL? It is not possible to directly query a JSON object in

How to query Json objects in MySQL? Read More »

Monitor logs in Laravel Telescope in production environment

Leave a Comment / Laravel / Moh / August 28, 2023

The Laravel Telescope package is great for debugging your application when you’re working on your application in the local environment. It provides insight into the requests coming into your application, exceptions, log entries, database queries, queued jobs, mail, notifications, cache operations, scheduled tasks, variable dumps, and various other things in this beautiful interface. Now all this is great

Monitor logs in Laravel Telescope in production environment Read More »