Unable to delete ShoreTel trunk group

Unable to delete ShoreTel trunk group

Email
(1 Vote)

Unable to delete ShoreTel trunk group

trunk group not deleting

 

So you are trying to delete a trunk group in Mitel Connect (previously ShoreTel) and you just keep getting this blue bar moving across the screen over and over. Why you no delete!? 

 Quick Note: Please be sure that all each user group has this old trunk group removed from the Outgoing trunk groups section.


usergroup trunks

Today, we will go through what is causing this and how to resolve it. First off, I want to warn you that this does require us to get into the database. Let's dive in!

What is causing this?

Prior to the ShoreTel connect days we use to have a section on user profiles that would specify your default trunk group. Since the move to bigger and brighter versions, this has been removed from the GUI, but... not from the database. Since we no longer have the option in the bulk edit tool to change this default trunk group, we have to go into the database.

 *Warning*: Anything you do in the database is not Mitel recommended. Just like the registry on your computer, you could seriously do damage to your phone system. I highly recommend doing a database backup prior to any work we do here.

 First, we will do our database backup.

D:\Program Files (x86)\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server\Examples\BackupConfig.bat

 Our Shoreline Communications folder is in D:\ because if our OS ever get's corrupted or crypto locked, then our telephone system files are still safe.

run backup as administratorbackup runs

 Don't forget to grab your backup from C:\ to a safe location as this is the default location it saves to, unless you changed your backup script.

 config dump file

 

saved config dump

 

 To get into the database, you will need a program like SQLyog or any SQL database client. Setup your client with the proper credentials to access the Mitel Connect database.
shoretel database credentials

 Now we want to find out what is the TrunkGroupID for our trunk group that we are trying to delete. In our example it shows TrunkGroupID 6.


shoretel trunk group id

Now that we know the TrunkgroupID, we can go find out what users are still configured to use this. After going to the users table we want to search to the right and find the table header called DefaultTrunkGroupID.

 Make sure that you are viewing all records, box circled in red, as most programs will limit the amount of rows you view so that the data loads faster. What we see in this screenshot is that we have a user with our TrunkGroupID 6. We want to change this, so that the database no longer has a reference to the Trunk Group we are trying to delete.

 shoretel users table default trunkgroup id

 I want to set this user's default trunk group to 'Denmark SIP' TrunkGroupID 10. I chose this because this is the current trunks the user should already be using since the old trunk group is actually no longer functional.

 shoretel users table default trunkgroup id updated

 That's it for changes! We will want to scroll up and down all of the users to ensure these users are changed to the current trunk group ID that they are using today. Once you complete this step, be sure to hit save!

 database save button

 

When you go back into Mitel Director be sure to refresh your page, you should now be able to delete the trunk group.


Leave a comment

© Copyright 2020 by Trifecta IT Solutions Pty. Ltd. All Rights Reserved.

Press enter to search

Trifecta IT Solutions

The ultimate experience

We provide Top Class telephony engineers for your projects, integrations, and customer support. Improving your customer satisfaction and saving you time and money.

(+61) 2 9158 6650
[email protected]
Sydney, NSW 2000

Opening Hours

Mon - Fri
9:00 am to 18:00 pm
Saturday
Closed
Sunday
Closed

CEO's Words

Trifecta CEO image

Our goal is to help our partners grow and to take on more business by offering highly skilled engineer services. Why pay for a low skilled engineer when you can get the job done right the first time and in fraction of the time with an engineer who knows what they are doing?

Trifecta CEO signature

Get Connected

facebooklinkedin