PHP启动：无法加载动态库'mysqli'未定义符号：mysqlnd_global_stats

Question

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?

Answer 1

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.