liangxu.wang
postgresql – LiangXu Wang
http://liangxu.wang/category/computer/postgresql
Create table sum point as. Select ts,lat,lon,sum(num) from point group by ts,lat,lon. Leave a comment on 数据巧处理 重复数据的合并处理. 8230; site no. 1. 8230; site no. 10. 8230; site no. 2. 这里和我们常规理解有所区别的就在于其排序是按照1、10、11、…、2、3进行排序的,而我们通常想要的结果是希望按照站点编号的自然数大小进行排序,即1、2、…、9、10…。 8230; order by title. 8230; order by substring(title, ‘[ 0-9]*’), (substring(title, ‘No.([0-9] )’) : int. 8230;10 July, 2012. 8230;9 August, 2012. 8230;10 July, 2012. 8230;9 July, 2013. Leave a comment on postgresql中字符串与数字的混合排序. Wang Y., Zhan...
liangxu.wang
管理ubuntu服务器上的阵列 – LiangXu Wang
http://liangxu.wang/1583
Lspci -v grep LSI. Apt-get install rpm2cpio rpm2cpio MegaCli-*.rpm cpio -idmv. Sudo cp MegaCli64 /usr/local/sbin/. The identifying number of the enclosure. Default for our systems is "8". Use # "MegaCli64 -PDlist -a0 grep "Enclosure Device" to see what your number # is and set this variable. ENCLOSURE="8". Sudo lsi.sh drives. Sudo lsi.sh status. MegaCli64 -PdReplaceMissing -PhysDrv[32:5] -array0 -row5 -a0 MegaCli64 -PDRbld -Start -PhysDrv[32:5] -a0. 1 MegaCLI Scripts and Commands.
liangxu.wang
ipv6 – LiangXu Wang
http://liangxu.wang/tag/ipv6
Content=@file get contents("http:/ dx.doi.org/".$row['doi']);. Leave a comment on ipv6域名强制解析为ipv4地址. 国内的dns解析经常有问题,会截断某些网站的解析,即使自己架构的DNS也不行,而且现在IP V6网络也可以直接使用,因此就考虑直接使用IP V6的DNS进行解析 而且可以突破G-F-W。 Http:/ blog.csdn.net/wangjingfei/archive/2010/03/19/5396845.aspx. Leave a comment on 使用IP V6的DNS进行地址解析. Wlx@wlxpc: /Projects/geonetwork-2.2.0/src/org/fao/geonet/kernel$ svn diff. AccessManager.java 版本 3883. 322,11 322,13 @. String network = settMan.getValue("system/intranet/network");. To avoid ipv6 problem.
liangxu.wang
lsi.sh – LiangXu Wang
http://liangxu.wang/tag/lsi-sh
Lspci -v grep LSI. Apt-get install rpm2cpio rpm2cpio MegaCli-*.rpm cpio -idmv. Sudo cp MegaCli64 /usr/local/sbin/. The identifying number of the enclosure. Default for our systems is "8". Use # "MegaCli64 -PDlist -a0 grep "Enclosure Device" to see what your number # is and set this variable. ENCLOSURE="8". Sudo lsi.sh drives. Sudo lsi.sh status. MegaCli64 -PdReplaceMissing -PhysDrv[32:5] -array0 -row5 -a0 MegaCli64 -PDRbld -Start -PhysDrv[32:5] -a0. 1 MegaCLI Scripts and Commands.
liangxu.wang
ubuntu – LiangXu Wang
http://liangxu.wang/tag/ubuntu
服务器上安装了ubuntu 14.04系统,存储是dell的直连存储md3060e 我第一次用这个设备 ,硬件上安装好后发现不知道怎么做RAID。 于是在dell官网上找到了对应的程序,发现有个linux版本的程序 StorageEnclosureManagement, 号称 可以支持debian和ubuntu。 Debian74 Storage Enclosure Management Software 1.3. Storage Enclosure Management Software for MD3060e JBOD Arrays, version 1.3, Debian74 installer. Fixes & Enhancements. New OS support for Ubuntu 14.04, SLES 12, and ESXi 5.5 (CLI only). Implement build version number. Ability to update HBA adapter firmware. 将其中的版本信息修改为debian wheezy 7.4。 Adapter 0 - ...
liangxu.wang
http_build_query – LiangXu Wang
http://liangxu.wang/tag/http_build_query
Tag: http build query. Db config=array('host'= 'localhost','user'= 'u','password'= 'p','dbname'= 'test');. Pg link="host=localhost user=u password=p dbname=test";. Pg link=http build query($db config,' ,' ');. Leave a comment on php中数组到字符串的键值变换. Proudly powered by WordPress.
liangxu.wang
wlx – LiangXu Wang
http://liangxu.wang/author/wlx
参考 http:/ stackoverflow.com/questions/2471884/histogram-using-gnuplot. Plot 'datafile' using (bin($1,binwidth) :(1.0) smooth freq with boxes. Leave a comment on 使用gnuplot画直方图. 4269,-84.6,1. 4174,-86.21,1. 4226,-83.73,2. 4301,-83.68,6. 4274,-84.48,3. 4229,-83.7,4. 4229,-83.25,2. 4136,-82.07,1. 4299,-83.73,3. 4224,-84.41,1. Google后发现了解决方案 Using AWK to Filter Rows. Awk -F',' '{ if($1. 870) {print } ' 20161026-2300-point.csv. Leave a comment on 使用AWK过滤数据. Create table sum point as. 即sudo service mysql stop.
liangxu.wang
LSI – LiangXu Wang
http://liangxu.wang/tag/lsi
Lspci -v grep LSI. Apt-get install rpm2cpio rpm2cpio MegaCli-*.rpm cpio -idmv. Sudo cp MegaCli64 /usr/local/sbin/. The identifying number of the enclosure. Default for our systems is "8". Use # "MegaCli64 -PDlist -a0 grep "Enclosure Device" to see what your number # is and set this variable. ENCLOSURE="8". Sudo lsi.sh drives. Sudo lsi.sh status. MegaCli64 -PdReplaceMissing -PhysDrv[32:5] -array0 -row5 -a0 MegaCli64 -PDRbld -Start -PhysDrv[32:5] -a0. 1 MegaCLI Scripts and Commands.
liangxu.wang
hosts – LiangXu Wang
http://liangxu.wang/tag/hosts
Content=@file get contents("http:/ dx.doi.org/".$row['doi']);. Leave a comment on ipv6域名强制解析为ipv4地址. Emca -config dbcontrol db -repos recreate. Leave a comment on emctl无法启动. Proudly powered by WordPress.
liangxu.wang
GIS – LiangXu Wang
http://liangxu.wang/category/gis
使用 nginx Tilestache 构建瓦片地图. Leave a comment on 使用 nginx Tilestache 构建瓦片地图. Sudo apt-get install tilestache python-pil python-gdal. Tilestache-seed -b 31.8 89.3 36.3 102.3 -c tilestache.cfg -l landuse2005 10 11 12 13 14 15. Tilestache-server -c tilestache.cfg -i 192.168.13.13. Http:/ 192.168.13.13:8080/landuse2005/preview.html. 2 Comments on 使用tilestache构建瓦片地图服务器. Ogrinfo -so id04632323 PAL. Had to open data source read-only. INFO: Open of `id04632323'. Using driver `AVCBin' successful. PARAMETER["false e...