PHP 7.3 - Find php.ini file

Simply run this command:

php -i | grep "Loaded Configuration File"

In my case it found the file here:

[root@x.x.x.x etc]# php -i | grep "Loaded Configuration File"
Loaded Configuration File => /etc/php.ini

Crontab -e log history on Amazon Linux 2

This is located here:

/var/log/cron

Example of usage:

tail -500f /var/log/cron

You shall find your scripts from crontab -e being run:

Apr 17 22:43:01 ip-172-31-39-55 CROND[1407]: (root) CMD (sh /home/dtech/monitoring/check-daily-requests.sh)
Apr 17 22:43:01 ip-172-31-39-55 CROND[1408]: (root) CMD (sh /home/dtech/monitoring/check-cpu)

Splunk: Split URL Path by removing query parameters

If you have something like the below:

/easybiny.stockprice.json?dt=123213

and want only to get the path without query string:
/easybiny.stockprice.json

Then easy way is to do this in the Splunk search statement:

eval url=mvindex(split(request, "?"), 0) | table request,url

MariaDB/MySQL show privilegies for DB User

MariaDB [xxxx]> show grants for 'xxxx'@"localhost";
+------------------------------------------------------------------------+
|Grants for xxxx@localhost                                              |
+------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xxxx'@'localhost' IDENTIFIED BY PASSWORD '*xxx'
| GRANT SELECT, INSERT ON `dtech`.`bins` TO 'xxxx'@'localhost'          
+------------------------------------------------------------------------+

Fix "PHP Fatal error: Uncaught Error: Call to a member function bind_param() on bool in"

First of all, please make sure you have proper verbose error to identify root cause:


if ($stmt = $conn->prepare("SELECT id, password FROM accounts WHERE email = ?")) {
        $stmt->bind_param("s", $_POST['username']);
        $stmt->execute();
        $stmt->store_result();
....

else{
$error = $conn->errno . ' ' . $conn->error;
echo $error;
}

Once this in place, I can get the exact error message in browser:

1142 SELECT command denied to user 'xxxx'@'localhost' for table 'accounts'DB error

So my xxxx user does not have proper access. 

This is easily to be fixed by running the following command:

GRANT SELECT ON db.accounts TO xxxx@'localhost';

Redirect www subdomain to "apex" like subdomain

First, please always use https and proper certificate.

Secondly, add the following rule to your virtual host:

...

RewriteEngine on
RewriteCond %{SERVER_NAME} =www.stage.easybiny.com
RewriteRule ^ https://stage.easybiny.com%{REQUEST_URI} [END,NE,R=permanent]

...

Note: In this example, stage.easybiny.com is the "apex" like subdomain.

Connect to MySQL MariaDB

Connect to MariaDB:

1.
mysql

Following prompt is to appear:
MariaDB [(none)]>

2.
show databases;

3.
use databasename;
E.g.
use dtech;

3.
show tables;

E.g.
MariaDB [dtech]> show tables;
+-----------------+
| Tables_in_dtech |
+-----------------+
| bins            |
+-----------------+
1 row in set (0.000 sec)
4.
select * from bins;

5.
exit;