CQD – Issue Version QoEMetrics

Hi all

I have encountered a little problem with the installation of CQD:

CQDissue

I was searching for the solution of this issue, I surfed in much web pages, much of Technet articules says what is the version that you need to have in your SFB QoEMetrics database. But I can’t find anything about the user that is needed to use for the installation process.

To detect if the problem is the version of QoEMetrics or the user privilege rights, try to execute a test-csdatabase with the affected user to get the database version. If you get a result like the image below, your user haven’t the appropiate permissions.

testDB

To solve this issue, use a user with the appropiate permissions or grant to the user administrative permissions in the database.

 

I hope this information will be useful for you

Regards

Advertisements

Audiocodes – Solve Issues with accented DisplayNames

Sometimes you have on a site some users with a display Name with special Characters. Well, if you have an audiocodes in the site you can have a problem. Audiocodes doesn’t accept calls with special characters in the display name by default. The ISO 8859 charset is the cause.

Syntoms:

Calls always fail. But if you change the number to another user without special characters, the call can be made.

Solution:

To solve this problem you need to apply in your Audiocodes the ISO 8859 charset:

“iso8859-charset no-accented”

Please, follow next steps to apply the ISO 8859:

Connect to Audiocodes with SSH, and enable the appliance to configure with administrator password

iso8859_1

Next step, type “configure voip” to access to Voip configuration page.

iso8859_2

Then, type “gw digital gw digital-gw-parameters” to access to GW Configuration.

iso8859_3.jpg

Next step, type “iso8859-charset not-accented” to enable this charset, and then type “activate” to activate new features.

iso8859_4

And then, exit from configure page and restart the appliance.

I hope this information will be useful for you

Regards

Enable Telnet on VVX Devices (Telnet Commands)

Hello all

My adventurous soul have discovered a new way to check stats, settings and more things without use web interface of Polycom VVX.

You can show more information using telnet (very useful for administrators and for troublesooting). However, Telnet is disabled by default on all Polycom device. If you want to use Telnet on VVX devices, you need to activate it, but the option doesn’t appear neither the phone menu or web interface. You need to create a cfg file to enable it.

To do that, open a notepad and type the following command:

<telnet diags.telnetd.enabled=”1″></telnet>

Then, you can rename it how you want, for examble “enableTelnet” but you need to ensure that the extension of this file is .cfg

After that, you must connect with VVX web interface and import this file using “import and export” configuration.

importexport

After that, you can connect by telnet to the device. By default, the user is “Polycom” but the password is the same that you configure in your Admin user (so if you didn’t change the default password, it will be “456“). (Note! If you have a mistake introducing username or pasword, it is probably that you need to restart the phone).

polycom

NOTE! Do not forget to create another cfg file to disable Telnet after you finish your configuration (If not, you will have a very high security hole). This file must have the following command:

<telnet diags.telnetd.enabled=”0″></telnet>

When you use “import and export” configuration to disable Telnet, phone will be restarted

How you have much possibilities availables to use commands. You can find below, a list of “Polycom Telnet commands” available to adapt to your needs (also you can obtain this list typing “help” on the command prompt):

addScheduledLogEntry  Adds a command to be run periodically that outputs to the phone’s log.
appPrt  Show UI’s call status.
arpShow  Display the contents of the ARP table.
auth  Change authentication level
BtoeHide  Send call hide request.
BtoeUnhide  Send call Unhide request.
certBackOffInfo  Show Cert Back off info
certBackOffSet  Show Cert Back off info
cfgParamName  Show cfg Param info by passing param name
cfgProvFileTemplateUpload  Uploads templates of the current non-default config to the boot server
cfgProvFlashTemplateUpload  Uploads templates of the current flash config to the boot server
changeRtpConfig  Change RTP/RTCP configuration for ongoing Incoming/Outgoing DECT call
changeRtpConfigForAll  Change RTP/RTCP configuration for all new Incoming/Outgoing DECT calls
checkStack  Checks the stack.
configSyslogSet  Set Syslog parameters in the flash.
                (Server Address, Server Type, Facility, Render level, Prepend MAC)
