Sunday, September 17, 2023

Find WHM/cPanel or linux failed email login log



Webmail Login attempt:


/usr/local/cpanel/logs/login_log

cp /usr/local/cpanel/logs/login_log /home/cpanel_unsername

chmod 644  /home/cpanel_unsername/ogin_log


POP3 login attempts:


/var/log/maillog

cp /usr/local/cpanel/logs/maillog /home/cpanel_unsername

chmod 644  /home/cpanel_unsername/maillog

Wednesday, September 6, 2023

MariaDB Socket from Path XAMPP for VSCODE on MAC OS


Run the following command in terminal:

ps -ax|grep mysql

FInd the output like this:

--socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock --port=3306

Then use this path without quote in Socket path

"Applications/XAMPP/xamppfiles/var/mysql/mysql.sock"


Then click Save and connect. It will show the success message.



How to Configure Xdebug in Mac with XAMPP

 To install with single command:

pecl install xdebug

Or Follow the instructions below:

https://xdebug.org/wizard

Installation Wizard

Summary

  • Xdebug installed: no
  • Server API: Apache 2.0 Handler
  • Windows: no
  • Zend Server: no
  • PHP Version: 8.2.4
  • Zend API nr: 420220829
  • PHP API nr: 20220829
  • Debug Build: no
  • Thread Safe Build: no
  • OPcache Loaded: no
  • Configuration File Path: /Applications/XAMPP/xamppfiles/etc
  • Configuration File: /Applications/XAMPP/xamppfiles/etc/php.ini
  • Extensions directory: /Applications/XAMPP/xamppfiles/lib/php/extensions/no-debug-non-zts-20220829

Instructions

 





  1. Download xdebug-3.2.2.tgz
  2. Install the pre-requisites for compiling PHP extensions.
    On your Mac, we only support installations with 'homebrew', and brew install php && brew install autoconf should pull in the right packages.
  3. Unpack the downloaded file with tar -xvzf xdebug-3.2.2.tgz
  4. Run: cd xdebug-3.2.2
  5. Run: phpize (See the FAQ if you don't have phpize).

    As part of its output it should show:

    Configuring for:
    ...
    Zend Module Api No:      20220829
    Zend Extension Api No:   420220829

    If it does not, you are using the wrong phpize. Please follow this FAQ entry and skip the next step.

  6. Run: ./configure
  7. Run: make
  8. Run: cp modules/xdebug.so /Applications/XAMPP/xamppfiles/lib/php/extensions/no-debug-non-zts-20220829
  9. Update /Applications/XAMPP/xamppfiles/etc/php.ini and add the line:
    zend_extension = xdebug
  10. Restart the Apache Webserver

Enabling Features

Now Xdebug is installed, you can enable its features. Please refer to the dedicated sections in the documentation about information on how to enable and configure these Xdebug features. Where these sections refer to php.ini or similar, please remember to use /Applications/XAMPP/xamppfiles/etc/php.ini:

  • Development Helpers — help you get better error messages and obtain better information from PHP's built-in functions.
  • Step Debugging — allows you to interactively walk through your code to debug control flow and examine data structures.
  • Profiling — allows you to find bottlenecks in your script and visualize those with an external tool.

Tuesday, September 5, 2023

Mac OS PHP and XAMPP path setup

Open file dependency profile of Mac:

sudo vi ~/.zshrc or ~/.bash_profile

Now enter the following linese and save the file from your editor vi or nano:

export XAMPP_HOME=/Applications/XAMPP
export PATH=${XAMPP_HOME}/bin:${PATH}
export PATH

Now refresh the terminal and check path using the following command staying in the same terminal without closing:

exec $SHELL -l;
which php

Saturday, September 2, 2023

Set HTTP to HTTPS redirect in CWP


RewriteCond %{HTTPS} off
RewriteRule .* https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

Friday, August 25, 2023

How to clear cache from Mailwizz

 /usr/bin/php -q /home/cm/public_html/apps/console/console.php clear-cache --verbose=1

Sunday, August 13, 2023

How to add Service to Autostart (CentOS 6/7)

systemctl enable httpd.service

systemctl disable httpd.service

systemctl status httpd.service

How to get Ranking of the Students in Excel using RANK Function

=RANK(number,ref,[order]) To rank in descending order, we will use the formula =RANK(B2,($C$5:$C$10),0) If we want unique ranks, we can use...