By:
On:
In: General

For some reason, when Vigor with Firmware 3.2 , it doesn’t work well with Palo Alto PA500 , especially Yahoo. When Palo Alto make the request with cookies > 1000 characters, Vigor will not return the result. In this interesting issue, if you use WIndows , you don’t see the problems, install a Ubuntu , you can replicate the issue. The solution is to upgrade firmware to 3.3Read More →

By:
On:
In: Linux

my mysql nagios plugin doesn’t work, tested with this command /usr/lib/nagios/plugins/check_mysql Error error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory It’s probably Ubuntu 16.04 is using higher mysql client version, while the nagios use lower version Here is the fix: cd ~root wget http://files.directadmin.com/services/debian_7.0_64/libmysqlclient.so.18 copy libmysqlclient.so.18 /usr/lib/x86_64-linux-gnu/ cd /usr/lib/x86_64-linux-gnu chmod 755 libmysqlclient.so.18 ldconfigRead More →

By:
On:
In: Database

If you just uncomment the slow query log variable in mysqld.conf , you can’t start your mysql server. it’s because the variable name has changed, the following configuration works well for me. nano /etc/mysql/mysql.conf.d/mysqld.conf # Here you can see queries with especially long duration slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow-queries.log long_query_time = 1Read More →

By:
On:
In: Linux

This works well on my Ubuntu 14.04 # Based on http://fearby.com/article/update-openssl-on-a-digital-ocean-vm/ Method1: $ sudo apt-get update $sudo apt-get install –only-upgrade libssl1.0.0 openssl #check if it patches successfully. $ zgrep -ie “(CVE-2016-2108|CVE-2016-2107)” /usr/share/doc/libssl1.0.0/changelog.Debian.gz Output should be like this: – debian/patches/CVE-2016-2107.patch: check that there are enough – CVE-2016-2107 – debian/patches/CVE-2016-2108-1.patch: don’t mishandle zero if it is – debian/patches/CVE-2016-2108-2.patch: fix ASN1_INTEGER handling in – CVE-2016-2108 Method2: $ sudo apt-get dist-upgrade $ wget ftp://ftp.openssl.org/source/openssl-1.0.2h.tar.gz $ tar -xvzf openssl-1.0.2h.tar.gz $ cd openssl-1.0.2h $ ./config –prefix=/usr/ $ make depend $ sudo make install $ openssl version # OpenSSL 1.0.2h 3 May 2016 # now restart your nginx or other server $Read More →

By:
On:
In: Linux

I have a url like this https://www.dailyithelp.com/countries/us/12%26pensylvania so in normal situation, we only have 3 sub folder: countries,us,12/pensylvainia , but in Apache2 , it treats this as 4 : countries,us,12,pensylvania , Apache 2.4 cheats all url encoded slashes as normal slash , if you want to fix this you have to allow slash in the url. <VirtualHost 127.0.0.1:80> ServerName mywebsite.socm AllowEncodedSlashes On </VirtualHost>Read More →

By:
On:
In: Database, Linux

You got error ” too many connections” when connecting to database, when you check the server “show processlist” you see a lot of process having “sleep” status. Here is the fix: change wait_timeout in /etc/mysql/my.cnf: wait_timeout = 600 # if this number is too low , you will get Lost Connection error when doing query then rebootRead More →

By:
On:
In: Linux

You try to increase your connections to 1000 by editing /etc/mysql/my.cnf (change max_connections=1000) , but when you login to your database, you can only see your mysql only accept upto 214 connections? It’s because the open_files_limit in Ubuntu system, here is the fix: Edit nano /lib/systemd/system/mysql.service And add this line to the end: LimitNOFILE=8192 Then run the 2 below commands or reboot the server systemctl daemon-reload systemctl restart mysql.serviceRead More →

By:
On:
In: Windows

If you can’t start Junier SSL VPN and got the error below in system viewer: taskhost (2940) WebCacheLocal: Database recovery/restore failed with unexpected error -1032 Here is the fix: Delete this file: “C:\Users\username\AppData\Local\Microsoft\Windows\WebCache\WebCacheV01.dat” Wecache is a hidden folder, make sure you change the option to see it.Read More →