confShow  Show conference info.
coreAudio  Print core audio information.
coreDumpEncrypt  Set to enable core dump encryption.
cpuLoadShow  Display CPU load (period (s), number of iterations).
cpuUsageShow  Display CPU usage by running Linux top command. [pid]
date  Display the current date.
dbsinfo  Display the database service information
deferwatchdog  Defer All watchdog timers
DelAuthSvcDB  Delete authSvc folder in flash
dhcpcParamsShow  Show DHCP client parameters.
dnsCacheShow  Show DNS cache records.
ds  Debug Services
dspLoadGraphToggle  Toggle DSP load graph between DSP-core-only load and total DSP thread load.
dspLoadShow  Display DSP load (period (s), number of iterations).
dump  Dump file to terminal, including decompressing compressed files
endErrShow  Show END device error stats.
ethBufPoolShow  Display the state of the ethernet pool stack(no parameters)
ethFilterShow  Show Ethernet ingress filter stats.
flkChangeMaxUsers  Changes the max number of user customizations on phone. Usage : flkChangeMaxUsers <number>
flkInitBookKeeping  Initializes the book keeping for FLK. Usage : flkInitBookKeeping <filename(optional)>
fschk  Check phone’s file system
gcovflush  flushes gcov report, upload it to boot server and cleanup.
getBToEPairingCode  Show BToE Pairing Code.
getLyncStatusInfo  Display Lync Status Information
help  Shows basic help for all commands.
hostShow  Show host table.
i  Display status of the specified process, or all running processes (Process_name (optional))
icmpstatShow  Show ICMP statistics.
ifShow  Display ethernet interface statistics (no parameters)
inetstatShow  Show transport layer network status.
iosFdShow  Show file descriptors in use.
ipstatShow  Show IP layer network statistics.
keyPrt  Shows information about the key mapping.
la  List all files in the flash filesystem, including subdirectories.
lfu  Send the logfiles to the provisioning server(no parameters).
linkShow  Show link status.
ll  List files in the flash filesystem (long format).
logd  Dump the log, parameter is reverse order or not.
logda  Print all available log modules and their current level.
logFullSip  Enable:1 or Disable:0 full sip message logging. If enabled fragmented SIP packets are not logged but whole
SIP message is logged
logl  Set the lowest log level which will be displayed (0-6)
logr  Set the renderStdout parameter for the log.
logreg  Set the registration list for sip message log filtering
logs  Set the log level output for a given module ([module] [0-6])
logsa  Set the log level output for all modules. ([0-6])
logt  Set the log display type (0-2)
ls  List files in the flash filesystem.
medSess  Show detailed information on the current media session(s),
medSessStat  medSessStat- Show call statistics of the active media session(s)
memShow  Display heap memory statistics.
mRouteShow  Display IP routing table.
msCallPark  Show detailed information on the MS Call Park session(s),
ncasCb  Show detailed ncas information, related to either call services,
Non call services, or server information (1, 2, or 3)
ncasMisc  Show misc. Non-call information (no parameters)
neighborCacheShow  Display the contents of Neighbor Cache Table
netCCB  Display open RTP ports and their status (no parameters)
netRxShow  Show network receive stats summary.
nslookup  Find the IP for a given hostname
pcapUpload  Upload background packet capture file
ping  Ping a given host (IPv4 or DNS name) [,Data Len in Bytes]
ping6  Ping a given host (IPv6 or DNS name) [,Data Len in Bytes]
printCurrentLocation  GENBAND: Print the current Location Description.
printCurrentTimestamp  GENBAND: Print the current Location information timestamp.
printLocationtree  GENBAND: Print the Location Tree.
pwrsvStat  display power saving status and configuration.
removeScheduledLogEntry  Remove a scheduled log entry.
resPrt  Show information about the resource finder.
routeShow  Display the contents of the routing table(no parameters)
rpcapSecureConnect  Connect to secure packet capture SSH gateway server
rpcapSecureStop  Close connection to secure packet capture SSH gateway server
setLocationID  GENBAND: Set the new locationID.
setTimestamp  GENBAND: Set a new timestamp to force location tree download.
showBackupConfig  Display backup configuration as stored in flash (no parameters)
showChannel  Display Ptt Page Channels information
showDeviceUpdateInfo  Display the Device Update configurations.
showEcho  Show acoustic echo cancellation/suppression status.
showGains  Show acoustic termination gains.
showHdPcm  Show Headset PCM channel status.
showHfPcm  Show Hands-free (chassis) PCM channel status.
showHsPcm  Show Handset PCM channel status.
showPcmAll  Show all PCM channels status.
showPowerSource  Detect power source
showQoeConfig  Prints QoE Configuration
showRunningConfig  Display the current running configuration (no parameters)
showStoredConfig  Display configuration as stored in flash (no parameters)
showUCDInfo  Display the Device Update configurations.
sipOutageToggle  toggle : create or remove outage.
sipPrt  Show SIP stack status.
sipSetAdmSubExp  set Exp SipCallStateSubscribeRoamingSelfOnBehalfOfBoss.
sspsDspBuf  Request DSP buffer status.
sspsMsgShow  Show msg hdi buffers.
sspsShow  Show hdi buffers.
sspsShowMix  Show mixer bindings.
streams  Show detailed information on the active RTP streams
syslogl  Set the lowest syslog level which will be displayed (0-6)
syslogsr  Set the syslog server IP address or Hostname
syslogtr  Set the syslog transport method [udp|tcp|none]
tcpstatShow  Show TCP network statistics.
testNand  Test a NAND block (non-destructive): testNand <blocks> <iterations>
testRam  Allocates and tests a buffer in SDRAM: testRam <alloc_size> <iterations>
time  Show current time.
timerShow  Show rtos timer information.
top  Run Linux top command. [pid]
tpcpStatus  Show TPCP Conversation status.
traceroute  Display the route taken by packets across an IP network for a given host (IPv4 or DNS name)
traceroute6  Display the route taken by packets across an IP network for a given host (IPv6 or DNS name)
TSID  Push the Tech Support Information Dump to the log (Does not reboot).
udpstatShow  Show UDP network statictics.
uiXml  Returns the UIXML command output.
upbasedeferval  Update base defer value
uploadCSR  Upload Generated private key and CSR [ Common Name Org Country State EmailAddress ]
uptime  Show phone uptime.
usbShow  Display USB port name (Plugged in a USB device before running this.)
utilBufPoolStatus  Display RTP current memory usage.
version  Display software and hardware version numbers.
wtPrt  Show Web Ticket status.

