Time Doctor is an application to track time. To uninstall Time Doctor on Ubuntu, run
|
1 |
sudo /bin/bash -c 'apt purge sfproc; /bin/bash /opt/sfproc/uninstall' |
VirtualBox Ubuntu Shared Folder
Once you shared a folder in VirtualBox with Ubuntu Guest, you need to install VirtualBox Guest additions, this can be done from menu.
|
1 |
Devices > Insert Guest Additions CD image |
Once this is done, in your Guest OS, you will see a CD rom, install the provided software.
Before you can use shared folder, you need to add the user you use to group vboxsf, to do this, run following command in terminal.
|
1 |
sudo usermod -G vboxsf -a $USER |
$USER is user name of the user you will be using. You can replace it with any user you will be using to access the shared folder.
Ubuntu pure-ftpd reply with unroutable address
On AWS Ubuntu server running pure-ftpd, when i try connecting, i get error
|
1 |
Status: Server sent passive reply with unroutable address. Using server address instead. |
To fix this, run
|
1 2 |
echo "30000 50000" > /etc/pure-ftpd/conf/PassivePortRange echo "YOUR_PUBLIC_IP_HERE" > /etc/pure-ftpd/conf/ForcePassiveIP |
YOUR_PUBLIC_IP_HERE = Replace with your Elastic IP or Public IP (if you don’t have an Elastic IP).
Restart pure-ftpd
|
1 2 |
systemctl stop pure-ftpd systemctl start pure-ftpd |
On AWS security groups, you need to open following ports
|
1 2 |
TCP 21 TCP 30000-50000 |
ISPConfig reset admin password
To reset password for ISPConfig, login to MySQL as root.
|
1 |
mysql -u root -p |
if you don’t have MySQL root password, see ISPConfig Find MySQL root password.
Switch to ISPConfig database
|
1 |
use dbispconfig; |
To change password, run
|
1 |
UPDATE sys_user SET passwort = md5('NEW_PASSWORD_HERE') WHERE username = 'admin'; |
Replace NEW_PASSWORD_HERE with your new password.
ISPConfig Find MySQL root password
To find MySQL root password on ISPConfig server, run
|
1 |
/usr/local/ispconfig/server/lib/mysql_clientdb.conf |
Visual Code Studio Tab key not working
When pressing TAB key, no tab get inserted. It switch to UI, selecting “Explorer” in the side menu. Pressing tab again switch the selection to other UI elements.
I have to close the Visual Code Studio to get tab working again.
To fix this, press
|
1 |
CTRL + M |
This is keybinding for editor.action.toggleTabFocusMode, it allow switching TAB focus.
Aria engine is not enabled or did not start
When starting MaraDB, i got error
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
root@localhost:/var/log/mysql# cat error.log 2020-01-19 6:18:46 0 [ERROR] mysqld: Can't lock aria control file '/var/lib/mysql/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 2020-01-19 6:19:17 0 [ERROR] mysqld: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/var/lib/mysql/aria_log_control' 2020-01-19 6:19:17 0 [ERROR] Plugin 'Aria' init function returned error. 2020-01-19 6:19:17 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2020-01-19 6:19:17 0 [Note] InnoDB: Using Linux native AIO 2020-01-19 6:19:17 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-01-19 6:19:17 0 [Note] InnoDB: Uses event mutexes 2020-01-19 6:19:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-01-19 6:19:17 0 [Note] InnoDB: Number of pools: 1 2020-01-19 6:19:17 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-01-19 6:19:17 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2020-01-19 6:19:17 0 [Note] InnoDB: Completed initialization of buffer pool 2020-01-19 6:19:17 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-01-19 6:19:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2137316301 2020-01-19 6:19:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-01-19 6:19:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-01-19 6:19:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-01-19 6:19:17 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-01-19 6:19:17 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-01-19 6:19:17 0 [Note] InnoDB: Waiting for purge to start 2020-01-19 6:19:17 0 [Note] InnoDB: 10.3.18 started; log sequence number 2137316310; transaction id 2275296 2020-01-19 6:19:17 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-01-19 6:19:17 0 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables 2020-01-19 6:19:17 0 [ERROR] Aborting root@localhost:/var/log/mysql# |
To fix error, remove the file
|
1 |
mv /var/lib/mysql/aria_log_control /root/ |
Git Ignore file Permission (chmod)
Some times when you transfer file to web server, you may need a differnt file permission for files to run in web server, if your code is in git, this make the files marked as modified eventhough file contents are the same. To avoid git checking for file permission (chmod), run following command
|
1 |
git config core.filemode false |
Whitelist an IP in Amazon AWS security group from command line
To white list an IP in Amazon AWS security group using aws command line tool, run
|
1 |
aws ec2 authorize-security-group-ingress --group-id SECURITY_GROUP_ID_HERE --protocol tcp --port PORT_HERE --cidr IP_IN_CIDR_HERE |
Example
|
1 |
aws ec2 authorize-security-group-ingress --group-id sg-a777eee6 --protocol tcp --port 443 --cidr 94.31.33.128/27 |
Apache Performance Tuning
To optimize Apache web server, run
|
1 |
curl -sL https://raw.githubusercontent.com/richardforth/apache2buddy/master/apache2buddy.pl | sudo perl |