Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

cm 5 database

is the cm5 database completely locked down now or you can still run SQL queries against the database or create a new database under the structure as you could in version 4x?

8 REPLIES

Re: cm 5 database

I am not sure about creating a new database, but definitely you can run commands to add, update items in the database via command line. I have had to do that for some temp bug fixes.

HTH

Sankar

PS: please remember to rate posts!

Gold

Re: cm 5 database

To add to Shakar's note, you can run queries from the CLI using the command "run sql" to retrieve data from the database. Adding database is not allowed.

Community Member

Re: cm 5 database

is there a copy of the database table names and schema anywhere?

also have you had any joy with using the file get method from the CLI? I keep getting " Error cannot contact SFTP server on port 22"

Gold

Re: cm 5 database

to know what DB and table CM contains, you can use the command "show tech tables" this is give u a DBDump in a text file.

Yes, I've used CLI to get files from SFTP server. Do you have an SFTP Server configured and accepting connections ?? You need SFTP Server to download a file from CM using CLI

Re: cm 5 database

If looking for a SFTP freeware server for Windows, try Freeftpd.

http://www.sofotex.com/FreeFTPd-download_L30099.html

Community Member

Re: cm 5 database

There is a free IBM Informix ODBC driver here: http://www14.software.ibm.com/webapp/download/search.jsp?rs=ifxic

You just need to register a name and email address to get it. However how you configure the options (protocol/setnet/etc) I don't know but I think this is a good step to being able to use something a bit more friendly that the sql utils provided.

Anyone know how to configure the options?

Community Member

Re: cm 5 database

Anyone figure this out yet?

Community Member

Re: cm 5 database

I spoke to a TAC guy about this yesterday - he said they are getting a tonne of complaints about this.

117
Views
15
Helpful
8
Replies
CreatePlease to create content