Messages

46

Mitel MiVoice Business/MCD/3300 / Re: SIP to analogue converters

« on: December 13, 2008, 12:28:36 AM »

I haven't seen any issue yet; though I don't know if they have tried any 40 page transactions.

47

Mitel MiVoice Business/MCD/3300 / Re: SIP to analogue converters

« on: December 11, 2008, 01:21:47 PM »

Well we are using G.711u-law and T.38 over SIP between the vegastreams. We are using an ASU to provide dial tone to one Vega unit, which converts to SIP, goes across the network to another Vegastream which converts back to analog. If you wanted to use a SIP provider that supports faxing you could use the vega units without the need for the ASU, but it would be a completely separate installation from the 3300.

And as far as modems go... I've seen them work and not work. Mitel's sampling and compression software seems to adjust based on system and network load, and the modem's success seems to relate directly to this as well.

48

Mitel MiVoice Business/MCD/3300 / Re: SIP to analogue converters

« on: December 10, 2008, 07:25:39 PM »

Even with T38, faxing (even at low baud rates) does not work well (at all). We have a site that purchased mitel's T38 faxing upgrade and tried to implement it. Currently Mitel has 3 engineers dedicated to out customer trying to figure out how to make it actually work. If you want to fax through your 3300 you'll have to make sure you stay on the TDM side of your 3300. You can't reliably use SIP or MiNET in any way. We purchased some Vegastream Vega 50 Europa units. They are a few hundred bucks but they actually work (and deploying them was cheaper for our customer than deploying the Mitel T38 upgrade). We have a single controller with a few PRIs on it that terminates dial tone into the ASU for faxing. From their we configured the Vega units to do 1:1 to the remote IP sites. If you wanted to get your Fax dial tone from a SIP service provider that supports faxing, you could do that as well and not need the ASU, just a good internet connection. The Vegastream units aren't simple to configure, but if you have trouble just call and they will walk you through it. They even offered to set mine up for me using a remote desktop tool.

49

Introduction and Announcements / Re: Spammers

« on: December 05, 2008, 03:17:34 PM »

That's probably reasonable if you are only getting one or two a week.. but it gets harder if you get a few hundred a day.

50

Introduction and Announcements / Re: Spammers

« on: December 04, 2008, 06:00:37 PM »

Blocking IP addresses and especially IP ranges is probably not a good option. Large spam operations employ botnets which are composed of computers all over, not to mention IP spoofing. Captchas might be an alternative option, or "How much is <integer less than 10> + <integer less than 10>?" or e-mail activation, etc. If the forum grows to any reasonable size IP blacklists just become a nightmare.

51

Mitel MiVoice Business/MCD/3300 / Re: Polycom Voicestation IP 7000

« on: December 04, 2008, 05:48:50 PM »

I've never used that particular sip device but I have used a lot of other SIP devices. Mitel's SIP support isn't what I would call great, but it does work. I have been able to get every SIP device I've ever tried to communicate with the 3300, but your success may very well depend on your knowledge of SIP (the protocol). Note that even if it works 100%, it won't have a lot of the features that MiNET offers, and it won't even  support all SIP features, but you will probably be able to get a connection made and voice flowing through it.

52

Mitel MiVoice Business/MCD/3300 / Re: MSI Package for MiTai

« on: November 22, 2008, 11:01:00 PM »

An MSI is just a way of packaging an executable installer. The job of the MSI is to prepare the installer for installation by providing the EXE arguments that the user would normally input manually. Tools like Resource Hacker (http://www.angusj.com/resourcehacker/) can be used to take installers apart, and to modify them, and to put them back together. There is also the Microsoft Installer SDK which would require you to do a bit of coding. There are, however, many freeware apps that allow you to build MSI installers. I haven't used any of them, since I usually write the installers myself, instead of trying to wrap some other EXE.

53

Mitel MiVoice Business/MCD/3300 / Re: MSI Package for MiTai

« on: November 20, 2008, 09:05:24 PM »

Build one. Just put the .exe in an .msi and write a wrapper to start the .exe installer.

54

Mitel MiVoice Business/MCD/3300 / Re: Call Logging Software (Free?)

« on: November 02, 2008, 01:16:18 PM »

My SMDR settings are as follows (I haven't played around enough to see which ones are required):

DASS II - Call Charge Information Provided:    No
Extended Digit Length:    No
MCD - Report Transfers:    No
Network Format:    Yes
Report Account Codes:    No
Report Incoming Calls:    Yes
Report Internal Calls:    Yes
Report Meter Pulses:    Yes
Report Outgoing Calls:    Yes
SMDR Meter Unit Per Station:    Yes
SMDR Record Transfer:    Yes
System Identification:    1
Time Change Reporting:    No
Twenty-four Hour Time Reporting:    Yes
ANI/DNIS/ISDN/CLASS Number Delivery Reporting:    Yes
SMDR Real Time Reporting:    No
OLI Node ID Format for Incoming Trunk Calls:    No
Extended Time To Answer:    No
SMDR File Transfer:    No
Standardized Network OLI:    Yes
Standardized Call ID Format:    Yes
Suite Services Reporting:    No
Report Internal Unanswered Calls:    No
SMDR Extended Reporting Level 1:    No
Report Attendant Name:    No
Account Code Reporting for Internal Calls:    No
Tag Call Reporting:    No
Tag Call Identifier:     
Path Reporting for Internal ACD2 Calls:    No
Number of destination address digits to mask:    0
SMDR Extended Reporting Level 2:    No
Two B-Channel Transfer Reporting:    No
 
The CSV export is attached so you can attempt an import if you wish. I added the extension .txt because the forum wouldn't let me upload a .csv.

55

Mitel MiVoice Business/MCD/3300 / Re: Call Logging Software (Free?)

« on: November 02, 2008, 05:52:29 AM »

Call-Logger v4.1 Setup Instructions
Download at http://71.28.21.109/call-logger-setup.exe.
 [Editors Note 7/20/12: The link above is no longer active]


Dependencies

Call-Logger is written in and depends on a few packages that are all freely distributed.

• Python (Developed on 2.5 branch)
• mysql-pyhon (The MySQL Connector for Python)
• pywin32 (Python Windows Extensions)
• MySQL Server (Developed on 5.0 branch)

To run Call-Logger you must download all of these packages and install them manually.

• Python

Go to http://python.org/download/releases/2.5.2/ and download the x86 release of Python. Call-loggr
may also work on the Win64-AMD64 version but this has not been tested at all. Once the installer is
downloaded just double-click on it and accept all of the default settings.

• mysql-python

Go to http://sourceforge.net/project/showfiles.php?group_id=22307&package_id=15775 and download an
appropriate version of mysql-python. Call-Logger v4.1 was developed on MySQL_python-1.2.2.win32-py2.5.exe
Once you have downloaded the package install it.

• pywin32

Go to http://sourceforge.net/project/platformdownload.php?group_id=78018 and download the version of
pywin32 that matches your Python version. For me it was the pywin32-212.win32-py2.5.exe (currently
highlighted in green on the downloads page. Install the package once you have downloaded it.

• MySQL

If you already have a MySQL server installed on your network you can optionally skip this step and
perform the MySQL setup listed below on the existing server. If you do not have an existing MySQL
server or you would like to install a separate instance on your server go to
http://dev.mysql.com/downloads/mysql/5.0.html#win32 and download the "Windows Essentials (x86)"
version of the MySQL installer. Note that if you are running a separate MySQL server the version
number doesn't really matter much as long as it is at least MySQL 4.0.0. Once you have downloaded
the install double-click on it and do a "Complete" install. After the installer finishes MySQL will
ask you if you want to configure the instance now, choose yes. My settings are as follows, but pretty
much anything will do.

• Detailed
• Server Machine
• Multifunctional Database
• Include Bin Directory in Windows PATH

Don't forget to set a root password and *remember* it

All other settings are default from what the install chooses.

MySQL Configuration

• Click on Start->All Programs->MySQL->MySQL Server <version>->MySQL Command Line Client
• Enter your password from the Instance Configuration above
• Copy and paste the following commands:

Code: [Select]

CREATE DATABASE logger;

USE logger;

CREATE TABLE `calls` (
  `id` int(11) NOT NULL auto_increment,
  `date` date default NULL,
  `time` time default NULL,
  `length` varchar(15) default NULL,
  `ext` varchar(10) default NULL,
  `trunk` varchar(10) default NULL,
  `digits` varchar(50) default NULL,
  `fdigits` varchar(50) default NULL,
  `city` varchar(50) default NULL,
  `state` varchar(50) default NULL,
  `country` char(2) NOT NULL default 'US',
  `transfer` varchar(10) default NULL,
  `thirdParty` varchar(10) default NULL,
  `accountCode` varchar(50) default NULL,
  `aniClassDigits` varchar(50) default NULL,
  `dnisDigits` varchar(50) default NULL,
  `type` varchar(15) default NULL,
  `rawData` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `extensions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `description` text,
  `ext` varchar(50) NOT NULL default 'xxxx',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ext` (`ext`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `trunks` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `description` text,
  `trunk` varchar(255) NOT NULL default 'Txxx',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `trunk` (`trunk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

GRANT INSERT, SELECT, UPDATE ON logger.* TO 'logger'@'127.0.0.1' IDENTIFIED BY 'logger';


scroll through and look for any errors. If there are none you can type "quit;" to exit the CLI.

MySQL configuration is done.

Install Call-Logger
Double-click on the setup package and follow the on-screen instructions.

Editing the Main Config File

We need to edit the main configuration file so that Call-Logger knows where to find things. To do that,

• click on the Windows "Start" button and choose "Run"
• The Run dialog box will appear with a text-box labeled "Open:" Type "Wordpad" in this box and click on "OK"
• Wordpad (a text editor) will open and display a blank document.
• Click on the "File" menu and choose "Open"
• In the Open dialog box, navigate to where you installed Call-Logger. This is C:\Program Files\Call-Logger\
  by default.
• in the "Files of Type:" select box choose "All Documents (*.*)" and choose the file called config.py and
  click OK. Be careful not to choose config.pyc instead of config.py.

Wordpad is now displaying the configuration contents of your installation. If you followed the instructions above
you do not need to edit any of there parameters (The defaults will be fine) except "host". Set this paramater to
the IP address of your PBX. If you did change anything above make the proper changes here to reflect your earlier
settings.

• Save the file and close Wordpad

Install the Services

Navigate to the Folder where you installed Call-Logger (the default is C:\Program Files\Call-Logger\) and
double-click on install-services.bat. Read the ouput and look for any errors (The word "Error"). If there
are none your installation is complete. Restart your server to test the install.


I wrote these instructions really quickly so let me know if you don't understand or have trouble and any input you have. If people are interested I might make improvements and / or write a front end for the database. I found a bug shortly after I built this version that stops the City, State of a call based on area code, prefix from being reported in some cases. I have fixed this bug and will release the fix after some extended testing. The next version will not depend on python, mysql-python or pywin32. I am going to statically link all of the libraries that I need to simplify installation and configuration.

56

Mitel SX200, SX2000, and older SX platforms / Re: ssh port

« on: October 31, 2008, 11:43:22 PM »

It isn't SSH but there are a range of ports 2000-2004 or so that have plaintext stream sockets on them. You can connect to them using either a plaintext client (netcat, hyperterminal, telnet) or a TLS enabled telnet client (this is required for the maintenance ports). A TLS enabled telnet client is available from Mitel on the 200icp software download page IIRC.

57

Mitel SX200, SX2000, and older SX platforms / Re: Time Server on 200 ICP

« on: October 31, 2008, 11:37:30 PM »

200 inside a Linux hypervisor? hmmm  =( Yes if you set the time on the host OS in this type of setup the guest hardware clock would be updated. Then any time the guest kernel made an explicit / implicit call to get or set time offsets the time would be syncd to the host which is sync'd via NTPd.

58

Mitel SX200, SX2000, and older SX platforms / Re: Teleworker

« on: October 31, 2008, 11:30:39 PM »

I run Nupoint, Teleworker, Mobile Extension all on VMWare Server and / or Xen under Linux 2.6. It may not be officially supported but I would hate to waste an entire server on Teleworker. I've never had any trouble with it (been doing it since MSL was.... MAS6000? or whatever they called it? MSL is an outdated version of CentOS and MAS was SME Server and before that it was E-Smith. All based on CentOS which works on a wide variety of hardware). Spanmirroring means never having to worry about backups.

59

Mitel MiVoice Business/MCD/3300 / Re: Call Logging Software (Free?)

« on: October 31, 2008, 11:17:48 PM »

I have a set of python scripts that are capable of parsing mitel smdr output. They currently are not extremely robust in how they adapt to changes in the smdr format (so you must set your SMDR settings exactly like mine were when I wrote it). Python connects via MySQLdb to a MySQL database and inserts the records. You could then use a query browser or write a web front end to view the records. The version of these that I have that are currently under development are made to integrate with enterprise and are written in C and PHP for the webfrontend. This version can monitor many controllers at once and make relations between calls transfered across IP trunks, but I'm not willing to share the code to all of that.

I will, however, post the python stuff if anyone wants a crude script to parse SMDR to a relational DB.

60

Mitel MiVoice Business/MCD/3300 / Re: ? about Ops/Ent Mgr

« on: October 31, 2008, 11:05:55 PM »

This would be an architecture limitation, Since (without PAE or WAE as Microsoft calls it) 32-bit integers can only address 4GB of memory for any given process. Windows Std and Enterprise will treat this the same way if they are both 32-bit. Switch to a 64-bit version of Windows if you need a single process to consume more than 4GB of RAM.

Oh. And don't use PAE or WAE. 64-bit hardware is cheap now.

*Note I am assuming that 32-bit limitations aren't hard coded into enterprise manager / ops man