Mitel MiCollab or NuPoint database export

ssh root@10.11.12.13
(admin password)

sudo -u postgres psql -p 5444 -d NuPoint -c "copy np.np_mbox_id to '/tmp/mboxid.csv' with (format csv,header)"

exit

scp root@10.11.12.13:/tmp/mboxid.csv .

Contents of csv:

Mitel NuPoint auto attendant override message.

I think of this feature as an alternate greeting.

Example:
"We are closed for the snowstorm today."

The message can be recorded and enabled remotely via phone.

Dial in to the message center.
xxxx * (Attendant mailbox number and *)
Passcode
* (AA options)

Here is what my call flow looks like.

How to use Multi-device licenses on Mitel MCD.

Users and Devices form.
Change the Service Level to Multi-device



Multi-device User Groups form.
Add a group with one member.


Now it works like a normal phone.

Mitel TA7102 SIP setup with MCD.

Do not use the wan port. It has a DHCP server that caused havoc on my network.

Use the lan port and find the IP address on your router. The MAC address usually begins with 00:90:f8.

Login with the default user of "public" and no password.

These three screens are the minimum configuration I needed to receive a fax with the device.







I can not get one of these to make calls on the Mitel 3300 yet!!!

If anyone knows how, let me know.

How to change Mitel 3300 system telnet password.

I recently found out you can telnet into Mitel systems with a default password. Https and telnet have different system passwords. Even if you change the password in the browser, telnet is still open.

Here is the way to change the telnet password.

telnet 1.2.3.4

Welcome to the SX-2000 (vxTarget)

login: sytem

Password:       

ESC 6 for maintenance.

Reset Password System, New Password       , Verify New Password

Mitel 3300 phone systems with telnet port open!!!

I went to shodan.io and searched for "SX-2000 port:23"

There are some Mitel phone systems open to the Internet with telnet. The default password has probably been changed so you can not login with HTTPS. But telnet is available with a default login.

WARNING

If you change the system login, this does not change the telnet login.

Someone could access these systems and view all programming.

Update: You can use maintenance commands like "busy extension 1234" to busy out an extension. The phone is then unusable.

Port 1752 is also available to view SMDR call records.

Don't connect Mitel systems directly to the Internet!

Mitel SMDR call records with telnet port 1752.

telnet 10.1.2.3 1752

 07/03 09:37A 0000:00:00 T104     *** 4372                      E
 07/03 09:37A 0000:00:49 T103     005 3225                        3225
 07/03 09:38A 0000:00:22 T101     004 3225                        3225
 07/03 09:53A 0000:00:01 T101     *** 1808                      E
 07/03 10:21A 0000:00:57 T101     008 3235                      T 3236
-07/03 10:24A 0000:06:33 T101     008 3215                        3215
 07/03 10:31A 0000:00:31 T102     009 3235                      T 3236
 07/03 11:00A 0000:01:06 T101     006 3225                        3225
 07/03 11:06A 0000:02:28 T101     006 3221                        3221
 07/03 11:29A 0000:02:04 T101     002 3223                        3223
 07/03 12:40P 0000:00:24 T101     *** 3216                        3216
 07/03 12:59P 0000:00:20 T103     002 3210                        501

The phone numbers are usually on the right side but I deleted that info. This is very quick and useful for troubleshooting phone issues.

How to extract music on hold from Mitel 3300.

I put a music file on the Mitel a couple of years ago. Now I need to put it on another Mitel and of course I lost the original file.

ftp mitel-ip

cd "/db"

cd "eMOH"

ls

The file name does not match the name in the GUI.

Mitel command line trunk busy-out.

I have a Mitel with two PRI circuits. The 2nd PRI is bouncing every few minutes. Almost every time you get on the phone, the call is dropped. I wanted to busy-out or disable the 2nd trunk group to force all the phone calls to the good PRI. I could not find a way in the GUI so back to the command line.

busy trunk group 2 ( The status of the lines will change to man-busy.)
rts trunk group 2     ( Return to Service.)

The first time I tried this, the status of the lines changed to "not seizable." The command below fixed that.

dtstat clear 3 1 3 1   ( This command restored the lines to Idle. You will need to find cabinet, shelf, slot, and circuit to use dtstat.)

Now I wish the telco provider would get the PRI fixed!

Mitel 3300 command line intro.

You may have used the "Maintenance Commands" tool form the Mitel web interface. You can also telnet to the system and use some of the same commands. This is good for me because it works on a Mac which I use most of the time. I have always been irritated that the GUI requires IE.

telnet 10.1.2.3
system / xxxxxx  (Hint: This is not the same system password as the GUI)

There is a numbered menu bar at the bottom of the screen. To use these functions, type Esc and the number.

Here are my favorite commands.

stat trunk group 1 (This shows how many lines are busy)
cong (Traffic congestion report)
traffic status (I have not figured out how to use this feature yet but I want it)
loc num xxx (Identify extension number)
loc feat ext xxx (Shows if an extension is forwarded or if message light is on)

I will explore this CLI more later on.

Creating music on hold for Mitel with Audacity.

The Mitel 3300 is very picky about the format of MOH files you can upload. First I find free music from somewhere like archive.org. Open the file with Audacity and convert track to mono. Change the Project Rate to 8000 Hz and then export as WAV (Microsoft) and U-law.

Update:

Check Ghost Notes for some interesting hold music. The artist gave me permission to use his stuff.

http://ghostnotes.blogspot.com/