Wednesday, April 22, 2020

Find and Remove Incorrect Office 2019 Keys

Find and Remove Incorrect Office 2019 Keys


Remove a bad key that you installed previously. Using cmd.exe DOS prompt in elevated mode.

in this directory
C:\Program Files\Microsoft Office\Office16

Office 2016 / 2019: C:\Program Files\Microsoft Office\Office16
or
C:\Program Files (x86)\Microsoft Office\Office16
Office 2013: C:\Program Files\Microsoft Office\Office15
or
C:\Program Files (x86)\Microsoft Office\Office15

look for ospp.vbs
Looking for ospp.vbs

Show the keys

Now you can check the license status by running the script called ospp.vbs, which is located in your Office program folder.
cscript ospp.vbs /dstatus
(will show you the keys circled)


Remove the keys

To remove your Office product key, you need to use the /unpkeyswitch, along with the last 5 characters of the product key.
cscript ospp.vbs /unpkey:{last five characters of product key}

Using key tool


See:
https://www.top-password.com/blog/remove-license-product-key-for-office-2016-2013/

Wednesday, April 15, 2020

How to Convert Cisco 7965G from SCCP to SIP Firmware Load

SIP Firmware Load on Cisco 7965G


First Step is to get the firmware from 3CX

Then follow these steps:


When SCCP is loaded:
    Complete the following steps:

    Unplug the power cable from the phone, hold dows the # key, and
    then plug the power cable in again.

    The phone begins its power up cycle.

    Release the # key after the Speaker button is no longer
    lit.

    You should see the following message on the phone:

    "Reset key sequence detected"

    Press 123456789*0# within 60 seconds after the Headset, Mute,
    and Speaker buttons begin to flash.

    If you enter this key sequence correctly, the phone displays
    this prompt:

    Keep network cfg? 1 = yes 2 = no

    In order to maintain the current network configuration settings
    for the phone when the phone resets, press 1. In order to reset the
    network configuration settings when the phone resets, press 2.


After SIP is loaded:


Unlock the Config and Set the TFTP Server:

1) Press the Settings button on your 7960 phone
2) press 9 to unlock config, or scroll down to "Unlock Config"
3) Enter "cisco" on the keypad in alpha chars
4) Press Accept button after entering the pass
6) scroll Up to Network Configuration, press Select
7) Locate "Alternate TFTP" option, change to YES
8) Locate "32 Alternate TFTP" item, and then change NO to YES, press YES button, DONT press SAVE button
9) Scroll up to "7 TFTP Server" press EDIT, press "<--"
10) enter 192.168.1.25, press ACCEPT, then SAVE
11) Phone reboots and contacts your TFTP server

Secret Keystokes for Cisco 7965G

Lock and Unlock the Configuration:  **#   (press settings button on phone then enter this)
Reboot the phone:  **#**  ( press settings button first, then enter this )
Firmware Load:  #  (press & hold # during power up until speed dial lights flash, then enter 1234567890*# )

Sample Dialplan for USA


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
<DIALTEMPLATE>
    <TEMPLATE MATCH="0"              Timeout="1" User="Phone"/> <!-- Local operator-->
    <TEMPLATE MATCH="011*"         Timeout="6" User="Phone"/> <!-- International calls-->
    <TEMPLATE MATCH="0"            Timeout="8" User="Phone"/> <!-- PSTN Operator-->
    <TEMPLATE MATCH="11"           Timeout="0" User="Phone" Route="Emergency" Rewrite="9911"/>
    <TEMPLATE MATCH="w!"             Timeout="1" User="PHONE" Route="Emergency" Rewrite="9911"/>
    <TEMPLATE MATCH=".11"          Timeout="0" User="Phone"/> <!-- Service numbers -->
    <TEMPLATE MATCH="1.........."    Timeout="0" User="Phone"/> <!-- Long Distance -->
    <TEMPLATE MATCH="......."        Timeout="0" User="Phone"/> <!-- Local numbers -->
    <TEMPLATE MATCH="2..."           Timeout="0" User="Phone"/> <!-- Corporate Dial plan-->
    <TEMPLATE MATCH="3..."           Timeout="0" User="Phone"/> <!-- Corporate Dial plan-->
    <TEMPLATE MATCH="*"              Timeout="15"/>             <!-- Anything else -->
