ServerOK – Page 2 – Linux Server Management

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.

Devices > Insert Guest Additions CD image

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.

sudo usermod -G vboxsf -a $USER

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

Status:	Server sent passive reply with unroutable address. Using server address instead.

1	Status: Server sent passive reply with unroutable address. Using server address instead.

To fix this, run

echo "30000 50000" > /etc/pure-ftpd/conf/PassivePortRange
echo "YOUR_PUBLIC_IP_HERE" > /etc/pure-ftpd/conf/ForcePassiveIP

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

systemctl stop pure-ftpd
systemctl start pure-ftpd

1 2	systemctl stop pure-ftpd systemctl start pure-ftpd

On AWS security groups, you need to open following ports

TCP 21
TCP 30000-50000

1 2	TCP 21 TCP 30000-50000

ISPConfig reset admin password

To reset password for ISPConfig, login to MySQL as root.

mysql -u root -p

1	mysql -u root -p

if you don’t have MySQL root password, see ISPConfig Find MySQL root password.

Switch to ISPConfig database

use dbispconfig;

1	use dbispconfig;

To change password, run

UPDATE sys_user SET passwort = md5('NEW_PASSWORD_HERE') WHERE username = 'admin';

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

/usr/local/ispconfig/server/lib/mysql_clientdb.conf

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

CTRL + M

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

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#

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

mv /var/lib/mysql/aria_log_control /root/

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

git config core.filemode false

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

aws ec2 authorize-security-group-ingress --group-id SECURITY_GROUP_ID_HERE --protocol tcp --port PORT_HERE --cidr IP_IN_CIDR_HERE

1	aws ec2 authorize-security-group-ingress --group-id SECURITY_GROUP_ID_HERE --protocol tcp --port PORT_HERE --cidr IP_IN_CIDR_HERE

Example

aws ec2 authorize-security-group-ingress --group-id sg-a777eee6  --protocol tcp --port 443 --cidr 94.31.33.128/27

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

curl -sL https://raw.githubusercontent.com/richardforth/apache2buddy/master/apache2buddy.pl | sudo perl

1	curl -sL https://raw.githubusercontent.com/richardforth/apache2buddy/master/apache2buddy.pl \| sudo perl

Gitlab find version

To find version of hosted Gitlab installation, run

gitlab-rake gitlab:env:info

1	gitlab-rake gitlab:env:info

Example

root@simplegitlab:~# gitlab-rake gitlab:env:info

System information
System:		Ubuntu 16.04
Current User:	git
Using RVM:	no
Ruby Version:	2.5.3p105
Gem Version:	2.7.9
Bundler Version:1.17.3
Rake Version:	12.3.2
Redis Version:	3.2.12
Git Version:	2.21.0
Sidekiq Version:5.2.7
Go Version:	unknown

GitLab information
Version:	11.11.0
Revision:	3e8ca2fb781
Directory:	/opt/gitlab/embedded/service/gitlab-rails
DB Adapter:	PostgreSQL
DB Version:	9.6.11
URL:		https://gitlab.simplecloud.co.za
HTTP Clone URL:	https://gitlab.simplecloud.co.za/some-group/some-project.git
SSH Clone URL:	git@gitlab.simplecloud.co.za:some-group/some-project.git
Using LDAP:	no
Using Omniauth:	yes
Omniauth Providers: 

GitLab Shell
Version:	9.1.0
Repository storage paths:
- default: 	/var/opt/gitlab/git-data/repositories
GitLab Shell path:		/opt/gitlab/embedded/service/gitlab-shell
Git:		/opt/gitlab/embedded/bin/git
root@simplegitlab:~#

root@simplegitlab:~# gitlab-rake gitlab:env:info

System information

System: Ubuntu 16.04

Current User: git

Using RVM: no

Ruby Version: 2.5.3p105

Gem Version: 2.7.9

Bundler Version:1.17.3

Rake Version: 12.3.2

Redis Version: 3.2.12

Git Version: 2.21.0

Sidekiq Version:5.2.7

Go Version: unknown

GitLab information

Version: 11.11.0

Revision: 3e8ca2fb781

Directory: /opt/gitlab/embedded/service/gitlab-rails

DB Adapter: PostgreSQL

DB Version: 9.6.11

URL: https://gitlab.simplecloud.co.za

HTTP Clone URL: https://gitlab.simplecloud.co.za/some-group/some-project.git

SSH Clone URL: git@gitlab.simplecloud.co.za:some-group/some-project.git

Using LDAP: no

Using Omniauth: yes

Omniauth Providers:

GitLab Shell

Version: 9.1.0

Repository storage paths:

- default: /var/opt/gitlab/git-data/repositories

GitLab Shell path: /opt/gitlab/embedded/service/gitlab-shell

Git: /opt/gitlab/embedded/bin/git

root@simplegitlab:~#