I understand you can use the Dude very well with all the mikrotik routers, AP’s and clients very well. But has anyone actually set up a system to integrate with all these routers to pull the data and have an actual CRM with ticketing and graphs etc?
Also can MT do net masquerading?
Of course MT can Masqurade!
As far as dude creating tickets etc, not really, its not a CRM system, but it can monitor your system. You can though, have DUDE e-mail to a ticketing system, that auto creates tickets 
Done that! Hit up the dude consultants list!
No I understand what the Dude does etc because I’ve used it in the past. I was just wondering if there was any sort of CRM that will easily tie in with Mikrotik, and the Dude etc. If anyone has successfully done that.
We will be adding a few MT routers and I was also curious about the masquerading. From what I’ve seen it looks identical to regular iptables.
I’m also interested in hearing what systems people use, and how they all tie them together.
/ip firewall nat add chain=srcnat action=masquerade out-interface=Public
Salesforce CRM could possibly be used.
They have a feature where if you develop a solution (e.g. integrating with other apps) that many others might want to use you can sell it via their site e.g. if User Manager was ever integrated with Salesforce that could be popular since Slaesforce is one of the leading CRM solutions (but not cheap)
So you could solve a problem and make money with the solution!
for a complete isp management solution, and easy to integrate into mikrotik, i suggest you use lms (lms.org.pl)
i can provide install and custom setup with a small fee. or you can try to learn it by yourself…
Can you supply contact details? I checked your profile and nothing there. 
first, look at their software, it’s not that hard… www.lms.org.pl
i’ve been working with lms since 2005, and managed a isp with 3000+ customers
it can do for you everything you want from bookkeeping to hosting, and everything an isp needs (i was a beta tester/developer for them, and i provided several ideas, to make the program work better, and more easy to use.)
for a time, i helped other people thru’ the mailing list but now i don’t have the time and nerves to do it for free, sorry.
if you are really interested, you can contact me via email, and show you what it can do, or can’t do for you.
reach me at brosky at gmail dot com
ps. that product is not a competition to mikrotik, i say they complete each other.
mikrotik offers hardware connectivity, lms offers customer invoicing, bandwidth limitation, customer management and much more. it’s a free , open source software, while others that do the same thing, cost hundreds of $$ or EUR.
Hey yah that LMS looks pretty slick and quick. Very nice little CRM but it doesn’t do any monitoring right? No graphing or shaping or management of networks. From my initial look at it, looks lke its just a CRM, but I guess you could link information from other graphs and monitoring tools. Oh after re-reading you said it could do bandwidth limitation.. it interfaces with mikrotiks? What do you do place a mikrotik at particular locations and the system interfaces with it and adds queues and such?
No contact info for me because I don’t want to be contacted / spammed. If you have something to say out in the open is where is should be This is a discussion forum I am participating in.
I’m curious as to other interfaces people have put together. There are not too many solid “packages” out there that do it all without having to be a rocket scientist to run. I’m curious to see how others have tied in their Mikrotik networks with CRM’s etc.
Yep thanks I’ve tested it out and it works well.
well, lonecrow, you are wrong
LMS DOES traffic shaping , graphing and management of networks. Like I said, it looks easy, but it isn’t , from some point…
For shaping , you have multiple possibilities. 1st, it’s the firewall combined htb that does your shaping, but that in my opinion, is not a solution when you have more than 500 customers.
The ideea behind the script is this:
print OUTFILE "$iptables_binary -t mangle -A LIMITS -d $ipaddr -j MARK --set-
mark $iptid\n";
print OUTFILE "$tc_binary class add dev $if parent 1:9999 classid 1:".$htbid{
$if}." htb rate ".$row->{'uprate'}."kbit ceil ".$row->{'upceil'}."kbit burst ".($row->{'uprate'} / 8) . "kbit\n";
print OUTFILE "$tc_binary filter add dev $if protocol ip parent 1: handle $ip tid fw classid 1:".$htbid{$if}."\n";
But, LMS has a little magic, it has a script called lms-magic-script, who can extract from it’s database each variable , and use it in your custom limits script
For graphing, it has basic rrd graphs for each user, or the built in iptables script, that can offer you per customer traffic data, with precision of minutes.
Problem is that in a few days you’ll have a mysql database big as 500mb (0.5mb customer data, 499.5 traffic data). I prefered to use a third party traffic accounting tool, on a different machine. Of course, this one depends if you really need to offer traffic accounting data to your customers via userpanel (lms has a frontend for the regular customer, who can submit tickets, view invoice/accounting data, traffic, helpdesk, etc)
and it’s not a CRM . It’s a LMS (Lan Management System) On my network with over 3000+ customers, i did everything i needed with it (load balancing 10 ADSL’s, vpn’s, pppoe, ticketing, hosting, providing internet to a whole city.)
Ah, and one feature that i like, is the network management. It draws your network, viewing your entire grid, online/offline users, you can see instantly where a malfunction is, what equipment is damaged/offline
for better support, subscribe to their mailing list. It’s in Polish The english one does not have any activity lately. Or mail me.
Could anyone answer to my post?
http://forum.mikrotik.com/t/where-should-i-implement-htb/39455/1
Normis, Chupaka, members, staffs, everyone… can you help please???