Clients signal strenght/ccq into remote linux SQL server?

RouterOS Scripting
1

Is there a simple solution to export data from registration table into remote linux sql server from MT device od DUDE for customers to access their signal strenght/quality database ??

This is usable for users can check if their signal level is good or bad with one click on website.

Is there non API solution?

2

Hi there

For NON-API solution i think you can locally save registration table and fetch it from Router using SCP/FTP to a server and parse it to put into database.

Saving file:

[admin@Technologic] /interface wireless registration-table> print stats file=stats

File content:

# jan/ 3/1970  2:48:48 by RouterOS 4.16
# software id = E45Y-YZMH
#
 0 interface=wlan2 mac-address=00:27:13:7D:F5:B4 ap=no wds=no rx-rate="1Mbps" 
   tx-rate="2Mbps" packets=16,12 bytes=4136,4104 frames=16,12 
   frame-bytes=4064,4032 hw-frames=16,54 hw-frame-bytes=4448,5328 
   tx-frames-timed-out=0 uptime=13s last-activity=480ms 
   signal-strength=-60dBm@1Mbps signal-to-noise=38dB 
   strength-at-rates=-60dBm@1Mbps 480ms tx-ccq=40% p-throughput=1759 
   ack-timeout=30 802.1x-port-enabled=yes wmm-enabled=no

IMHO API would be better for this task becouse you dont need to do on router locally at all and all logic is in server scripts.

3

I found some php scripts that do exactly what you said…
One php script logs to MT over ftp and downloading…
Other php parsing data into sql.

I have more than 20MT devices with different ROS and parsing is not the same … :slight_smile:
Second problem is in 2.9.xx versions you cannot see ccq in registration table…

PHP that I have, calculate ccq over signal strenght but i think this is not accurate.