If you have forgotten your password, or just would like to change your MySQL password for Denika, Logalot or Scrutinizer, then here are some tips on how to reset your MySQL password.

1) Stop the MySQL service.

2) From a command prompt navigate to the SOEmysqlbin folder. (or scrutinizermysqlbin)

3) Run the following command: “mysqld-nt.exe –skip-grant-tables“. This will start the mySQL server running and the command prompt will appear to hang; this is normal.

4) Open another command prompt and navigate to the same folder as step 2.

5) Run the following command: “mysql -u root mysql“. This will bring up a command line MySQL session and the prompt will change to mysql>.

6) Copy and paste the following command: “UPDATE user SET Password=PASSWORD(‘mynewpassword’) where user=’root’;”
<ENTER>

** where mynewpassword is your new password

7) You should see the following output:
Query OK, 2 rows affected (0.05 sec)

Type “quit”, and you will return to a command prompt.

9) Enter “mysqladmin shutdown”. You will see the other command session return to the prompt.

10) Start the mySQL service and dependent services.

11) Write down your new password so you don’t have to go through these steps again. 

Milton

For all the Scrutinizer gurus out there that would like move Scrutinizer to a different hard drive; here are some instructions that will help you.

1. Stop all Scrutinizer services (which includes apache2, mysql, filed and collectd.)

2. Backup:
scrutinizer\mysql\data\scrutinizer*
scrutinizer\files
** if you copy it to the drive you will be moving Scrutinizer to, make sure the folder is not named ’scrutinizer’

3. Uninstall Scrutinizer from the original drive

4. Install Scrutinizer on the new drive

5. Stop all the Scrutinizer services for the new install

6. Copy your backup scrutinizer\mysql\data\scrutinizer* folder(s) into your new installs scrutinizer\mysql\data\ folder

7. Copy your backup scrutinizer\files into your new installs scrutinizer\files folder

8. Restart the services for Scrutinizer

Milton

Typically we have recommended using MySQL Administrator to backup the MySQL databases we use for our Denika, Logalot, and WebNM applications. This is because typical backup processes tend to cause database corruption to MySQL database tables when there is contention between the data backup application and MySQL Server locking the files.
Read more »

We have developed a Call Tracking system to monitor and report statistics of our Sales and Technical Support phone activity on our Asterisk PBX system.

This call tracking system was originally created by Marcus Del Greco, a former employee of Plixer International, and has since been upgraded and maintained by me.

The result is our in-house tool plumTrack, which provides call statistics including total number of calls per person, total time on the phone (both incoming and outgoing), and also broken out by internal (company extension) calls and external calls. This is tailored very specifically to our needs, as this tool is used to base our monthly bonuses on. Management uses this tool to track how many calls to customers and how long, in minutes, we were on the phone.
Read more »

The one thing that Scrutinizer does not like, when your anti-virus is running active scans on MySQL database. MySQL is rewriting or changing files every second or two, and anti-virus active scan is scanning every time a file changes, which becomes problematic and will cause tables to crash when the Scrutinizer directory is not excluded from your anti-virus active scan.

Here are some symptoms that you will see when Scrutinizer directory has not been excluded for your anti-virus active scan.

• Your Vitals tab will not display any information, or incorrect information
• Your Top Conversations will Display no data
• Slow performance
• Table corruption
• SNMP may not show devices

If you are experiencing these symptoms, most likely some of your tables are corrupted. You may download MySQL Administrator in order to repair any of the tables that are corrupted. If you are unable to resolve this issue, please do not hesitate to call technical support.

Milton