Cisco :: LMS 3.2 - How To Access Database
Sep 22, 2011what is the database to use cisco LMS3.2 and how to access the database?
View 3 Replieswhat is the database to use cisco LMS3.2 and how to access the database?
View 3 Replieswhat is the easiest method permitting a local and a remote pc to access the same database ? They both have internet access.
View 3 Replies View RelatedBecause of limited budget and a paranoid boss, the MS Access database at work is running through a simple Linksys wireless E2000 N router rather than a more dedicated server setup.A desktop server PC is storing the Access database and 3-4 laptops are connecting to the split database linked tables via laptop wireless N adapters only.Upon having several people accessing and updating records we've noticed a huge amount of instability frequent network interruptions.I have several theories/observations:
1) While not an ideal location (one end of the building), signal strength is consistently shown as 4/5 bars to 5/5 bars, even through several walls
2) Interference: Several other routers, all on 2.4Ghz could be creating too much interference. (none of the laptops support 5Ghz)
3) Number of individuals accessing the database at one time. This is where I'm unclear. Could having 3-4 people working on the database at once pose any potential problems? I'd ordinarily think not but I am coming up short with explanations.
Last week two of us were working with the database, updating records and such, from probably 100 ft or more away with no issues. Then the last few days just to stay connected requires being within 5-10 feet of the router AT MOST. No settings have been changed and network disconnects/interruptions in Access are happening every few minutes.
Our company has a Server in the office to which we all map network drives.This server is backed up to a Cloud Server (egnyte.com). Whenever I am working on a database on the mapped network drive, it freezes up after 5-10 minutes with the alert "Your network access was interrupted.To continue, close the database,and then open it again."
This problem does not occur with any other Office Products,only Access.It happens to all databases on the server and to all users.
It does not do this when the file is saved on my desktop or when I am working on it directly through the cloud server. When working on the cloud server, however, I went to Compact and Repair my database and a window came up saying the file location did not exist and my whole database disappeared. It was already saved in the file location, I was just compacting and repairing.
Is there some problem with using a local server that backs up to a cloud that makes it lose connectivity every few minutes? Why is this only happening with Access?
How do I, if I even can, adjust the MAC table timeout from 5 minutes to whatever is bigger and allowable?
I would like to also like to change the ARP table timeout as well.
I need to generate an ODBC connection to the upm Datasource on LMS 4.1 running on Win2K8. I have successfully built connections to cmf, ipm and rmeng, however UPM keeps failing saying that the Database is not found.
Here are my settings.
Driver = CiscoWorks Embedded Database
ODBC Tab - Data source name = upm
ODBC Tab - Description = Device Performance
Login Tab - Supply user ID and Password is selcted
Login Tab - User ID = lmsdatafeed (i have tried DBA as well)
Login Tab - Password = set using the password I estabplished with the dbaccess.pl and dbpasswd.pl scripts
Database.Server name = upmEng
Network.TCP/IP = HOST=<lms server ip>;DOBROADCAST=NO;ServerPort= 43800
I validated the server port using netstat -a -b -o and matching up the PID with the UPMDBEngine process shown in the LMS Manage Processes window.Windows firewalls on the remote machine and the LMS server are off.
If i reinialize(restore) the cmf database.do i need to reinialize all the databases.???
or if i reinialize the cmf database and do bulk import the devices is enough?
I would like to know if its possible setup database replication from Cisco ACS 4.2 server to ACS 5.4 server ?
View 3 Replies View RelatedI am not able to replicate Database between two ACS SE 4.2. I am getting the following error:
Inbound database replication from ACS 'ACS_BEX_001' denied - shared secret mismatch.
The configuration apparently is ok. I am attaching the configuration from both ACS.
We are using CWLMS 2.6 on a UNIX machine. And recently we changed the SNMP String to our network devices. One of L2 switches keeps logging the following message:
%SNMP-3-AUTHFAIL: Authentication failure for SNMP req from host 10.x.x.1
Where 10.x.x.1 is ciscoworks LMS server. I found a solution on many sites that suggest resetting DFM database. I stopped first the daemon manager and tried to apply the perl script:
perl dbRestoreOrig.pl dsn=dfmInv dmprefix=INV npwd=cisco
but it gives me the following error:
Can't locate CRM.pm in @INC (@INC contains: /usr/perl5/5.6.1/lib/sun4-solaris-64int /usr/perl5/5.6.1/lib /usr/perl5/site_perl/5.6.1/sun4-solaris-64int /usr/perl5/site_perl/5.6.1 /usr/perl5/site_perl /usr/perl5/vendor_perl/5.6.1/sun4-solaris-64int /usr/perl5/vendor_perl/5.6.1 /usr/perl5/vendor_perl .) at dbRestoreOrig.pl line 31.
BEGIN failed--compilation aborted at dbRestoreOrig.pl line 31.
CRM.pm already exists in the path ENV{NMSROOT}/lib/perl/db
At line 31 of dbRestoreOrig.pl – the error – I found the following:
push(@INC, "$ENV{NMSROOT}/cgi-bin/dbadmin/pdbadmin");
use lib "$ENV{NMSROOT}/lib/perl/db";
I gave the system the path of NMSROOT and run the script again but it gives me the same error “Can't locate CRM.pm”
we are desperately trying to set a custom password of our WCS database in order to use it for direct SQL queries (Cumbersome over Web surface). To my knowledge there is a way to reset it however this password would be randomly generated and not available in plain text.
Until version 6 there was a feature to directly set a password via the dbadmin command.
I have done a WCS 7.0.220.0 to NCS migration prior to moving to Prime 1.2. I followed the instructions to export the WCS database via the export.bat all command and exported the database. However, when I import this zip fileto NCS there do not seem to be any of the original WCS templates. All the maps and AP details have migrated but no templates.
I have tried the export again and ploughed through the resultant zip file looking for anything that looks like template files but there is nothing immediately apparent that looks like templates.
I tried to change my password for rmeng using the following command:
./dbpasswd.pl dsn=rmeng encryption=yes npwd=NEWPASSWORD
Here is the output from the dbpwdChange.log
INFO: Start changing password for database 'rmeng'...
Thu Sep 29 14:51:18 GMT 2011> INFO: New userinfo updated into database
[Code].....
Recently I installed LMS 4.1 accidentally on the c-drive, which, as a result, fills itself with a growing database and associated logfiles. How can I move both items to another drive safely? I allready managed to move configs and downloaded software.
View 7 Replies View RelatedI have a 4402 being used as a dmz anchor and we use WCS to allow our Helpdesk to create lobby ambassador accounts. Recently they have been getting error messages when attempting to create accounts. I am seeing the database maxxed out at 2048. The docs state database entries are made up of mac filters(don't use)..ap mic/ssc(don't use)..Dynamic interfaces(minimal) management users(2) local netusers (100 approx)..and excluded clients(none). So the numbers don't add up.I am on 4.2.61.0 code.. I will say also that WCS shows alot more netuser accounts than my anchor does but no where the numbers to max out the database. Is there some other criteria that hits against the datasbase number?? And what can I do on the WCS to insure it si synch'd up against the dmz anchor other than a audit..
View 3 Replies View RelatedI have question about the basics of a high performance application and database server connection to each other. I have two servers, one application and one database server. Both of them are Windows 2008 R2 servers. I would like to connect them. What is the best configuration for quicker communication between them. Is it better to connect them through a network switch? Or directly connect them? Do I need to dedicate one of the ethernet ports on each server to separate their traffic to each other, from the internet connection traffic?
View 5 Replies View Relatedi configured pix 525 for easy vpn. About 100 to 200 people will use this service. i dont have much knowledge about radius and tacacas servers. Is local data base enough for extended authentication or should i configure the server for it ?
View 2 Replies View Relatedan attacker have configured his PC with an static IP address but there is no such entry configured statically in switch, neither in DHCP snooping database.now when he want to generate traffic will switch block him? because there is no entry of his PC in the switch database.
View 2 Replies View RelatedFirstly the ACS 4.2.1 for Windows database replication does any one have and documentation on the processes required?Secondly I have a single system installed which is providing TACACS authentication for management access to a Cisco 5508 WLC, the controller prompts with a login box on connection to the web interface. When you put in the username and password pair the box comes back as if the authentication has failed. On the ACS I was unable to see any failed authentications so enabled passed authentication reporting and can see the user passing the process. The WLC is running software version 6.0.199.4. On the ACS I have added the extra two options within the TACACS interface configuration and have a ‘role1=all’ against both the user and the group the user is part of so I am confused as to why the user is still denied access.
View 3 Replies View RelatedWhen I try to add new MAC entrys to the WLC I get the following message unable to add mac entry to database, reached max size the problem is when I look at the stats there is only 386 MAC entry and the databse size was set to 1024 entry..The work around was to increase the size of the database to 2048.Is there any why to clean up the database?
View 2 Replies View RelatedJust installed ACS 5.0.0.21. Monitoring and reports database was working, but now is not. When trying to open, I get "Monitoring and reports database currently unavailable. Trying reconnect in 5 minutes." From CLI "sho application status acs" gives me the following:
ACS role: PRIMARY
Process 'database' runningProcess 'management' runningProcess 'runtime' runningProcess 'adclient' runningProcess 'view-database' runningProcess 'view-collector' runningProcess 'view-jobmanager' runningProcess 'view-alertmanager' running
Also, logs show nothing unusual.
Would like to check up either Microsoft SQL Express 2012 is able work with ACS 5.3 remote database?
View 5 Replies View RelatedI have the following message in my CiscoPrime LMS 4.2.2 home portal: Discrepancies: Unable to connect to Data base. Probable Cause: ANIDbEngine process may be down.
View 4 Replies View RelatedI am considering using IP sticky timeout, but have a quick question about the database, is the 800,000 sticky connection per appliance or per context?
View 1 Replies View RelatedWe have recently upgraded acs 5.1 to 5.3 ( normal upgrade process), all secondary (ACS-B) was deregistered from primary (ACS-A , used as configuration server and log collector) and updated successfully. But while upgrading primary acs server was rebooted manually. But later primary server was re upgraded successfully to 5.3.
Just to ensure database is not lost on primary acs (ACS-A) , primary acs was registered to one of the secondary acs (ACS-B). Initially ACS-A registered with ACS-B, both ACS was showing proper role now. ACS-A ( secondary ) and ACS-B (primary). But on New primary ACS (ACS-B) is showing new secondary (ACS-A) offline and replication pending. Whereas on Secondary ACS-B its shows primary ACS-A online and updated. But ACS replication id is gradually incrementing. ACS system is in this system for last 2 day, But not sure if there is real replication happening at backend? How long it take place to replicate completely? and how to check / verify status of upgrade?
when we add new switch to STP converged enviroment, switch flush the data from the data base.how to protect database from deleting the information
View 10 Replies View RelatedIf i have a database on access 2007 containing around 1500 products how could i link this to a web site so that the item has the correct price and when an item is sold directly from the site the stock level reduces.what programs would I need and how would I set it up. I have little experience in this field and generally deal with hardware
View 1 Replies View Relatedhow to migrate the db from acs windows 3.3 to acs appliance 4.2.15.We are replacing win 3.3 to appliance 4.2.15 as a part of end of life. So we have the eap-tls/peap authentication.It has the huge records. So suggest me the steps to migrate the db from win 3.3 to appl 4.2.15.Do we need to upgrade to win 3.3 to win 4.0 to win 4.2 & then to migrate to appl 4.2 ?
View 4 Replies View RelatedWe are wanting to use local database users to authenticate our SSH connections to our 6500 cores.
We have added the usernames and password into the 6500 using
username anameduser password astrongpassword or username anameduser secret astrongpassword
We where expecting the commands to be the same as other iOS devices example C3750 we would add.
Line vty 0 4 login local
And this would allow us to use the local user database to authenticate our ssh sessions.
The login local commands are not availbe on the 6500s and we have not found any documentation on how to impliment a local database for this purpose except in a CatOS 6500.
on the dashboard of the "Monitoring & Report Viewer" I see a lot of system alarms related to the database.The explanation of the alarm says to look at the Collector logs for the details.
View 3 Replies View RelatedWe are relocating lms on same server from c to e: drive, with new installation on e:drive Successfully uninstall LMS from c: drive with clean_system. Exe. I have done fresh installation of LMS 3.2.1, installation has been 100% successful, after installation Iam trying to restore database which was backed from exactly same version of LMS. Database restore has been 100% successful for 7 hours, till the point that iam start seeing below message in restore backup.log and also same message in cmd as well.
1. restorebackup seems to loop at the point of restoring RME database.
---
The untar for the tar file E:CAPCIS~1 empBackupData
mengfilebackup.tar is still locking the directory [E:CAPCIS~1 empBackupData
meng]. May be the file content is huge, and its taking more time. It is recommended to type (y) and continue restore.
Do you want to continue the restore (y) or quit the restore (n) [y/n][Sat Nov 12 02:05:24 2011]
[Sat Nov 12 02:05:24 2011]
[code]....
i'm trying to configure acs 5.2 to LDAP external idenity store, when LDAP failes ACS 5.2 should use internal indenity store. I configured A sequence to use LDAP 1st then Internal and i shut off the link to the LDAP but ACS will not use internal, AAA Diagnostics keeps telling me that Cannot establish connection with LDAP server and will not use the internal store.
View 7 Replies View RelatedI am working on project with Secure ACS 5.2. I am trying to determine the proper External Database to use. LDAP or direct to AD?
Additionally, the Domain that I am connecting to has Multiple sub domains. All of the users are currently in the Sub domains, but will be moving to root domain later. How should I configure the connection, do I need to connec to each sub domain or can I just connect to the root?