1239=nmsd NMSD
1243=Sub-7木马
1245=Vodoo
1248=hermes
1269=Mavericks Matrix
1492=FTP99CMP (BackOriffice.FTP)
1509=Streaming Server
1524=ingreslock后门
1313=bmc_patroldb
1314=pdps
1321=pip PIP
1345=vpjp VPJP
1346=alta-ana-lm
1347=bbn-mmc
1348=bbn-mmx
1349=sbook Registration Network Protocol
1350=editbench
1352=lotusnote
1353=relief
1354=rightbrain
1355=intuitive-edge
1356=cuillamartin
1357=pegboard
1358=connlcli
1359=ftsrv
1360=mimer
1361=linx
1362=timeflies
1363=ndm-requester
1364=ndm-server
1365=adapt-sna
1366=netware-csp
1367=dcs
1368=screencast
1369=gv-us
1370=us-gv
1371=fc-cli
1372=fc-ser
1373=chromagrafx
1374=molly EPI Software Systems
1375=bytex
1376=ibm-pps
1377=cichlid
1378=elan
1379=dbreporter Integrity Solutions
1380=telesis-licman
1381=apple-licman
1382=udt_os
1383=gwha
1384=os-licman
1385=atex_elmd
1386=checksum
1387=cadsi-lm
1388=objective-dbc
1389=iclpv-dm
1390=iclpv-sc
1391=iclpv-sas
1392=iclpv-pm
1393=iclpv-nls
1394=iclpv-nlc
1395=iclpv-wsm
1396=dvl-activemail
1399=cadkey-licman
1400=cadkey-tablet
1402=prm-sm-np
1403=prm-nm-np
1404=igi-lm
1405=ibm-res
1406=netlabs-lm
1407=dbsa-lm
1408=sophia-lm
1409=here-lm
1410=hiq
1411=af AudioFile
1412=innosys
1413=innosys-acl
1414=ibm-mqseries
1415=dbstar
1416=novell-lu6.2
1417=timbuktu-srv1
1418=timbuktu-srv2
1419=timbuktu-srv3
1420=timbuktu-srv4
1421=gandalf-lm
1422=autodesk-lm
1423=essbase
1424=hybrid
1425=zion-lm
1426=sais
1427=mloadd
1428=inFORMatik-lm
1429=nms Hypercom NMS
1430=tpdu Hypercom TPDU
1431=rgtp
1432=blueberry-lm
1433=ms-sql-s
1434=ms-sql-m
1435=ibm-cics
1436=saism
1437=tabula
1438=eicon-server
1439=eicon-x25
1440=eicon-slp
1441=cadis-1
1442=cadis-2
1443=ies-lm
1444=marcam-lm
1445=proxima-lm
1446=ora-lm
1447=apri-lm
1448=oc-lm
1449=peport
1450=dwf
1451=infoman
1452=gtegsc-lm
1453=genie-lm
1454=interhdl_elmd
1455=esl-lm
1456=dca
1457=valisys-lm
1458=nrcabq-lm
1459=proshare1
1460=proshare2
1461=ibm_wrless_lan
1462=world-lm
1463=nucleus
1464=msl_lmd
1465=pipes
1466=oceansoft-lm
1467=csdmbase
1468=csdm
1469=aal-lm
1470=uaiact
1471=csdmbase
1472=csdm
1473=openmath
1474=telefinder
1475=taligent-lm
1476=clvm-cfg
1477=ms-sna-server
1478=ms-sna-base
1479=dberegister
1480=pacerforum
1481=airs
1482=miteksys-lm
1483=afs
1484=confluent
1485=lansource
1486=nms_topo_serv
1487=localinfosrvr
1488=docstor
1489=dmdocbroker
1490=insitu-conf
1491=anynetgateway
1492=stone-design-1
1493=netmap_lm
1494=ica
1495=cvc
1496=liberty-lm
1497=rfx-lm
1498=sybase-sqlany
1499=fhc
1500=vlsi-lm
1501=saiscm
1502=shivadiscovery
1503=imtc-mcs
1504=evb-elm
1505=funkproxy
1506=utcd
1507=symplex
1508=diagmond
1509=robcad-lm
1510=mvx-lm
1511=3l-l1
1512=wins
1513=fujitsu-dtc
1514=fujitsu-dtcns
1515=ifor-protocol
1516=vpad
1517=vpac
1518=vpvd
1519=vpvc
1520=atm-zip-office
1521=ncube-lm
1522=ricardo-lm
1523=cichild-lm
1525=orasrv
1525=prospero-np
1526=pdap-np
1527=tlisrv
1528=mciautoreg
1529=coauthor
1530=rap-service
1531=rap-listen
1532=miroconnect
1533=virtual-places
1534=micromuse-lm
1535=ampr-info
1536=ampr-inter
1537=sdsc-lm
1538=3ds-lm
1539=intellistor-lm
1540=rds
1541=rds2
1542=gridgen-elmd
1543=simba-cs
1544=aspeclmd
1545=vistium-share
1546=abbaccuray
1547=laplink
1548=axon-lm
1549=shivahose
1550=3m-image-lm
1551=hecmtl-db
1552=pciarray
1553=sna-cs
1554=caci-lm
1555=livelan
1556=ashwin
1557=arbortext-lm
1558=xingmpeg
1559=web2host
1560=asci-val
1561=facilityview
1562=pconnectmgr
1563=cadabra-lm
1564=pay-per-view
1565=winddlb
1566=corelvideo
1567=jlicelmd
1568=tsspmap
1569=ets
1570=orbixd
1571=rdb-dbs-disp
1572=Chipcom License Manager
1573=itscomm-ns
1574=mvel-lm
1575=oraclenames
1576=moldflow-lm
1577=hypercube-lm
1578=Jacobus License Manager
1579=ioc-sea-lm
1580=tn-tl-r1 tn-tl-r1
1581=mil-2045-47001
1582=msims
1583=simbaexpress
1584=tn-tl-fd2
1585=intv
1586=ibm-abtact
1587=pra_elmd
1588=triquest-lm
1589=vqp
1590=gemini-lm
1591=ncpm-pm
1592=commonspace
1593=mainsoft-lm
1594=sixtrak
1595=radio
1596=radio-sm
1597=orbplus-iiop
1598=picknfs
1599=simbaservices
1600=Shiv
1601=aas
1602=inspect
1603=picodbc
1604=icabrowser icabrowser
1605=slp Salutation Manager
1606=Salutation Manager
1607=stt
1608=Smart Corp. License Manager
1609=isysg-lm
1610=taurus-wh
1611=ill Inter Library Loan
1612=NetBill Transaction Server
1613=NetBill Key Repository
1614=NetBill Credential Server
1615=NetBill Authorization Server
1616=NetBill Product Server
1617=Nimrod Inter-Agent Communication
1618=skytelnet
1619=xs-openstorage
1620=faxportwinport
1621=softdataphone
1622=ontime
1623=jaleosnd
1624=udp-sr-port
1625=svs-omagent
1636=cncp
1637=cnap
1638=cnip
1639=cert
1640=cert-responder
1641=invision
1642=isis-am
1643=isis-ambc
1645=datametrics
1646=sa-msg-port
1647=rsap rsap
1648=concurrent-lm
1649=inspect
1650=nkd
1651=shiva_confsrvr
1652=xnmp
1653=alphatech-lm
1654=stargatealerts
1655=dec-mbadmin
1656=dec-mbadmin-h
1657=fujitsu-mmpdc
1658=sixnetudr
1659=sg-lm
1660=skip-mc-gikreq
1661=netview-aix-1
1662=netview-aix-2
1663=netview-aix-3
1664=netview-aix-4
1665=netview-aix-5
1666=netview-aix-6
1667=netview-aix-7
1668=netview-aix-8
1669=netview-aix-9
1670=netview-aix-10
1671=netview-aix-11
1672=netview-aix-12
1673=Intel Proshare Multicast
1674=Intel Proshare Multicast
1675=pdp Pacific Data Products
1676=netcomm1
1677=groupwise
1678=prolink
1679=darcorp-lm
1681=sd-elmd
1682=lanyon-lantern
1683=ncpm-hip
1684=snaresecure
1685=n2nremote
1686=cvmon cvmon
1687=nsjtp-ctrl
1688=nsjtp-data
1689=firefox
1690=ng-umds
1691=empire-empuma
1692=sstsys-lm
1693=rrirtr
1694=rrimwm
1695=rrilwm
1696=rrifmm
1697=rrisat
1698=rsvp-encap-1
1699=rsvp-encap-2
1700=mps-raft
1701=l2f,l2tp
1702=deskshare
1703=hb-engine
1704=bcs-broker
1705=slingshot
1706=jetFORM
1707=vdmplay
1708=gat-lmd
1709=centra
1710=impera
1711=pptconference
1712=registrar resource monitoring service
1713=conferencetalk
1714=sesi-lm
1715=houdini-lm
1716=xmsg
1717=fj-hdnet
1718=h323gatedisc
1719=h323gatestat
1720=h323hostcall
1721=caicci
1722=HKS License Manager
1723=pptp
1724=csbphonemaster
1725=iden-ralp
1726=iberiagames
1727=winddx
1728=telindus
1729=CityNL License Management
1730=roketz
1731=msiccp
1732=proxim
1733=sSIIPAT Protocol for Alarm Transmission
1734=Camber
1735=privatechat
1736=street-stream
1737=ultimad
1738=gamegen1
1739=webaccess
1740=encore
1741=cisco-net-mgmt
1742=3Com-nsd
1743=Cinema Graphics License Manager
1744=ncpm-ft
1745=remote-winsock
1746=ftrapid-1
1747=ftrapid-2
1748=oracle-em1
1749=aspen-services
1750=Simple Socket Library's PortMaster
1751=swiftnet
1752=Leap of Faith Research License Manager
1753=Translogic License Manager
1754=oracle-em2
1755=ms-streaming
1756=capfast-lmd
1757=cnhrp
1758=tftp-mcast
1759=SPSS License Manager
1760=www-ldap-gw
1761=cft-0
1762=cft-1
1763=cft-2
1764=cft-3
1765=cft-4
1766=cft-5
1767=cft-6
1768=cft-7
1769=bmc-net-adm
1770=bmc-net-svc
1771=vaultbase vaultbase
1772=EssWeb Gateway
1773=kmscontrol
1774=global-dtserv
1776=femis
1777=powerguardian
1779=pharmasoft
1780=dpkeyserv
1781=answersoft-lm
1782=hp-hcip
1783=Fujitsu Remote Install Service
1784=Finle License Manager
1785=windlm
1786=funk-logger
1787=funk-license
1788=psmond
1789=hello
1790=Narrative Media Streaming Protocol
1791=EA1
1792=ibm-dt-2
1793=rsc-robot
1794=cera-bcm
1795=dpi-proxy
1796=Vocaltec Server Administration
1797=uma
1798=etp
1799=netrisk
1801=Microsoft Message Que
1804=enl
1807=SpySender
1812=radius
1813=RADIUS Accounting
1814=TDP
1815=mmpft
1816=harp
1818=etftp
1819=Plato License Manager
1820=mcagent
1821=donnyworld
1822=es-elmd
1823=Unisys
1824=metrics-pas
1850=gsi
1863=msnp
1865=entp
1901=Fujitsu
1902=Fujitsu
1903=linkname
1904=Fujitsu
1905=sugp
1906=tpmd
1908=dawn
1911=mtp
1913=armadp
1914=elm-momentum
1915=facelink
1916=persona
1917=noagent
1921=noadmin
1944=close-combat
1945=dialogic-elmd
1946=tekpls
1947=hlserver
1948=eye2eye
1949=ismaeasdaqlive
1950=ismaeasdaqtest
1951=bcs-lmserver
1973=dlsrap
1981=ShockRave
1985=hsrp
1986=licensedaemon cisco license management
1987=cisco RSRB Priority 1 port
1988=cisco RSRB Priority 2 port
1989=cisco RSRB Priority 3 port
1989=mshnet
1990=cisco STUN Priority 1 port
1991=cisco STUN Priority 2 port
1992=cisco STUN Priority 3 port
1992=ipsendmsg
1993=cisco SNMP TCP port
1994=cisco serial tunnel port
1995=cisco perf port
1996=cisco Remote SRB port
1997=gdp-port
1998=x25-svc-port
1999=Backdoor
2000=黑洞(木马)
2001=黑洞(木马)
2002=globe
2004=mailbox
2005=berknet
2007=dectalk
2012=ttyinfo
2013=raid-am
2014=troff
2015=cypress
2023=Pass Ripper
2025=ellpack
2030=device2
2032=blackboard
2033=glogger
2035=imsldoc
2040=lam
2042=isis
2044=rimsl
2045=cdfunc
2046=sdfunc
2047=dls
2049=NFS
2049=nfs
2053=knetd
2065=dlsrpn
2067=dlswpn
2090=lrp
2091=prp
2102=zephyr-srv
2103=zephyr-clt
2140=DeepThroat.10 或 Invasor
2105=minipay
2200=ici
2201=ats
2213=kali
2222=unreg-ab2
2232=ivs-video
2234=directplay
2236=nani
2240=recipe
2241=ivsd
2242=foliocorp
2279=xmquery
2280=lnvpoller
2281=lnvconsole
2282=lnvalarm
2283=Rat
2284=lnvmaps
2285=lnvmailmon
2286=nas-metering
2287=dna
2288=netml
2300=cvmmon
2307=pehelp
2308=sdhelp
2313=iapp
2316=sent-lm
2321=rdlap
2322=ofsd ofsd
2323=3d-nfsd
2326=idcp
2327=xingcsm
2329=nvd
2330=tscchat
2333=snapp
2337=ideesrv
2344=fcmsys
2345=dbm
2356=gxtelmd
2358=futrix
2390=rsmtp
2396=wusage
2397=ncl
2398=orbiter
2401=cvspserver
2407=orion
2412=cdn
2415=comtest
2418=cas
2421=g-talk
2423=rnrp
2427=stgcp
2428=One Way Trip Time
2429=ft-role
2430=venus
2432=codasrv
2436=TOP/X
2438=msp
2443=powerclientcsf
2445=dtn1
2447=ovwdb
2449=ratl
2451=netchat
2458=griffin
2500=rtsserv
2501=rtsclient
2528=ncr_ccl
2529=utsftp
2532=ovtopmd
2565=Striker
2583=Wincrash2
2592=netrek
2628=dict
2634=pk-electronics
2636=solve
2639=aminet
2641=hdl-srv
2642=tragic
2646=and-lm
2653=sonus Sonus
2655=unglue UNIX Nt Glue
2656=kana Kana
2700=tqdata
2784=development
2785=aic-np
2786=Destiny MCD database
2787=Cornerstone Software
2788=Seagate Software
2789=media-agent
2801=Phineas
2908=mao
2912=epicon
2971=netclip
2974=signal
2975=fjmpcm
3000=hbci
3001=redwood-broker
3003=cgms
3010=gw Telerate Workstation
3012=twsdss
3020=cifs CIFS
3047=hlserver Fast Security HL Server
3048=pctrader Sierra Net PC Trader
3049=nsws
3105=cardbox
3128=Squid HTTP代理服务器的默认端口
3129=MastersParadise.92
3130=icpv2
3141=vmodem
3143=seaview
3147=rfio
3150=Deep Throat 1.0
3210=SchoolBus
3264=ccmail
3266=ns-cfg-server
3267=ibm-dial-out
3268=msft-gc
3273=sxmp
3275=samd
3279=admind
3281=sysopt
3284=4talk
3285=plato
3286=e-net
3288=cops
3289=enpc
3290=CAPS LOGISTICS TOOLKIT
3291=S A Holditch &Associates
3293=fg-fps
3294=fg-gip
3296=rib-slm
3299=pdrncs
3304=opsession-srvr
3306=mysql的端口
3309=tns-adv
3313=uorb
3314=uohost
3315=cdid CDID
3318=ssrip
3319=sdt-lmd
3321=vnsstr
3326=sftu
3327=bbars
3328=egptlm
3329=hp-device-disc
3330=mcs-calypsoicf
3333=dec-notes
3338=anet-b
3339=anet-l
3340=anet-m
3341=anet-h
3342=webtie
3351=btrieve
3352=ssql
3353=fatpipe
3354=suitjd
3362=dj-ilm
3372=tip2
3378=wsicopy WSICOPY
3379=socorfs SOCORFS
3381=geneous Geneous
3383=Enterprise Software Products License Manager
3389=Win2000 远程登陆端口
3390=dsc
3391=savant
3392=efi-lm
3395=dyna-lm
3421=bmap
3455=prsvp RSVP Port
3456=VAT default data
3457=vat-control
3900=udt_os Unidata UDT OS
3984=mapper-nodemgr
3985=mapper-mapethd
3986=mapper-ws_ethd
4000=OICQ Client
4001=newoak NewOak
4008=netcheque
4096=bre BRE
4132=nuts_dem NUTS Daemon
4133=nuts_bootp NUTS Bootp Server
4143=oidsr Document Replication
4321=rwhois Remote Who Is
4343=unicall UNICALL
4346=elanlm ELAN LM
4348=itose
4444=krb524
4444=nv-video
4446=n1-fwp
4449=privatewire
4450=camp Camp
4451=ctisystemmsg
4452=ctiprogramload
4500=sae-urn
4501=urn-x-cdchoice
4546=SF License Manager
4567=FileNail
4672=rfa
4800=iims
4801=iwec
4802=ilss
4827=htcp
4868=phrelay Photon Relay
4885=abbs ABBS
4899=Remote Administrator [远程控制]
4950=IcqTrojan
5000=Blazer 5
5002=rfe
5003=Proprietary
5004=avt-profile-1
5005=avt-profile-2
5010=telelpathstart
5190=ICQ Query
5020=zenginkyo-1
5021=zenginkyo-2
5050=mmcc
5060=sip SIP
5150=atmp
5190=aol America-Online
5191=AmericaOnline1
5192=AmericaOnline2
5193=AmericaOnline3
5272=pk PK
5300=HA cluster heartbeat
5301=HA cluster general services
5304=HA Cluster Commands
5305=HA Cluster Test
5307=sco-aip SCO AIP
5310=outlaws Outlaws
5311=tmlogin TM Login
5321=Firehotcker
5400=BackConstruction1.2 或 BladeRunner
5402=mftp MFTP
5404=hpoms-dps-lstn
5407=foresyte-clear
5409=salient-dtasrv
5410=salient-usrmgr
5411=actnet ActNet
5414=statusd StatusD
5418=mcntp MCNTP
5419=dj-ice DJ-ICE
5500=fcp-addr-srvr1
5501=fcp-addr-srvr2
5502=fcp-srvr-inst1
5503=fcp-srvr-inst2
5504=fcp-cics-gw1
5550=Xtcp
5555=personal-agent
5556=mtb
5569=RoboHack
5602=a1-msc
5603=a1-bs
5631=pcanywheredata
5632=pcanywherestat
5678=rrac
5679=dccm
5713=proshareaudio
5714=Wincrash3
5715=prosharedata
5717=prosharenotify
5729=openmail
5741=ida-discover1
5742=Wincrash
5745=fcopy-server
5746=fcopys-server
5755=openmailg
5757=x500ms
5766=openmailns
5767=s-openmail
6000=x11 X Window System
6110=softcm
6111=spc
6112=dtspcd
6123=backup-express
6141=meta-corp
6142=aspentec-lm
6143=watershed-lm
6144=License Manager - 1
6145=License Manager - 2
6146=lonewolf-lm
6147=montage-lm
6148=ricardo-lm
6149=tal-pod
6253=crip CRIP
6389=clariion-evr01
6400=The Thing
6500=boks
6558=xdsxdm
6665=ircu IRCU
6669=Vampire
6670=Deep Throat
6711=SubSeven
6713=SubSeven
6672=vision_server
6673=vision_elmd
6767=NT Remote Control
6771=Deep Throat 3
6776=SubSeven
6790=hnmp HNMP
6831=ambit-lm
6883=DeltaSource
6939=Indoctrination
6969=Gatecrasher.a
7010=ups-onlinet
7020=dpserve DP Serve
7070=arcp ARCP
7099=lazy-ptop lazy-ptop
7100=Font Service
7121=virprot-lm
7174=clutild Clutild
7200=fodms FODMS FLIP
7201=dlip DLIP
7306=NetMonitor (NetSpy)
7307=ProcSpy
7308=X Spy
7395=winqedit winqedit
7426=pmdmgr
7430=xmpv7
7431=pmd
7491=telops-lmd telops-lmd
7511=pafec-lm pafec-lm
7544=nta-ds
7545=nta-us
7588=sun-lm
7626=冰河(木马) 默认端口
7777=tini.exe开的后门
7781=accu-lmgr accu-lmgr
7789=ICQKiller
7932=Data Resource Manager
7933=Business Rules Manager
7999=irdmi2 iRDMI2
8000=irdmi iRDMI
8032=pro-ed ProEd
8400=cvd cvd
8401=sabarsd sabarsd
8402=abarsd abarsd
8403=admind admind
8450=npmp npmp
8473=vp2p Vitual Point to Point
8888=NewsEDGE server
8889=Desktop Data TCP 1
8890=Desktop Data TCP 2
8891=NESS application
8892=FARM product
8893=NewsEDGE/Web application
8894=COAL application
9000=cslistener CSlistener
9006=sctp SCTP
9090=websm WebSM
9400=InCommand
9401=InCommand
9402=InCommand
9535=man
9537=mantst
9594=msgsys Message System
9595=pds Ping Discovery Service
9872=Portal of Doom
9875=Portal of Doom
9876=sd Session Director
9989=InIkiller
9992=palace Palace
9993=palace Palace
9994=palace Palace
9995=palace Palace
9996=palace Palace
9997=palace Palace
9998=distinct32 Distinct32
9999=distinct distinct
10000=bnews
10001=queue
10002=poker
10167=Portal Of Doom
10607=Coma
11000=Senna Spy Trojans
11001=metasys Metasys
11223=ProgenicTrojan
12076=Gjamer 或 MSH.104b
12223=Hack?9 KeyLogger
12345=netbus木马 默认端口
12346=netbus木马 默认端口
12631=WhackJob.NB1.7
12753=tsaf tsaf port
13160=i-zipqd I-ZIPQD
13720=bprd BPRD Protocol
13721=bpbrm BPBRM Protocol
13782=bpcd VERITAS NetBackup
16969=Priotrity
17219=chipper Chipper
17300=Kuang2
18000=biimenu Beckman Instruments, Inc.
19410=hp-sco hp-sco
19411=hp-sca hp-sca
19541=jcp JCP Client
20000=Millenium II (GrilFriend)
20001=Millenium II (GrilFriend)
20034=NetBus Pro
20331=Bla
21554=GirlFriend 或 Schwindler 1.82
21845=webphone webphone
21846=Directory Services
21847=Connection Services
21848=Automatic Call Distribution
21849=Credit Processing System
22222=Prosiak
22273=wnn6 wnn6
22555=vocaltec-wconf
22800=aws-brf
22951=brf-gw
23456=Evil FTP 或 UglyFtp 或 WhackJob
24000=med-ltp med-ltp
24004=med-ovw med-ovw
24005=med-ci med-ci
25000=icl-twobase1 icl-twobase1
25001=icl-twobase2 icl-twobase2
25002=icl-twobase3 icl-twobase3
25003=icl-twobase4 icl-twobase4
25004=icl-twobase5 icl-twobase5
25005=icl-twobase6 icl-twobase6
25006=icl-twobase7 icl-twobase7
25007=icl-twobase8 icl-twobase8
25008=icl-twobase9 icl-twobase9
25009=icl-twobase10 icl-twobase10
25793=vocaltec-hos
26000=quake quake
26208=wnn6-ds wnn6-ds
27374=Sub-7木马
29891=The Unexplained
30029=AOLTrojan
30100=NetSphere木马
30303=Socket23
30999=Kuang
31337=BackOriffice
31339=NetSpy
31666=BO Whackmole
31789=Hack a tack (木马)
33333=Prosiak
33911=Trojan Spirit 2001 a
34324=TN 或 Tiny Telnet Server
40412=TheSpy
40421=MastersParadise.96
40423=Master Paradise.97
45678=eba EBA PRISE
47557=dbbrowse Databeam Corporation
47806=ap ALC Protocol
47878=BirdSpy2
47808=bacnet
50766=Fore 或 Schwindler
61466=Telecommando
53001=Remote Shutdown
54320=Back Orifice 2000
54321=SchoolBus 1.6
54320=Back Orifice 2000
65000=Devil trojan
自己慢慢看吧，前面的没用给我删了
前一阵子尝试使用了一下Sphinx，一个能够被各种语言(PHP/Python/Ruby/etc)方便调用的全文检索系统。网上的资料大多是在linux环境下的安装使用，当然，作为生产环境很有必要部署在*nix环境下，作为学习测试，还是windows环境比较方便些。
本文旨在提供一种便捷的方式让Sphinx在windows下安装配置以支持中文全文检索，配置部分在linux下通用。
一、关于Sphinx
Sphinx 是一个在GPLv2 下发布的一个全文检索引擎，商业授权（例如, 嵌入到其他程序中）需要联系作者（Sphinxsearch.com）以获得商业授权。
一般而言，Sphinx是一个独立的搜索引擎，意图为其他应用提供高速、低空间占用、高结果相关度的全文搜索功能。Sphinx可以非常容易的与SQL数据库和脚本语言集成。
当前系统内置MySQL和PostgreSQL 数据库数据源的支持，也支持从标准输入读取特定格式的XML数据。通过修改源代码，用户可以自行增加新的数据源（例如：其他类型的DBMS的原生支持）。
搜索API支持PHP、Python、Perl、Rudy和Java，并且也可以用作MySQL存储引擎。搜索API非常简单，可以在若干个小时之内移植到新的语言上。
Sphinx特性：
高速的建立索引(在当代CPU上，峰值性能可达到10MB/秒)高性能的搜索(在2–4GB的文本数据上，平均每次检索响应时间小于0.1秒)可处理海量数据(目前已知可以处理超过100GB的文本数据,在单一CPU的系统上可处理100M文档)提供了优秀的相关度算法，基于短语相似度和统计（BM25）的复合Ranking方法支持分布式搜索提供文件的摘录生成可作为MySQL的存储引擎提供搜索服务支持布尔、短语、词语相似度等多种检索模式文档支持多个全文检索字段(最大不超过32个)文档支持多个额外的`属性信息(例如：分组信息，时间戳等)停止词查询支持单一字节编码和UTF-8编码原生的MySQL支持(同时支持MyISAM和InnoDB)原生的PostgreSQL支持.
中文手册可以在这里获得（酷勤网备用下载地址：sphinx_doc_zhcn_0.9.pdf）。
二、Sphinx在windows上的安装
1.直接在http://www.sphinxsearch.com/downloads.html找到最新的windows版本，我这里下的是Win32 release binaries with MySQL support，下载后解压在D:sphinx目录下；
2.在D:sphinx下新建一个data目录用来存放索引文件，一个log目录方日志文件，复制D:sphinxsphinx.conf.in到D:sphinxbinsphinx.conf（注意修改文件名）；
3.修改D:sphinxbinsphinx.conf，我这里列出需要修改的几个：
type= mysql # 数据源，我这里是mysqlsql_host= localhost # 数据库服务器sql_user= root # 数据库用户名sql_pass='' # 数据库密码sql_db= test # 数据库sql_port= 3306 # 数据库端口
sql_query_pre= SET NAMES utf8 # 去掉此行前面的注释，如果你的数据库是uft8编码的
index test1{#放索引的目录path= D:/sphinx/data/# 编码charset_type= utf-8#指定utf-8的编码表charset_table=0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F# 简单分词，只支持0和1，如果要搜索中文，请指定为1ngram_len= 1# 需要分词的字符，如果要搜索中文，去掉前面的注释ngram_chars= U+3000..U+2FA1F}
# index test1stemmed : test1# {# path= @CONFDIR@/data/test1stemmed# morphology= stem_en# }# 如果没有分布式索引，注释掉下面的内容# index dist1# {# 'distributed' index type MUST be specified# type= distributed
# local index to be searched# there can be many local indexes configured# local= test1# local= test1stemmed
# remote agent# multiple remote agents may be specified# syntax is 'hostname:port:index1,[index2[,...]]# agent= localhost:3313:remote1# agent= localhost:3314:remote2,remote3
# remote agent connection timeout, milliseconds# optional, default is 1000 ms, ie. 1 sec# agent_connect_timeout= 1000
# remote agent query timeout, milliseconds# optional, default is 3000 ms, ie. 3 sec# agent_query_timeout= 3000# }
# 搜索服务需要修改的部分searchd{# 日志log= D:/sphinx/log/searchd.log
# PID file, searchd process ID file namepid_file= D:/sphinx/log/searchd.pid
# windows下启动searchd服务一定要注释掉这个 # seamless_rotate= 1}
4.导入测试数据
C:Program FilesMySQLMySQL Server 5.0bin>mysql -uroot test<d:/sphinx/example.sql
5.建立索引
D:sphinxbin>indexer.exe test1
Sphinx 0.9.8-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file ‘./sphinx.conf’…
indexing index ‘test1′…
collected 4 docs, 0.0 MB
sorted 0.0 Mhits, 100.0% done
total 4 docs, 193 bytes
total 0.101 sec, 1916.30 bytes/sec, 39.72 docs/sec
D:sphinxbin>
6.搜索’test’试试
D:sphinxbin>search.exe test
Sphinx 0.9.8-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file ‘./sphinx.conf’…
index ‘test1′: query ‘test ‘: returned 3 matches of 3 total in 0.000 sec
displaying matches:
1. document=1, weight=2, group_id=1, date_added=Wed Nov 26 14:58:59 2008
id=1
group_id=1
group_id2=5
date_added=2008-11-26 14:58:59
title=test one
content=this is my test document number one. also checking search within
phrases.
2. document=2, weight=2, group_id=1, date_added=Wed Nov 26 14:58:59 2008
id=2
group_id=1
group_id2=6
date_added=2008-11-26 14:58:59
title=test two
content=this is my test document number two
3. document=4, weight=1, group_id=2, date_added=Wed Nov 26 14:58:59 2008
id=4
group_id=2
group_id2=8
date_added=2008-11-26 14:58:59
title=doc number four
content=this is to test groups
words:
1. ‘test’: 3 documents, 5 hits
D:sphinxbin>
都所出来了吧。
6.测试中文搜索
修改test数据库中documents数据表，
UPDATE `test`.`documents` SET `title` = ‘测试中文’, `content` = ‘this is my test document number two，应该搜的到吧’ WHERE `documents`.`id` = 2
重建索引：
D:sphinxbin>indexer.exe –all
搜索’中文’试试：
D:sphinxbin>search.exe 中文
Sphinx 0.9.8-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
using config file ‘./sphinx.conf’…
index ‘test1′: query ‘中文 ‘: returned 0 matches of 0 total in 0.000 sec
words:
D:sphinxbin>
貌似没有搜到，这是因为windows命令行中的编码是gbk，当然搜不出来。我们可以用程序试试，在D:sphinxapi下新建一个foo.php的文件，注意utf-8编码
<?php
require ’sphinxapi.php’
$s = new SphinxClient()
$s->SetServer(’localhost’,3312)
$result = $s->Query(’中文’)
var_dump($result)
?>
启动Sphinx searchd服务
D:sphinxbin>searchd.exe
Sphinx 0.9.8-release (r1533)
Copyright (c) 2001-2008, Andrew Aksyonoff
WARNING: forcing –console mode on Windows
using config file ‘./sphinx.conf’…
creating server socket on 0.0.0.0:3312
accepting connections
执行PHP查询：
php d:/sphinx/api/foo.php
结果是不是出来？剩下的工作就是去看手册，慢慢摸索高阶的配置。
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)启动是如下显示：
[root@localhost mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data
020405 05:06:42 mysqld ended
数据库为什么会 ended 的呢？
再执行这个语句：/usr/local/mysql/bin/mysqld_safe --user=mysql &
显示如下：
[1] 24154
[root@localhost bin]# The file /usr/local/mysql/libexec/mysqld doesn't exist or is not
executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.
查看日志(一般在mysql/data/下)，如下：
020405 09:58:28 mysqld started
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the
command line
020405 9:58:28 Can't start server : Bind on unix socket: Permission denied
020405 9:58:28 Do you already have another mysqld server running on socket:
/usr/local/mysql/mysql.sock ?
020405 9:58:28 Aborting
020405 9:58:28 /usr/local/mysql/bin/mysqld: Shutdown Complete
020405 09:58:28 mysqld ended
020405 11:06:36 mysqld started
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the
command line
020405 11:06:36 Can't start server : Bind on unix socket: Permission denied
020405 11:06:36 Do you already have another mysqld server running on socket:
/usr/local/mysql/mysql.sock ?
020405 11:06:36 Aborting
020405 11:06:36 /usr/local/mysql/bin/mysqld: Shutdown Complete
020405 11:06:36 mysqld ended
@@@@@@@@@@@@@@@@@@@@ 问题遇到转机： @@@@@@@@@@@@@@@@@@@@
输入：sudo /usr/local/mysql/bin/safe_mysqld
出现：
Starting mysqld daemon with databases from /usr/local/mysql/data
（命令停止不动，没有回到命令行下，按ctrl+z结束，出现）
[1]+ Stopped sudo /usr/local/mysql/bin/safe_mysqld
执行
[root@localhost mysql]# ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
root 1 0.0 0.0 1368 64 ?S09:06 0:05 init [3]
root 2 0.0 0.0 00 ?SW 09:06 0:00 [keventd]
root 3 0.0 0.0 00 ?SW 09:06 0:00 [kapmd]
root 4 0.0 0.0 00 ?SWN 09:06 0:00 [ksoftirqd_CPU0]
root 9 0.0 0.0 00 ?SW 09:06 0:00 [bdflush]
root 5 0.0 0.0 00 ?SW 09:06 0:00 [kswapd]
root 6 0.0 0.0 00 ?SW 09:06 0:00 [kscand/DMA]
root 7 0.0 0.0 00 ?SW 09:06 0:02 [kscand/Normal]
root 8 0.0 0.0 00 ?SW 09:06 0:00 [kscand/HighMem]
root10 0.0 0.0 00 ?SW 09:06 0:00 [kupdated]
root11 0.0 0.0 00 ?SW 09:06 0:00 [mdrecoveryd]
root17 0.0 0.0 00 ?SW 09:06 0:00 [scsi_eh_0]
root20 0.0 0.0 00 ?SW 09:06 0:00 [kjournald]
root78 0.0 0.0 00 ?SW 09:06 0:00 [khubd]
root 2744 0.0 0.0 00 ?SW 09:06 0:00 [kjournald]
root 3065 0.0 0.0 1440 68 ?S09:07 0:00 syslogd -m 0
root 3069 0.0 0.0 1368 20 ?S09:07 0:00 klogd -x
rpc 3087 0.0 0.0 1548 120 ?S09:07 0:00 [portmap]
rpcuser 3106 0.0 0.0 1524 164 ?S09:07 0:00 [rpc.statd]
root 3173 0.0 0.0 1364 68 ?S09:07 0:00 /usr/sbin/apmd -p 10 -w 5 -W
-P /etc/sysconfig/apm-scripts/apm
root 3210 0.0 0.2 3508 1016 ?S09:08 0:00 /usr/sbin/sshd
root 3224 0.0 0.0 2028 316 ?S09:08 0:00 xinetd -stayalive -reuse -
pidfile /var/run/xinetd.pid
root 3285 0.0 0.5 5908 1924 ?S09:08 0:00 [sendmail]
smmsp 3294 0.0 0.4 5712 1616 ?S09:08 0:00 [sendmail]
root 3304 0.0 0.0 1412 96 ?S09:08 0:01 gpm -t ps/2 -m /dev/mouse
root 3313 0.0 0.0 1420 136 ?S09:08 0:00 crond
root 3324 0.0 0.3 8356 1400 ?S09:08 0:00 cupsd
xfs 3388 0.0 0.6 4536 2568 ?S09:08 0:00 [xfs]
daemon3406 0.0 0.0 1412 180 ?S09:08 0:00 [atd]
root 3414 0.0 0.0 1348 56 tty1 S09:08 0:00 /sbin/mingetty tty1
root 3415 0.0 0.0 1348 56 tty2 S09:08 0:00 /sbin/mingetty tty2
root 3416 0.0 0.0 1348 56 tty3 S09:08 0:00 /sbin/mingetty tty3
root 3417 0.0 0.0 1348 56 tty4 S09:08 0:00 /sbin/mingetty tty4
root 3418 0.0 0.0 1348 56 tty5 S09:08 0:00 /sbin/mingetty tty5
root 3419 0.0 0.0 1348 56 tty6 S09:08 0:00 /sbin/mingetty tty6
root 8755 0.0 0.5 11304 2268 ?S10:19 0:00 /usr/local/apache/bin/httpd
-k start
nobody8756 0.0 0.8 11612 3164 ?S10:19 0:00 [httpd]
nobody8759 0.0 0.8 11696 3392 ?S10:19 0:00 [httpd]
nobody8760 0.0 0.8 11520 3164 ?S10:19 0:00 [httpd]
nobody8761 0.0 0.8 11688 3416 ?S10:19 0:00 [httpd]
nobody8763 0.0 0.8 11696 3324 ?S10:19 0:00 [httpd]
nobody8829 0.0 0.8 11552 3364 ?S10:20 0:00 [httpd]
root 8874 0.0 0.3 6748 1408 ?S11:04 0:00 /usr/sbin/sshd
kent 8876 0.0 0.4 6800 1588 ?S11:04 0:00 [sshd]
kent 8877 0.0 0.0 5156 296 pts/3S11:04 0:00 -bash
root 8909 0.0 0.0 4964 356 pts/3S11:04 0:00 [su]
root 8910 0.0 0.0 5224 360 pts/3S11:05 0:00 bash
root 8970 0.0 0.3 6748 1408 ?S11:06 0:00 /usr/sbin/sshd
kent 8972 0.0 0.4 6880 1604 ?S11:06 0:00 [sshd]
kent 8973 0.0 0.0 5160 300 pts/4S11:06 0:00 -bash
root 9007 0.0 0.0 4960 356 pts/4S11:07 0:00 [su]
root 9008 0.0 0.0 5224 364 pts/4S11:07 0:00 bash
nobody9064 0.0 0.8 11540 3276 ?S11:08 0:00 [httpd]
nobody9066 0.0 0.8 11628 3180 ?S11:08 0:00 [httpd]
nobody9069 0.0 0.8 11636 3264 ?S11:08 0:00 [httpd]
root 9110 0.0 0.3 6748 1408 ?S11:52 0:00 /usr/sbin/sshd
kent 9112 0.0 0.4 6800 1588 ?S11:52 0:00 [sshd]
kent 9113 0.0 0.0 5160 300 pts/1S11:52 0:00 -bash
root 9144 0.0 0.0 4960 356 pts/1S11:52 0:00 [su]
root 9145 0.0 0.0 5224 364 pts/1S11:52 0:00 bash
root 9213 0.0 0.3 6748 1408 ?S12:10 0:00 /usr/sbin/sshd
kent 9215 0.0 0.4 6880 1640 ?S12:10 0:00 [sshd]
kent 9216 0.0 0.0 5164 300 pts/5S12:10 0:00 -bash
root 9247 0.0 0.0 4960 356 pts/5S12:11 0:00 [su]
root 9248 0.0 0.2 5224 880 pts/5S12:11 0:00 bash
nobody9288 0.0 0.7 11464 3032 ?S12:33 0:00 [httpd]
root 9302 0.0 0.0 5012 188 pts/5T12:42 0:00 /bin/sh
/usr/local/mysql/bin/safe_mysqld
mysql 9324 0.2 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9325 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9326 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9327 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9328 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9329 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9330 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9331 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9332 0.0 4.6 39228 18008 pts/5 S12:42 0:00 [mysqld]
mysql 9333 0.0 4.6 39228 18008 pts/5 T12:42 0:00 [mysqld]
root 9334 1.0 0.1 2660 712 pts/5R12:44 0:00 ps aux
惊奇发现MYSQL启动了！！！~_~
更改密码：[root@localhost bin]# ./mysqladmin -u root password 123456
成功！！！
再次修改：[root@localhost bin]# ./mysqladmin -u root -p123456 password ******
成功！！！YEAH...........
但是不行登陆mysql数据库：
[root@localhost bin]# ./mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'
(2)
至此问题有转机了：
执行：
[root@localhost bin]# find / -name mysql.sock
/tmp/mysql.sock
居然出现mysql.sock了。。。。
@@@@@@@@@@@@@@@@@@@@ 现在分析情况@@@@@@@@@@@@@@@@@@@@
可以修改密码了，证明MYSQL可以用，并且启动了。
但是出现
ERROR 2002: Can't connect to local MySQL server through socket '/usr/local/mysql/mysql.sock'
(2)
证明有地方不对，需要修改，不外乎这两个地方：
1）my.cnf和php.ini文件，具体可查找（find / -name 文件）
my.cnf文件一般在/etc/my.cnf
php.ini一般在/etc/php.ini
2）确保两个文件里的 socket = /tmp/mysql.sock 都相同！！！
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
呵，到此，我看到了 Belltree 的回复！！！
@@@@@@@@@@@@@@@@@@@@（Belltree 原话）@@@@@@@@@@@@@@@@@@@@
你以root身份登录，然后
killall -9 mysql
killall -9 mysqld
killall -9 mysqld_safe
然后ps -Af | grep mysql，确定没有任何mysqld的进程，有就杀掉
cd /usr/local/mysql
./bin/mysqld_safe &
应该可以的
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@@@@@@@@@@@@@@@@@@@@ 结尾 @@@@@@@@@@@@@@@@@@@@
一试果然OK了，呵，现在的心情是无比的痛快真想抱着 Belltree 狂吻！！！！
[root@localhost mysql]# ./bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with or \g.
Your MySQL connection id is 2 to server version: 4.1.0-alpha-standard
Type 'help' or '\h' for help. Type '\c' to clear the buffer.
欢迎分享，转载请注明来源：内存溢出
微信扫一扫
支付宝扫一扫
评论列表（0条）