hosted Posted January 10, 2010 Report Posted January 10, 2010 The phones have 4 line buttons and that is all we require four our small business. The goal is to allow someone put a call on hold on one extension and allow it to be picked up on another extension. PBXnSIP shows that they only support SNOM phones with this type of setup I dont think key emulation works with Aastra, but would be a fantastic if they added it. We see a lot of packet8 drop off and it would be nice to support their existing phones with key system emulation. The other problem we have is with DTMF - it is hit or miss as to when it works making it impossible to navagate phone menu's when calling Credit Card Co, even My sip provider SOTEL Tell itLogistix to use nexSIP trunks Quote
hosted Posted January 10, 2010 Report Posted January 10, 2010 what is Authentication PIN for? I like how the help (?) field pulls up external web page, but are we going to be able to white label those links? I hope so. Can you make it so there is an option to disable users from changing this field: ANI for emergency calls Quote
Vodia PBX Posted January 11, 2010 Report Posted January 11, 2010 This will be a part of mySQL also right? I hope the login is fixed (disable grants).. No, we dropped the idea of supporting mySQL natively... First of all, there is email2db available (and probably other tools as well), which makes it very easy and reliable to send the CDR into a database of your choice (mySQL, postgreSQL, SQLServer, Oracle, ...). The other thing is that mySQL does not exist in this form any more, check out the news about Sun Microsystems! Quote
mattlandis Posted January 11, 2010 Report Posted January 11, 2010 what is Authentication PIN for? I like how the help (?) field pulls up external web page, but are we going to be able to white label those links? I hope so. Can you make it so there is an option to disable users from changing this field: ANI for emergency calls Alright, i hated to complain too much, but I agree that the help files would look much better if "white label-able". Matt Quote
Vodia PBX Posted January 11, 2010 Report Posted January 11, 2010 Alright, i hated to complain too much, but I agree that the help files would look much better if "white label-able". They are; there is a file called "helplinks.txt", I attach a current snapshot for reference. helplinks.txt Quote
mattlandis Posted January 11, 2010 Report Posted January 11, 2010 No, we dropped the idea of supporting mySQL natively... First of all, there is email2db available (and probably other tools as well), which makes it very easy and reliable to send the CDR into a database of your choice (mySQL, postgreSQL, SQLServer, Oracle, ...). The other thing is that mySQL does not exist in this form any more, check out the news about Sun Microsystems! If there is no mySQL then make it go into MS SQL. There is a free edition. It is a standard. My Opinion. matt Quote
mattlandis Posted January 11, 2010 Report Posted January 11, 2010 They are; there is a file called "helplinks.txt", I attach a current snapshot for reference. Where is the text file? In pbxnsip folder or something? Matt Quote
Vodia PBX Posted January 11, 2010 Report Posted January 11, 2010 If there is no mySQL then make it go into MS SQL. There is a free edition. It is a standard. My Opinion. I used to tend to agree until I found out how easy and powerful it is to use email for this instead. It is a dinosaur technology, but it just works great. All kinds of workflow, achive, you name it is based on email. Email is not only for human interaction, it is also for machine machine interaction. Quote
mattlandis Posted January 11, 2010 Report Posted January 11, 2010 -email2db=it costs $300 (cheapest version) -another thing to config -another thing to keep working -not realtime Just some thots, matt Quote
hosted Posted January 11, 2010 Report Posted January 11, 2010 yea I dont like the email2db option myself. there are to many variables that can break. (email system, email2db app) The SOAP XML CDR function will give all the same information right? (it will generate a XML for an agent logging in) Quote
shopcomputer Posted January 14, 2010 Report Posted January 14, 2010 yea I dont like the email2db option myself. there are to many variables that can break. (email system, email2db app)The SOAP XML CDR function will give all the same information right? (it will generate a XML for an agent logging in) I agree MS SQL would be the best option, once we have it in SQL, we can do what ever we need to. Email2db is not ideal I did try it a while back. Quote
Vodia PBX Posted January 14, 2010 Report Posted January 14, 2010 I agree MS SQL would be the best option, once we have it in SQL, we can do what ever we need to. Email2db is not ideal I did try it a while back. The problem with talking to the SQL servers of the world is that they all have their little dirty login mechanisms, way of stating the SQL statements etc. I thought it would be an ASCII-based protocol such as SMTP or POP3; but seems that was a mistake. You have to implement the whole history of mySQL versions with all their little changes in the protocol. So we are back to SOAP and Email. Quote
mattlandis Posted January 14, 2010 Report Posted January 14, 2010 Once again, your talking mySQL and we are talking Microsoft SQL. Have you taken a look at MS SQL? Just want to make sure we are on the same page. take care, Matt Quote
shopcomputer Posted January 14, 2010 Report Posted January 14, 2010 Once again, your talking mySQL and we are talking Microsoft SQL. Have you taken a look at MS SQL?Just want to make sure we are on the same page. take care, Matt Yes MS SQL also requires a login, unless you are using an ODBC, which stores the login. It should not be difficult to configure a data source, similar to the way any website stores a data source. <!-- Connection String for SQL Server 2000/2005 <add name="SiteSqlServer" connectionString="Server=(local);Database=PBXnSIP;uid=;pwd=;" providerName="System.Data.SqlClient" /> If you can't do this, then we will need to create a simple webpage to capture your soap traffic, and store in a SQL database. Quote
pbx support Posted January 14, 2010 Report Posted January 14, 2010 Yes MS SQL also requires a login, unless you are using an ODBC, which stores the login.It should not be difficult to configure a data source, similar to the way any website stores a data source. <!-- Connection String for SQL Server 2000/2005 <add name="SiteSqlServer" connectionString="Server=(local);Database=PBXnSIP;uid=;pwd=;" providerName="System.Data.SqlClient" /> If you can't do this, then we will need to create a simple webpage to capture your soap traffic, and store in a SQL database. The issue here is not about storing these values(connection string). That part is easy and we can do it anytime. The major issue is the authentication mechanisms (for sending the user name / password / database names etc natively without using ODBC). That is the reason why we want to use a common interface (like the SOAP or email) and let the customer use whatever they are familiar / comfortable with on other side(MySQL, MS-SQL, postgres, Oracle etc). The advantage of this approach is that PBX does not have to tied into the database vendor's version cycle. Quote
mattlandis Posted January 14, 2010 Report Posted January 14, 2010 odbc IS that open channel... Matt Quote
Carl Johnson Posted January 27, 2010 Report Posted January 27, 2010 I agree with the forum admin .. SOAP is the native answer .. all major databases have a native ability now to take input via SOAP without any 3rd party, here are the MSSQL docs .. I think your issue is you may not want to pay for it .. http://msdn.microsoft.com/en-us/library/ms...23(SQL.90).aspx odbc IS that open channel... Matt Quote
Vodia PBX Posted January 28, 2010 Report Posted January 28, 2010 Whow, this is big! Seems SQLServer supports SOAP very well. We might be able to interface to the SQLServer very easily! For mySQL I could not find anything except the usual PHP/Apache stuff where you have to program the SOAP processing in PHP. Quote
mattlandis Posted January 28, 2010 Report Posted January 28, 2010 If you can make the steps to integrate to SQL please publish them. (i'm not a soap/xml expert--much more familiar with tradiontal SQL methods) We don't have any problem with SQL licensing. Matt Quote
Top System Posted February 1, 2010 Report Posted February 1, 2010 May be can you have a look at this new topic : PBXNSIP cdr2sql Quote
hosted Posted February 1, 2010 Report Posted February 1, 2010 I would prefer SOAP over email2db also. We dont have a problem with the current mysql either. we just ip-tables restrict what can access the wide open mysql server oops did i say that out loud? ut oh.. good thing its just CDR info ip-tables rocks. Quote
mattlandis Posted February 1, 2010 Report Posted February 1, 2010 hey Nexsip, Send it to MS SQL with the new tool and things are secure... ;-) (i didn't get the tool...but ms sql is secure) Matt Quote
hosted Posted February 4, 2010 Report Posted February 4, 2010 I have not tried it yet. But I like SOAP so hopefully it can send a agent login message and more ACD stats.. not just simple CDR Quote
mattlandis Posted February 23, 2010 Report Posted February 23, 2010 I would love to test the latest v4.x version for windows If i can get the download link. you can email to me if it shouldn't be here. tx matt Quote
Vodia PBX Posted February 24, 2010 Report Posted February 24, 2010 We will make a MSI image available today or tomorrow. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.