Categories
Unix

Couldn’t execute ‘SHOW TRIGGERS LIKE XXX”: Got error 28 from storage engine (1030)

That means space/memory issue on your server

Free space !

du -skh .
df
Categories
Unix

How to find executable command in unix ?

Type the following :

whereis 
Categories
Unix

How to find out Unix release version ?

cat /etc/*elease
Categories
Unix

How to fix CURL error setting certificate verify locations ?

error setting certificate verify locations:
CAfile: /usr/local/etc/openssl/cert.pem
CApath: /usr/local/etc/[email protected]/certs

To fix this issue find my solution below

ln -s  /usr/local/etc/openssl\@1.1 /usr/local/etc/openssl

Create a symbolic link toward the folder researched

Categories
Hacker Unix Web Server

How to harden files permission wordpress ?

Files

find . -type f -print0 | xargs -0 chmod 0400

Directory

find . -type d -print0 | xargs -0 chmod 0500
Categories
Hacker Security Unix Web Server

Files Permission – Unix Server

  • Folders – 755
  • Files – 644
  • wp-config.php – 600
  • .htaccess – 644, or 600

Unix command for directories 755

find . -type d -print0 | xargs -0 chmod 0755
sudo find . -type d -print0 | sudo xargs -0 chmod 0755

Unix command for files 644

find . -type f -print0 | xargs -0 chmod 0644
sudo find . -type f -print0 | sudo xargs -0 chmod 0644

Find hacked files

grep -r --include=*.php -e '[[:alnum:]\/\+]\{137,\}'

Categories
MySql SQL Unix

Import CSV data to mysql

Fastest way to import data over time found to be csv format data

mysql> load data local infile 'Desktop/data.csv'
-> INTO TABLE cars
-> FIELDS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '\n'
-> IGNORE 1 ROWS;
Query OK, 232880 rows affected, 65535 warnings (27.87 sec)
Records: 232880 Deleted: 0 Skipped: 0 Warnings: 232880

Categories
Technical

git pull origin master returns fatal: invalid refspec


remove lines below from .git/config[remote “origin”]


        url = [email protected]:dxxxx/xxxxxxxx.git
        fetch = +refs/heads/*:refs/remotes/origin/*

Type following commands

 git remote add origin [email protected]:xxxxxx/xxx.git
 git remote -v
Categories
Unix

“continue” targeting switch is equivalent to “break”.

  PROBLEM

[ErrorException]                                                                         
  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

SOLUTION

composer self-update
composer update

Categories
Books Interview

Book Review – Complete Software Developers Career Guide

Overall Grade : 3/5
Easy to read : 5/5

Take away : Very Good for starter in software development or novice in this area. This overview matches some of my professional experience.

The book contains about 800 pages and it quite covering a lot of elements

Missing Part [Politics]: Political IT environment – struggle – In an IT department, it is likely that the most efficient and logical decision will not be taken into account. Nowadays ITs/developers are run by marketers and political ambitious individuals. A full chapter should be dedicated on surviving such environment. Hard work is not rewarded anymore but eloquent techie speech makes the difference.

IT people are at fault somehow as they are easily dominated and replaced by consultants fabulous promises and speeches

Other missing Part Align business and IT: As professor Jerry Luftman mentionned many times IT and Business should be aligned