| Author |
Message |
 Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
 Forum: Brekeke SIP Server Forum Posted: Thu May 12, 2016 2:32 am Subject: Diaplan db.query not working |
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 definitio ... |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Tue May 10, 2016 10:11 pm Subject: Diaplan db.query not working |
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 ... |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Mon Mar 28, 2016 3:16 am Subject: Diaplan db.query not working |
> Pattern: $db.query("vXiPP", "select username from t_userdir where username='%1'") = (.+)
> Input: $db.query("vXiPP", "select username from t_userdir where u ... |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Sun Mar 27, 2016 9:40 am Subject: Diaplan db.query not working |
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.  |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Tue Mar 08, 2016 7:40 pm Subject: Diaplan db.query not working |
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 e ... |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Mon Mar 07, 2016 9:12 pm Subject: Diaplan db.query not working |
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 ... |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Mon Mar 07, 2016 8:23 pm Subject: Diaplan db.query not working |
Did you set variables below in the
Thank you. Didn't notice require configure connection again. Thought it will make use of existing connection.  |
| Topic: Diaplan db.query not working |
kelvintee
Replies: 16
Views: 18153
|
Forum: Brekeke SIP Server Forum Posted: Sun Mar 06, 2016 9:47 pm Subject: Diaplan db.query not working |
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/ ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Mon May 14, 2012 1:58 am Subject: Port Allocation failed |
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 p ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Sun May 06, 2012 8:41 pm Subject: Port Allocation failed |
Can you upgrade the CentOS to the latest version?
Yes. going to run brekeke SIP server on latest CentOS 5.8 version. |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Fri May 04, 2012 7:38 am Subject: Port Allocation failed |
Im using several Windows including XP and 7.
Wonder will it CentOS 4.6 causing this issue. |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Fri May 04, 2012 7:37 am Subject: Port Allocation failed |
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 ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Wed May 02, 2012 7:32 am Subject: Port Allocation failed |
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 enou ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Thu Apr 26, 2012 12:57 am Subject: Port Allocation failed |
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 app ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Wed Apr 25, 2012 12:22 pm Subject: Port Allocation failed |
try the following.
Add net.rtp.native=false in the
Hi Redroof,
I tried but still getting port allocation failed message in session log during busy hour. What else I can try? |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Tue Apr 24, 2012 9:09 pm Subject: Port Allocation failed |
try the following.
Add net.rtp.native=false in the
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 c ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Tue Apr 24, 2012 3:05 am Subject: Port Allocation failed |
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 ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Tue Apr 24, 2012 3:03 am Subject: Port Allocation failed |
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.NullPoin ... |
| Topic: Port Allocation failed |
kelvintee
Replies: 19
Views: 19226
|
Forum: Brekeke SIP Server Forum Posted: Sun Apr 22, 2012 12:04 am Subject: Port Allocation failed |
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/soft ... |
| |
