Password Reset

This guide describes how to manually reset an admin account's password in Call Recording and Quality Manager applications.

Icon

The guide uses sql queries that directly modify your Database and commands cannot be undone. Therefore, make sure that you follow the steps carefully.

Call Recording

To reset your admin account's password for your Call Recording Web Interface run the following command (works for GQM 4.8.X and higher):

psql -U postgres callrec -c "update users SET password=md5('admin') where login='admin'; delete from passwords WHERE userid =1;"

Changes take affect immediately after executing the command. Your admin account's password will be reset to: admin

Quality Manager

To reset your admin account's password for your Quality Manager Web Interface run the following command (works for GQM 4.9.X and higher):

psql -U postgres callrec -c "delete from wbsc.passwords where userid=1;insert INTO wbsc.passwords VALUES ('1','1','21232f297a57a5a743894a0e4a801fc3','','2001-01-01 00:00:00+01');"

For ccmanager use:

psql -U postgres callrec -c "delete from wbsc.passwords where userid=2;insert INTO wbsc.passwords VALUES ('1','2','21232f297a57a5a743894a0e4a801fc3','','2001-01-01 00:00:00+01');"

Restarting the Web Interface (both Call Recording and Quality Manager) is required to apply the changes:

/opt/callrec/bin/rc.callrec_web restart

Your admin or ccmanager's password will be reset to: admin

Note: Although restarting Web UI doesn't affect the Call Recording process, it might interrupt your Screen Recording. Therefore you might want to run these commands during non-business hours.

NTP Configuration

  1. Firstly, check whether the selected NTP server is accessible:

    ntpdate -q server_address

    For example:

    ntpdate -q 192.168.1.1
  2. Add the servers to the configuration file of NTP: /etc/ntp.conf (you can edit the default "*.pool.ntp.org" entries, if the server doesn't have internet access and isn't using these NTP servers anyway. Or you can just add the entries as new lines) 
    For example:

     

    server 192.168.1.1
    server 192.168.1.2
  3. To stop Call Recording services:

    service callrec stop
  4. To synchronize the time manually:
    ntpdate server_address

    For example:

    ntpdate 192.168.1.1
  5.  To synchronize the HW clock with the current system time:

     

    hwclock --systohc
  6. To restart NTP daemon:

     

    /etc/init.d/ntpd start
  7. To make NTP daemon start automatically after server startup:
     
    chkconfig ntpd on
  8. To start Call Recording Services:

    service callrec start

Verifying ISO Integrity

Use the MD5 checksum provided with the ISO download file. Download WinMD5Sum and install it based on the manufacturer's instructions from: http://www.nullriver.com/products/WinMD5Sum

The MD5 verification procedure through WinMD5Sum for an ISO file is shown below:

  1. Click ... to browse for the downloaded file.
  2. The MD5 Sum field checksum appears.

Use a text editor to open the zqm-x.x.x-xxx.iso.md5 file. Copy the number from the text file. Paste it into the Compare field. The checksum is 32 characters long.

  1. Click Compare.
  2. If the checksums are the same, then the confirmation dialog is displayed.