What is the Difference between Call Filter and Data Filter?

Hello, I have confused between Call Filter and Data Filter in Vigor Draytek configuration. I search officially document and googled relatively link. Finally I see what I need in i-helpdesk.com.au Now I show you that hope it can help reduce your time. Hope you see this post in the top result of google...

Wireshark Filters frequently use

Hello, I show you somes Wireshark Filters frequently use :) Hope this help, 1.       ip.addr == 10.0.0.1 [Sets a filter for any packet with 10.0.0.1, as either the source or dest]2.       ip.addr==10.0.0.1  && ip.addr==10.0.0.2 [sets a conversation filter between the two defined IP addresses]3.      ...

[HOW TO] remove the special character in linux?

Do you need to remove the special character in linux? A quick tip will be help you. Firstly, you use "ls -il" to show the inode information of file/ folder [~]# ls -iltotal 179001048619 -rw-r--r--  1 root root     297 Jul 23 15:15 \ To be continued, you use find command to delete them by inode [~]#find . -inum  1048619 -exec rm -rf {} \; It will find and remove...

[HOW TO] Easiest way to fix MySQL UTF8 to Latin1 character set encoding issues.

MySQL originally used the latin1 character set by default which stored characters in a 2-byte sequence. In recent versions it defaults to UTF-8 to be friendlier to international users. When migrating MySQL databases, occasionally you’ll see odd characters appear on the new system. For example, a simple quote mark may be replaced by 4-5 characters of junk symbols. This happens when MySQL is trying...

[HOW TO] Export mysql result to csv file

Hello, Export mysql result to csv file is necessary. It is useful in case of you need to send the result to developer or others. You can follow: SELECT * FROM report INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; What it means? FIELDS TERMINATED BY ',' :the fields will be separated by commas, ENCLOSED BY '"' :each field will be enclosed in “double...

Export/Import/Create database with exact character set (eg. utf8)

Hello, A short article, 1. Export database with exact character set (eg. utf8) $mysqldump -uUSERNAME -pPASSWORD --default-character-set=utf8 USER_DATABASE > backup.sql 2. Import database with exact character set (eg. utf8) #mysql -uUSERNAME -pPASSWORD --default-character-set=utf8 USER_DATABASE < backup.sql 3. Create database with exact character set (eg. utf8) $mysql -uroot -p ... mysql>...

[HOW TO] copy multiple files from remote host to local host

Hello, A short article, copy multiple files from remote host to local host $scp your_user_remotehost@remote_host:/direct1/\{file1,file2,file3\} /home/local_host Thank you for reading this article, please a comment if you are interested. Tiến Phan - R0039 Knowledge is Endless Sharing for Succes...

Install Sun/Oracle Java JDK/JRE 7u79/80 on Fedora 22/21/20/19, CentOS/Red Hat (RHEL) 7.1/6.6/5.11

1. Download Sun/Oracle Java JDK/JRE 7u79/80 32-bit/64-bit RPM packages Download Sun/Oracle Java 7u79 or 7u80 from here http://www.oracle.com/technetwork/java/javase/downloads/index.html. Select rpm package (jdk-7u79-linux-i586.rpm, jdk-7u79-linux-x64.rpm, jre-7u79-linux-i586.rpm or jre-7u79-linux-x64.rpm) or (jdk-7u80-linux-i586.rpm, jdk-7u80-linux-x64.rpm, jre-7u80-linux-i586.rpm or jre-7u80-linux-x64.rpm). 2....

[HOW TO] fix :com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed

The last week, when check the logs of Tomcat, I see: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed Humn, it looks like the MySQL connection has a problem about connection pooling. Mysql implicitly closed the db connection because the db connection has been inactive too long time ( 34,247,052 milliseconds ).so you prgram fetch...

Linux Disable Core Dumps

Only software developers legitimately need to access core files and none of my production web server requires a core dump. How do I disable core dumps on Debian / CentOS / RHEL / Fedora Linux to save large amounts of disk space?A core dump file is the memory image of an executable program when it was terminated by the operating system due to various error behavior. Reference link: http://www.cyberciti.biz/faq/linux-disable-core-dumps/ ...

Intrusion detection tools on Linux - AIDE

AIDE is an opensource file integrity check tool. It can help you verifying files integrity in an easy way. 1. Install AIDE package on CentOS/RHEL: # yum install -y aide 2. Check and adjust aide configuration file to fulfill your needs: # vim /etc/aide.conf 3. Initialize AIDE database - it will scan all the files in folders that were included in the config file and save their hash as well as attributes...

[HOW TO] use yum history to roll back an update in CentOS

You just updated OS. Unlucky, some applications has a errors, it can not start properly. Rollback is the right action that you need. How to roll back an update? In this article I show you Environment: CentOS 6.6 yum Resolution Note: Downgrading a system to minor version (ex: RHEL6.1 to RHEL6.0) is not recommended as this might leave the system in broken state where libgcc and other libraries...

Allow others access to home own directory chroot

On the last week, developer told me that he need to write the data to sftp folder of customer. Humnnn, break out the chroot? It comes fast to me. I am using the chroot to jail sftp user, they can not come around others and do anything (limited access to files normally in their own home directory). And now developer want to allow access to this. Providing convenience to users, while still ensure...

[HOW TO] configure Step Ticker (NTP) Linux

Lynis report give me the recommendation about "Step Ticker". What is a "Step Ticker"? I do not know "Step Ticker" until now. I googled to know a bit about it. A Step Ticker is basically a way to tell the NTP daemon to check a server or two, and correct time on startup, rather than relying on the time that was restored from the hardware. Ok, How to configure? /etc/ntp.conf:server 192.168.0.5server...

[HOW TO] Improvement DNS lookups (Linux)

Around two weeks ago, I checked handling the Linux system with Lynis. It recommended me improvement the DNS lookups A long time ago, co-worker has improved the DNS local system, he said it will be improved the DNS operation. Linked them, I think this is a useful. Nameservers are listed in /etc/resolv.conf, one per line Example: nameserver 10.10.5.130 To improve DNS lookups, add multiple DNS servers Example: nameserver...

[HOW TO] backup and restore the mysql database

Hello, Do you want to backup/ restore the MySQL database? Please follows this article: 1. Backup mysqldump -u username -p -–all-databases > file.sql 2. Backup and compress mysqldump -u username -p -–all-databases | gzip > file.sql.gz 3. Restore mysql -u username -p < file.sql Thank you for reading this article, please a comment if you are interested. Tiến Phan - R0039 Knowledge is...

[HOW TO] Cannot establish FTP connection to an SFTP server. Please select proper protocol.

Hello, 2 hours ago, I got the notification when I try to connect to my sftp server on FileZilla (software ftp client) Status:    Connecting to x.x.x.x:4444... Status:    Connection established, waiting for welcome message... Response:    SSH-2.0-OpenSSH_5.3 Error:    Cannot establish FTP connection to an SFTP server. Please select proper...