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!
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: