Giter VIP home page Giter VIP logo

cucm-cdr-cmr's Introduction

CUCM-CDR-CMR

Cisco Unified Communications Manager (CallManager) CDR and CMR to MySQL import using PowerShell

Requirements:

MySQL .NET Connector
SysInternals handle.exe (handle.exe needs to be in the executing users %PATH%)

Files and functions:

CDR Scheduled Task.xml - Windows Scheduled Task for CDR Processing
CMR Scheduled Task.xml - Windows Scheduled Task for CMR Processing
CDR-MySQL-Import.ps1 - PowerShell script for processing CDR files
CMR-MySQL-Import.ps1 - PowerShell script for processing CMR files
Get-HandlesAndProcessIds.ps1 - Helper script used by handle.ps1 script (requires handle.exe from SysInternals Suite)
handle.ps1 - Helper script called to determine if data files are open by another process and should be skipped

cucm-cdr-cmr's People

Contributors

nschlutter avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

cucm-cdr-cmr's Issues

command is not allowed with this MariaDB version

MariaDB Server version: 10.3

the script is running in the same machine,

# Set database information $mySqlhost = "localhost" $dbName = "call_detail_records" $dbUsername = "admin" $dbPassword = "Aa123456" $dbCdrTbl = "cdr" $dbCmrTbl = "cmr"

below is the log file,

`**********************
Windows PowerShell transcript start
Start time: 20200110220633
Username: DZN-PC\DZN
RunAs User: DZN-PC\DZN
Configuration Name:
Machine: DZN-PC (Microsoft Windows NT 10.0.18363.0)
Host Application: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -Command if((Get-ExecutionPolicy ) -ne 'AllSigned') { Set-ExecutionPolicy -Scope Process Bypass }; & 'C:\Users\DZN\Documents\Dev\CUCM-CDR-CMR\CDR-MySQL-Import.ps1'
Process ID: 1488
PSVersion: 5.1.18362.145
PSEdition: Desktop
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.18362.145
BuildVersion: 10.0.18362.145
CLRVersion: 4.0.30319.42000
WSManStackVersion: 3.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1


Transcript started, output file is C:\Users\DZN\Documents\Dev\CUCM-CDR-CMR\logs\CDR_Import_1_10_2020.log
The used command is not allowed with this MariaDB version
ERROR - Failed to insert file 'C:/Users/DZN/Documents/Dev/CUCM-CDR-CMR/data/2019-01/cdr_StandAloneCluster_01_201901010504_106166'
The connection is already open.
ERROR - Could not connect to database server 'localhost'
PS>TerminatingError(): "System error."

$global:?
False


Windows PowerShell transcript end
End time: 20200110220646


`

i can connect to the DB throw phpmyadmin, and i tryied by power shell its working fine. but the code is throwing an error for db connection issue.

appreciate your support.

Regards,

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.