https://wiki.freecode.com.cn/ 2026-10-22T03:41:12+00:00 https://wiki.freecode.com.cn/ https://wiki.freecode.com.cn/lib/tpl/dokuwiki/images/favicon.ico text/html 2009-12-19T05:22:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:a_java_class_to_get_a_compressed_file_from_the_server&rev=1261200150&do=diff A java class to get a compressed file from the server Some guys often ask me to help them to get some files from the server, such as tomcat log. Everytime I must open ftp client to connect the server, download these file. The lazy man need a smart way to do this job. Now they can help themselves. text/html 2009-12-10T15:08:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:adjust_tomcat_time&rev=1260457689&do=diff Adjust Tomcat timezone under CentOS Tomcat alway complains that it got wrong timezone, but the Linux time is right. The problem is the timezone in the file /etc/sysconfig/clock is wrong. This timezone is not same as the timezone of the command 'date', so modified /etc/sysconfig/clock, make Java happy. text/html 2009-04-15T02:53:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:apparmor_and_mysql_on_ubuntu&rev=1239764012&do=diff apparmor and mysql on ubuntu The default data directory is /var/lib/mysql. How to change to a new directory, such as /data? * stop mysql * move /var/lib/mysql /data * modify /etc/apparmor.d/usr.sbin.mysqld, /var/lib/mysql to /data/mysql * restart apparmor text/html 2009-01-31T15:01:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:hide_delphi_application_from_taskbar&rev=1233414116&do=diff hide delphi application from taskbar I am newbie of dephi. I spent a few days to hide the main form from the taskbar. I wrote a application which creates security tunnel and then runs a special program, such as mstsc(MS remote desktop) to connect the remote server via this tunnel. text/html 2008-12-30T08:40:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:installed_blog_plugin&rev=1230626420&do=diff Installed blog plugin Spent a few minutes to install the plugin:blog text/html 2009-11-21T07:25:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:monitor_the_statistics_of_nginx_with_cacti&rev=1258788358&do=diff Monitor the statistics of Nginx with Cacti First, add the next lines to configuration file of nginx location /server_status { stub_status on; access_log off; # Only me can access this #allow 10.0.0.12; #deny all; } Run nginx -t text/html 2022-11-30T12:18:23+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:reduce_time_wait_on_linux&rev=1669810703&do=diff Reduce TIME_WAIT on linux sysctl net.ipv4.tcp_tw_reuse=1 sysctl net.ipv4.tcp_tw_recycle=1 text/html 2009-02-12T03:58:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:shrink_the_larger_log_of_mssql_server&rev=1234411132&do=diff Shrink the larger log of MSSQL Server 1. BACKUP DATABASE database_name TO backup_device 2. BACKUP LOG database_name TO backup_device 3. DBCC SHRINKFILE (log_file_name) list the size of tables EXEC sp_msforeachtable 'sp_spaceused ''?''' text/html 2009-12-17T16:12:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:speed_up_mysql_import&rev=1261066347&do=diff speed up mysql import Generally, it is very slow to restore the data from mysqldump file. Here is a tip to speed up this work: % mysql -u someuser -p > SET AUTOCOMMIT=0; > SET UNIQUE_CHECKS=0; > SET FOREIGN_KEY_CHECKS=0; > source dump.sql; > SET FOREIGN_KEY_CHECKS=1; > UNIQUE_CHECKS=1; > COMMIT; text/html 2009-04-14T03:16:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:sysctl_string&rev=1239678961&do=diff sysctl string on FreeBSD The way to 'sysctl' string in the kernel module program The sysctl_proc function: char sysctl_str[1024]; static int sysctl_str_ctrl(SYSCTL_HANDLER_ARGS) { int error; char *p; p = sysctl_str; error = sysctl_handle_string(oidp, p, sizeof(sysctl_str), req); if (!error && req->newptr) { // } error = SYSCTL_OUT(req, sysctl_str, sizeof(sysctl_str)); return error; } text/html 2009-04-14T03:15:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:the_easy_way_to_add_locale_environment_on_ubuntu&rev=1239678900&do=diff The easy way to add locale environment on Ubuntu sudo /usr/share/locales/install-language-pack zh_CN.GBK install-language-pack will have nothing to do if the locale is invalid. text/html 2009-01-08T04:20:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.freecode.com.cn/doku.php?id=mirnshi:unlock_svnsync&rev=1231388451&do=diff Unlock svnsync When svnsync reports: Failed to get lock on destination repos, currently held by 'xxxxx', use the next command to unlock svnsync: svn propdel svn:sync-lock --revprop -r 0 file:///mirror