Author Archives: Kaven Gagnon

avatar

About Kaven Gagnon

System & Network Architect

Linux : sar command return “Cannot open /var/log/sysstat/sa27: No such file or directory”

Attempting to use the SAR (sadc) command to lookup the historical system resources consumption metrics and got the following message? Cannot open /var/log/sysstat/sa27: No such file or directory Please check if data collecting is enabled Most likely data collecting is disabled (it is the default on several systems). You need to enable data collecting and… Read More »

Linux : phpMyAdmin – Error Incorrect format parameter

Having the following error while importing a MySQL dump? phpMyAdmin – Error Incorrect format parameter Have a look at the “upload_max_filesize” value in your “php.ini” parameters. Most of the time, the dump file you are trying to import exceed that limit. Increase the value as needed.

Windows : Unable to merge cells within a table in Microsoft Excel

If you attempted to merge cells together within a table in Microsoft Excel, you may have faced the grayed out “Merge and Center” button issue. To work around this problem, do the following : 1. Select the cells that you want to merge 2. Right click on the selection 3. In the context menu, click… Read More »

Category: PC

Linux : How to change the OpenVPN lockout time policy

By default, OpenVPN has 15 minutes timeout lockout policy for consecutive unsuccessful authentication attempt (whatever you are using Local, PAM or LDAP authentication). If you want to change it to shorter or longer time period, follow these easy steps below : 1. Push the new timeout value to the configuration using this command (this example… Read More »