I forget put shell information
cron
* * * * * cd /home/aichaes/public_html/invoiceninja && /usr/bin/php -d register_argc_argv=On artisan schedule:run >> /dev/null 2>&1
Result on shell
cd /home/aichaes/public_html/invoiceninja && /usr/bin/php -d register_argc_argv=On artisan schedule:run
cd /home/aichaes/public_html/invoiceninja && /usr/bin/php -d register_argc_argv=On artisan schedule:run
INFO No scheduled commands are ready to run.
X-Powered-By: PHP/8.1.18
Content-type: text/html; charset=UTF-8
0 0 * * * App\Jobs\Util\VersionCheck ...................................................................................................................................................................................... Next Due: 17 hours from now
10 2 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 19 hours from now
0 * * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ....................................................................................................................... Next Due: 19 minutes from now
*/5 * * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ........................................................................................................................ Next Due: 4 minutes from now
20 23 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 16 hours from now
30 23 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 16 hours from now
1 0 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 17 hours from now
0 * * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ....................................................................................................................... Next Due: 19 minutes from now
30 * * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ....................................................................................................................... Next Due: 49 minutes from now
10 0 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 17 hours from now
10 5 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 22 hours from now
0 7 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ....................................................................................................................... Next Due: 19 minutes from now
20 6 * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ......................................................................................................................... Next Due: 23 hours from now
10 1 * * * App\Jobs\Util\SchedulerCheck .................................................................................................................................................................................... Next Due: 18 hours from now
10 * * * * Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ....................................................................................................................... Next Due: 29 minutes from now
30 2 * * 0 Closure at: vendor/laravel/framework/src/Illuminate/Console/Scheduling/Schedule.php:150 ............................................................................................................................ Next Due: 1 day from now
*/5 * * * * Closure at: app/Console/Kernel.php:97 .......................................................................................................................................................................... Next Due: 4 minutes from now
php cli on shell
This php info show that PDO is installed on shell for the user.
/usr/bin/php -i | grep pdo
<tr><td class="e">Configure Command </td><td class="v"> './configure' '--disable-dependency-tracking' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--target=x86_64-redhat-linux-gnu' '--program-prefix=' '--prefix=/opt/alt/php81' '--exec-prefix=/opt/alt/php81' '--bindir=/opt/alt/php81/usr/bin' '--sbindir=/opt/alt/php81/usr/sbin' '--sysconfdir=/opt/alt/php81/etc' '--datadir=/opt/alt/php81/usr/share' '--includedir=/opt/alt/php81/usr/include' '--libdir=/opt/alt/php81/usr/lib64' '--libexecdir=/opt/alt/php81/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/opt/alt/php81/usr/share/man' '--infodir=/opt/alt/php81/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/opt/alt/php81/etc' '--with-config-file-scan-dir=/opt/alt/php81/link/conf' '--disable-debug' '--enable-calendar' '--enable-exif' '--enable-ftp' '--enable-huge-code-pages' '--enable-jit' '--enable-shmop' '--enable-xml' '--with-bz2' '--with-freetype=/usr' '--with-gettext' '--with-gmp=shared' '--with-iconv' '--with-jpeg=/usr' '--with-layout=GNU' '--with-mhash' '--with-password-argon2=/usr' '--with-pcre-jit' '--with-pic' '--with-readline' '--with-webp=/opt/alt/libwebp' '--with-xpm=/usr' '--with-zlib' '--with-zlib-dir=/usr' '--without-gdbm' '--without-pear' '--with-curl=/opt/alt/curlssl11/usr' '--with-openssl-dir=/opt/alt/openssl11' '--with-openssl=/opt/alt/openssl11' '--with-pcre-dir=/opt/alt/pcre2' '--with-kerberos=/opt/alt/krb5/usr' '--enable-bcmath=shared' '--enable-dba=shared' '--with-db4=/usr' '--enable-dom=shared' '--enable-fileinfo=shared' '--enable-gd=shared' '--enable-intl=shared' '--enable-json=shared' '--enable-mbregex' '--enable-mbstring=shared' '--enable-opcache' '--enable-pcntl' '--enable-pdo=shared' '--enable-phar=shared' '--enable-posix=shared' '--enable-soap=shared' '--enable-sockets=shared' '--enable-sysvsem=shared' '--enable-sysvshm=shared' '--enable-sysvmsg=shared' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-enchant=shared,/usr' '--with-external-gd' '--with-gnu-ld=yes' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pspell=shared' '--with-tidy=shared,/usr' '--with-unixODBC=shared,/usr' '--with-zip=shared' '--with-pdo-pgsql=shared,/opt/alt/postgresql11/usr' '--with-pgsql=shared,/opt/alt/postgresql11/usr' '--with-imap=shared,/opt/alt/libc-client11' '--with-imap-ssl=/opt/alt/openssl11' '--with-ldap=shared,/opt/alt/openldap11' '--with-ldap-sasl' '--with-pdo-dblib=shared,/opt/alt/freetds11/usr' '--with-pdo-sqlite=shared,/opt/alt/sqlite/usr' '--with-snmp=shared,/opt/alt/net-snmp11/usr' '--with-sqlite3=/opt/alt/sqlite/usr' '--with-pdo-oci=shared,instantclient,/usr/lib/oracle/12.1/client64/lib' '--with-sodium=shared,/usr' '--with-ffi=shared,/usr' '--with-pdo-firebird=shared' '--with-xsl=shared,/usr' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'target_alias=x86_64-redhat-linux-gnu' 'PKG_CONFIG_PATH=/opt/alt/curlssl11/usr/lib64/pkgconfig:/opt/alt/openssl11/lib64/pkgconfig:/opt/alt/libicu/usr/lib64/pkgconfig:/opt/alt/sqlite/usr/lib64/pkgconfig:/opt/alt/pcre2/usr/lib64/pkgconfig:/opt/alt/libzip/usr/lib64/pkgconfig:/opt/alt/libxml2/usr/lib64/pkgconfig:/opt/alt/libgd/lib64/pkgconfig::/usr/lib64/pkgconfig:/usr/share/pkgconfig' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -Dmp_bitcnt_t=long -fno-strict-aliasing -Wno-pointer-sign' 'LDFLAGS= -Wl,-rpath=/opt/alt/libxml2/usr/lib64,-rpath=/opt/alt/libwebp/lib64 -L/opt/alt/openssl11/lib64 -L/opt/alt/libicu/usr/lib64 -L/opt/alt/libc-client11/lib64 -L/opt/alt/openldap11/lib64 -L/opt/alt/net-snmp11/usr/lib64 -L/opt/alt/libssh211/usr/lib64 -Wl,-rpath=/opt/alt/curlssl11/usr/lib64,-rpath=/opt/alt/openssl11/lib64,-rpath=/opt/alt/libicu/usr/lib64,-rpath=/opt/alt/t1lib/usr/lib64,-rpath=/opt/alt/sqlite/usr/lib64,-rpath=/opt/alt/pcre2/usr/lib64,-rpath=/opt/alt/openldap11/lib64,-rpath=/opt/alt/freetds11/usr/lib64,-rpath=/opt/alt/net-snmp11/usr/lib64,-rpath=/opt/alt/libssh211/usr/lib64,-rpath=/opt/alt/libc-client11/lib64 -L/opt/alt/nghttp2/lib64 -L/opt/alt/postgresql11/usr/lib64 -Wl,-rpath=/opt/alt/nghttp2/lib64,-rpath=/opt/alt/postgresql11/usr/lib64 -Wl,-rpath=/usr/lib64 ' 'CXXFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic' 'KERBEROS_CFLAGS=-I/usr/include' 'KERBEROS_LIBS=-L/usr/lib64' 'WEBP_LIBS=-L/opt/alt/libwebp/lib64 -Wl,-rpath=/opt/alt/libwebp/lib64' 'SASL_CFLAGS=-I/usr/include' 'SASL_LIBS=-L/usr/lib64' </td></tr>
<h2><a name="module_pdo">PDO</a></h2>
<h2><a name="module_pdo_mysql">pdo_mysql</a></h2>
<tr><td class="e">pdo_mysql.default_socket</td><td class="v">/var/lib/mysql/mysql.sock</td><td class="v">/var/lib/mysql/mysql.sock</td></tr>
<h2><a name="module_pdo_sqlite">pdo_sqlite</a></h2>
After this problem, I’ve changed .env QUEUE_CONNECTION from REDIS to sync
As a general rule, in my projects when I make this change, the mail delivery problems no longer go to the redis, horizon or the selected queue logs, since being synced the logs are immediate in the laravel logging system.
Well, we still don’t get any errors, neither in the dashboard nor in the Laravel log.
And of course we still do not send emails.
And of course we still don’t see any error, while the interface after 30 seconds tells us “Budget sent correctly”
On my screen three shells with their respective logs involved.
And of course, the dashbaord log system says 0.
In this state of affairs, it is quite difficult to find a fault in an application, its configuration.