how can we add sqlite to my routerboards!
becouse i dont want to change my firmaware to openwrt
You can’t.
why ?
I HAVE DATA COMMING IN FORM THE SERIAL PORT THAT I WNAT TO BUFFER ON THE BOARD IF THE WLAN CONNECTION IS LOST AS THE RB WILL BE MOVING AROUND
SO IF THE CONNECTION IS LOST FOR 1 SEC OR SOMTHING
I JUST WANT TO USE IT FOR A BUFFER SO THAT THE DATA DOESNT GET LOST IN ANY WAY
there are other ways how to do this, you don’t have to buffer anything, and you don’t have to use any databases!
use either WDS or the new HWMP+ Mesh. Those technologies already have taken care of these problems, so you don’t have to solve them yourself. Data WILL NOT BE LOST during reconnect to other AP, if you use HWMP or WDS. Forget about Sqlite
AND IF I WANT TO PULL THE DATA into a sql server so i can store the data
question have you got a script for a basic firewall
What data are you wanting to store? You never need to store packets, you just need to buffer them until you can send them along the proper destination.
What are you using the serial port for? The only mikrotik packages that use the serial port are UPS & GPS, neither of which need to have data stored.
Routerboards are not servers, they are routers, they don’t have the storage for databases.
Store the items on a server. You can log to a remote syslog server. And if you want to store a copy of the traffic look into netflow, packet sniffer and torch
remote login! the router board works like this if set up right ip serial converter so no need to buy any converters
so any serial device works on it
no need for packages
what im working on is the board is on a tranes engenmanagment system when the train comes in to the station it will pull the log off of it and send it to control so no need to stop the train for this data
it all works but now im putting everyting into one programe to control more the one train