Dump multiple databases: mysqldump -u root -p –databases db1 db2 db3 >dump.sql Dump some selected tables: mysqldump -u mysqlusername -p databasename table1 table2 table3 > databasebackup.sql Dome all tables except some tables: mysqldump -u username -p database –ignore-table=database.table1 –ignore-table=database.table2 > database.sql Read More →
1. Set all ssh account to use bash shell by default , /etc/passwd 2. Make sure that you have install exim or postfix or any other email tool to send mail 3. Edit /etc/bash.bashrc , and the below lines echo ‘Date:’ `date` $’\n’WhoAmI: `whoami` \ $’\n’Who: $’\n'”`who`” \ $’\n’Netstat: $’\n'”`netstat -nt | grep EST`” \ $’\n’Process: $’\n'”`ps -aux`” \ | mail -aFrom:[email protected] -s “Security Alert: SSH Access(`hostname -s`)” [email protected] This script will send the following info : Date , WhoAMI, who , netstat, processlist 4. Test (1) Copying the above code in your shell and run , make sure that you receive the email (2)Read More →
When you run apt-get install , you got some error this dpkg: dependency problems prevent configuration of linux-server: linux-server depends on linux-image-server (= 3.2.0.88.102); however: Version of linux-image-server on system is 3.2.0.113.129. linux-server depends on linux-headers-server (= 3.2.0.88.102); however: Version of linux-headers-server on system is 3.2.0.113.129. dpkg: error processing linux-server (–configure): Run the following command will fix the issue: apt-get remove linux-server apt-get install linux-serverRead More →
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 →
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 →
A complete guide https://svn.apache.org/repos/asf/subversion/trunk/subversion/mod_authz_svn/INSTALL If you want to setup a tool to manage the subversion over web , try if.SVNAdminRead More →
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 →
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 →
I have a url like this http://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 →
The below command will go through all tables in all database databases to do a repair check. mysqlcheck -uroot -p -A –auto-repairRead More →