Hi JanP, working perfect. THank you very much. :) Hi JanP, you are right. it seem this is root caused. let me try it. thank you very much :) kelvintee, I tested your DialPlan definition in my Brekeke SIP Server without any issues. So I can get "username" value as the result successfully. I think you ...

Hi JanP, you are right. it seem this is root caused. let me try it. thank you very much :) kelvintee, I tested your DialPlan definition in my Brekeke SIP Server without any issues. So I can get "username" value as the result successfully. I think you don't have the correct settings. Have you set ...

> Pattern: $db.query("vXiPP", "select username from t_userdir where username='%1'") = (.+) > Input: $db.query("vXiPP", "select username from t_userdir where username=' 6597115774@xxxxxx.ngtnetworks.com '") = null Are you sure "6597115774@xxxxxx.ngtnetworks.com" is a SIP username? Yes. we running ...

ambrosio wrote:Are you sure the table "t_userdir" exists in the database?

Yes, I have no issue using the External database for SIP registration authentication. It just failed to query via diaplan.

Is it Advanced Edition? If not, $db.query() doesn't work. Go to the DialPlan history page and check whether the expected rule is executed or not. Yes. is advanced edition and the dialplan did execute but value always return as "null" even the callee is registered in DB ...

Tata wrote:Hope it works.

db-name.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
db-name.url = jdbc\:sqlserver\://xxx.xxx.xxx.xxx\:1433;databasename\=vXiPP
db-name.user = dbusrname
db-name.password = ******

I have setup the connection but still not seeing any SQL response to database.

Did you set variables below in the [Configuration] -> [Advanced] page? --------------------------- db-name.driver = <jdbc_driver> db-name.url = <database_url> db-name.user = <user_name> db-name.password = <password> ---------------------------- Refer http://wiki.brekeke.com/wiki/Execute-SQL-query ...

1. Brekeke Product Name and Version: 3.5.5.2/424-1 2. Java version: 1.8.0_66 3. OS type and the version: Linux version 3.10.0-327.4.4.el7.x86_64 4. UA (phone), gateway or other hardware/software involved: Softphone 5. Your problem: db.query not working via MS SQL. We trying implement dialplan db ...

kelvintee wrote:

redroof wrote:Can you upgrade the CentOS to the latest version?

Yes. going to run brekeke SIP server on latest CentOS 5.8 version.

Everything working fine in CentOS 5.8. No cruel why CentOS 4.9 got got such problem.

redroof wrote:Can you upgrade the CentOS to the latest version?

Yes. going to run brekeke SIP server on latest CentOS 5.8 version.

redroof wrote:Im using several Windows including XP and 7.

Wonder will it CentOS 4.6 causing this issue.

redroof wrote:Did you execute "netstat -a" command to see how UDP ports are consumed?

Yes, everything seem normal. infect using java tools to manual open 2000 UDP port and it can open all port without any problem.

I didn't set any special settings. It means almost default. I set the RTP-relay=on. Have you tried to use another server hardware? My Server is Quad Core 8GB ram so hardware should be good enough. I don't have other server hardware to try. I am running on Centos v4.6. Please share with me what OS ...

in my environment, there are more than 700 concurrent calls. the peak cps is around 120. I doubt a port confliction problem happened in your machine. Let you check it. Make sure close other applications which may use the port 10000 -29999. Open these ports on the firewall. Port open failed error ...

redroof wrote:try the following.

Add net.rtp.native=false in the [Configuration]->[Advanced] page, and restart the SIP Server.

Hi Redroof,

I tried but still getting port allocation failed message in session log during busy hour. What else I can try?

try the following. Add net.rtp.native=false in the [Configuration]->[Advanced] page, and restart the SIP Server. Hi Redroof, Thank you for the suggestion. May I know what is the impact on above changes? Will it affect my proxy RTP & Signalling? I couldn't find any info on this particular setting in ...

What kind of SIP UA are you using? How about memory usage? Are there enough free memory during busy hour? I don't used SIP UA. Those traffic direct terminate from softswitch, I used the SIP server act as SIP proxy server for topology hiding. Porxy SIP signalling and RTP path. No memory issue as ...

is there any error message in sv log? sv log is at webapps\sip\WEB-INF\work\sv\log\2012\04\ Yes. Following keep repeating appear in sv.log Exception: 04/23/12 21:28:21.957 java.lang.NullPointerException com.brekeke.net.sip.sv.SIPex.runImple (null:-1) com.brekeke.thread.ThreadCommon.run (null:-1 ...

1. Brekeke Product Name and version: Brekeke SIP Server v.3 Advanced edition 2. Java version: 1.6.0_31 3. OS type and the version: CentOS 4.6 4. UA (phone), gateway or other hardware/software involved: Class 4 softswitch 5. Select your network pattern from http://www.brekeke-sip.com/bbs/network ...