web development and system administration of Linux
MySQL has an amazing option called –defaults-file. It can be used to store credentials in configuration file as it shown in example below: [client] user=dbUser password=dbPassword Make sure you did not store such configration files anywhere inside public_html accessible via HTTP or HTTPS on your website. It is real security breach. Do not do it. … Continue reading mysql and mysqldump –defaults-file without a password
The command below will tell git you want to start ignoring the changes to the file: When you want to start keeping track again:
If you can`t start built-in web server in Yii2 Framework on Windows with error message like Document root “…\console/web” does not exist. in advanced application template you should use the following commands: 1. For backend admin application: yii.bat serve/index –docroot=”backend/web/” 2. For frontend application: yii.bat serve/index –docroot=”frontend/web/” For basic application template use command: yii.bat serve/index … Continue reading Yii2 Framework console built-in web server can’t start
To check all PHP files syntax in current folders including subfolders you can use command like: If you want to check few files syntax you can add them to some file e.g. /tmp/check-php-files-syntax.list and then run command below:
As you may know Git has wonderful feature create archive of files in repository. For example, you can create Bash script to automate making of Git archives: Also, you can use tar format instead of zip and then to gzip it. v1.0 – is tag name of release to archive –prefix=git-1.0/ – adds folder git-1.0/ … Continue reading Git: create archive
To display changes between two commits you need to know SHA sum of commit. You can take it from command output. Example command output: Then you can run command: it will show you list of changed files. Alternatively, you can also use command: to see the difference between seventh and fourteenth latest commits.
To set up virtual host password protection in Nginx you can follow such steps: 1. Created .htpassword file outside web server foot folder using commands below: Second command will ask you for a password. 2. Add the following lines to Nginx configuration file /etc/nginx/nginx.conf into virtual host definition section.
To fix error below: You should increase APC opcode cache parameter apc.shm_size, which is set to 32M by default and restart web server Apache module if PHP is set to wokr like web server module. One more thing, you can switch off APC module for some domain or virtual host you can add the following … Continue reading PHP Warning: Unknown: Unable to allocate memory for pool. in Unknown on line 0
WordPress CMS has a lot of useful features e.g. shortcodes, custom fields. Look at the code example below: In example above it allows to output slides of exact category on page. Possible slider shortcode usage can be: [mySlider slide_category=”1″] Where mySlider is shortcode, slide_category is shortocode attribute which allows us to display flides of particular … Continue reading Example usage of custom fields and shortcode parameters in WordPress CMS
If you have shell access to your hosting account and your web server is running WordPress websites under Linux you should check amazing command line utility wp-cli. Some usage examples: 1. Upgrade WordPress CMS core: 2. List installed themes: Example output $ wp theme list +—————-+———-+——–+———+ | name | status | update | version | … Continue reading WP-CLI: command line interface for WordPress CMS