</DIALTEMPLATE>

dialplan reference:

http://usecallmanager.nz/dial-template-xml.html

Here are some resources that may help

https://blog.zencoffee.org/2015/12/cisco-7965-voip-phones-standalone-asterisk/
https://www.youtube.com/watch?v=2EdH2GdwP2A&ab_channel=PhilippeMartorell
https://www.voip-info.org/asterisk-phone-cisco-79xx/
https://youtu.be/s4tVYB4NeR4

The Sepmac

http://usecallmanager.nz/sepmac-cnf-xml.html

Patching Asterisk to Work on Cisco Phones

http://usecallmanager.nz/patching-asterisk.html

Firmware is Here

http://www.firewall.cx/downloads/cisco-tools-a-applications/cisco-ip-phone-a-ata-firmware-downloads.html

Download The SCCP and SIP Firmware

https://cti-solutions.com/downloads/cmterm-7945_7965-sccp.9-2-1.tar
https://cti-solutions.com/downloads/cmterm-7945_7965-sip.9-2-1.tar
https://cti-solutions.com/downloads/cisco-79xx.zip


Sunday, April 12, 2020

How to Make A Self Signed SSL Certificate Using apache openssl

Make Your Own Self Signed Certificate Using openssl

Step 1: use openssl command

this will make a new key called server.key and a new certificate called server.crt. the expiration will be 2 years from now.

openssl req -x509 -nodes -days 730 -newkey rsa:2048 -keyout server.key -out server.crt

openssl session
This command will make a file called server.key, containing your private key, with no password, and a server certificate called server.crt.

Make a Certificate Request and A Password Protected Private key


openssl req -new -passout pass:"Secret" -keyout priv-pass.key -subj "/CN=asterisk.elevendimensions.com" -out server.csr -sha512 -newkey rsa:2048

making a new private key with password=Secret
Decrypt the private key with your password
openssl rsa -in priv-pass.key -passin pass:'Secret' | head -n2

decrypting the key

References
https://www.sslshopper.com/article-how-to-create-and-install-an-apache-self-signed-certificate.html

Thursday, April 9, 2020

Ellie Mae Encompass - Cannot Initialize MS Word

While Printing Custom Forms It Fails with "Cannot Initialize MS Word"

This Fix Below:


1. When attempting to print a custom doc in Encompass, change the Options drop down box, located at the bottom right of the Encompass Print window, to "Print forms with field IDs".
2. Next, click the Preview button at the bottom of the Encompass Print window.
3. Once Microsoft Word opens up, change the view from Read Mode to Print Layout (lower right corner of the Word document).
4. Close Microsoft Word.
5. Change the Options drop down box, located at the bottom right of the Encompass Print window, to "Print forms with borrower data".
6. Click Print.


Additionally:

-Open Regedit

-Back up HKEY_CLASSES_ROOT\TypeLib\{00020905-0000-0000-C000-000000000046}, by right-clicking on it and selecting Export. name and save the KEY in an easy to access location. This will allow you to recover the KEY is anything goes wrong.

-Delete HKEY_CLASSES_ROOT\TypeLib\{00020905-0000-0000-C000-000000000046}, by right clicking on it and selecting Delete

Encompass Form Failure - How to Fix

When Printing Custom Forms in Ellie Mae Encompass you see Form Failure


With Office 2013 or Office 2016, you may suddenly start seeing failures to print custom forms. The fix is very simple.  There are several things to try.  Before you do this, make sure that Adobe Reader is the default PDF viewer, and the App Compatibility flags are not set.

