query embedded SOLID database in WCS

[vanoverschelde]

I was wondering if it is possible to query the WCS embedded SOLID DB with the Solid JDBC driver?

I am using syslog to analyze the logs but I would like to have the mapping MAC to AP name available from outside WCS so I can send more readable error mails.

[drolemc]

Try:

http://www.cisco.com/en/US/products/ps6305/products_data_sheet0900aecd802570d0.html

[Toivo]

We're interested in the ability to query the DB as well, though mostly to get automated access to heat maps for external documentation.

[srego4]

were you able to do this?  ie query the solid db? or acces

s it?

thks

[Toivo]

Nope :-(

[Lucien Avramov]

I am attaching a DB dump so you can see the tables.

[Toivo]

Thanks!

[Lucien Avramov]

Great!

I guess this resolves your question.

[srego4]

hi lucien,

so what is the default dbname, userid and pwd to connect?

also which driver did u use?

thanks

[c0v3rr1d3]

I too needed this information.

[Stephan Spittaler]

Hi there,

Please have a look to this post: https://supportforums.cisco.com/message/3683444.

It explains how you can change the password to directly access the WCS DB.

HTH

---

Stephan