LMS 2.6 database restore problem

Unanswered Question
Nov 15th, 2007

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?


I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Joe Clarke Thu, 11/15/2007 - 08:16

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.

eric.e.eastridge Thu, 11/15/2007 - 11:49

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.

Joe Clarke Thu, 11/15/2007 - 11:59

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.

eric.e.eastridge Thu, 11/15/2007 - 12:10

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.

Joe Clarke Thu, 11/15/2007 - 12:11

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.

eric.e.eastridge Thu, 11/15/2007 - 12:13

That's what I was suspecting. At least I'll make sure to grab a copy of my .lic file. Thanks for the try!


This Discussion