My entire site runs flawlessly via browser. I have just added a cron job, and each time it runs this error gets triggered:
PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20180731/mysqli (/usr/lib/php/20180731/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20180731/mysqli.so (/usr/lib/php/20180731/mysqli.so: undefined symbol: mysqlnd_global_stats))
Not sure what is going on. I have logged PHP version both using the browser, and using cron, and it came out the same: 7.3.2-3+0~20190208150725.31+stretch~1.gbp0912bd
What is so different in cron? How can i fix this?
I have 2 solutions.
Solution one: I noticed that closing the mysql connection at the end of the script solves the problem.
Solution two: As it turns out, there was a difference between /etc/php/7.3/cli/php.ini and /etc/php/7.3/fpm/php.ini.
The first one has this line:
extension=mysqli
The second one hat this (note the semicolon):
; extension=mysqli
Adding the semicolon to /etc/php/7.3/cli/php.ini completly fixed my issue.