Git change remote url

git remote set-url origin https://username@hostname:port/project.git

Yii2 print ActiveRecord query sql output

<?php
 
echo $query->createCommand()->sql;

Beanstalkd stats and jobs delete

telnet localhost 11300
stats
 
peek-ready
FOUND 7 90
{"job":"Kleidoo\\Queue\\Job\\Shop\\Import\\ProductFeed","data":{"id":"303","revision":19}}
 
peek-delayed
FOUND 7 90
{"job":"Kleidoo\\Queue\\Job\\Shop\\Import\\ProductFeed","data":{"id":"303","revision":19}}
 
delete 7

Beanstalkd “cold” delete all jobs

/etc/init.d/beanstalkd stop
cd /var/lib/beanstalkd
rm -r -f *
/etc/init.d/beanstalkd start

Git hard remove last commit

git reset --hard HEAD~1

Apache2 enable mod_proxy

a2enmod proxy_http

Php curl verbose

<?php
 
curl_setopt($f1, CURLOPT_VERBOSE, true);

Yii 2 Download a File

<?php
 
return Yii::$app->response->sendFile($fileName);

Yii2 custom logger

Step 1:
app/config/console.php

 
        'log' => [
            'traceLevel' => YII_DEBUG ? 3 : 0,
            'targets' => [
                [
                    'class' => 'app\helpers\MyFileTarget',
                    'exportInterval' => 1,
                    'categories' => ['my-category'],
                    'except' => ['application'],
                    'levels' => ['trace'],
                    'logFile' => '@app/runtime/logs/my-category.log',
                ],
            ],
        ],

Step 2:
Create file app/helpers/MyFileTarget.php

 
<?php
 
namespace app\helpers;
 
use Yii;
use yii\log\Logger;
use yii\log\FileTarget;
 
class MyFileTarget extends FileTarget
{
 
    public function formatMessage($message)
    {
        list($text, $level, $category, $timestamp) = $message;
        $level = Logger::getLevelName($level);
 
        if ($level == 'trace') {
        return date('Y-m-d H:i:s', $timestamp) . " [$level][$category] $text";
        }
    }
}

Step 3:

cat /var/www/yii2-installed-dir/app/runtime/logs/my-category.log

Change apache2 running user/group

vi /etc/apache2/envvars

Edit

export APACHE_RUN_USER=imran
export APACHE_RUN_GROUP=www-data

Save and restart apache