LMS 2.6 problem with "odbc".tmplorig

stevejhale · ‎12-11-2007

Due to a little script running to remove .tmp files these files have been removed from the system. We are running a Windows 2000 server. I am looking to recreate this file or run a database clean then reimport via CSV. Can anyone offer any help with this issue? If I took a copy of the odbc tmplorig file from another install then ran the commands to clean the db would this work?

Joe Clarke · ‎12-11-2007

You can copy an orig file from another LMS server (provided it's the same version of LMS). If all that is missing is the tmplorig, you do not need to run anything after copying the file over.

stevejhale · ‎12-12-2007

Excellent thank you very much.

stevejhale · ‎12-13-2007

What happened was a script was setup by another team to del *.tmp /s so this odbc file was involved also involved is odbc.tmpl am I ok to copy this as well (from another system)?

Joe Clarke · ‎12-13-2007

No, this file cannot be copied over. This file stores the current database password. If this file is lost, and you do not have a backup, then you will have to reinitialize your database. To do that, run:

NMSROOT\bin\perl NMSROOT\bin\dbRestoreOrig.pl dsn=DSN dmprefix=DMPREFIX

Where DSN is the datasource name (e.g. rmeng) and DMPREFIX is the Daemon Management prefix (e.g. RME).

stevejhale · ‎12-14-2007

I tried this and got the following message, I have an import file ready and all I really need is a clean new databse to import to. Thamks for your assistance.

perl dbRestoreOrig.pl dsn=ani dmprefix=ANI

D:\CSCOpx\bin>perl dbRestoreOrig.pl dsn=cmf dmprefix=Cmf

ERROR: dmprefix specified is invalid.

ERROR: The dsn cmf is currently registered using dmprefix ANI

Joe Clarke · ‎12-14-2007

Okay, it looks like you've copied the ani odbc.tmpl to cmf. That won't work. Copy the cmf odbc.tmplorig to odbc.tmpl, then try running the dbRestoreOrig.pl command.