12-02-2010 04:05 PM
I have a VSOM/VSMS coresident on same box, and on back of the chasis it has a analog capture card. I currently have 2 analog cameras that are functioning off of this card, I want to add another ( i belive it supports 16) But when i try to add a new camera on channel 3 of VSOM, it says (DB Error: No such field.) Does the encoder card on the chasis have some kind of admin page i need to preconfigure for the third channel? if so what is the URL or setup for doing this? Or am i just running into a VSOM bug.
Thanks in advance.
Solved! Go to Solution.
12-03-2010 04:56 PM
The VSOM Install & Upgrade Guide for 4.2.0 contains the required steps to upgrade the database schema
The final section of this document is entitled Upgrading VSOM.
Step 6 in that procedure deals with updating the database
Step 6
Upgrade the VSOM database in MySQL.
Enter the MySQL password when prompted. The default password is blank; press enter if there is no password.
If you are upgrading from Release 4.1.1 to Release 4.2.1:
shell> mysql -u root -p < /usr/BWhttpd/vsom/db/mysql-update-4.1.1-5_to_4.2.1.sql
If you are upgrading from Release 4.0.0 to Release 4.2.1, Run the following commands in sequence to upgrade the database:
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.0.0-23_to_4.1.0.sql
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.1.0-15_to_4.1.1.sql
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.1.1-6_to_4.2.0.sql
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.2.0-16_to_4.2.1.sql
In your case, you would begin with the step in bold above, and continue with the step below in order to arrive at a 4.2.0 schema. It is always a good idea to backup your VSOM database before updating the schema.
Backing up VSOM
After configuring VSOM, you can back up the VSOM configuration.
Procedure
Step 1Step 1
Step 2 Click Download.
Step 3 When prompted, save the .tar file to a secure directory.
The VSOM backup file is named VSOM_
12-03-2010 03:45 PM
Hello,
The error you describe sounds more like a database error than something to do with the encoder. Did you recently upgrade your VSMS/VSOM version?
From a console or ssh session, please issue the following command (after the # prompt) and cut/paste the results:
# rpm -qa | grep -i cisco
# /etc/init.d/mysql status
# mysql
mysql> use bas;
mysql> select * from bas_settings;
Then look on line id 12, "DB_VERSION"
You may possibly have a database schema which was not properly updated when upgrading VSOM.
I hope that helps...
12-03-2010 04:04 PM
It looks like it is the wrong version, where do I go from here ?
Cisco_VSMS-6.2.0-15d
Cisco_VSDocs-6.2.0-15d
Cisco_VSOM-4.2.0-12
Cisco_VSTools-6.2-15
Cisco_VSRecorder-6.2.0-15d
Cisco_VSES-6.2.0-15d
Cisco_VSBWT-6.2.0-16d
Cisco_VSVM-6.2.0-15
Cisco_VSDrivers-6.2.0-15d
Cisco_VSBase-6.2.0-15d
12 | DB_VERSION | Application Database Version | 4.1.0-15
12-03-2010 04:56 PM
The VSOM Install & Upgrade Guide for 4.2.0 contains the required steps to upgrade the database schema
The final section of this document is entitled Upgrading VSOM.
Step 6 in that procedure deals with updating the database
Step 6
Upgrade the VSOM database in MySQL.
Enter the MySQL password when prompted. The default password is blank; press enter if there is no password.
If you are upgrading from Release 4.1.1 to Release 4.2.1:
shell> mysql -u root -p < /usr/BWhttpd/vsom/db/mysql-update-4.1.1-5_to_4.2.1.sql
If you are upgrading from Release 4.0.0 to Release 4.2.1, Run the following commands in sequence to upgrade the database:
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.0.0-23_to_4.1.0.sql
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.1.0-15_to_4.1.1.sql
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.1.1-6_to_4.2.0.sql
mysql -u root -p < /usr/BWhttpd/bas/db/mysql-update-4.2.0-16_to_4.2.1.sql
In your case, you would begin with the step in bold above, and continue with the step below in order to arrive at a 4.2.0 schema. It is always a good idea to backup your VSOM database before updating the schema.
Backing up VSOM
After configuring VSOM, you can back up the VSOM configuration.
Procedure
Step 1Step 1
Step 2 Click Download.
Step 3 When prompted, save the .tar file to a secure directory.
The VSOM backup file is named VSOM_
12-09-2010 03:54 PM
worked like a charm thanks!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide