INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

VM PRO in Linux interactions with databases

VM PRO in Linux interactions with databases

(OP)
Hi,
The release 10.1 of VM Pro based in Linux is working with database interactions. In previous releases it was forbidden.
According to the documentation:

For Linux-based voicemail servers (IP Office Server Edition and IP Office Application Server), from Release
10.1, database interoperation is supported with external PostgreSQL and MySQL databases. However,
database actions are not supported on the Unified Communications Module.

Does anyone knows if it is also working with SQL Server Databases or it is limited to PostgreSQL and MySQL?
It doesn't any sense if it is only limited to those databases.
Regards

RE: VM PRO in Linux interactions with databases

the docs state it is limited to PostgreSQL & MySQL

it makes perfect sense because those are both open source enterprise grade database engines that run Linux (And windows) and (iirc) as they are both GPL* do not incur any cost to distribute.



* actual postgresql ha its own licensing terms but they are very similar to the BSD licence which has almost no restrictions

Quote:

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

These two paragraphs (or close facsimiles thereof) appear in all proprietary licences as well so no big deal there.

it is also the DB engine used by contact store/recorder for precisely the same reasons.

It should be a relatively trivial task to write a scheduled task that would copy relevant data from a MSSql server to Postgreql on the IP Office server as required.




Do things on the cheap & it will cost you dear

RE: VM PRO in Linux interactions with databases

"It doesn't any sense if it is only limited to those databases." - Why?

Stuck in a never ending cycle of file copying.

RE: VM PRO in Linux interactions with databases

(OP)
Because could be plenty of enterprises willing enough to pay for that SQL Server connector as my own company. Once Avaya has developed the connector against one DDBB working with Linux I assume the develop efforts to do it with SQL Server will be insignificant. But for sure the reasons are as IPGuru said.

Regards

RE: VM PRO in Linux interactions with databases

Avaya hasn't developed the connectors, they are using standard ODBC connectors in Linux and seems to have started with supporting MySQL and PostGRESQL.

I wouldn't be surprised if support for MSSQL comes in a later release. but it seems like you should be able to install it yourself if you really want looking at how it's implemented in AppServer.
It's on my "Test when bored list" but that day hasn't come yet =|

"Trying is the first step to failure..." - Homer

RE: VM PRO in Linux interactions with databases

I believe Microsoft have already written an ODBC driver for linux for free that Avaya can use. Having said this however the IP office SE uses unixODBC as the driver manager but for some reason they are using version unixODBC-2.2.14-14. The Microsoft SQL ODBC driver requires unixODBC-2.3.0.

https://docs.microsoft.com/en-us/sql/connect/odbc/...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close