Fixed: Where PHP sessions are stored?

This is setup using the following parameter:

session.save_path  

By default, at least in PHP 7.3, this is commented in php.ini:
;session.save_path = "/tmp"

It means default location is the following one:
/var/lib/php/session

In there you'll get files like the below:
[root@ip-172-31-39-55 session]# ls -l
-rw------- 1 apache apache 71 Apr 18 18:31 sess_0a2bbj0u9nsf9gh5vbddte855e
-rw------- 1 apache apache  0 Apr 18 11:13 sess_0uttil3jnenoos2kcf6t45gqj5
-rw------- 1 apache apache  0 Apr 17 15:30 sess_1f57jnsc28gj06km301b4von1a
-rw------- 1 apache apache  0 Apr 18 10:39 sess_2ips2j6djo8fst8lm4lq9q7l6n
-rw------- 1 apache apache  0 Apr 18 09:23 sess_32ta8talaki4a7umbuq6ivfqdi


If you also have have session parameters ($_SESSION['parameter']), you shall see those in file:
cat sess_vssets4hr5b1h89ad7k93q3rhl
loggedin|b:1;name|s:1:"D";id|i:6;

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.