How to create this MySQL query with CakePHP 4? SET @search = '9233' COLLATE utf8mb4_general_ci; SELECT * FROM 100pbc_new.addresses WHERE trading_partner LIKE CONCAT('%', @search, '%') OR dc_code LIKE CONCAT('%', @search, '%') OR dc_name LIKE CONCAT('%', @search, '%')...
James McDonald
How to get the Google Chrome PDF Viewer to Display Document Page Sizes in Metric
I am in Melbourne Australia and we use metric page sizes. The default display units for the embedded Google Chrome PDF Viewer is inches. How to set Google Chrome to display document properties in Metric Click the three vertical dots menuChoose settingsEnter language...
Chrome file download – Failed Network error
Just had a situation with sending a file to a browser with POST request and it kept erroring with "Failed - Network error" <?php // post request $barcodefile = 'barcode.pdf'; return $response->withFile(TMP . '$barcodefile, ['download' => true, 'name'=>...
Custom Location of cups-pdf denied by apparmor
Apr 25 09:31:23 tgn-vm-wms01 kernel: audit: type=1400 audit(1650879083.060:80): apparmor="DENIED" operation="mknod" profile="/usr/lib/cups/backend/cups-pdf" name="/var/www/tgn/webroot/files/PDF/Test_Page-job_12.pdf" pid=80336 comm="gs" requested_mask="c"...
CakePHP 4 from a sub directory
I have a default Nginx install on Ubuntu 22.04 LTS inside a Docker Container using I want /var/www/html to remain as the root but a CakePHP 4 app to be served as follows requests to hostname.example.com as served from /var/www/html requests to...
Where in the Middlewares should CORS Middleware be placed in CakePHP?
Answer: Before RoutingMiddleware EventManager::instance()->on('Server.buildMiddleware', function ($event, $middleware) { try { $middleware->insertBefore(RoutingMiddleware::class, new CorsMiddleware()); } catch (\LogicException $exception) { $middleware->add(new...
Client Apache Reverse Proxy Cake Token Auth
I have a reverse proxy that protects backend with basic auth client -> basic auth reverse proxy -> token auth cakephp backend curl -v \ -H 'Authorization: Basic base64_encoded_user_pass_here' \ -H 'Authorization: Token cakephptokenhere' \...
CentOS httpd taking 90 seconds to restart – systemctl restart httpd
The fix: systemctl kill httpd systemctl start httpd The problem: systemctl restart httpd ### wait for 90 seconds... too long
Using 7z cli to create chunked PST
# create a folder to hold the chunks mkdir archive651 # run the command to split the pst into 1GB chunks and plonk them in the folder 7z a -v1g archive651\archive651 "archive 651.pst" Just discovered that azcopy is nowhere near as good as the AWS utilities that upload...
Replacing my OnePlus 3T with a OnePlus 9
I purchased a OnePlus 3T from Kogan July 2018 It has been a good phone but recently I noticed it was starting to get slow. So I started to think about replacing it However the decision to replace it was forced on me. While on holidays recently in Tasmania I fumbled my...
