Month: October 2017

Notes : Cannot delete virtual server

That seems to be a bug that shows up occasionally, though it’s not reliably reproducible, so it hasn’t been corrected.

The fix is simple though, you can delete the domain ID in “/etc/webmin/virtual-server/domains/”, restart Virtualmin, and then it should be gone from your drop-down list.

https://www.virtualmin.com/node/15222

 

15078987692871

 

Setting up log file rotation ..
.. Log file rotation failed! : .. the log file /var/log/virtualmin/xxxxxxxxxxxx_access_log is already being rotated at /usr/libexec/webmin/web-lib-funcs.pl line 1433.

Delete the log files in /var/log/virtualmin

Delete the user in “User and Group” in webmin

Next step : re-create the virtual server!

VirtualMIN Backup Failed – MySQL “MariaDB” crash

Good day! I ran into a problem when backing up all my virtualMIN websites. When the backup failed something stange happened to MySQL “MariaDB” database server. When backup fail, MariaDB crash!

To fix this issue I added a command to run after backup:

systemctl stop mariadb ; systemctl start mariaDB

Located in > VirtualMIN > Scheduled Backups >

This will prevent mariaDB to crash after a failed virtualMIN backup!

Notes: Check the size of your /tmp and increase it!

If you are having “Out of resources Errcode : 24 message”

The mysql error:  Out of resources when opening file… (Errcode: 24)   indicates that the number of files that msyql is permitted to open has been exceeded.

This limit is controlled by the variable open_files_limit.   You can read this in phpMyAdmin (or the MySQL command line utility) with the statement:

SHOW VARIABLES LIKE 'open%'

To set this variable to a higher number, edit the /etc/my.cnf file and add the lines:

[mysqld]
open_files_limit = 5000

Then be sure to restart mysql with:   sudo /etc/init.d/mysql restart

Remember to use the server administrative account and sudo when you edit the file.  The choice of editor is up to you.

Now, showing the variable should show the number you choose.

Note that 5000 shown above is an example. A good rule of thumb is to take the current number of files and add 1000 to it. If this doesn’t help, add some more.  This number affects the amount of memory that MySQL uses, so setting it to a very high number is not a good idea.

You may also verified your /etc/my.cfg configurations:

[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock

local-infile=0
symbolic-links=0
innodb_file_per_table = 1
thread_concurrency = 8
query_cache_size = 64M
thread_cache_size = 8
myisam_sort_buffer_size = 256M
read_rnd_buffer_size = 32M
read_buffer_size = 4M
sort_buffer_size = 4M
table_open_cache = 512
max_allowed_packet = 7M
key_buffer_size = 512M
open_files_limit = 10000
max_connections = 32768
innodb_buffer_pool_size = 40M

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

!includedir /etc/my.cnf.d

After modifications you must restart MySQL server

# systemctl restart mariadb

Free Anti-Ransomware Tool

Bitdefender Anti-Ransomware is a free security tool that can protect against existing and emerging ransomware attacks.

Ransomware is a category of malicious software designed to block access to your computer and files until you pay a large sum of money. Download our advanced ransomware vaccine right now to stay safe from losing your money or files.**

Download your free copy here now!

Opencart 2.3.0.x Additional Alert Email not saved

Here is a simple fix:

In file ‘admin/view/template/setting/setting.tpl’ replace the line:

<textarea name="config_mail_alert_email" rows="5" placeholder="<?php echo $entry_mail_alert_email; ?>" id="input-alert-email" class="form-control"><?php echo $config_alert_email; ?></textarea>

with this one:

<textarea name="config_alert_email" rows="5" placeholder="<?php echo $entry_mail_alert_email; ?>" id="input-alert-email" class="form-control"><?php echo $config_alert_email; ?></textarea>

Download the OCMOD here!