I hope this information will be useful for you.

Thank you

Best Regards

503 error in CQD Portal

It is possible that you have this problem at any time.

Sometimes CQD Portal can be in error with error code 503 service unavailable.

Well, sometimes you need to install certain applications with privilege users that, for enterprise policies, it can’t have a password thar never expires. This is a very high problem to our administration, but sometimes we can’t fight with the Security Policy of the Company.

In this hand, it is possible that you find this problem at any time

CQD3

This error will be following by a IIS event like this:

CQD4

And then, you will finded the QoEPortal Application Pool disabled:

CQD5

Ok, so this problem can appear by a user and password problem. Did you change your password a few days ago? It can be the problem.

To solve this issue you can following the next steps (it’s Easy):

Go to the IIS Administration Portal, next go to Application Pools and then select QoEPortal pool and clic on right button, then select Advanced Settings:

CQD6

Now, below Process Model menu select Identity and clic on suspensive points

CQD7B

In the new window, clic en SET and introduce the new password.

CQD8

After that, apply all settings and restart the pool, if it is necessary realize a IIS Reset.

Well… It’s magical!s CQD Portal works once more time!

cqd9

I hope this information will be useful for you.

Thank you

Best Regards

Turning my Home Network into a Secure Network

This article is not an Unified Communications topic, But I think that it is important to be more safe at home.
Exist a lot of topics on Internet about a safe network. I think a lot of them are usefull, but others are simply post without sense.

I can give you some recommendations to be more safe at your home network, even more if you use it for your daily work.

Modify your Router Settings.

If you can, change your standard router for a new one more secure. Although I imagine, that this action is very difficult. Instead, you can modify your router settings to be more safe.

How can I change my settings?

You need to enter into the configuration page (generally the IP Address of your gateway 192.168.1.1) or to your operator control panel.

Use WPS is very usefull to connect to your network, more easy and simple, but a lot of hackers use it to hack your network and connect into it.

A good recommendation is to shut down WPS on your Router.

besafe1

