Comments - Do not understand why MariaDB rejected REGEXP with 42000 You have an error in your SQL syntax
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
It would be nice to create an issue https://jira.mariadb.org/projects/MDEV/issues/ with trace from wireshark, and php version.
I failed to reproduce the issue with latest php and according pdo driver, the only way to identify the issue is having wireshark log to identify if this is a server issue, connector issue or otherwise
Someone will still have to tell me how to perform the trace. Since the web server and the Sql server are on the same host they communicate using a named pipe, not by IP over the internet, so there is no IP traffic for wireshark to look at.
I still do not know how to perform the trace. For example I tried the steps described on https://dbtut.com/index.php/2018/11/15/how-to-get-the-data-packets-between-mysql-client-and-server/
$ sudo tcpdump -nnei any port 8001 -w tmp.pcap [sudo] password for jcobban: tcpdump: listening on any, link-type LINUX_SLL (Linux cooked v1), capture size 262144 bytes
At this point I invoked the script http://localhost/Ontario/WmbResponse.php?district=Oxford+%26+Middlesex&area=Nissouri+Twp.E%26W which duplicated the error.
^C0 packets captured 0 packets received by filter 0 packets dropped by kernel
The error is on requests made from PHP to the MariaDB server, not on requests from the mysql client.
I do not know how to perform a wireshark trace of the MariaDB client server connection. As to the PHP level my development system is running PHP Version 7.3.11-0ubuntu0.19.10.2 with mysqlnd 5.0.12-dev - 20150407 and MariaDB 10.3.20-MariaDB-0ubuntu0.19.10.1. Those are quite current as I am running the latest available release of Ubuntu. As noted in the original post my production system is currently running PHP Version 7.2.24-0ubuntu0.18.04.2 with MySQL 5.7.28-0ubuntu0.18.04.4 which is still quite current. So I am experiencing the problem across a broad range of environments. In both cases PHP and the SQL server are on the same host.