ISSUE: When installing MySQL on HP desktop or Server platforms, the installation may fail. A check of the MySQL install logs or Windows Application logs will show an error indicating the following: “Could not access network location Hewlett-Packard\” CAUSE: This problem stems from a registry entry left behind on some…
In environments with multiple clusters, an HTTP 500 error may be thrown in Variphy by Apache Tomcat when trying to access CUCM clusters in the Call Analytics tab. This may be caused by too many connections trying to access the MySQL database at once (the default number is set to…
On Windows MySQL starts up with configurations defined in a file named “my.ini”. To find where the active “my.ini” configuration file is located on the Windows Server: Step 1) Open Windows Services (e.g. start –> run –> “services.msc”) Step 2) Find the appropriate MySQL Service entry (e.g. “MySQL” or “MySQL56”),…
Introduction It may be necessary to upgrade the current version of MySQL that Variphy is using to the latest production release available in order to address security concerns with older versions. This document will cover the steps to upgrade from MySQL 5.0.x -5.5.x, to MySQL 5.6.21 (the latest production release…
In SQL Server, there are 2 possible types of Authentication: Windows – Local Windows user accounts to access SQL Server SQL – Configured user accounts within SQL Server, such as the ‘SA’ account, which is the default admin account (similar to the ‘root’ account in MySQL) SQL Server can be configured to…
In MS SQL Server, change the DATABASE_NAME_HERE to the appropriate database name and then run the following SQL query: SELECT (size * 8.0)/1024.0 AS size_in_mb, CASE WHEN max_size = -1 THEN 9999999 ELSE (max_size * 8.0)/1024.0 END AS max_size_in_mb FROM DATABASE_NAME_HERE.sys.database_files WHERE data_space_id = 0;
A Transaction log file is associated to each MS SQL database, even if the database is in simple recovery mode. While Simple recovery mode does not create logs as exensively as full recovery mode does, running a large query that is requiring signifigant memory and disk space can still create very large logs….
By Default, Microsoft SQL server 2008 R2 (or later) will allocate memory for database caching dynamically, unlike MySQL server, which requires that the innodb_buffer_pool_size parameter in the MySQL configuration file (my.cnf on Linux/OVA and my.ini on Windows) file be set to a fixed amount. However, in the event that MS SQL…
PREPARE SOURCE MSSQL SERVER: Step 1) Login to source server via RDP or Console Step 2) Launch MSSQL Management Studio Step 3) Connect to the instance of the SQL Server Database Engine and then expand the instance. Step 4) Expand Databases, and select the name of the user database you want…
The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server and is used to hold the following: Temporary user objects that are explicitly created, such as: global or local temporary tables, temporary stored procedures, table variables, or cursors. Internal objects that…
