Setup Sceduled job using Laravel Forge

@tykus Hi! Yes, its already a schedule there (some other has created this) but its not working

php8.1 /home/forge/app.easyflow.golf/artisan schedule:run

In the log its saying

Could not open input file: /home/forge/app.easyflow.golf/artisan

@birdietorerik is that directory correct on your production server? And is that the root of your Laravel project?

Is your app deployed and working in the browser?

@tykus Hi! When try to run this:

php8.1 /home/forge/test.easyflow.golf/current/artisan schedule:run

Now, i get this error:

   UnexpectedValueException 

  The stream or file "/home/forge/test.easyflow.golf/releases/20240911092916/storage/logs/laravel-2024-09-11.log" could not be opened in append mode: Failed to open stream: Permission denied
The exception occurred while attempting to log: Class "App\Jobs\ProcessGpsDataJob" not found
Context: {"exception":{}}

  at test.easyflow.golf/releases/20240911092916/vendor/monolog/monolog/src/Monolog/Handler/StreamHandler.php:137
    133▕             }
    134▕             if (!is_resource($stream)) {
    135▕                 $this->stream = null;
    136▕ 
  ➜ 137▕                 throw new \UnexpectedValueException(sprintf('The stream or file "%s" could not be opened in append mode: '.$this->errorMessage, $url) . Utils::getRecordMessageForException($record));
    138▕             }
    139▕             stream_set_chunk_size($stream, $this->streamChunkSize);
    140▕             $this->stream = $stream;
    141▕         }

      +12 vendor frames 

  13  test.easyflow.golf/releases/20240911092916/artisan:37
      Illuminate\Foundation\Console\Kernel::handle()

@birdietorerik which user are you, and which user owns the directory/log file?

It also seems that you have not resolved this problem

Class "App\Jobs\ProcessGpsDataJob" not found

Did you confirm that the PHP file is located at app/Jobs/ProcessGpsDataJob.php and the class inside is named ProcessGpsDataJob?

@tykus Hi!

Yes, file App/Jobs/ProcessGpsDataJob.php exist

Here is then content of this file:

<?php

namespace App\Jobs;

use Illuminate\Bus\Queueable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use App\Models\UnprocessedGpsData;
use App\Models\TrackerGps;
use App\Facades\GpsService;
use App\Models\Golfclub;
use Illuminate\Support\Facades\DB;

class ProcessGpsDataJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;

    /**
     * Execute the job.w
     *
     * @return void
     */
    public function handle()
    {
        // Process data twice in one minute, with a 30-second delay between runs
        for ($i = 0; $i < 2; $i++) {
            $chunkSize = 500; // Process data in chunks of 500 records

            UnprocessedGpsData::where('status', 0)->chunk($chunkSize, function ($unprocessedData) {
                $idsToUpdate = [];
                $idsToDelete = [];

                DB::transaction(function () use ($unprocessedData, &$idsToUpdate, &$idsToDelete) {
                    // Fetch trackers in bulk to avoid repeated querying
                    $trackers = TrackerGps::whereIn('tracker', $unprocessedData->pluck('tracker'))->get()->keyBy('tracker');

                    foreach ($unprocessedData as $unprocessed) {
                        $tracker = $trackers->get($unprocessed->tracker);

                        // If no tracker found, create a new one
                        if (!$tracker) {
                            $tracker = new TrackerGps();
                            $tracker->tracker = $unprocessed->tracker;
                            $tracker->golfclub_id = config('tracker.default_club');
                        }

                        // Get the golf club and its timezone
                        $golfclub = Golfclub::with('timezone')->find($tracker->golfclub_id);
                        $timezone = $golfclub->timezone->timestring;

                        // Use Carbon to handle timezone conversion
                        $unprocessedDate = \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $unprocessed->date, $timezone);

                        // Update tracker's battery value
                        $tracker->battery = $unprocessed->battery;
                        $tracker->save();

                        // Store GPS position and process it
                        $isProcessed = GpsService::storegpsposWithCoordinates(
                            null,
                            $tracker,
                            $unprocessed->latitude,
                            $unprocessed->longitude,
                            $unprocessedDate,
                            0.0, // Assuming altitude as 0.0
                            1    // Assuming some default status
                        );

                        // Mark as processed
                        $unprocessed->status = 1;
                        $unprocessed->save();

                        if ($isProcessed === false) {
                            $idsToUpdate[] = $unprocessed->id; // Data that failed to process
                        } else {
                            $idsToDelete[] = $unprocessed->id; // Successfully processed data
                        }
                    }

                    // Delete successfully processed data
                    if (!empty($idsToDelete)) {
                        UnprocessedGpsData::whereIn('id', $idsToDelete)->delete();
                    }
                });
            });

            // Sleep for 30 seconds to effectively run this job twice in a minute
            sleep(30);
        }
    }
}

