11-15-2007 08:09 AM
I had a crash of my Windows2003 server running LMS 2.6. We managed to restore the OS, LMS application, etc. I try running the restorebackup.pl script, but get an error saying the database password has changed. Is there a way to get around this, or just create empty databases (for all installed applications) and start from scratch?
Thanks!
11-15-2007 08:16 AM
You can first try resetting the database's password using the NMSROOT\bin\dbpasswd.pl script (NMSROOT\bin\perl NMSROOT\bin\dbpasswd.pl). If that doesn't work, then you can reinitialize the database using the NMSROOT\bin\dbRestoreOrig.pl command.
11-15-2007 11:49 AM
Unfortunately neither of those work, as the odbc.tmpl files are missing. These were missed in the backup by the application, or by the sysadmin.
11-15-2007 11:59 AM
Ouch, that should not happen. The odbc.tmpl files should be backed up to REV/APP/APP.tmpl (e.g. 0/cmf/cmf.tmpl). If that does not happen, you should at least be able to reinitialize the database using dbRestoreOrig.pl provided the original database file and odbc.tmplorig exist.
11-15-2007 12:10 PM
I have no "odbc".tmplorig files anywhere. Is there a way to copy the "odbc".tmpl files and modify them to act as the original? I can copy a version of the .db file from the backup directory.
11-15-2007 12:11 PM
At this point, I don't think you can trust the application data that was backed up by your sysadmin. It might be safer to completely uninstall LMS, then reinstall and re-patch it. Once it is back to the current patch rev, then you can restore the LMS backup that was taken.
11-15-2007 12:13 PM
That's what I was suspecting. At least I'll make sure to grab a copy of my .lic file. Thanks for the try!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide