07-03-2007 05:52 AM
im in the process of upgrading a CiscoWorks LMS server to the latest software(years of neglect by the now fired tech) There used to be a way to delete the database from a command prompt via a perl script if I remember correctly. Init.db or init_db I believe the command was. I cant seem to find that command in any of the documentation.
Does anyone know if that stiil exists.
Or maybe a better question is How do I wipe out the database and start with a clean slate without veing to uninstall Ciscoworks and reinstall all the applications?
Thank You
07-03-2007 06:15 AM
You can do the following to wipe out the LMS 2.5/2.6 databases
Stop the daemon manager
perl dbRestoreOrig.pl dsn=rmeng dmprefix=RME
perl dbRestoreOrig.pl dsn=ani dmprefix=ANI
If you have DFM installed:
NMSROOT\bin\dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM
NMSROOT\bin\dbRestoreOrig.pl dsn=dfmInv dmprefix=INV
NMSROOT\bin\dbRestoreOrig.pl dsn=dfmFh dmprefix=FH
Clear CMF DB last:
(If on Windows use the perl option to run the command for all of the above and below)
perl dbRestoreOrig.pl dsn=cmf dmprefix=Cmf
Start the daemon manager
07-03-2007 06:33 AM
I am running this on Windows server. Is the syntax the same? Which directory to I need to run them from
Thank You
07-03-2007 06:39 AM
Here's the syntax for Windows:
net stop crmdmgtd
NMSROOT\bin\perl dbRestoreOrig.pl dsn=rmeng dmprefix=RME
NMSROOT\bin\perl dbRestoreOrig.pl dsn=ani dmprefix=ANI
If you have DFM installed:
NMSROOT\bin\perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM
NMSROOT\bin\perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV
NMSROOT\bin\perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH
Clear CMF DB last:
NMSROOT\bin\perl dbRestoreOrig.pl dsn=cmf dmprefix=Cmf
NOTE -- NMSROOT refers to the install directory of LMS (default on Windows is c:\progra~1\CSCOpx
07-03-2007 06:48 AM
Thank you very much!!!
07-03-2007 06:42 AM
cd\Program Files\CSCOpx\bin
echo y|perl dbRestoreOrig.pl dsn=cmf dmprefix=Cmf
#I didn't know about the ANI line mentioned by the previous post so I added it just now in the post. Not sure what it will do. Currently it is commented out, so run at your perril
#echo y|perl dbRestoreOrig.pl dsn=ani dmprefix=ANI
echo y|perl dbRestoreOrig.pl dsn=rmeng dmprefix=RME
echo y|perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV
echo y|perl dbRestoreOrig.pl dsn=dfmFh dmprefix=FH
echo y|perl dbRestoreOrig.pl dsn=dfmEpm dmprefix=EPM
cd\Program Files\Internetwork Performance Monitor\Server\bin
echo y|ipm dbclean
cd\program files\cscopx\bin
echo you need to run the following to complete:
echo perl ..\campus\bin\reinitdb.pl -restore
echo have a nice day
above is from a batch file I wrote to do this when I was deleting things out and trying different ways to get the data in. Stop the deamon manager first then run this from the drive that CiscoWorks is installed. In my case I have all modules on the same server. This will restore the original databases or create new ones for all modules starting with Common Services. Then RME. Then 3 lines for DFM. Followed by IPM and then Campus Manager. However the batch does not do campus manager. You must past what the patch shows you on your own as for some reason the echo y| before the command causes something funny to happen.
good luck
Edwin Thornhill
07-03-2007 06:50 AM
Thank You
07-03-2007 07:30 AM
The only thing I see wrong with your batch is that you are wiping out CMF first, this should be done last.
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: