Problem Description:
How to retreive Camera Password from VSOM in case customer has forgot the password or required to login to cameras.
Workaround/Solutions
There are couple of ways to retrieve the password
1) factory reset of camera but that a tideous job and required alot of effort to perform.
2) another way simply grep the proxy information of that particular camera or doing DB query to deviceaccess table.
In VSM 6.3.x
Step 1
Login to VSMS
Step 2
Go to cd /usr/BWhttpd/conf/proxy
# cd /usr/BWhttpd/conf/proxy
# ls -lrt
total 4
-rw-rw-rw- 1 nobody nobody 679 Mar 3 11:54 10.p_nadeahm-cam_1.xml
Step 3
more 10.p_nadeahm-cam_1.xml
<proxy>
<alias>p_nadeahm-cam_1</alias>
<exec>proxy</exec>
<modelName>cisco_4500</modelName>
<config></config>
<camera>0</camera>
<remote_server>1_1</remote_server>
<remote_port>80</remote_port>
<remote_host>14.1.147.181</remote_host>
<udp>1</udp>
<multicast>0</multicast>
<multicastAddr></multicastAddr>
<username>admin</username>==============>Camera User ID
<password>cisco!123</password>==========>Camera Password
<mediatype>jpeg</mediatype>
<vframerate>20.000000</vframerate>
<bitrate>640</bitrate>
<quality>50</quality>
<width>352</width>
<height>240</height>
<format>ntsc</format>
<resolution>cif</resolution>
<aframrate>20.000000</aframrate>
<samplerate>8000</samplerate>
</proxy>
Same procedure can apply to VSM 7.x however in 7.x we can do a DB query to Deviceaccess tables to pull the cameras information along with User Id and Password
Procedure to DB query.
Step 1
login to VSOM
For 7.0.0 and 7.0.1 :
# sudo /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-file=/usr/BWhttpd/vsom_be/db/mysql/my.cnf vsom
For 7.2.x and later
# sudo /usr/BWhttpd/vsom_be/db/mysql/bin/mysql --defaults-file=/usr/BWhttpd/vsom_be/db/db.cnf vsom
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| vsom |
+--------------------+
mysql> use vsom;
Database changed
Mysql> mysql> Select * from deviceaccess;
It shows up all the password of cameras and devices along servers as well.
P.S: The proxy XML method is ONLY valid for VSM 6.x and earlier, and is done by accessing the VSMS server.The VSOM database method is valid for VSOM 7, does not apply to VSM 6.x
Regards
Nadeem Ahmed