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?
-
-
cieplik206
Trainer
- Posts: 290
- Joined:
- Contact:
Re: Clients signal strenght/ccq into remote linux SQL server
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:
File content:
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.
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:
Code: Select all
[admin@Technologic] /interface wireless registration-table> print stats file=statsFile content:
Code: Select all
# 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
Re: Clients signal strenght/ccq into remote linux SQL server
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 ...
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.
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 ...
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.
Who is online
Users browsing this forum: No registered users and 24 guests