Delete App Compatibility key


Step 1:

Open Microsoft Word, open a new document in Word, then find the Read Mode and Print Layout buttons in the lower right corner of your Word Document. Press Read Mode, then Press Print Layout.
Press 1, then press 2

Step 2:

Leave Microsoft Word open with a new document open. Print a custom form now. Word will automatically close out.

Conclusion

There are some other things to try.  This other blog entry has more things to try out.  Another fix is to read this too.


Wednesday, April 8, 2020

Shoretel Director - Locked Out Until Full License Compliance Has Been Restored. Get Back In!

Suddenly Without Warning You Are Locked Out of Shoretel Director

You or your phone system administrator has made a change that violated your licensing, such as added softphones or granted some user Workgroup Supervisor roles. And 45 days went by and nobody noticed the red warning banner. Now you are locked out for good.  That's real cute, thanks guys. You need to call Shoretel TAC to unlock it. You may even need to call your "partner" Grrrr....  Unfortunately, the only fix is to add more licences to come into compliance again.  Furthermore, you may have to pay for another compliance token.  Fortunately, there IS another way to weasel your way back into Shoretel Director so you can comply with the licencing.  Our method of weaseling back in is to edit the MainFrame.asp front end director landing page.  First step is to use RDP to logon to the console of your HQ server.  In this excercise, we will show you how to do this with Shoretel 14.2 (build 19.82)  This method will work with Shoretel versions below 15.  With newer versions of Shoretel Connect and Mitel Connect, the method is similar but the ASP files are long gone, and you will have to edit the NGINX files instead. Come back later and we will figure that out too.
Locked Out of Shoretel Director

To unlock it, you need to find the shoretel director landing page html file.
Find and edit the landing page
Now you need to edit the MainFrame.asp code to comment out the locking section
Comment Out these lines and save the file
Edit the page and save the changes. Now open Director in Internet Explorer and you will find that you are able to make changes to the configuration again.

Once you are in compliance again, undo the changes to MainFrame.asp.

Update for Mitel Connect Versions 21.82, and 21.87 and Beyond

The next generation of Shoretel (21.82) and Mitel (21.87) Connect are completely new and re-engineered around a new NGINX and "Ruby on Rails" web framework.  The Ruby back-end code indicates the presence of many backdoor, testing and development hacks that were left behind.  In my opinion the entire web framework is a hack. It is a hacked-up mess of Ruby, mysql, and web technologies.  The license_helper.rb file is a particularly interesting ruby module that could be the key to unlocking locked up servers.

See our other Shoretel related blog entries using this link. If this post helped you out in some way or you would like to add your two cents worth, please leave us a comment.

Sunday, April 5, 2020

Shoretel CDR Database Schema Upgrade 19.XX to 21.82

Schema Upgrade Script Before Import Old Records

Immediately after upgrading from Shoreware 19.XX to Shoreware 21.82, you will want to import your old CDR records.  Before you can do that, you must upgrade the old CDR records by adding some new fields.  My upgrade script will take your old CDR and add those fields.  To use it, import your old CDR into a stand-alone mysql instance and then upgrade it using my handy script, then export it out, finally import the records into your Shoreware director.

Create a Stand-alone Instance of the CDR database


1
2
3
4
5
drop database shorewarecdr;
CREATE DATABASE shorewarecdr;
GRANT ALL ON shorewarecdr.* TO st_cdrreport@localhost IDENTIFIED BY 'passwordcdrreport';
GRANT ALL ON shorewarecdr.* TO `root`@`127.0.0.1` IDENTIFIED BY 'passwordcdrreport';
FLUSH PRIVILEGES;

Upgrade the old CDR


 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
Alter table `agentactivity` Add `TenantID` int(11) NOT NULL DEFAULT '1' AFTER `Archived`;
ALTER TABLE `agentactivity` Add `ClusterID` int(11) DEFAULT '0' AFTER `TenantID`;

