Trace log files generated by the Cisco AXL Web Service running on the CUCM Publisher server can be very helpful when troubleshooting and diagnosing issues where Variphy Insight is unable to capture information from CUCM via AXL. The log files can help identify how CUCM is handling and performing on…
As more CDR/CMR data is created by CUCM and saved by Variphy, the database storage files for MySQL can become large in size and consume disk space, particularly if located on the C drive/partition. It’s recommended to store the database files on a ‘data’ partition (such as the D…
PREPARE SOURCE MYSQL SERVER: Step 1) Login via SSH to Variphy Server (Variphy OVA installation assumed) Step 2) Identify the desired database to migrate: mysql – u root -p mysql> show databases; Step 3) Exit out of mysql by typing exit at the prompt mysql> exit Step 4) Backup the database using mysqldump,…
PROBLEM After installing MySQL 5.7.x, the root password will expire (default is 360 days). When this happens, Variphy will not be connect to the MySQL database to be able to run CUCM CDR queries or perform data inserts. SYMPTOMS The following issues will arise when this condition occurs. 1) Any…
When Variphy Call Analytics for CUCM CDR searches/reports appear very slow, it is often caused by a shortage of available memory on the MySQL database server. This typically happens when the size of the database outgrows the amount of memory made available to cache it. The larger the ratio of…
MySQL & MariaDB considers connections from the same local machine different than connections from a remote machine, even if using the same root user and password. When installing and configuring MySQL or MariaDB, the root account and password being setup is by default, only for connections from the same…
MySQL performs best with all (or at least most) of its data cached in its buffer pool(s). For larger systems, this can often mean that there are many GBs of data cached. If MySQL is restarted, for example as part of a server maintenance reboot, it can often take…
On Windows, locate the folder where the file “mysqld.exe” exist – it is often in the folder “C:\Program Files>MySQL>MySQL Server 5.6>bin“ Open the command prompt in Windows Click Start and enter ‘cmd’ in the Run window In the command window, change the working directory to that of where the “mysql.exe”…
Background If you can no longer access the CDR database in MySQL and do not have a working root account password, the root account may be reset via the following instructions. The following applies to MySQL 5.6 – please consult the appropriate MySQL user manual for different versions: Windows On Windows,…
Background According to MySQL discussion forums, a max_allowed_packet value that is too low (such as 4M) can cause connection issues with MySQL, which can look like the following in Variphy Logs: ERROR … com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketExceptionMESSAGE: socket closed STACKTRACE: java.net.SocketException:…
