Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

VSOM Identity Collision

I have 5 UCS Chassis that host all my cameras and my VSOM server.  During our initial deployment using VSOM 7.2 we had a IP issue.  I corrected our IP scheme and made the changes to the other machines.  But a error persists in our system.  It does not cause any issues, just a nuisance.  It says I have a Identity Collision.  But I have checked all the UCS chassis and on the backend in the Linux settings.  Can someone help me figure out the error and how to clear it.  I have attached pictures for reference.

20 REPLIES
Silver

Sooo... The IP Addressing

Sooo... The IP Addressing scheme changed for all of your servers?  How were the IP addresses of the servers actually changed?

What version were you at when you changed them?

Scott Olsen Solutions Specialist Bulletproof Solutions Inc. Web: www.bulletproofsi.com
New Member

just one box had to change. 

just one box had to change.  I had fat fingered the IP and the rest is history. 

 

155.150.215.245 is the second NIC on the box for failover.

 

I have attached 3 more pics

 

Cisco Employee

It seems like you have not

It seems like you have not configured the host-name properly for this server, its showing there as "localhost. localhost". Its validation failed there only which cause this error. Please correct the proper host-name then try.

I hope that clears this error then.

Cheers,

Jayesh

 

New Member

I have tried chanaging the

I have tried chanaging the the local host through the GUI and it gives me a error that it cannot do that?  Any ideas?

Cisco Employee

Is it  possible  you to open

Is it  possible  you to open a TAC case?

 

Br,

Nadeem

Br, Nadeem Please rate all useful post.
Cisco Employee

What is the error you are

What is the error you are getting now? Can you share that snapshot please.

Cisco Employee

 HelloTry deleting the event

 

Hello


Try deleting the event id from VSOM database and reset the status it will fix the issue.

 

Procedure to do so:

login as root on VSOM server

#sudo /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-file=/usr/BWhttpd/vsom_be/db/db.cnf vsom

 

This command will get you to the SQL prompt

SQL> Select * from issue;

 

Once you run this command you will get a output of all event that are there on VSOM . copy and past e in any notepad . Grep the object id of of that error/alarm/event you are getting Collision identity.

SQL>DELETE from issue WHERE OBJECTID = '<objectid>';

 

or if  you find any difficulties finding the object id post me the "Select * from issue; command output  to me.

 

Br,

Nadeem

 

 

Br, Nadeem Please rate all useful post.
New Member

Nadeem,     I never got

Nadeem,

     I never got alerted you replied to my post.

     Do you happen to have the default root password that ships with them?  No one seems to remember the password?

 

Thanks

Tim

 

Cisco Employee

Where are you trying to login

Where are you trying to login and what is the VSM version

 

if it VSM 6.x  default user name and password

VSMC : root/secur4u

VSOM: root/secur4u

SSH: root/secur4u

 

if its VSM 7.x , default username password

 

VSMC: localadmin/secur4u

VSOM:admin/admin

SSH: localadmin/secur4u

 

 

Br,

Nadeem

 

 

Br, Nadeem Please rate all useful post.
New Member

Ok I am in the box,Now I must

Ok I am in the box,

Now I must not being getting the syntax correct.

 

Please see attached picture

 

Silver

I think I see you're issue...

I think I see you're issue... you don't have the full path to the mysql binary.   Double check Nadeem's post above ;-)

 

This is from one of my own servers:

 

[localadmin@VSM76COLO-1 ~]$ whoami
localadmin
[localadmin@VSM76COLO-1 ~]$sudo su -
[root@VSM76COLO-1 ~]#whoami
root
[root@VSM76COLO-1 ~]# pwd
/root
[root@VSM76COLO-1 ~]# cd /usr/BWhttpd/vsom_be/db/mysql/bin/
[root@VSM76COLO-1 bin]#
filemy
my_print_defaults           mysql_convert_table_format  mysql_find_rows             mysql_upgrade
mysql                       mysqld                      mysql_fix_extensions        mysql_waitpid

mysqladmin                  mysqld_multi                mysqlhotcopy                mysql_zap
mysqlbinlog                 mysqld_safe                 mysql_install_db
mysqlbug                    mysqldump                   mysql_secure_installation
mysqlcheck                  mysqldumpslow               mysql_tzinfo_to_sql
[root@VSM76COLO-1 bin]#
filemysql
mysql: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
[root@VSM76COLO-1 bin]#

 

 

 

Scott Olsen Solutions Specialist Bulletproof Solutions Inc. Web: www.bulletproofsi.com
New Member

Ok I think I am another step

Ok I think I am another step forward.  Now I am getting prompted for the root password and it is not our localadmin password.  I am assuming it got changed during the install last year.  I have tried secur4u and the localadmin password we have set for the box.

 

please help

Cisco Employee

SSH to server first$ sudo su

SSH to server first

$ sudo su -

# sudo /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-file=/usr/BWhttpd/vsom_be/db/db.cnf vsom

 

Regards

Nadeem

Br, Nadeem Please rate all useful post.
New Member

Nadeem, I got where you

Nadeem,

 

I got where you needed me.  I am not getting any output.  Please see attachment.

Silver

You need to terminate the

You need to terminate the SQL statement with a semi-colon ";".

Cheers :-)

Scott Olsen Solutions Specialist Bulletproof Solutions Inc. Web: www.bulletproofsi.com
New Member

Please see attached :[root

Please see attached :

[root@localhost bin]# sudo /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-fi                le=/usr/BWhttpd/vsom_be/db/db.cnf vsom
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 55
Server version: 5.6.18-enterprise-commercial-advanced-log MySQL Enterprise Serve                r - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * select issue;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that                 corresponds to your MySQL server version for the right syntax to use near 'selec                t issue' at line 1
mysql>

 

Silver

Again, your syntax is

Again, your syntax is incorrect and you haven't used the SQL command that Nadeem provided.  Please double check.

Also, I would *highly* recommend you open a case with TAC for this obvious software bug.

Scott Olsen Solutions Specialist Bulletproof Solutions Inc. Web: www.bulletproofsi.com
New Member

I got the output, I am trying

I got the output, I am trying to locate the object

New Member

Nadeem, I have attached the

Nadeem,

 

I have attached the output and I do not see the object that is causing the error.

Looks like a common issue.

Looks like a common issue. There may be stale entries in the VSOM DB regarding the ip-add change  after you upgraded to  vsm 7.5.0. 

 

The below steps mentioned by Nadeem should help you out, after you are done with it do a "Reset status" on VSOM page.

Make sure you carry out the steps on the VSOM cli, run the command "service Cisco status" to check vsom db running it shld be the first line when you run the command.

-Kevin

 

538
Views
3
Helpful
20
Replies
CreatePlease to create content