README.RPC 48 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454
  1. This README contains details about the BFGMiner RPC API
  2. It also includes some detailed information at the end,
  3. about using miner.php
  4. If you start BFGMiner with the "--api-listen" option, it will listen on a
  5. simple TCP/IP socket for single string API requests from the same machine
  6. running BFGMiner and reply with a string and then close the socket each time
  7. If you add the "--api-network" option, it will accept API requests from any
  8. network attached computer.
  9. You can only access the commands that reply with data in this mode.
  10. By default, you cannot access any privileged command that affects the miner -
  11. you will receive an access denied status message see --api-allow below.
  12. You can specify IP addresses/prefixes that are only allowed to access the API
  13. with the "--api-allow" option e.g. --api-allow W:192.168.0.1,10.0.0/24
  14. will allow 192.168.0.1 or any address matching 10.0.0.*, but nothing else
  15. IP addresses are automatically padded with extra '.0's as needed
  16. Without a /prefix is the same as specifying /32
  17. 0/0 means all IP addresses.
  18. The 'W:' on the front gives that address/subnet privileged access to commands
  19. that modify BFGMiner (thus all API commands)
  20. Without it those commands return an access denied status.
  21. See --api-groups below to define other groups like W:
  22. Privileged access is checked in the order the IP addresses were supplied to
  23. "--api-allow"
  24. The first match determines the privilege level.
  25. Using the "--api-allow" option overrides the "--api-network" option if they
  26. are both specified
  27. With "--api-allow", 127.0.0.1 is not by default given access unless specified
  28. More groups (like the privileged group W:) can be defined using the
  29. --api-groups command
  30. Valid groups are only the letters A-Z (except R & W are predefined) and are
  31. not case sensitive
  32. The R: group is the same as not privileged access
  33. The W: group is (as stated) privileged access (thus all API commands)
  34. To give an IP address/subnet access to a group you use the group letter
  35. in front of the IP address instead of W: e.g. P:192.168.0/32
  36. An IP address/subnet can only be a member of one group
  37. A sample API group would be:
  38. --api-groups P:switchpool:enablepool:addpool:disablepool:removepool:poolpriority:*
  39. This would create a group 'P' that can do all current pool commands and all
  40. non-privileged commands - the '*' means all non-privileged commands
  41. Without the '*' the group would only have access to the pool commands
  42. Defining multiple groups example:
  43. --api-groups Q:quit:restart:*,S:save
  44. This would define 2 groups:
  45. Q: that can 'quit' and 'restart' as well as all non-privileged commands
  46. S: that can only 'save' and no other commands
  47. The RPC API request can be either simple text or JSON.
  48. If the request is JSON (starts with '{'), it will reply with a JSON formatted
  49. response, otherwise it replies with text formatted as described further below.
  50. The JSON request format required is '{"command":"CMD","parameter":"PARAM"}'
  51. (though of course parameter is not required for all requests)
  52. where "CMD" is from the "Request" column below and "PARAM" would be e.g.
  53. the CPU/GPU number if required.
  54. An example request in both formats to set GPU 0 fan to 80%:
  55. gpufan|0,80
  56. {"command":"gpufan","parameter":"0,80"}
  57. The format of each reply (unless stated otherwise) is a STATUS section
  58. followed by an optional detail section
  59. From API version 1.7 onwards, reply strings in JSON and Text have the
  60. necessary escaping as required to avoid ambiguity - they didn't before 1.7
  61. For JSON the 2 characters '"' and '\' are escaped with a '\' before them
  62. For Text the 4 characters '|' ',' '=' and '\' are escaped the same way
  63. Only user entered information will contain characters that require being
  64. escaped, such as Pool URL, User and Password or the Config save filename,
  65. when they are returned in messages or as their values by the API
  66. For API version 1.4 and later:
  67. The STATUS section is:
  68. STATUS=X,When=NNN,Code=N,Msg=string,Description=string|
  69. STATUS=X Where X is one of:
  70. W - Warning
  71. I - Informational
  72. S - Success
  73. E - Error
  74. F - Fatal (code bug)
  75. When=NNN
  76. Standard long time of request in seconds
  77. Code=N
  78. Each unique reply has a unique Code (See api.c - #define MSG_NNNNNN)
  79. Msg=string
  80. Message matching the Code value N
  81. Description=string
  82. This defaults to the BFGMiner version but is the value of --api-description
  83. if it was specified at runtime.
  84. For API version 1.10 and later:
  85. The list of requests - a (*) means it requires privileged access - and replies are:
  86. Request Reply Section Details
  87. ------- ------------- -------
  88. version VERSION CGMiner=BFGMiner version
  89. API=API version
  90. config CONFIG Some miner configuration information:
  91. GPU Count=N, <- the number of GPUs
  92. PGA Count=N, <- the number of PGAs
  93. CPU Count=N, <- the number of CPUs
  94. Pool Count=N, <- the number of Pools
  95. ADL=X, <- Y or N if ADL is compiled in the code
  96. ADL in use=X, <- Y or N if any GPU has ADL
  97. Strategy=Name, <- the current pool strategy
  98. Log Interval=N, <- log interval (--log N)
  99. Device Code=GPU ICA , <- spaced list of compiled devices
  100. OS=Linux/Apple/..., <- operating System
  101. Failover-Only=true/false, <- failover-only setting
  102. ScanTime=N, <- --scan-time setting
  103. Queue=N, <- --queue setting
  104. Expiry=N| <- --expiry setting
  105. summary SUMMARY The status summary of the miner
  106. e.g. Elapsed=NNN,Found Blocks=N,Getworks=N,...|
  107. pools POOLS The status of each pool
  108. e.g. Pool=0,URL=http://pool.com:6311,Status=Alive,...|
  109. devs DEVS Each available GPU, PGA and CPU with their status
  110. e.g. GPU=0,Accepted=NN,MHS av=NNN,...,Intensity=D|
  111. Last Share Time=NNN, <- standard long time in seconds
  112. (or 0 if none) of last accepted share
  113. Last Share Pool=N, <- pool number (or -1 if none)
  114. Last Valid Work=NNN, <- standand long time in seconds
  115. of last work returned that wasn't an HW:
  116. Will not report PGAs if PGA mining is disabled
  117. Will not report CPUs if CPU mining is disabled
  118. devscan|info DEVS Probes for a device specified by info, which is
  119. the same format as the --scan-serial command line
  120. option
  121. devdetail DEVS Each available device with their fixed details
  122. e.g. GPU=0,Driver=opencl,Kernel=diablo,Model=...|
  123. gpu|N GPU The details of a single GPU number N in the same
  124. format and details as for DEVS
  125. pga|N PGA The details of a single PGA number N in the same
  126. format and details as for DEVS
  127. This is only available if PGA mining is enabled
  128. Use 'pgacount' or 'config' first to see if there are any
  129. cpu|N CPU The details of a single CPU number N in the same
  130. format and details as for DEVS
  131. This is only available if CPU mining is enabled
  132. Use 'cpucount' or 'config' first to see if there are any
  133. gpucount GPUS Count=N| <- the number of GPUs
  134. pgacount PGAS Count=N| <- the number of PGAs
  135. Always returns 0 if PGA mining is disabled
  136. cpucount CPUS Count=N| <- the number of CPUs
  137. Always returns 0 if CPU mining is disabled
  138. switchpool|N (*)
  139. none There is no reply section just the STATUS section
  140. stating the results of switching pool N to the
  141. highest priority (the pool is also enabled)
  142. The Msg includes the pool URL
  143. enablepool|N (*)
  144. none There is no reply section just the STATUS section
  145. stating the results of enabling pool N
  146. The Msg includes the pool URL
  147. addpool|URL,USR,PASS (*)
  148. none There is no reply section just the STATUS section
  149. stating the results of attempting to add pool N
  150. The Msg includes the pool URL
  151. Use '\\' to get a '\' and '\,' to include a comma
  152. inside URL, USR or PASS
  153. poolpriority|N,... (*)
  154. none There is no reply section just the STATUS section
  155. stating the results of changing pool priorities
  156. See usage below
  157. disablepool|N (*)
  158. none There is no reply section just the STATUS section
  159. stating the results of disabling pool N
  160. The Msg includes the pool URL
  161. removepool|N (*)
  162. none There is no reply section just the STATUS section
  163. stating the results of removing pool N
  164. The Msg includes the pool URL
  165. N.B. all details for the pool will be lost
  166. cpuenable|N (*)
  167. none There is no reply section just the STATUS section
  168. stating the results of the enable request
  169. cpudisable|N (*)
  170. none There is no reply section just the STATUS section
  171. stating the results of the disable request
  172. cpurestart|N (*)
  173. none There is no reply section just the STATUS section
  174. stating the results of the restart request
  175. gpuenable|N (*)
  176. none There is no reply section just the STATUS section
  177. stating the results of the enable request
  178. gpudisable|N (*)
  179. none There is no reply section just the STATUS section
  180. stating the results of the disable request
  181. gpurestart|N (*)
  182. none There is no reply section just the STATUS section
  183. stating the results of the restart request
  184. gpuintensity|N,I (*)
  185. none There is no reply section just the STATUS section
  186. stating the results of setting GPU N intensity to I
  187. gpumem|N,V (*)
  188. none There is no reply section just the STATUS section
  189. stating the results of setting GPU N memoryclock to V MHz
  190. gpuengine|N,V (*)
  191. none There is no reply section just the STATUS section
  192. stating the results of setting GPU N clock to V MHz
  193. gpufan|N,V (*)
  194. none There is no reply section just the STATUS section
  195. stating the results of setting GPU N fan speed to V%
  196. gpuvddc|N,V (*)
  197. none There is no reply section just the STATUS section
  198. stating the results of setting GPU N vddc to V
  199. save|filename (*)
  200. none There is no reply section just the STATUS section
  201. stating success or failure saving the BFGMiner config
  202. to filename
  203. The filename is optional and will use the BFGMiner
  204. default if not specified
  205. quit (*) none There is no status section but just a single "BYE"
  206. reply before BFGMiner quits
  207. notify NOTIFY The last status and history count of each devices problem
  208. e.g. NOTIFY=0,Name=PGA,ID=0,ProcID=0,Last Well=1332432290,...|
  209. privileged (*)
  210. none There is no reply section just the STATUS section
  211. stating an error if you do not have privileged access
  212. to the API and success if you do have privilege
  213. The command doesn't change anything in BFGMiner
  214. pgaenable|N (*)
  215. none There is no reply section just the STATUS section
  216. stating the results of the enable request
  217. You cannot enable a PGA if its status is not WELL
  218. This is only available if PGA mining is enabled
  219. pgadisable|N (*)
  220. none There is no reply section just the STATUS section
  221. stating the results of the disable request
  222. This is only available if PGA mining is enabled
  223. pgaidentify|N (*)
  224. none There is no reply section just the STATUS section
  225. stating the results of the identify request
  226. This is only available if PGA mining is enabled
  227. and currently only BitForce Singles support this command
  228. On a BitForce Single it will flash the led on the front
  229. of the device for approximately 4s
  230. All other non-BFL PGA devices will return a warning
  231. status message stating that they don't support it
  232. This adds a 4s delay to the BFL share being processed
  233. so you may get a message stating that processing took
  234. longer than 7000ms if the request was sent towards
  235. the end of the timing of any work being worked on
  236. e.g.: BFL0: took 8438ms - longer than 7000ms
  237. You should ignore this
  238. devdetails DEVDETAILS Each device with a list of their static details
  239. This lists all devices including those not supported
  240. by the 'devs' command
  241. e.g. DEVDETAILS=0,Name=PGA,ID=0,ProcID=0,Driver=bitforce,...|
  242. restart (*) none There is no status section but just a single "RESTART"
  243. reply before BFGMiner restarts
  244. stats STATS Each device or pool that has 1 or more getworks
  245. with a list of stats regarding getwork times
  246. The values returned by stats may change in future
  247. versions thus would not normally be displayed
  248. Device drivers are also able to add stats to the
  249. end of the details returned
  250. check|cmd COMMAND Exists=Y/N, <- 'cmd' exists in this version
  251. Access=Y/N| <- you have access to use 'cmd'
  252. failover-only|true/false (*)
  253. none There is no reply section just the STATUS section
  254. stating what failover-only was set to
  255. coin COIN Coin mining information:
  256. Hash Method=sha256/scrypt,
  257. Current Block Time=N.N, <- 0 means none
  258. Current Block Hash=XXXX..., <- blank if none
  259. LP=true/false, <- LP is in use on at least 1 pool
  260. Network Difficulty=NN.NN|
  261. debug|setting (*)
  262. DEBUG Debug settings
  263. The optional commands for 'setting' are the same as
  264. the screen curses debug settings
  265. You can only specify one setting
  266. Only the first character is checked (case insensitive):
  267. Silent, Quiet, Verbose, Debug, RPCProto, PerDevice,
  268. WorkTime, Normal
  269. The output fields are (as above):
  270. Silent=true/false,
  271. Quiet=true/false,
  272. Verbose=true/false,
  273. Debug=true/false,
  274. RPCProto=true/false,
  275. PerDevice=true/false,
  276. WorkTime=true/false|
  277. setconfig|name,value (*)
  278. none There is no reply section just the STATUS section
  279. stating the results of setting 'name'
  280. The valid values for name are currently:
  281. queue, scantime, expiry (integer in the range
  282. 0 to 9999)
  283. coinbase-sig (string)
  284. http-port (valid port number)
  285. pgaset|N,opt[,val] (*)
  286. none There is no reply section just the STATUS section
  287. stating the results of setting PGA N with opt[,val]
  288. This is only available if PGA mining is enabled
  289. If the PGA does not support any set options, it will
  290. always return a WARN stating pgaset isn't supported
  291. If opt=help it will return an INFO status with a
  292. help message about the options available
  293. The current options are:
  294. MMQ opt=clock val=2 to 250 (and a multiple of 2)
  295. XBS opt=clock val=2 to 250 (and a multiple of 2)
  296. zero|Which,true/false (*)
  297. none There is no reply section just the STATUS section
  298. stating that the zero, and optional summary, was done
  299. If Which='all', all normal cgminer and API statistics
  300. will be zeroed other than the numbers displayed by the
  301. usbstats and stats commands
  302. If Which='bestshare', only the 'Best Share' values
  303. are zeroed for each pool and the global 'Best Share'
  304. The true/false option determines if a full summary is
  305. shown on the cgminer display like is normally displayed
  306. on exit.
  307. When you enable, disable or restart a GPU or PGA, you will also get Thread
  308. messages in the BFGMiner status window.
  309. The 'poolpriority' command can be used to reset the priority order of multiple
  310. pools with a single command - 'switchpool' only sets a single pool to first
  311. priority. Each pool should be listed by id number in order of preference (first
  312. = most preferred). Any pools not listed will be prioritised after the ones that
  313. are listed, in the priority order they were originally If the priority change
  314. affects the miner's preference for mining, it may switch immediately.
  315. When you switch to a different pool to the current one (including by priority
  316. change), you will get a 'Switching to URL' message in the BFGMiner status
  317. windows
  318. Obviously, the JSON format is simply just the names as given before the '='
  319. with the values after the '='
  320. If you enable BFGMiner debug (--debug or using RPC), you will also get messages
  321. showing some details of the requests received and the replies
  322. There are included 5 program examples for accessing the API:
  323. api-example.php - a PHP script to access the API
  324. usage: php api-example.php command
  325. by default it sends a 'summary' request to the miner at 127.0.0.1:4028
  326. If you specify a command it will send that request instead
  327. You must modify the line "$socket = getsock('127.0.0.1', 4028);" at the
  328. beginning of "function request($cmd)" to change where it looks for BFGMiner
  329. api-example.c - a 'C' program to access the API (with source code)
  330. usage: api-example [command [ip/host [port]]]
  331. again, as above, missing or blank parameters are replaced as if you entered:
  332. api-example summary 127.0.0.1 4028
  333. miner.php - an example web page to access the API
  334. This includes buttons and inputs to attempt access to the privileged commands
  335. See the end of this README.RPC for details of how to tune the display
  336. and also to use the option to display a multi-rig summary
  337. api-example.py - a Python script to access the API
  338. usage: python api-example.py [--host HOST] [--port PORT] [command] [parameter]
  339. by default it sends a 'summary' request to the miner at 127.0.0.1:4028
  340. If you specify a command it will send that request instead
  341. ----------
  342. Feature Changelog for external applications using the API:
  343. API V1.25.3
  344. Modified API commands:
  345. 'setconfig' - add 'http-port' number
  346. ----------
  347. API V1.25.2
  348. Modified API commands:
  349. 'pgaset' - added: XBS opt=clock val=2 to 250 (and a multiple of 2)
  350. ----------
  351. API V1.25.1 (BFGMiner v3.1.2)
  352. Added API commands:
  353. 'devscan'
  354. ----------
  355. API V1.25 (BFGMiner v3.0.1)
  356. Modified API commands:
  357. 'devs' 'gpu' and 'pga' - add 'Last Valid Work'
  358. ----------
  359. API V1.24.1 (BFGMiner v3.0.0)
  360. Modified API commands:
  361. 'cpustatus' - add 'ProcID'
  362. 'gpustatus' - add 'ProcID'
  363. 'pgastatus' - add 'ProcID'
  364. 'devstatus' - add 'ProcID'
  365. 'notify' - add 'ProcID'
  366. 'devdetails' - add 'ProcID'
  367. 'devdetail' - add 'Name', 'ID', and 'ProcID'
  368. 'pools' - add 'Message'
  369. 'coin' - add 'Network Difficulty'
  370. Pretty much updated every method returning 'Name' and 'ID' to also return
  371. 'ProcID'. This is a number starting with 0 for 'a', 1 for 'b', etc.
  372. ----------
  373. API V1.24 (BFGMiner v2.10.3)
  374. Added API commands:
  375. 'zero'
  376. Modified API commands:
  377. 'pools' - add 'Best Share'
  378. 'stats' - rename 'Bytes Sent' and 'Bytes Recv' to 'Net Bytes Sent' and
  379. 'Net Bytes Recv'
  380. ----------
  381. API V1.23 (BFGMiner v2.10.1)
  382. Added API commands:
  383. 'pgaset' - with: MMQ opt=clock val=2 to 230 (and a multiple of 2)
  384. ----------
  385. API V1.22 (not released)
  386. Enforced output limitation:
  387. all extra records beyond the output limit of the API (~64k) are ignored and
  388. chopped off at the record boundary before the limit is reached however, JSON
  389. brackets will be correctly closed and the JSON id will be set to 0 (instead
  390. of 1) if any data was truncated
  391. Modified API commands:
  392. 'stats' - add 'Times Sent', 'Bytes Sent', 'Times Recv', 'Bytes Recv'
  393. ----------
  394. API V1.21 (BFGMiner v2.10.0)
  395. Modified API commands:
  396. 'summary' - add 'Best Share'
  397. ----------
  398. API V1.20b (BFGMiner v2.9.1)
  399. Support for the X6500 FPGA was added
  400. ----------
  401. API V1.20 (BFGMiner v2.9.0)
  402. Modified API commands:
  403. 'pools' - add 'Has Stratum', 'Stratum Active', 'Stratum URL'
  404. ----------
  405. API V1.19b (BFGMiner v2.8.1)
  406. Added API commands:
  407. 'pgaidentify|N' (only works for BitForce Singles so far)
  408. Modified API commands:
  409. Change pool field name back from 'Diff1 Work' to 'Diff1 Shares'
  410. 'devs' - add 'Difficulty Accepted', 'Difficulty Rejected',
  411. 'Last Share Difficulty' to all devices
  412. 'gpu|N' - add 'Difficulty Accepted', 'Difficulty Rejected',
  413. 'Last Share Difficulty'
  414. 'pga|N' - add 'Difficulty Accepted', 'Difficulty Rejected',
  415. 'Last Share Difficulty'
  416. 'notify' - add '*Dev Throttle' (for BitForce Singles)
  417. 'pools' - add 'Difficulty Accepted', 'Difficulty Rejected',
  418. 'Difficulty Stale', 'Last Share Difficulty'
  419. 'stats' - add 'Work Diff', 'Min Diff', 'Max Diff', 'Min Diff Count',
  420. 'Max Diff Count' to the pool stats
  421. 'setconfig|name,value' - add 'Coinbase-Sig' string
  422. ----------
  423. API V1.19 (BFGMiner v2.8.0)
  424. Added API commands:
  425. 'debug'
  426. 'setconfig|name,N'
  427. Modified API commands:
  428. Change pool field name 'Diff1 Shares' to 'Diff1 Work'
  429. 'devs' - add 'Diff1 Work' to all devices
  430. 'gpu|N' - add 'Diff1 Work'
  431. 'pga|N' - add 'Diff1 Work'
  432. 'pools' - add 'Proxy'
  433. 'config' - add 'Queue', 'Expiry'
  434. ----------
  435. API V1.18 (BFGMiner v2.7.4)
  436. Modified API commands:
  437. 'stats' - add 'Work Had Roll Time', 'Work Can Roll', 'Work Had Expire',
  438. and 'Work Roll Time' to the pool stats
  439. 'config' - include 'ScanTime'
  440. ----------
  441. API V1.17b (BFGMiner v2.7.1)
  442. Modified API commands:
  443. 'summary' - add 'Work Utility'
  444. 'pools' - add 'Diff1 Shares'
  445. ----------
  446. API V1.17 (BFGMiner v2.6.5)
  447. Added API commands:
  448. 'coin'
  449. ----------
  450. API V1.16 (BFGMiner v2.6.5)
  451. Added API commands:
  452. 'failover-only'
  453. Modified API commands:
  454. 'config' - include failover-only state
  455. ----------
  456. API V1.15 (BFGMiner v2.5.2)
  457. Added API commands:
  458. 'poolpriority'
  459. ----------
  460. API V1.14 (BFGMiner v2.5.0)
  461. Modified API commands:
  462. 'stats' - more Icarus timing stats added
  463. 'notify' - include new device comms error counter
  464. The internal code for handling data was rewritten (~25% of the code)
  465. Completely backward compatible
  466. ----------
  467. API V1.13 (BFGMiner v2.4.4)
  468. Added API commands:
  469. 'check'
  470. Support was added to BFGMiner for API access groups with the --api-groups option
  471. It's 100% backward compatible with previous --api-access commands
  472. ----------
  473. API V1.12 (BFGMiner v2.4.3)
  474. Modified API commands:
  475. 'stats' - more pool stats added
  476. Support for the ModMiner FPGA was added
  477. ----------
  478. API V1.11 (BFGMiner v2.4.2)
  479. Modified API commands:
  480. 'save' no longer requires a filename (use default if not specified)
  481. 'save' incorrectly returned status E (error) on success before.
  482. It now correctly returns S (success)
  483. ----------
  484. API V1.10 (BFGMiner v2.4.1)
  485. Added API commands:
  486. 'stats'
  487. N.B. the 'stats' command can change at any time so any specific content
  488. present should not be relied upon.
  489. The data content is mainly used for debugging purposes or hidden options
  490. in BFGMiner and can change as development work requires
  491. Modified API commands:
  492. 'pools' added "Last Share Time"
  493. ----------
  494. API V1.9 (BFGMiner v2.4.0)
  495. Added API commands:
  496. 'restart'
  497. Modified API commands:
  498. 'notify' corrected invalid JSON
  499. ----------
  500. API V1.8 (BFGMiner v2.3.5)
  501. Added API commands:
  502. 'devdetails'
  503. Support for the ZTEX FPGA was added
  504. ----------
  505. API V1.8-pre (BFGMiner v2.3.4)
  506. Added API commands:
  507. 'devdetail'
  508. ----------
  509. API V1.7 (BFGMiner v2.3.4)
  510. Added API commands:
  511. 'removepool'
  512. Modified API commands:
  513. 'pools' added "User"
  514. From API version 1.7 onwards, reply strings in JSON and Text have the
  515. necessary escaping as required to avoid ambiguity
  516. For JSON the 2 characters '"' and '\' are escaped with a '\' before them
  517. For Text the 4 characters '|' ',' '=' and '\' are escaped the same way
  518. ----------
  519. API V1.6 (cgminer v2.3.2)
  520. Added API commands:
  521. 'pga'
  522. 'pgaenable'
  523. 'pgadisable'
  524. 'pgacount'
  525. Modified API commands:
  526. 'devs' now includes Icarus and BitForce FPGA devices
  527. 'notify' added "*" to the front of the name of all numeric error fields
  528. 'config' correct "Log Interval" to use numeric (not text) type for JSON
  529. Support for Icarus and BitForce FPGAs was added
  530. ----------
  531. API V1.5 was not released
  532. ----------
  533. API V1.4 (Kano's interim release of cgminer v2.3.1)
  534. Added API commands:
  535. 'notify'
  536. Modified API commands:
  537. 'config' added "Device Code" and "OS"
  538. Added "When" to the STATUS reply section of all commands
  539. ----------
  540. API V1.3 (cgminer v2.3.1-2)
  541. Added API commands:
  542. 'addpool'
  543. Modified API commands:
  544. 'devs'/'gpu' added "Total MH" for each device
  545. 'summary' added "Total MH"
  546. ----------
  547. API V1.2 (cgminer v2.3.0)
  548. Added API commands:
  549. 'enablepool'
  550. 'disablepool'
  551. 'privileged'
  552. Modified API commands:
  553. 'config' added "Log Interval"
  554. Starting with API V1.2, any attempt to access a command that requires
  555. privileged security, from an IP address that does not have privileged
  556. security, will return an "Access denied" Error Status
  557. ----------
  558. API V1.1 (cgminer v2.2.4)
  559. There were no changes to the API commands in cgminer v2.2.4,
  560. however support was added to cgminer for IP address restrictions
  561. with the --api-allow option
  562. ----------
  563. API V1.1 (cgminer v2.2.2)
  564. Prior to V1.1, devs/gpu incorrectly reported GPU0 Intensity for all GPUs
  565. Modified API commands:
  566. 'devs'/'gpu' added "Last Share Pool" and "Last Share Time" for each device
  567. ----------
  568. API V1.0 (cgminer v2.2.0)
  569. Remove default CPU support
  570. Added API commands:
  571. 'config'
  572. 'gpucount'
  573. 'cpucount'
  574. 'switchpool'
  575. 'gpuintensity'
  576. 'gpumem'
  577. 'gpuengine'
  578. 'gpufan'
  579. 'gpuvddc'
  580. 'save'
  581. ----------
  582. API V0.7 (cgminer v2.1.0)
  583. Initial release of the API in the main cgminer git
  584. Commands:
  585. 'version'
  586. 'devs'
  587. 'pools'
  588. 'summary'
  589. 'gpuenable'
  590. 'gpudisable'
  591. 'gpurestart'
  592. 'gpu'
  593. 'cpu'
  594. 'gpucount'
  595. 'cpucount'
  596. 'quit'
  597. ----------------------------------------
  598. miner.php
  599. =========
  600. miner.php is a PHP based interface to the BFGMiner RPC API
  601. (referred to simply as the API below)
  602. It can show rig details, summaries and input fields to allow you to change
  603. BFGMiner
  604. You can also create custom summary pages with it
  605. It has two levels to the security:
  606. 1) BFGMiner can be configured to allow or disallow API access and access level
  607. security for miner.php
  608. 2) miner.php can be configured to allow or disallow privileged BFGMiner
  609. access, if BFGMiner is configured to allow privileged access for miner.php
  610. ---------
  611. To use miner.php requires a web server with PHP
  612. Basics: On Xubuntu 11.04, to install Apache and PHP, the commands are:
  613. sudo apt-get install apache2
  614. sudo apt-get install php5
  615. sudo /etc/init.d/apache2 reload
  616. On Fedora 17:
  617. yum install httpd php
  618. systemctl restart httpd.service
  619. systemctl enable httpd.service --system
  620. On windows there are a few options.
  621. Try one of these (apparently the first one is easiest - thanks jborkl)
  622. http://www.easyphp.org/
  623. http://www.apachefriends.org/en/xampp.html
  624. http://www.wampserver.com/en/
  625. ---------
  626. The basic BFGMiner option to enable the API is:
  627. --api-listen
  628. or in your bfgminer.conf
  629. "api-listen" : true,
  630. (without the ',' on the end if it is the last item)
  631. If the web server is running on the BFGMiner computer, the above
  632. is the only change required to give miner.php basic access to
  633. the BFGMiner API
  634. -
  635. If the web server runs on a different computer to BFGMiner,
  636. you will also need to tell BFGMiner to allow the web server
  637. to access BFGMiner's API and tell miner.php where BFGMiner is
  638. Assuming a.b.c.d is the IP address of the web server, you
  639. would add the following to BFGMiner:
  640. --api-listen --api-allow a.b.c.d
  641. or in your bfgminer.conf
  642. "api-listen" : true,
  643. "api-allow" : "a.b.c.d",
  644. to tell BFGMiner to give the web server read access to the API
  645. You also need to tell miner.php where BFGMiner is.
  646. Assuming BFGMiner is at IP address e.f.g.h, then you would
  647. edit miner.php and change the line
  648. $rigs = array('127.0.0.1:4028');
  649. to
  650. $rigs = array('e.f.g.h:4028');
  651. See --api-network or --api-allow for more access details
  652. and how to give write access
  653. ---------
  654. Once you have a web server with PHP running
  655. copy your miner.php to the main web folder
  656. On Xubuntu 11.04
  657. /var/www/
  658. On Fedora 17
  659. /var/www/html/
  660. On Windows
  661. see your windows Web/PHP documentation
  662. Assuming the IP address of the web server is a.b.c.d
  663. Then in your web browser go to:
  664. http://a.b.c.d/miner.php
  665. Done :)
  666. ---------
  667. The rest of this documentation deals with the more complex
  668. functions of miner.php, using myminer.php, creating custom
  669. summaries and displaying multiple BFGMiner rigs
  670. ---------
  671. If you create a file called myminer.php in the same web folder
  672. where you put miner.php, miner.php will load it when it runs
  673. This is useful, to put any changes you need to make to miner.php
  674. instead of changing miner.php
  675. Thus if you update/get a new miner.php, you won't lose the changes
  676. you have made if you put all your changes in myminer.php
  677. (and don't change miner.php at all)
  678. A simple example myminer.php that defines 2 rigs
  679. (that I will keep referring to further below) is:
  680. <?php
  681. #
  682. $rigs = array('192.168.0.100:4028:A', '192.168.0.102:4028:B');
  683. #
  684. ?>
  685. Changes in myminer.php supersede what is in miner.php
  686. However, this is only valid for variables in miner.php before the
  687. 2 lines where myminer.php is included by miner.php:
  688. if (file_exists('myminer.php'))
  689. include_once('myminer.php');
  690. Every variable in miner.php above those 2 lines, can be changed by
  691. simply defining them in your myminer.php
  692. So although miner.php originally contains the line
  693. $rigs = array('127.0.0.1:4028');
  694. if you created the example myminer.php given above, it would actually
  695. change the value of $rigs that is used when miner.php is running
  696. i.e. you don't have to remove or comment out the $rigs line in miner.php
  697. It will be superseded by myminer.php
  698. ---------
  699. The example.php above also shows how to define more that one rig to
  700. be shown my miner.php
  701. Each rig string is 2 or 3 values separated by colons ':'
  702. They are simply an IP address or host name, followed by the
  703. port number (usually 4028) and an optional Name string
  704. miner.php displays rig buttons that will show the details of a single
  705. rig when you click on it - the button shows either the rig number,
  706. or the 'Name' string if you provide it
  707. PHP arrays contain each string separated by a comma, but no comma after
  708. the last one
  709. So an example for 3 rigs would be:
  710. $rigs = array('192.168.0.100:4028:A', '192.168.0.102:4028:B', '192.168.0.110:4028:C');
  711. Of course each of the rigs listed would also have to have the API
  712. running and be set to allow the web server to access the API - as
  713. explained before
  714. ---------
  715. So basically, any variable explained below can be put in myminer.php
  716. if you wanted to set it to something different from its default value
  717. and did not want to change miner.php itself every time you updated it
  718. Below is each variable that can be changed and an explanation of each
  719. ---------
  720. Default:
  721. $dfmt = 'H:i:s j-M-Y \U\T\CP';
  722. Define the date format used to print full length dates
  723. If you get the string 'UTCP' on the end of your dates shown, that
  724. means you are using an older version of PHP and you can instead use:
  725. $dfmt = 'H:i:s j-M-Y \U\T\CO';
  726. The PHP documentation on the date format is here:
  727. http://us.php.net/manual/en/function.date.php
  728. ---------
  729. Default:
  730. $title = 'Mine';
  731. Web page title
  732. If you know PHP you can of course use code to define it e.g.
  733. $title = 'My Rig at: '.date($dfmt);
  734. Which would set the web page title to something like:
  735. My Rig at: 10:34:00 22-Aug-2012 UTC+10:00
  736. ---------
  737. Default:
  738. $readonly = false;
  739. Set $readonly to true to force miner.php to be readonly
  740. This means it won't allow you to change BFGMiner even if the RPC API
  741. options allow it to
  742. If you set $readonly to false then it will check BFGMiner 'privileged'
  743. and will show input fields and buttons on the single rig page
  744. allowing you to change devices, pools and even quit or restart
  745. BFGMiner
  746. However, if the 'privileged' test fails, the code will set $readonly to
  747. true
  748. ---------
  749. Default:
  750. $userlist = null;
  751. Define password checking and default access null means there is no password
  752. checking
  753. $userlist is an array of 3 arrays e.g.
  754. $userlist = array('sys' => array('boss' => 'bpass'),
  755. 'usr' => array('user' => 'upass', 'pleb' => 'ppass'),
  756. 'def' => array('Pools'));
  757. 'sys' is an array of system users and passwords (full access)
  758. 'usr' is an array of user level users and passwords (readonly access)
  759. 'def' is an array of custompages that anyone not logged in can view
  760. Any of the 3 can be null, meaning there are none of that item
  761. All validated 'usr' users are given $readonly = true; access
  762. All validated 'sys' users are given the $readonly access you defined
  763. If 'def' has one or more values, and allowcustompages is true, then anyone
  764. without a password can see the list of custompage buttons given in 'def' and
  765. will see the first one when they go to the web page, with a login button at the
  766. top right
  767. From the login page, if you login with no username or password, it will show
  768. the first 'def' custompage (if there are any)
  769. If you are logged in, it will show a logout button at the top right
  770. ---------
  771. Default:
  772. $notify = true;
  773. Set $notify to false to NOT attempt to display the notify command table of data
  774. Set $notify to true to attempt to display the notify command on the single rig
  775. page
  776. If your older version of BFGMiner returns an 'Invalid command' because it
  777. doesn't have notify - it just shows the error status table
  778. ---------
  779. Default:
  780. $checklastshare = true;
  781. Set $checklastshare to true to do the following checks:
  782. If a device's last share is 12x expected ago then display as an error
  783. If a device's last share is 8x expected ago then display as a warning
  784. If either of the above is true, also display the whole line highlighted
  785. This assumes shares are 1 difficulty shares
  786. Set $checklastshare to false to not do the above checks
  787. 'expected' is calculated from the device Mh/s value
  788. So for example, a device that hashes at 380Mh/s should (on average) find a
  789. share every 11.3s
  790. If the last share was found more than 11.3 x 12 seconds (135.6s) ago, it is
  791. considered an error and highlighted
  792. If the last share was found more than 11.3 x 8 seconds (90.4s) ago, it is
  793. considered a warning and highlighted
  794. The default highlighting is very subtle
  795. ---------
  796. Default:
  797. $poolinputs = false;
  798. Set $poolinputs to true to show the input fields for adding a pool and changing
  799. the pool priorities on a single rig page
  800. However, if $readonly is true, it will not display them
  801. ---------
  802. Default:
  803. $rigs = array('127.0.0.1:4028');
  804. Set $rigs to an array of your BFGMiner rigs that are running format: 'IP:Port'
  805. or 'Host:Port' or 'Host:Port:Name'
  806. If you only have one rig, it will just show the detail of that rig
  807. If you have more than one rig it will show a summary of all the rigs with
  808. buttons to show the details of each rig - the button contents will be 'Name'
  809. rather than rig number, if you specify 'Name'
  810. e.g. $rigs = array('127.0.0.1:4028','myrig.com:4028:Sugoi');
  811. ---------
  812. Default:
  813. $rigipsecurity = true;
  814. Set $rigipsecurity to false to show the IP/Port of the rig in the socket error
  815. messages and also show the full socket message
  816. ---------
  817. Default:
  818. $rigtotals = true;
  819. $forcerigtotals = false;
  820. Set $rigtotals to true to display totals on the single rig page 'false' means
  821. no totals (and ignores $forcerigtotals)
  822. If $rigtotals is true, all data is also right aligned
  823. With false, it's as before, left aligned
  824. This option is just here to allow people to set it to false if they prefer the
  825. old non-total display when viewing a single rig
  826. Also, if there is only one line shown in any section, then no total will be
  827. shown (to save screen space)
  828. You can force it to always show rig totals on the single rig page, even if
  829. there is only one line, by setting $forcerigtotals = true;
  830. ---------
  831. Default:
  832. $socksndtimeoutsec = 10;
  833. $sockrcvtimeoutsec = 40;
  834. The numbers are integer seconds
  835. The defaults should be OK for most cases
  836. However, the longer SND is, the longer you have to wait while PHP hangs if the
  837. target BFGMiner isn't running or listening
  838. RCV should only ever be relevant if BFGMiner has hung but the API thread is
  839. still running, RCV would normally be >= SND
  840. Feel free to increase SND if your network is very slow or decrease RCV if that
  841. happens often to you
  842. Also, on some windows PHP, apparently the $usec is ignored (so usec can't be
  843. specified)
  844. ---------
  845. Default:
  846. $hidefields = array();
  847. List of fields NOT to be displayed
  848. You can use this to hide data you don't want to see or don't want shown on a
  849. public web page
  850. The list of sections are:
  851. SUMMARY, POOL, PGA, GPU, NOTIFY, CONFIG, DEVDETAILS, DEVS
  852. See the web page for the list of field names (the table headers)
  853. It is an array of 'SECTION.Field Name' => 1
  854. This example would hide the slightly more sensitive pool information:
  855. Pool URL and pool username:
  856. $hidefields = array('POOL.URL' => 1, 'POOL.User' => 1);
  857. If you just want to hide the pool username:
  858. $hidefields = array('POOL.User' => 1);
  859. ---------
  860. Default:
  861. $ignorerefresh = false;
  862. $changerefresh = true;
  863. $autorefresh = 0;
  864. Auto-refresh of the page (in seconds) - integers only
  865. $ignorerefresh = true/false always ignore refresh parameters
  866. $changerefresh = true/false show buttons to change the value
  867. $autorefresh = default value, 0 means don't auto-refresh
  868. ---------
  869. Default:
  870. $placebuttons = 'top';
  871. Where to place the Refresh, Summary, Custom Pages, Quit, etc. buttons
  872. Valid values are: 'top' 'bot' 'both'
  873. anything else means don't show them - case sensitive
  874. ---------
  875. Default:
  876. $miner_font_family = 'verdana,arial,sans';
  877. $miner_font_size = '13pt';
  878. Change these to set the font and font size used on the web page
  879. ---------
  880. Default:
  881. $colouroverride = array();
  882. Use this to change the web page colour scheme
  883. See $colourtable in miner.php for the list of possible names to change
  884. Simply put in $colouroverride, just the colours you wish to change
  885. e.g. to change the colour of the header font and background
  886. you could do the following:
  887. $colouroverride = array(
  888. 'td.h color' => 'green',
  889. 'td.h background' => 'blue'
  890. );
  891. ---------
  892. Default:
  893. $allowcustompages = true;
  894. Should we allow custom pages?
  895. (or just completely ignore them and don't display the buttons)
  896. ---------
  897. OK this part is more complex: Custom Summary Pages
  898. A custom summary page in an array of 'section' => array('FieldA','FieldB'...)
  899. The section defines what data you want in the summary table and the Fields
  900. define what data you want shown from that section
  901. Standard sections are:
  902. SUMMARY, POOL, PGA, GPU, NOTIFY, CONFIG, DEVDETAILS, DEVS, STATS, COIN
  903. Fields are the names as shown on the headers on the normal pages
  904. Fields can be 'name=new name' to display 'name' with a different heading
  905. 'new name'
  906. There are also now joined sections:
  907. SUMMARY+POOL, SUMMARY+DEVS, SUMMARY+CONFIG, DEVS+NOTIFY, DEVS+DEVDETAILS
  908. SUMMARY+COIN
  909. These sections are an SQL join of the two sections and the fields in them
  910. are named section.field where section. is the section the field comes from
  911. See the example further down
  912. Also note:
  913. - empty tables are not shown
  914. - empty columns (e.g. an unknown field) are not shown
  915. - missing field data shows as blank
  916. - the field name '*' matches all fields except in joined sections
  917. (useful for STATS and COIN)
  918. There are 2 hard coded sections:
  919. DATE - displays a date table like at the start of 'Summary'
  920. RIGS - displays a rig table like at the start of 'Summary'
  921. Each custom summary requires a second array, that can be empty, listing fields
  922. to be totalled for each section
  923. If there is no matching total data, no total will show
  924. ---------
  925. Looking at the Mobile example:
  926. $mobilepage = array(
  927. 'DATE' => null,
  928. 'RIGS' => null,
  929. 'SUMMARY' => array('Elapsed', 'MHS av', 'Found Blocks=Blks',
  930. Accepted', 'Rejected=Rej', 'Utility'),
  931. 'DEVS+NOTIFY' => array('DEVS.Name=Name', 'DEVS.ID=ID', 'DEVS.ProcID=Proc',
  932. 'DEVS.Status=Status',
  933. 'DEVS.Temperature=Temp', 'DEVS.MHS av=MHS av',
  934. 'DEVS.Accepted=Accept', 'DEVS.Rejected=Rej',
  935. 'DEVS.Utility=Utility', 'NOTIFY.Last Not Well=Not Well'),
  936. 'POOL' => array('POOL', 'Status', 'Accepted', 'Rejected=Rej', 'Last Share Time'));
  937. $mobilesum = array(
  938. 'SUMMARY' => array('MHS av', 'Found Blocks', 'Accepted', 'Rejected', 'Utility'),
  939. 'DEVS+NOTIFY' => array('DEVS.MHS av', 'DEVS.Accepted', 'DEVS.Rejected', 'DEVS.Utility'),
  940. 'POOL' => array('Accepted', 'Rejected'));
  941. $customsummarypages = array('Mobile' => array($mobilepage, $mobilesum));
  942. This will show 5 tables (according to $mobilepage)
  943. Each table will have the chosen details for all the rigs specified in $rigs
  944. DATE
  945. A single box with the web server's current date and time
  946. RIGS
  947. A table of the rigs: description, time, versions etc
  948. SUMMARY
  949. This will use the API 'summary' command and show the selected fields:
  950. Elapsed, MHS av, Found Blocks, Accepted, Rejected and Utility
  951. However, 'Rejected=Rej' means that the header displayed for the 'Rejected'
  952. field will be 'Rej', instead of 'Rejected' (to save space)
  953. Same for 'Found Blocks=Blks' - to save space
  954. DEVS+NOTIFY
  955. This will list each of the devices on each rig and display the list of
  956. fields as shown
  957. It will also include the 'Last Not Well' field from the 'notify' command
  958. so you know when the device was last not well
  959. You will notice that you need to rename each field e.g. 'DEVS.Name=Name'
  960. since each field name in the join between DEVS and NOTIFY is actually
  961. section.fieldname, not just fieldname
  962. The join code automatically adds 2 fields to each GPU device: 'Name', 'ID',
  963. and 'ProcID'. They don't exist in the API 'devs' output but we can correctly
  964. calculate them from the GPU device data. These two fields are used to join
  965. DEVS to NOTIFY: i.e. find the NOTIFY record that has the same Name/ID/ProcID
  966. as the DEVS record and join them.
  967. POOL
  968. This will use the API 'pools' command and show the selected fields:
  969. POOL, Status, Accepted, Rejected, Last Share Time
  970. Again, I renamed the 'Rejected' field using 'Rejected=Rej', to save space
  971. $mobilesum lists the sections and fields that should have a total
  972. You can't define them for 'DATE' or 'RIGS' since they are hard coded tables
  973. The example given:
  974. SUMMARY
  975. Show a total at the bottom of the columns for:
  976. MHS av, Found Blocks, Accepted, Rejected, Utility
  977. Firstly note that you use the original name i.e. for 'Rejected=Rej'
  978. you use 'Rejected', not 'Rej' and not 'Rejected=Rej'
  979. Secondly note that it simply adds up the fields
  980. If you ask for a total of a string field you will get the numerical
  981. sum of the string data
  982. DEVS+NOTIFY
  983. Simply note in this join example that you must use the original field
  984. names which are section.fieldname, not just fieldname
  985. POOL
  986. Show a total at the bottom of the columns for:
  987. Accepted and Rejected
  988. Again remember to use the original field name 'Rejected'
  989. ---------
  990. With BFGMiner 2.10.1 and later, miner.php includes an extension to the custom
  991. pages that allows you to apply SQL style commands to the data: where, group,
  992. and having
  993. As an example, miner.php includes a more complex custom page called 'Pools'
  994. this includes the extension:
  995. $poolsext = array(
  996. 'POOL+STATS' => array(
  997. 'where' => null,
  998. 'group' => array('POOL.URL', 'POOL.Has Stratum',
  999. 'POOL.Stratum Active'),
  1000. 'calc' => array('STATS.Bytes Sent' => 'sum',
  1001. 'STATS.Bytes Recv' => 'sum'),
  1002. 'having' => array(array('STATS.Bytes Recv', '>', 0)))
  1003. );
  1004. This allows you to group records together from one or more rigs
  1005. In the example, you'll get each Pool (with the same URL+Stratum info) listed
  1006. once for all rigs and a sum of each of the fields listed in 'calc'
  1007. 'where' and 'having' are an array of fields and restrictions to apply
  1008. In the above example, it will only display the rows where it contains the
  1009. 'STATS.Bytes Recv' field with a value greater than zero
  1010. If the row doesn't have the field, it will always be included
  1011. All restrictions must be true in order for the row to be included
  1012. Any restiction that is invalid or unknown is true
  1013. An empty array, or null, means there are no restrictions
  1014. A restriction is formatted as: array('Field', 'restriction', 'value')
  1015. Field is the simple field name as normally displayed, or SECTION.Field if it is
  1016. a joined section (as in this case 'POOL+STATS')
  1017. The list of restrictions are:
  1018. 'set' - true if the row contains the 'Field' ('value' is not required or used)
  1019. '=', '<', '<=', '>', '>' - a numerical comparison
  1020. 'eq', 'lt', 'le', 'gt', 'ge' - a case insensitive string comparison
  1021. You can have multiple restrictions on a 'Field' - but all must be true to
  1022. include the row containing the 'Field'
  1023. e.g. a number range between 0 and 10 would be:
  1024. array('STATS.Bytes Recv', '>', 0), array('STATS.Bytes Recv', '<', 10)
  1025. The difference between 'where' and 'having' is that 'where' is applied to the
  1026. data before grouping it and 'having' is applied to the data after grouping it
  1027. - otherwise they work the same
  1028. 'group' lists the fields to group over and 'calc' lists the function to apply
  1029. to other fields that are not part of 'group'
  1030. You can only see fields listed in 'group' and 'calc'
  1031. A 'calc' is formatted as: 'Field' => 'function'
  1032. The current list of operations available for 'calc' are:
  1033. 'sum', 'avg', 'min', 'max', 'lo', 'hi', 'count', 'any'
  1034. The first 4 are as expected - the numerical sum, average, minimum or maximum
  1035. 'lo' is the first string of the list, sorted ignoring case
  1036. 'hi' is the last string of the list, sorted ignoring case
  1037. 'count' is the number of rows in the section specified in the calc e.g.
  1038. ('DEVS.Name' => 'count') would be the number of DEVS selected in the 'where'
  1039. of course any valid 'DEVS.Xyz' would give the same 'count' value
  1040. 'any' is effectively random: the field value in the first row of the grouped data
  1041. An unrecognised 'function' uses 'any'