Hi list
Having installed kamailio 4.2 and siremis 4.4 I now get the below error when browsing to either the 'subscribers list' or the 'location list' tried both deb8.8 and ubuntu 14.04 using MySQL and php5 with apache2
Error message: #0, Error in query:: SELECT T0.id, T0.username, T0.domain, T0.contact, T0.received, T0.path, T0.expires, T0.q, T0.callid, T0.cseq, T0.last_modified, T0.flags, T0.cflags, T0.user_agent, T0.socket, T0.methods, T0.ruid, T0.instance, T0.reg_id, T0.server_id, T0.connection_id, T0.keepalive, T0.partition FROM `location` T0 LIMIT 10. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'T0.server_id' in 'field list'
Script name and line number of error: /var/www/siremis-4.4.0/openbiz/bin/data/BizDataObj_Lite.php:447
Any ideas please
Thanks
Clive
Sent from my iPhone
Hello,
i installer siremis on centos .
i need help or manual tu configure it .
there is no help on the net .
thank you .
Borhen Ben Jedidia
borhen(a)praxys-crm.com
Technico-commercial
Skype: borhen3856
Mobile 1 : 00 216 26 76 78 77
Mobile 2 : 06 12 95 62 91
Ligne directe : 01 78 76 90 80
www.praxys-crm.com
Hello
I am working with Kamailio 5.0 dispatcher module. I am aiming at having two
or more gateways receiving the traffic with load balancing, and when one
fails, that the traffic is distributed among others. Currently, testing
with 2 gw.
I see the options message going out (and not being answered). When I
monitor with kamctl dispatcher dump, I never see the faulty gw going
inactive (flags remain AP), and calls are still tried to the faulty gw.
"Best" result so far is with ds_probing_mode=1, the flags start at AX with
both gateway up, then AP once they've replied to an OPTIONS, and even if I
stop one, and OPTIONS is no longer replied, it stays at AP. when a call
comes through, it is tried on this GW (3 invites), and then fails onto the
other one. I was expecting that the gw would not be tried if inactive.
Am I missing something ?
J.
modparam("dispatcher", "db_url", DBURL)
modparam("dispatcher", "table_name", "dispatcher")
modparam("dispatcher", "flags", 2)
modparam("dispatcher", "dst_avp", "$avp(AVP_DST)")
modparam("dispatcher", "grp_avp", "$avp(AVP_GRP)")
modparam("dispatcher", "cnt_avp", "$avp(AVP_CNT)")
modparam("dispatcher", "sock_avp", "$avp(AVP_SOCK)")
modparam("dispatcher", "ds_ping_method", "OPTIONS")
modparam("dispatcher", "ds_ping_from", "sip:probe@probe")
modparam("dispatcher", "ds_ping_reply_codes",
"class=2;class=3;class=4;class=5")
modparam("dispatcher", "ds_ping_interval", 30)
modparam("dispatcher", "ds_probing_mode", 1)
modparam("dispatcher", "ds_probing_threshold", 3)
modparam("dispatcher", "ds_timer_mode", 1)
Hi list,
We are using RTPProxy as media proxy. When doing a SIPcall we would need
to know the final ports used by RTPProxy.
Hence I would need to access the rewritten SDP of the 200 OK send by our
application server.
Unfortunately we are not achieving to get that rewritten SDP.
I tried calling sdp_print("1") using module sdpops just after calling
rtpproxy_offer or rtpproxy_answer in kamailio script. (According the doc
those methods do: "Rewrites SDP body to ensure that media is passed through
an RTP proxy. To be invoked on INVITE for the cases the SDPs are in INVITE
and 200 OK and on 200 OK when SDPs are in 200 OK and ACK".)
However the sdp we print just after calling that is still having the
original ports set by the AS but not the ports used in the rtpproxy or that
we will send to the client in the rewritten SDP
What are we doing wrong? Any hint how we can get the rewritten SDP in the
200 OK answer we send to caller side?
Hi all,
Theoretical question about the role of a Kamailio proxy which is also a registration server for UAs.
Assuming a B2BUA on IP 1.2.3.4 behind the Kamailio proxy. Kamailio receives an INVITE from this B2BUA with From and Contact as something like sip:4321@1.2.3.4
When Kamailio routes the INVITE to that UA, is it Kamailio’s responsibility to change the domain part of the From and/or Contact to itself (e.g. sip:4321@proxy.mytld.com)?
The question has arisen from Polycom missed call “call back” behaviour. When issuing a call back from a Polycom, following a missed call, it sends the call directly to the full URI in the INVITE’s From (or maybe Contact… I’ve not fully tested yet). As such the call is sent to the B2BUA, which UAs do not have access to, and thus times out.
I suspect here the answer is “no”, and the Polycom must be configured to force all outbound calls through the proxy… but thoughts welcome.
Cheers
Phil
Hello,
I build three kamailioes, one acts as a pass-through proxy as well as load-balancing, the two registrars.
The kamailio_1 decides to which registrar the REGISTER should forward by a dispatcher based on db_text.
----->kamailio_2(IP2, registrar)
SoftPhone--->kamailio_1(IP1, pass-through proxy)--|
| ----->kamailio_3(IP3, registrar)
|
dispatcher(db_text)
I expect the kamailio_1 forward the REGISTERs to kamailio_2/kamailio_3, and kamailio_2/kamailio_3 respond with 200 OK. But in fact, the registrars send the REGISTER back to kamailio_1.
I think the reason is that the host part of Request-URI in REGISTER from SoftPhone is IP1, and kamailio_1 does not rewrite it as a pass-through proxy, so kamailio_2/kamailio_3 will find the host in Request-URI is not mine, thus route the REGISTER back to kamailio_1 according Request-URI.
The setting of SoftPhone cannot be changed, so is it possible to :
1) replace host part of Request-URI in the REGISTERs with the result of dispatcher in kamailio_1 , or
2) force kamailio_2/kamailio_3 to respond rather than forward?
Thanks!
Hello Everyone,
Trying understand how push notification works based on Daniel example
in 2014
Code in question:
if(lua_runstring("do_push([[$hdr(X-VxTo)]], [[$tU]],
[[$hdr(X-VxFrom)]], [[$fU]], [[$ci]])")<0) {
send_reply("501", "No link to destination");
exit;
}
I understand how string should look like, but lua give this error
ERROR: app_lua [app_lua_api.c:607]: app_lua_runstring(): lua loading
state not initialized (call: do_push([[<null>]], [[4310]], [[<null>]],
[[4311]], [[dd4cb9b2-bf21-1235-05b5-5254003e39bb]]))
Is possible clarify how this part should work ?
volga629
Hello there,
I'm trying to use the following command:
*kamctl rpc get_statistics usrloc::registered_users*
and i'm getting the following errors:
{
"jsonrpc": "2.0",
"error": {
"code": -32000,
"message": "Execution Error"
},
"id": 12006
}
ERROR: jsonrpcs [jsonrpcs_mod.c:1323]: jsonrpc_exec_ex(): method callback
not found [get_statistics]
Question here is:
This rpc raw command isn't available on new kamctl v5? or i have to call
this in a different way?
Thank you
Regards
José Seabra
Hi anyone,
Kamailio server receive a register packet, but IP addr of request line is not same with addr of kamailio server ,then ther server will transfer it out. Now I want kamailio server process it as it receive a register itsself. So how do I close proxy function of kamailio server.
For Example:
Receive packet:
========================================
REGISTER sip:113.80.5.159:9198 SIP/2.0
kamailio server: 222.222.1.2
--
Best Regards,
Shengy