@birdietorerik

Is the file in this path? /home/forge/test.easyflow.golf/current/app/Jobs/ProcessGpsDataJob.php

Also, generally storage/logs folder is in the same path as artisan. Whereas the error shows a different path: "/home/forge/test.easyflow.golf/releases/20240911092916/storage/logs/" @tykus is it possible to have logs in a different folder?

@Snapey Hi! You right, it was wrong filename.

But still not working :(

In Forge -> Sceduler....

Command:

php8.1 /home/forge/test.easyflow.golf/artisan schedule:run

Gives me this errormessage:

Could not open input file: /home/forge/test.easyflow.golf/artisan

Have used many hours to try to fix this, no luck ???

No errors in laravel.log ?

@birdietorerik seriously, how many times did I ask you about the filename/class name??? Same about the path to the root of your project on the server.

Why is there no artisan file in the root of your project? How was it deployed to the server; did you use git or FTP or rsync or scp???

@birdietorerik You mentioned that the path is different:

php8.1 /home/forge/test.easyflow.golf/current/artisan schedule:run

It is test.easyflow.golf/current/artisan right? not just test.easyflow.golf/artisan. There is a "current" folder in the path.

@tykus

I'm not very good with servers and don't fully understand this thing about a file called artisan. Sorry that I don't get it. For example, when I want to run a command like php artisan migrate, shouldn't I just write artisan migrate?

I'm using Git, Laravel Forge, GitHub, and Laravel Envoyer. When I deploy with Laravel Envoyer, previous versions are saved as a directory with a number. The latest code runs under the directory current. Current is linked to the folder that has the numeric identifier.

@birdietorerik I never used forge / envoyer. I manage my own servers on AWS. So I know a bit about server paths etc...

Having said that, Forge is meant to make life easy for people who are not server experts.

Anyways, Backtracking to a previous post in this thread, you said you got a different error when you did this:

php8.1 /home/forge/test.easyflow.golf/current/artisan schedule:run

The error was:

The stream or file "/home/forge/test.easyflow.golf/releases/20240911092916/storage/logs/laravel-2024-09-11.log" could not be opened in append mode: Failed to open stream: Permission denied
The exception occurred while attempting to log: Class "App\Jobs\ProcessGpsDataJob" not found
Context: {"exception":{}}

There are 2 errors being highlighted in this:

1. First error - not able to find the class "App\Jobs\ProcessGpsDataJob". This should ideally be in this path: "/home/forge/test.easyflow.golf/current/app/Jobs/ProcessGpsDataJob.php". If you have ssh access to your server please check using

"ls /home/forge/test.easyflow.golf/current/app/Jobs/"

If you don't ave ssh access, please check whether the file exists in you latest git repository branch which was pushed to forge.

2. Second error: When an error occurs, laravel will try to log it to the latest file in storage/logs/. But linux servers are very strict. It is mandatory that the "user" performing the task has permission to do so. this is generally achieved by running

sudo chmod -R 775 storage

I'm assuming that forge does this automatically.

I believe a forge expert can solve this for you. But, till then, you can try this:

1. Confirm that the file ProcessGpsDataJob.php exists in the git repo in this path: app/Jobs/ProcessGpsDataJob.php"
2. If you have ssh access to the server confirm that it is in this path on the server: /home/forge/test.easyflow.golf/current/app/Jobs/ProcessGpsDataJob.php
3. try sudo chmod -R 775 storage in /home/forge/test.easyflow.golf/current/@birdietorerik

@birdietorerik

For example, when I want to run a command like php artisan migrate, shouldn't I just write artisan migrate?

No. Open the artisan file. It's a PHP file, just without the extension. So when you run php artisan X Y Z, it simply runs the artisan PHP script with the command line parameters X, Y and Z.