Next step to be more safe on your network, is to use a custom WPA (or WPA2) password. This password should be at least 6 chatacters including Numbers, Letters and if it is possible Special Characters (understanding % $ # @ as special characters).

besafe2
Next step is to use double authentication factor. How? You can to activate MAC Filtering for example. Yes, I know, it is veeeery boring because it means to type one by one all your MAC devices. Yes it is true, but is more safe.

besafe3

If you need, you can also follow more safety steps, this steps would be:

  • Hide your SSID: If you hide your SSID, only can to connect with it, if you know the SSID (but it will be more inproductive with a kind of devices)
  • Port Filtering (Open only safe ports).

When you finish, save your new configuration and restart your router. Before, you can work quietly because now your network will be more secure.
I hope this information will be usefull for you
Thank you
Kind regards

How to use Call Quality Methodology (CQM)

What’s CQM?

CQM is the response of your Prayers. Most mushrooms that you can find in your platform can have a sense thanks to Call Quality Methodology.

This tool help you to obtain full statistics of your stream sessions. You can to obtain statistics from Call Quality, bad devices, bad streams, user rates, and more. It is a great tool (THANK YOU MICROSOFT!)

Here, you can look up more usefull information (and download links) of the tool:

https://technet.microsoft.com/en-us/library/dn593600(v=ocs.15).aspx

https://www.microsoft.com/en-us/download/details.aspx?id=47724

Now I explain you some instructions that you can follow to deploy the tool in your platform.

First, you may download the tool from here.

The tool is just a Powershell Script that obtain data from SQL Server, It doesn’t touch anything, doesn’t modify anything.So you can save it on any computer or server in you network. I recommend to save it on a computer that you use for remote management. Instead you can save it on your SQL Server if you want (remember,the tool doesn’t modify anything, it is safe).

When you will have it into a directory on your machine (for instance E:\CSResources), you can start using the tool.

You will have the following files and folders (all of them are important).

folder

As you can see, you will have an excel named “Microsoft Call Quality Methodology Scorecard for Skype for Business Server v15”, be patient, this file is not important now. You can use it after you get the information.

Ok, so now you need to open a Windows Powershell. Browse to CQM directory
Next, you need to known what date format you have into your SQL. To known it, you need to execute “getSQLDateFormat.ps1” script typing your SQL Instance.

cqm1
Next, you can to obtain data with the other script CQM.ps1. You will need to type the first day that you want to collect data. after that, you need to indicate to the script the instance as the same mode as you typed it on “getSQLDateFormat.ps1”.

cqm2

After CQM have collected data you can look up it at “Results” directory. Similar as the following

cqm3
Inside the folder, you can see all querys discovered.

cqm4

Ok, Firsts steps are over. Now you need to ordenate the information. How you can sort this data?

Now you need to open “Microsoft Call Quality Methodology Scorecard for Skype for Business Server v15” after that, you need to allow macros and enable editing. When you have complete this steps you should have an excel as the following:

cqm5.jpg
Next step is to import CQM Query Results, to do that you need click on “import CQM Query Results” and then search the exported folder that you type on CQM.ps1 (DataRoot option)
As you can see, more than one tab are available now, for example “Endpoint_0_Device”,”Endpoint_1_system”, …

Next step is to generate all informs. “stream Distribution Charts”, “Trending charts”, “Reliability Charts” and “Top issues”. If you have follow all steps correctly, you must have an inform as the following:

cqm6.jpg

If you followed all steps and you arrived here, you got it! Please, read Microsoft Call Quality Methodology.docx for more detailed information. This tool have a lot of possibilities.

I hope this information will be usefull for you.

Thank you
Kind Regards

Skype For Business with Skype Issues

Hello guys!

Today I have a very appetizing mushroom. Perhaps you have had at anytime a problem with your Skype to Skype for Business integration.

I describe the problem:

Some users advise you that they can contact with Skype users, but Skype users can’t view presence and doesn’t have chat with Skype for business users, for example:

failureII

If you have tested your deployment, and you followed all steps from Technet guidance: https://technet.microsoft.com/en-us/library/dn705313.aspx

Also you checked your firewall and everything is allowed. Keep calm, you are not crazy. Your environment are correctly configured, but you have some users that are using Lync 2013 (With or without skype for business interface). Please, follow next steps to solve your issue.

Check if your users with those clients have next configuration:

failure.jpg

If not, please apply it and try again.

Open your client options and go to ‘alerts’. On ‘contacts not using Skype for Business’ menu, check ‘allow anyone to contact me’. The problem will be resolved.

I hope this information will be useful for you.

Regards