IPS1 Linux Server

  IPS1 General Info

Description Remarks
Add isupport(user) for SSH vim /etc/ssh/sshd_config

AllowUsers isupport


vim /etc/sudoers

## Same thing without a password
# %wheel ALL=(ALL) NOPASSWD: ALL
isupport ALL=(ALL) NOPASSWD: ALL

adduser isupport
passwd isupport

service sshd restart

mysql open_files_limit check error log
cat /var/lib/mysql/cld01.domain.com.err

check for mysql password in directadmin server


cat /usr/local/directadmin/conf/my.cnf
mysql -u da_admin -p

mysql> SHOW VARIABLES LIKE 'open%';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| open_files_limit | 10000 |
+------------------+-------+
1 row in set (0.00 sec)

to change the value, go to /etc/my.cnf

[mysqld]
local-infile=0
innodb_file_per_table
query_cache_type=1
query_cache_limit = 32M
query_cache_size = 2048M
open_files_limit = 10000

service mysqld restart
Generate CSR openssl req -new -newkey rsa:4096 -nodes -keyout domain.key -out domain.csr