cant get APM to Log the stuff in PHP7.0 FPM

[ChrisWesterfield]

Hi I would like to add APM to my applications But somehow the database tables aren't created during the run of the scripts. I have enabled the opcache of php7 I also have the tideways profiler installed.

heres my php-fpm pool config

[cp] user = ######### group = ########## listen = /home/####################/run/php.sock listen.owner = ############ listen.group = ############## listen.mode = 0660 pm = dynamic pm.max_children = 30 pm.start_servers = 4 pm.min_spare_servers = 4 pm.max_spare_servers = 8 php_flag[display_errors] = off php_admin_value[error_log] = /home/##########/logs/php5-fpm.log php_admin_flag[log_errors] = on php_admin_value[memory_limit] = 512M php_admin_value[opcache.file_cache] = "/home/############" php_admin_value[apm.mysql_enabled]=1 php_admin_value[apm.mysql_error_reporting]=E_ALL|E_STRICT php_admin_value[apm.mysql_host]=localhost php_admin_value[apm.mysql_user]=########### php_admin_value[apm.mysql_pass]=####################### php_admin_value[apm.mysql_db]=########## php_admin_value[apm.socket_path]=/home/##########/run/php-apm.sock php_admin_value[apm.application_id]=##################### php_admin_value[apm.socket_enabled]=0 php_admin_value[apm.sqlite_enabled]=0 php_admin_value[apm.statsd_enabled]=0 php_admin_value[apm.mysql_port]=3306

where is my mistake?

[patrickallaert]

Hi,

Can you try without tideways and/or xdebug if activated?

I notice that you defined apm.mysql_error_reporting to E_ALL|E_STRICT. That might be the issue. While configured within PHP (ini_set, php.ini,...), PHP knows what are the values of E_ALL (32767) and E_STRICT (2048) which means that E_ALL|E_STRICT = 32767 (in PHP 7). I am, however, not sure that your web server knows those values and is probably not computing that correctly and tries to pass the string "E_ALL|E_STRICT" which is then received by PHP as the integer value "0" which means => report nothing.

Do you see APM in a page with phpinfo() and does the configuration match your configuration file? You will be able to validate my possible theory looking at the apm.mysql_error_reporting value.

The tables are supposed to be created by APM, but the database should be created in advance. Does the DB user has access to table creation?

You can test this connecting to your DB with:

$ mysql -u<USER> -p<PASSWORD> <DATABASE>
> CREATE TABLE test ( `test` varchar(255) DEFAULT NULL  );
> DROP TABLE test;

Cheers.

[Lewiscowles1986]

So this extension works with PHP7 or no?

[jamesstout]

@Lewiscowles1986 yes it works