Alter table `audio_attendee` Add `TenantID` int(11) NOT NULL DEFAULT '1' AFTER `is_host`;
ALTER TABLE `audio_attendee` Add `ClusterID` int(11) DEFAULT '0' AFTER `TenantID`;

Alter table `call` Add `TenantID` int(11) NOT NULL DEFAULT '1' AFTER `ConfAdjDuration`;
Alter table `call` Add `StartTimeUTC` datetime DEFAULT NULL AFTER `TenantID`;
Alter table `call` Add `EndTimeUTC` datetime DEFAULT NULL AFTER `StartTimeUTC`;
ALTER TABLE `call` Add `ClusterID` int(11) DEFAULT '0' AFTER `EndTimeUTC`;
ALTER TABLE `call` Add `RelatedCallGUID` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL AFTER `ClusterID`;

ALTER TABLE `connect` ADD  `TenantID` int(11) NOT NULL DEFAULT '1'  AFTER `AOC_E`;
ALTER TABLE `connect` ADD  `ProfileID` int(11) DEFAULT '0'          AFTER `TenantID`;
ALTER TABLE `connect` ADD  `AccountID` int(11) DEFAULT '0'          AFTER `ProfileID`;
ALTER TABLE `connect` ADD  `StartTimeUTC` datetime DEFAULT NULL     AFTER `AccountID`;
ALTER TABLE `connect` ADD  `EndTimeUTC` datetime DEFAULT NULL       AFTER `StartTimeUTC`;
ALTER TABLE `connect` ADD  `FPGSync` tinyint(4) DEFAULT '0'         AFTER `EndTimeUTC`;
ALTER TABLE `connect` ADD  `FCLSync` tinyint(4) DEFAULT '0'         AFTER `FPGSync`;
ALTER TABLE `connect` ADD  `DMSync` tinyint(4) DEFAULT '0'          AFTER `FCLSync`;
ALTER TABLE `connect` ADD  `SwitchName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL  AFTER `DMSync`;
ALTER TABLE `connect` ADD  `ClusterID` int(11) DEFAULT '0'  AFTER `SwitchName`;
ALTER TABLE `connect` ADD  `PartyDID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL AFTER `ClusterID`;
ALTER TABLE `connect` ADD  `ExternalSIPCallID` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL  AFTER `PartyDID`;

ALTER TABLE `mediastream` ADD `TenantID` int(11) NOT NULL DEFAULT '1' AFTER `CallLegType`;
ALTER TABLE `mediastream` ADD `ClusterID` int(11) DEFAULT '0' AFTER `TenantID`;

ALTER TABLE `queuecall` ADD  `TenantID` int(11) NOT NULL DEFAULT '1' AFTER `ServerName`;
ALTER TABLE `queuecall` ADD  `ClusterID` int(11) DEFAULT '0' AFTER `TenantID`;

ALTER TABLE `queuedepth` ADD  `TenantID` int(11) NOT NULL DEFAULT '1'  AFTER `QueueDepth`;
ALTER TABLE `queuedepth` ADD  `ClusterID` int(11) DEFAULT '0'  AFTER `TenantID`;

ALTER TABLE `queuestep` ADD  `TenantID` int(11) NOT NULL DEFAULT '1' AFTER `Hunting`;
ALTER TABLE `queuestep` ADD  `ClusterID` int(11) DEFAULT '0' AFTER `TenantID` ;

/* WE DONT USE WEB_ATTENDEE AND WEB_SESSION */

Export the newly upgrade CDR


1
2
mysqldump --user=st_cdrreport --password=passwordcdrreport   --no-create-info  shorewarecdr call connect mediastream queuecall queuedepth queuestep > dump.sql
mysqldump --user=st_cdrreport --password=passwordcdrreport  shorewarecdr agentactivity > dump2.sql