hi
SRV records are all in place, but as I trace the DNS lookup queries sent
by the OpenSER host, it only asks for A records for "iptel1.ipatl.se" and
no NAPTR or SRV. the hostname that the NAPTR and SRV records points to is
"sip.iptel1.ipatl.se", but this is not resolved by OpenSER for the route-header
destination.
but, for the initial INVITE, OpenSER correctly queries NAPTR and SRV rr to
resolv the hostname/IP of the server responsible for the domain "iptel1.ipatl.se".
i'm familiar with the rfc3263, and all is set up correctly and working just fine.
best regards,
/staffan
> -----Ursprungligt meddelande-----
> Från: users-bounces(a)openser.org
> [mailto:users-bounces@openser.org] För Norman Brandinger
> Skickat: den 6 juli 2006 14:57
> Till: users(a)openser.org
> Ämne: Re: [Users] Route-header DNS lookup?
>
> Hi Kerker,
>
> Perhaps there needs to be SRV records in the DNS server that
> manages iptel1.ipatl.se.
>
> Below are example SRV records. If this is your first time
> working with SRV records, I strongly suggest reading some of
> the online doc that deals with them.
>
> _sip._tcp.iptel1.ipatl.se. IN SRV 0 0 5060
> sip.iptel1.ipatl.se.
> _sip._udp.iptel1.ipatl.se. IN SRV 0 0 5060
> sip.iptel1.ipatl.se.
>
> Regards,
> Norm
>
> Kerker Staffan wrote:
> > hi
> > i recently bounced into this problem, and i'm not sure here.
> > i'm running the openser-devel, with the cacheless
> db_mode=3. (works
> > fine btw)
> >
> > the record-route header received by the proxy on the other side
> > (SNOM4S), inserts the domain name (iptel1.ipatl.se) and not the
> > hostname (sip.iptel1.ipatl.se) in the record-route header,
> and uses the maddr=<ip_of_server> with the actual server IP address.
> >
> > now, when my client (behind the OpenSER) replies with an
> ACK to the
> > incomming OK, it uses the Route-header recieved in the
> RR-header, and
> > sends the ACK to OpenSER. i then get the following errors
> in OpenSER.
> >
> > ---
> > /usr/local/sbin/openser[3583]: ERROR: mk_proxy: could not
> resolve hostname: "iptel1.ipatl.se"
> > /usr/local/sbin/openser[3583]: ERROR: uri2proxy: bad host
> name in URI
> >
> <sip:4ffec4ce755c218a72228c6643cb3b6b@iptel1.ipatl.se:5060;ma
> ddr=172.2
> > 8.248.66;transport=udp;lr>
> > ---
> >
> > the ACK i sent look like this:
> >
> > ---
> > Request-Line: ACK sip:2307@iptel1.ipatl.se;gruu=6fg9n6dl SIP/2.0
> > Via: SIP/2.0/UDP
> 172.28.248.52:2051;branch=z9hG4bK-d96b1fvapkyn;rport
> > Route: <sip:172.28.248.10;lr=on;ftag=li9buf1i4p>
> > Route:
> <sip:4ffec4ce755c218a72228c6643cb3b6b@iptel1.ipatl.se:5060
> ;maddr= 172.28.248.66;transport=udp;lr>
> > From: "Snom 2652" <sip:2652@ipatl.se>;tag=li9buf1i4p
> > To: <sip:2307@ipatl.se>;tag=hvseiz7kgb
> > Call-ID: 3c269d83900b-xj3ild14y880@snom360
> > CSeq: 1 ACK
> > Max-Forwards: 70
> > Contact: <sip:2652@172.28.248.52:2051;line=cp4a7ljd>
> > Content-Length: 0
> > ---
> >
> > as far as i understand, according the rfc 3263, the
> route-header may
> > contain domain name that has to be resolved using SRV.
> >
> > ---
> > "6 Constructing SIP URIs
> >
> > In many cases, an element needs to construct a SIP URI
> for inclusion
> > in a Contact header in a REGISTER, or in a Record-Route
> header in an
> > INVITE. According to RFC 3261 [1], these URIs have to have the
> > property that they resolve to the specific element that inserted
> > them. However, if they are constructed with just an IP
> address, for
> > example:
> >
> > sip:1.2.3.4
> >
> > then should the element fail, there is no way to route
> the request or
> > response through a backup.
> >
> > SRV provides a way to fix this. Instead of using an IP
> address, a
> > domain name that resolves to an SRV record can be used:
> >
> > sip:server23.provider.com"
> > ---
> >
> > now, OpenSER only asks DNS for an A record of the name
> recieved in the
> > route header, and since that's a domain name, it's
> unresolvable, and so the ACK is never sent.
> >
> > any hints or clues?
> >
> > best regards,
> > /Staffan Kerker
> >
> >
> > --
> > Staffan Kerker
> > Saab Communications, Växjö
> > p. +46 470 42185
> > c. +46 705 391365
> > m. staffan.kerker(a)saabgroup.com
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
> >
> >
> >
>
>
> _______________________________________________
> Users mailing list
> Users(a)openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
Hi,
I guess acc_db is for local db accounting.
How can I use this module ?
I couldn't see any documentation in the sources.
Thanks,
ilker
<http://387555.sigclick.mailinfo.com/sigclick/0B090F04/0C074F06/0A05004D/0B7…>
_____________________________________________________________________________________________________________________________________________
Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.
This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
_____________________________________________________________________________________________________________________________________________
Okay, I'm trying to use uac_replace_from to anonymize the From: in order to
suppress ANI. I think I've got it, but it seems like the behavior isn't what
I expect. First, the relevent config file section:
if (search("Anonymous")) {
uac_replace_from("","sip:anonymous@xxxxxxx.com");
append_rpid_hf("",";party=calling;id-type=subscriber;screen=yes;privacy=full");
log(1,"Made a call anon");
};
Now, the headers as they go in and come out:
SIP MESSAGE 4 xx.7.96.185:5061() -> xx.7.96.82:5060()
UDP Frame 4 30/Jun/06 08:30:57.4723
TimeFromPreviousSipFrame=0.0069 TimeFromStart=0.0204
INVITE sip:1360789xxxx@voip02.xxxxxxx.com SIP/2.0
Via: SIP/2.0/UDP xx.7.96.185:5061;branch=z9hG4bK-7fa6fcd6;rport
From: Anonymous
<sip:+136091xxxxxx@voip02.xxxxxxxx.com>;tag=8c07328919ade13ao1
To: <sip:1360789xxxx@voip02.xxxxxxxx.com>
Call-ID: 51835bf5-ba1be6be@localhost
CSeq: 102 INVITE
Max-Forwards: 70
Contact: Anonymous <sip:+136091xxxxx@xx.7.96.185:5061>
Expires: 240
User-Agent: Sipura/SPA2000-3.1.5
Content-Length: 311
Allow: ACK, BYE, CANCEL, INFO, INVITE, NOTIFY, OPTIONS, REFER
Supported: x-sipura
Content-Type: application/sdp
SIP MESSAGE 6 xx.7.96.82:5060() -> xx.7.96.90:5060()
UDP Frame 6 30/Jun/06 08:30:57.4791
TimeFromPreviousSipFrame=0.0007 TimeFromStart=0.0272
INVITE sip:360789xxxx@xx.7.96.90:5060 SIP/2.0
Record-Route: <sip:xx.7.96.82;ftag=8c07328919ade13ao1;lr=on>
Via: SIP/2.0/UDP xx.7.96.82;branch=z9hG4bKe9d1.8c515a97.0
Via: SIP/2.0/UDP xx.7.96.185:5061;branch=z9hG4bK-7fa6fcd6;rport=5061
From: Anonymous <sip:36091xxxxx@voip02.xxxxxxxx.com>;tag=8c07328919ade13ao1
sip:anonymous@xxxxxxxx.com
To: <sip:360789xxxx@xx.7.96.90:5060>
Call-ID: 51835bf5-ba1be6be@localhost
CSeq: 102 INVITE
Max-Forwards: 69
Contact: Anonymous <sip:+136091xxxxx@xx.7.96.185:5061>
Expires: 240
User-Agent: Sipura/SPA2000-3.1.5
Content-Length: 311
Allow: ACK, BYE, CANCEL, INFO, INVITE, NOTIFY, OPTIONS, REFER
Supported: x-sipura
Content-Type: application/sdp
Remote-Party-ID: "xxxxxxxx Customer"
<sip:+136091xxxxx@xxxxxxxx.com>;party=calling;id-type=subscriber;screen=yes;privacy=full
And finally what I'm seeing in the log:
Jun 30 08:18:33 voip02 /usr/sbin/ser[4684]: DEBUG:uac:replace_from:
removing display [Anonymous]
Jun 30 08:18:33 voip02 /usr/sbin/ser[4684]: DEBUG:uac:replace_from: uri
to replace [sip:+136091xxxxx@voip02.xxxxxxxx.com]
Jun 30 08:18:33 voip02 /usr/sbin/ser[4684]: DEBUG:uac:replace_from:
replacement uri is [sip:anonymous@xxxxxxxx.com]
So what am I missing here? It looks like uac_replace_from is finding the
right URI and replacing it, just not properly. I've already gone into CVS
and I don't see any relevent changes.
Any help? Please?
-Keith
On 7/5/06, raviprakash sunkara <sunkara.raviprakash.feb14(a)gmail.com> wrote:
>
> hello Bogdan,
>
> Same problem occurred for me , but I'm Using X-lite 3.0 .
> And i'm put on DMZ in my router ( NETGEAR and BELkenn) .
>
>
> I install the openser 1.0.1 and rtp proxy 0.3 in same Linux System
> openser server is located with public id xx.xxx.xxx.xx of 192.168.2.2 ,
> And UAC are outside the NAT,
> When one UAC call to other UAC( are both in outside the NAT where
> openser server), after the INVITE method get request by server, after 32
> second its hung up automatically, Voice is ok , and callee is hung upping,
> not caller,
> UAC ( inside the nAT , openser server ) in not hung uping and voice is not
> ok....
>
> I think problem is not in NETWORK and it may in RTp , NAT ,
> Can u help on this ,
> Where is the problem, in NAt with rtp or networking,
> Here by Mime's openser.cfg
> ****************************************
> route{
> if (!mf_process_maxfwd_header("10")) {
> sl_send_reply("483","Too Many Hops");
> exit;
> };
> if (msg:len >= 2048 ) {
> sl_send_reply("513", "Message too big");
> exit;
> };
>
> # NAT detection
> route(2);
>
> if (!method=="REGISTER")
> record_route();
>
> if (loose_route()) {
> append_hf("P-hint: rr-enforced\r\n");
> route(1);
> };
>
> if (!uri==myself) {
> append_hf("P-hint: outbound\r\n");
> route(1);
> };
>
> if (uri==myself) {
> if (method=="REGISTER") {
> if (!www_authorize("xx.xxx.xxx.xxx", "subscriber")) {
> www_challenge("xx.xxx.xxx.xxx", "0");
> exit;
> };
>
> if (isflagset(5)) {
> setflag(6);
> # if you want OPTIONS natpings uncomment next
> # setflag(7);
> };
> save("location");
> exit;
> };
>
> if (!lookup("location")) {
> sl_send_reply("404", "Not Found");
> exit;
> };
> append_hf("P-hint: usrloc applied\r\n");
> };
>
> route(1);
> }
>
>
> route[1] {
> if (subst_uri('/(sip:.*);nat=yes/\1/')){
> setflag(6);
> };
>
> if (isflagset(5)||isflagset(6)) {
> route(3);
> }
>
> if (!t_relay()) {
> sl_reply_error();
> };
> exit;
> }
>
> route[2]{
> force_rport();
> if (nat_uac_test("19")) {
> if (method=="REGISTER") {
> fix_nated_register();
> } else {
> fix_nated_contact();
> };
> setflag(5);
> };
> }
>
> route[3] {
> if (is_method("BYE|CANCEL")) {
> unforce_rtp_proxy();
> } else if (is_method("INVITE")){
> force_rtp_proxy();
> t_on_failure("1");
> };
> if (isflagset(5))
> search_append('Contact:.*sip:[^>[:cntrl:]]*', ';nat=yes');
> t_on_reply("1");
> }
>
> failure_route[1] {
> if (isflagset(6) || isflagset(5)) {
> unforce_rtp_proxy();
> }
> }
>
> onreply_route[1] {
> if ((isflagset(5) || isflagset(6)) && status=~"(183)|(2[0-9][0-9])") {
> force_rtp_proxy();
> }
> search_append('Contact:.*sip:[^>[:cntrl:]]*', ';nat=yes');
>
> if (isflagset(6)) {
> fix_nated_contact();
> }
> exit;
> }
>
>
>
> On 7/5/06, Bogdan-Andrei Iancu <bogdan(a)voice-system.ro > wrote:
> >
> > Hi,
> >
> > it might be a signalling problem. Most of the UA drops the calls if they
> >
> > do not get the ACK for 200 OK.
> > check on the network if this is the case.
> >
> > regards,
> > bogdan
> >
> > Hamid Ali Asgari wrote:
> >
> > >The calls are between two UAs.
> > >The problem is that with a certain type of UA (type A), the calls are
> > ok if
> > >the calls are between two type A UAs and don't get disconnected. I can
> > talk
> > >as long as I want.
> > >
> > >But if I try calling from that UA (type A) to Windows messenger, the
> > call
> > >gets disconnects after less than a minute. In the 1 minute I can talk
> > (so I
> > >assume it's not a CODEC problem, correct me if I am wrong)
> > >
> > >I have also tried with a UA and a Cisco gateway. On the Cisco debugs I
> > see
> > >Disconnet cause code 102 (Session-End-Callback ) which I don't think
> > would
> > >be the case. There is no callback config on the gateway or the UA.
> > >
> > >I guess the UA is tearing down the call for some reasn I don't know.
> > >
> > >Any clues?
> > >Hamid
> > >
> > >
> > >-----Original Message-----
> > >From: users-bounces(a)openser.org [mailto:users-bounces@openser.org] On
> > Behalf
> > >Of Mike Williams
> > >Sent: Wednesday, July 05, 2006 8:04 PM
> > >To: users(a)openser.org
> > >Subject: Re: [Users] Disconnect Cause on OpenSER
> > >
> > >On Wednesday 05 July 2006 12:31, Hamid Ali Asgari wrote:
> > >
> > >Are the calls from one UA to another, or from a UA to a gateway? I know
> > for
> > >instance that Asterisk has problems with G729b silence detection and
> > will
> > >drop calls because it thinks the call has dropped. Perhaps other
> > equipment
> > >or
> > >carriers has this problem too.
> > >
> > >---Mike
> > >
> > >
> > >
> > >
> > >>Hi,
> > >>
> > >>I am having a problem with OpenSER and certain types of CPEs. The
> > problem
> > >>is that the calls get established and the parties can talk, however
> > after
> > >>
> > >>
> > >a
> > >
> > >
> > >>very short period the call gets disconnected. Any guidelines how I
> > could
> > >>troubleshoot this?
> > >>
> > >>
> > >>
> > >>PS: Is there anyway to see the calls disconnect cause on OpenSER? I am
> >
> > >>currently running OpenSER with radius.
> > >>
> > >>
> > >>
> > >>Thanks in advance,
> > >>
> > >>Hamid
> > >>
> > >>
> > >
> > >_______________________________________________
> > >Users mailing list
> > >Users(a)openser.org
> > >http://openser.org/cgi-bin/mailman/listinfo/users
> > >
> > >
> > >_______________________________________________
> > >Users mailing list
> > >Users(a)openser.org
> > >http://openser.org/cgi-bin/mailman/listinfo/users
> > >
> > >
> > >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users(a)openser.org
> > http://openser.org/cgi-bin/mailman/listinfo/users
> >
>
>
>
> --
> Thanks and Regards with cheers
> Sunkara Ravi Prakash (Voip Developer)
> Hyperion Technology
> Kondapur, Hi-tech city,
> Hyderabad.
> www.hyperion-tech.com
> +91-9985077535
>
--
Thanks and Regards with cheers
Sunkara Ravi Prakash (Voip Developer)
Hyperion Technology
Kondapur, Hi-tech city,
Hyderabad.
www.hyperion-tech.com
+91-9985077535
I restarted mediaproxy and now it doesn't say MySQL error: (2006, 'MySQL server has gone away')
but when I check mysql logs I see that only an UPDATE query is sent from the mediaproxy when the call ends.
But there is no row to update.
Do I need to use "ser accounting" for "mediaproxy accounting" to work fine ?
Thanks,
ilker
________________________________
From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of İlker Aktuna (Koç.net)
Sent: Thursday, July 06, 2006 4:02 PM
To: serusers(a)lists.iptel.org
Subject: RE: [Serusers] Mediaproxy problem - accounting
Hi,
I still couldn't solve the mediaproxy accounting problem.
In the syslog I see following messages :
Jul 6 16:13:51 sesapp mediaproxy[10602]: error: accounting failed. MySQL error: (2006, 'MySQL server has gone away')
Jul 6 16:13:51 sesapp mediaproxy[10602]: error: accounting failed. MySQL error: (2006, 'MySQL server has gone away')
Jul 6 16:13:51 sesapp mediaproxy[10602]: SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam Softphone release 1002t stamp 29726',
Jul 6 16:13:51 sesapp mediaproxy[10602]: SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam Softphone release 1002t stamp 29726',
Mysql server is up and running.
What may be the problem here ?
Thanks,
ilker
=============
Hi,
I am trying to use dbaccounting with mediaproxy. Undfortunately it doesn't seem to send anything to mysql db.
How can I trace where the problem is ?
My mediaproxy accounting config is :
[Accounting]
dbaccounting = on
[Database]
user = ser
password = heslo
host = 127.0.0.1
database = radius
table = radacct
Thanks,
ilker
<http://387555.sigclick.mailinfo.com/sigclick/070A0407/06044D05/0606064E/014…>
_____________________________________________________________________________________________________________________________________________
Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.
This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
_____________________________________________________________________________________________________________________________________________
Hi,
I still couldn't solve the mediaproxy accounting problem.
In the syslog I see following messages :
Jul 6 16:13:51 sesapp mediaproxy[10602]: error: accounting failed. MySQL error: (2006, 'MySQL server has gone away')
Jul 6 16:13:51 sesapp mediaproxy[10602]: error: accounting failed. MySQL error: (2006, 'MySQL server has gone away')
Jul 6 16:13:51 sesapp mediaproxy[10602]: SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam Softphone release 1002t stamp 29726',
Jul 6 16:13:51 sesapp mediaproxy[10602]: SipUserAgents = 'Eyebeam Softphone release 1002l stamp 29452 + Eyebeam Softphone release 1002t stamp 29726',
Mysql server is up and running.
What may be the problem here ?
Thanks,
ilker
________________________________
From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of İlker Aktuna (Koç.net)
Sent: Friday, June 23, 2006 11:25 AM
To: Adrian Georgescu; serusers(a)lists.iptel.org
Subject: RE: [Serusers] Mediaproxy problem - accounting
Hi,
Yes I have the python mysql package installed. My radacct table is like below:
mysql> describe radacct;
+-------------------------+----------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------+----------------------+------+-----+---------------------+----------------+
| RadAcctId | bigint(21) | NO | PRI | NULL | auto_increment |
| AcctSessionId | varchar(255) | NO | MUL | | |
| AcctUniqueId | varchar(255) | NO | MUL | | |
| UserName | varchar(64) | NO | MUL | | |
| Realm | varchar(64) | YES | MUL | | |
| NASIPAddress | varchar(15) | NO | MUL | | |
| NASPortId | varchar(50) | NO | | | |
| NASPortType | varchar(255) | NO | | | |
| AcctStartTime | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| AcctStopTime | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| AcctSessionTime | int(12) | YES | | NULL | |
| AcctAuthentic | varchar(32) | YES | | NULL | |
| ConnectInfo_start | varchar(32) | YES | | NULL | |
| ConnectInfo_stop | varchar(32) | YES | | NULL | |
| AcctInputOctets | bigint(12) | YES | | NULL | |
| AcctOutputOctets | bigint(12) | YES | | NULL | |
| CalledStationId | varchar(50) | NO | MUL | | |
| CallingStationId | varchar(50) | NO | MUL | | |
| AcctTerminateCause | varchar(32) | NO | | | |
| ServiceType | varchar(32) | YES | | NULL | |
| FramedProtocol | varchar(32) | YES | | NULL | |
| FramedIPAddress | varchar(15) | NO | | | |
| AcctStartDelay | int(12) | YES | | NULL | |
| AcctStopDelay | int(12) | YES | | NULL | |
| SipMethod | varchar(50) | NO | | | |
| SipResponseCode | smallint(5) unsigned | NO | | 0 | |
| SipToTag | varchar(128) | NO | | | |
| SipFromTag | varchar(128) | NO | | | |
| SipTranslatedRequestURI | varchar(255) | NO | MUL | | |
| SipUserAgents | varchar(255) | NO | | | |
| SipApplicationType | varchar(255) | NO | | | |
| SipCodecs | varchar(255) | NO | | | |
| SipRPID | varchar(255) | NO | | | |
| SipRPIDHeader | varchar(255) | NO | | | |
| SourceIP | varchar(255) | NO | MUL | | |
| SourcePort | varchar(255) | NO | | | |
| CanonicalURI | varchar(255) | NO | MUL | | |
| DelayTime | varchar(5) | NO | | | |
| Timestamp | bigint(20) | NO | | 0 | |
| DestinationId | varchar(15) | NO | MUL | | |
| Rate | text | NO | | | |
| Price | double(20,4) | YES | | NULL | |
| Normalized | enum('0','1') | YES | MUL | 0 | |
| BillingId | varchar(255) | NO | MUL | | |
| MediaInfo | varchar(32) | YES | MUL | NULL | |
| RTPStatistics | text | NO | | | |
| FromHeader | varchar(128) | NO | | | |
| UserAgent | varchar(128) | NO | | | |
| Contact | varchar(128) | NO | | | |
+-------------------------+----------------------+------+-----+---------------------+----------------+
49 rows in set (0.04 sec)
Any idea where the problem is ?
Thanks,
ilker
-----Original Message-----
From: serusers-bounces(a)lists.iptel.org [mailto:serusers-bounces@lists.iptel.org] On Behalf Of Adrian Georgescu
Sent: Friday, June 23, 2006 11:22 AM
To: serusers(a)lists.iptel.org
Subject: [Serusers] Mediaproxy problem - accounting
hi Ilker,
Pl check if you have the mysql python package installed. On Debian the name of the packet is python-mysqldb
ii python-mysqldb 1.2.1c3-4 A Python interface to
MySQL
also make sure you have the extra fields in the radacct table.
Adrian
=============
Hi,
I am trying to use dbaccounting with mediaproxy. Undfortunately it doesn't seem to send anything to mysql db.
How can I trace where the problem is ?
My mediaproxy accounting config is :
[Accounting]
dbaccounting = on
[Database]
user = ser
password = heslo
host = 127.0.0.1
database = radius
table = radacct
Thanks,
ilker
<http://387555.sigclick.mailinfo.com/sigclick/0A090F07/05044F00/0B050A4E/021…>
_____________________________________________________________________________________________________________________________________________
Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.
This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
_____________________________________________________________________________________________________________________________________________
Sorry for the subject; I forgot to change it in my first post...
Thanks for your answer.
Can I use YATE on the same server with SER and configure it only to accept sip from ser and send to h323 gateways ?
Can it make transcoding ? (from ILBC to g729 or gsm to g729) ?
Btw, I know about Asterisk but that's more likely a PBX solution which I don't need. I only need interworking and transcoding.
Thanks,
ilker
-----Original Message-----
From: Dani Popa [mailto:dani.popa@vipnet.ro]
Sent: Thursday, July 06, 2006 10:20 AM
To: İlker Aktuna (Koç.net)
Subject: Re: [Serusers] SER / MediaProxy / B2BUA
Hi,
asterisk or yate !
On Thu, 6 Jul 2006 10:14:45 +0300
İlker Aktuna (Koç.net) <ilkera(a)koc.net> wrote:
> Hi everyone,
>
> I am looking for a freeware (or even opensource) sip->h323 solution
> which would turn my sip calls (from SER) to h323 (to any gateway that runs h323) Is there any free solution for this ?
>
> Also, I am looking for some free transcoding system which would turn my ILBC (codec) calls to g729.
> Is there any freeware transcoding solution ?
>
> Thanks,
> ilker
>
>
>
>
<http://387555.sigclick.mailinfo.com/sigclick/03090604/06074E03/0202074D/012…>
_____________________________________________________________________________________________________________________________________________
Bu e-posta mesaji kisiye ozel olup, gizli bilgiler iceriyor olabilir. Eger bu e-posta mesaji size yanlislikla ulasmissa, icerigini hic bir sekilde kullanmayiniz ve ekli dosyalari acmayiniz. Bu durumda lutfen e-posta mesajini kullaniciya hemen geri gonderiniz ve tum kopyalarini mesaj kutunuzdan siliniz. Bu e-posta mesaji, hic bir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve para karsiligi satilamaz. Bu e-posta mesaji viruslere karsi anti-virus sistemleri tarafindan taranmistir. Ancak yollayici, bu e-posta mesajinin - virus koruma sistemleri ile kontrol ediliyor olsa bile - virus icermedigini garanti etmez ve meydana gelebilecek zararlardan dogacak hicbir sorumlulugu kabul etmez.
This message is intended solely for the use of the individual or entity to whom it is addressed , and may contain confidential information. If you are not the intended recipient of this message or you receive this mail in error, you should refrain from making any use of the contents and from opening any attachment. In that case, please notify the sender immediately and return the message to the sender, then, delete and destroy all copies. This e-mail message, can not be copied, published or sold for any reason. This e-mail message has been swept by anti-virus systems for the presence of computer viruses. In doing so, however, sender cannot warrant that virus or other forms of data corruption may not be present and do not take any responsibility in any occurrence.
_____________________________________________________________________________________________________________________________________________
Hello! everybody...
I am new in openSer and i want use it like load
balancer with 2 SIP Servers behind it, so i red the
docs about dispatcher and when i forward the request
e.g REGISTER the SIP server that is responsable for
process this request (SER server) dosen't process the
request because it recives the request that is send to
the load balancer.
My question is if i need to rewrite something part of
the SIP message laike a host and if this is rifth how
can i do that.
Thank's
___________________________________________________________
Do You Yahoo!?
La mejor conexión a Internet y <b >2GB</b> extra a tu correo por $100 al mes. http://net.yahoo.com.mx
