OS – zilli²

How to install the `ll` command on macOS

April 3, 2020April 3, 2020 by Zilli

#Edit:
vi ~/.bash_profile

#Then add this alias command to the end of file:
alias ll='ls -lGaf'

CLI – List of all MySQL command

March 13, 2020March 2, 2020 by Zilli

List of all MySQL commands:
Note that all text commands must be first on line and end with ‘;’

?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

Protected: Synology – enable personal photo station

September 24, 2019September 24, 2019 by Zilli

CentOS – ClamAV issues

January 16, 2020September 20, 2019 by Zilli

Clamd and freshclam will use 100% of core cpu process.

How to fix spotlight search on a macOS

January 26, 2020September 7, 2019 by Zilli

Important: We have a current backup of your Mac.

Open Terminal:

Now type in the following commands into Terminal, in the exact order they are shown:

sudo mdutil -i off /
sudo mdutil -i on /
sudo mdutil -E /

The first command turns spotlight off
The second command turns spotlight back on
The final command restarts the spotlight index.
If, after a few minutes, spotlight is still not indexing, try running this command, followed by the three commands above:

sudo rm -rf /.Spotlight-V100

macOS not shutting down since upgrading to new security upgrade

January 17, 2020September 7, 2019 by Zilli

Send this commands via terminal:

rm -rf ~/Library/Caches/*
rm -rf ~/Library/Saved\ Application\ State/*
sudo rm -rf /Library/Caches/*
sudo rm -rf /System/Library/Caches/*
atsutil databases -removeUser
sudo atsutil databases -remove
sudo atsutil server -shutdown
sudo atsutil server -ping
sudo rm -rf /var/folders/*

Reboot system.

How to change PhotoStation Synology logo

November 3, 2019July 31, 2019 by Zilli

ssh -2 [email protected]
sudo -i

Copy Your logo white template:

cp /yourlogo.png /var/packages/PhotoStation/target/photo/photo_new/images/White/logo_ps6.png

Copy Your logo dark template:

cp /yourlogo.png /var/packages/PhotoStation/target/photo/photo_new/images/Black/logo_ps6.png

Verify and Repair Disk Permissions via Terminal – macOS

July 30, 2019July 27, 2019 by Zilli

Verify Permissions
diskutil verifyPermissions /

Repair Permissions
diskutil repairPermissions /

How to use Time Machine to back up your Mac to a Windows shared folder – macOS

July 27, 2019July 27, 2019 by Zilli

The issue that makes Time Machine more difficult in terms of options for backup locations is that it requires use of Apple’s proprietary HFS+ filesystem. Although I’m certain the HFS+ features that Time Machine uses for file versioning and linking could be “mimicked” for use on other more open filesystems, the reality is that Apple chose HFS+ and supports that filesystem exclusively in Time Machine (in fact as of this writing Apple’s new APFS isn’t even supported for Time Machine backups as of yet).

Create a Windows share location
Make the remote share automatically mount
make Time Machine use the remote share and file
Check Time Machine

macOS Software Update via Terminal

July 27, 2019July 27, 2019 by Zilli

To get a list of available software updates, type the following command:

softwareupdate -l

You will see a list of available updates. You can then install all available software updates with the following command:

sudo softwareupdate -iva

The use of sudo is required to get superuser privileges to actually install the updates. You can also install only the recommended updates with:

sudo softwareupdate -irv