cm 5 database

[mymite060708]

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?

[thisisshanky]

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!

[mchandak]

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.

[mymite060708]

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"

[mchandak]

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

[thisisshanky]

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

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

[a.leahy]

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?

[sequent-is]

Anyone figure this out yet?

[a.leahy]

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