Telnet API & Mysql & Cisco Switch

Posted on 2013-10-07
Medium Priority
Last Modified: 2014-03-05
Hi all,

In theory would the below be possible and has anyone had experience with this before?

Assuming the following.

Stack of cisco switches sitting on a remote site.
Onsite router configured as remote terminal server. SSH & telnet
Mysql database with required information. switch & port information, customer VLANs etc....

In theory would the following be possible

Use the telnet API to remotely connect and configure those switches using information stored in the MYSQL database via the remote terminal server?

Question by:VantaBods
LVL 27

Accepted Solution

skullnobrains earned 1500 total points
ID: 39551735
you can generate your cisco conf from information in the database and apply the conf using either the web gui or telnet/ssh. you can run all this from within a telnet/ssh session to your router. you'll need a decent shell on the router if you want to be able to send sql queries and do proper scripting. you should even be able to automate stuff so that changes in the db are picked automagically.

but then i'm unsure this will be helpful in real world but that would depend on your setup. also note that you don't have to generate ALL the config. it might be both easier and wiser to only generate the needed part (i guess ports config). beware that the cisco command line changes a little when you change versions so don't apply upgrades without testing again.
LVL 84

Expert Comment

by:Dave Baldwin
ID: 39618462
MySQL uses it's own secure protocol and telnet can not be used to get info directly from it.  You generally need an application written in a language with a MySQL driver (Perl and PHP have such drivers) to get info from a MySQL server.  The only thing you can do with telnet or SSH is use the command line 'mysql' interface which lets you view info in the database.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Is your computer hacked? learn how to detect and delete malware in your PC
In this article, WatchGuard's Director of Security Strategy and Research Teri Radichel, takes a look at insider threats, the risk they can pose to your organization, and the best ways to defend against them.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question