[OpenSIPS-Users] Users Digest, Vol 35, Issue 52

Kurtis kurtisvelarde at gmail.com
Mon Jun 20 04:28:14 CEST 2011


Sent from my Verizon Wireless Sony Ericsson Xperia™ PLAY.

users-request at lists.opensips.org wrote:

>Send Users mailing list submissions to
>	users at lists.opensips.org
>
>To subscribe or unsubscribe via the World Wide Web, visit
>	http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>or, via email, send a message with subject or body 'help' to
>	users-request at lists.opensips.org
>
>You can reach the person managing the list at
>	users-owner at lists.opensips.org
>
>When replying, please edit your Subject line so it is more specific
>than "Re: Contents of Users digest..."
>
>
>Today's Topics:
>
>   1. Re: CDRTOOL Import Destinations. (dotnetdub)
>   2. Presentity <basic>closed</basic> always Closed
>      (duane.larson at gmail.com)
>
>
>----------------------------------------------------------------------
>
>Message: 1
>Date: Sun, 19 Jun 2011 20:06:29 +0100
>From: dotnetdub <dotnetdub at gmail.com>
>Subject: Re: [OpenSIPS-Users] CDRTOOL Import Destinations.
>To: OpenSIPS users mailling list <users at lists.opensips.org>
>Message-ID: <BANLkTim4=GwVvnthKvbPYxVVwwhQWr6Gyg at mail.gmail.com>
>Content-Type: text/plain; charset="iso-8859-1"
>
>Hi Adrian,
>
>Thanks for the quick response.
>
>Makes sense..
>
>Database had no meaningful data.
>
>I ran:
>
>mysql cdrtool < create_tables.mysql
>mysql cdrtool < create_data.mysql
>
>and all is good.
>
>Interested to know about region and what it is.
>
>Thanks again.
>
>Regards,
>Brian
>
>
>On 19 June 2011 19:37, Adrian Georgescu <ag at ag-projects.com> wrote:
>
>> You are missing the incremental database changes between your old version
>> and the current one. You must bring your database schema up to date when
>> upgrading as explained in the changelog, these database changes are
>> documented in setup/mysql/alter_tables.mysql
>>
>> The region field is indeed missing from the documentation, I will add it
>> there.
>>
>> Adrian
>>
>> On Jun 19, 2011, at 7:17 PM, dotnetdub wrote:
>>
>> On 19 June 2011 17:24, dotnetdub <dotnetdub at gmail.com> wrote:
>>
>>> Hi List,
>>>
>>> CDRTool version 8.12
>>>
>>> I am trying initial import of data.
>>>
>>> I start with the destination table.
>>>
>>> If I copy /var/www/cdrtool/setup/csv/destinations.csv to
>>> /var/spool/cdrtool and run importRatingTables.php I get:
>>>
>>> Database error for query insert into destinations
>>>                     (
>>>                     reseller_id,
>>>                     gateway,
>>>                     domain,
>>>                     subscriber,
>>>                     dest_id,
>>>                     region,
>>>                     dest_name,
>>>                     increment,
>>>                     min_duration,
>>>                     max_duration,
>>>                     max_price
>>>                     ) values (
>>>                     '0',
>>>                     '',
>>>                     '',
>>>                     '',
>>>                     '1',
>>>                     'USA',
>>>                     '',
>>>                     '0',
>>>                     '0',
>>>                     '0',
>>>                     ''
>>>                     ): Unknown column 'region' in 'field list' (1054)
>>>
>>>
>>> If I move the region field from it's position to the third column that
>>> gets rid of that error but now I get:
>>>
>>> Reading file /var/spool/cdrtool/destinations.csv
>>> Importing destinations from /var/spool/cdrtool/destinations.csv for
>>> reseller 0:
>>> Skipped 13127 records
>>>
>>> Here are two records and the header from destinations.csv
>>>
>>>        Ops Reseller Trusted peer Region Domain Subscriber Destination
>>> Description Incr Min Dur Max Dur Max Price  2 0   1 USA 0 6 0  2 0   1204 CANADA
>>> MANITOBA 0 0 0
>>>
>>> I have been using 6.71 for quite some time with no issue's.
>>>
>>> Any help would be most appreciated, probably missing something very
>>> obvious.
>>>
>>> Regards,
>>> Brian
>>>
>>
>>
>>
>> The sample customers,rates work fine.
>>
>> I've stripped down a destinations import to:
>>
>> Ops,Reseller,Trusted
>> peer,Domain,Subscriber,Destination,Description,Incr,Min Dur,Max Dur,Max
>> Price
>> 2,0,,,,1,USA,0,0,0,
>>
>>
>> When I run it:
>>
>> Reading file /var/spool/cdrtool/destinations.csv
>> Importing destinations from /var/spool/cdrtool/destinations.csv for
>> reseller 0:
>> Database error for query update destinations set
>>                     region             = 'USA',
>>                     dest_name          = '0',
>>                     increment          = '0',
>>                     min_duration       = '0',
>>                     max_duration       = '0',
>>                     max_price          = ''
>>                     where gateway      = ''
>>                     and reseller_id    = '0'
>>                     and domain         = ''
>>                     and subscriber     = ''
>>                     and dest_id        = '1'
>>                     : Unknown column 'region' in 'field list' (1054)
>>
>>
>> There seems to some major inconsistency between the scripts and docs..
>>
>> Nowhere in any documentation is region mentioned?
>>
>> Would appreciate any pointers.
>>
>> TIA.
>>
>> Brian
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: <http://lists.opensips.org/pipermail/users/attachments/20110619/32ba3697/attachment-0001.htm>
>
>------------------------------
>
>Message: 2
>Date: Mon, 20 Jun 2011 02:10:06 +0000
>From: duane.larson at gmail.com
>Subject: [OpenSIPS-Users] Presentity <basic>closed</basic> always
>	Closed
>To: OpenSIPS users mailling list <users at lists.opensips.org>
>Message-ID: <20cf305641e9e6bd6e04a61b3b01 at google.com>
>Content-Type: text/plain; charset="iso-8859-1"; Format="flowed";
>	DelSp="yes"
>
>I have OpenSIPS set up with Presence and am using Counterpath's Bria  
>Client. In the past I was able to get Bria/OpenSIPS/OpenXCAP to all work.  
>Now I am trying to get it to work again and I'm having problems. When two  
>users agree to view each others presence it doesn't work. I see that each  
>user is recieving NOTIFY messages about the other users presence but the  
>Bria client doesn't update the users status. I see that every time a Bria  
>client starts up it is Publishing its presence but it always has  
><basic>closed</basic> in the xml
>
>U 2011/06/19 21:00:12.240159 108.67.136.231:31194 -> 173.203.93.107:5060
>PUBLISH sip:9013349018 at irock.com SIP/2.0.
>Via: SIP/2.0/UDP  
>108.67.136.231:31194;branch=z9hG4bK-d8754z-96515b7ec527b151-1---d8754z-;rport.
>Max-Forwards: 70.
>Contact: <sip:9013349018 at 108.67.136.231:31194;transport=udp>.
>To: "9013349018"<sip:9013349018 at irock.com>.
>From: "9013349018"<sip:9013349018 at irock.com>;tag=71799813.
>Call-ID: NTJkNzgyYmMwMDQ1ZWUwMzExMzkyM2Y1OTgxNDgwN2U..
>CSeq: 1 PUBLISH.
>Expires: 3600.
>Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE,  
>SUBSCRIBE, INFO.
>Content-Type: application/pidf+xml.
>User-Agent: Bria 3 release 3.2.1 stamp 62387.
>Event: presence.
>Content-Length: 469.
>.
><?xml version='1.0' encoding='UTF-8'?><presence  
>xmlns='urn:ietf:params:xml:ns:pidf'  
>xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
>xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
>xmlns:c='urn:ietf:params:xml:ns:pidf:cipid'  
>xmlns:lt='urn:ietf:params:xml:ns:location-type'  
>xmlns:caps='urn:ietf:params:xml:ns:pidf:caps'  
>entity='sip:9013349018 at irock.com'><tuple  
>id='td9cbb9c2'><status><basic>closed</basic></status></tuple><dm:person  
>id='p0f48c387'></dm:person></presence>
>#
>U 2011/06/19 21:00:12.244401 173.203.93.107:5060 -> 108.67.136.231:31194
>SIP/2.0 200 OK.
>Via: SIP/2.0/UDP  
>108.67.136.231:31194;branch=z9hG4bK-d8754z-72b75f4a63995f60-1---d8754z-;rport=31194.
>To: <sip:9013349018 at irock.com>;tag=31ec65e482de21ae66d7d44df69d3d8c-c4ef.
>From: "9013349018"<sip:9013349018 at irock.com>;tag=b5e76db3.
>Call-ID: ZGI1OTA4NmEyYjAzZjFiY2VhNDY4OWY1Njk5MWIwZDA..
>CSeq: 1 SUBSCRIBE.
>Expires: 3600.
>Contact: <sip:sa at 173.203.93.107:5060>.
>Server: Aethercommunications SIP Proxy.
>Content-Length: 0.
>
>
>
>
>Then in the Presentity table I have the following
>
>mysql> select * from presentity;
>+------+------------+-----------+----------+--------------------------+------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+--------+
>| id | username | domain | event | etag | expires | received_time | body |  
>extra_hdrs | sender |
>+------+------------+-----------+----------+--------------------------+------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+--------+
>| 2914 | 9013349018 | irock.com | presence | a.1308527728.29011.36.15 |  
>1308537940 | 1308534340 | <?xml version='1.0' encoding='UTF-8'?><presence  
>xmlns='urn:ietf:params:xml:ns:pidf'  
>xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
>xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
>xmlns:c='urn:ietf:params:xml:ns:pidf:cipid'  
>xmlns:lt='urn:ietf:params:xml:ns:location-type'  
>xmlns:caps='urn:ietf:params:xml:ns:pidf:caps'  
>entity='sip:9013349018 at irock.com'><tuple  
>id='t1f9e4914'><status><basic>closed</basic></status></tuple><dm:person  
>id='pf69e3d57'></dm:person></presence> | | |
>| 2916 | 9013349018 | irock.com | presence | a.1308527728.29010.37.2 |  
>1308538423 | 1308534823 | <?xml version='1.0' encoding='UTF-8'?><presence  
>xmlns='urn:ietf:params:xml:ns:pidf'  
>xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
>xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
>xmlns:c='urn:ietf:params:xml:ns:pidf:cipid'  
>xmlns:lt='urn:ietf:params:xml:ns:location-type'  
>xmlns:caps='urn:ietf:params:xml:ns:pidf:caps'  
>entity='sip:9013349018 at irock.com'><tuple  
>id='tb1de818c'><status><basic>closed</basic></status></tuple><dm:person  
>id='p43342606'></dm:person></presence> | | |
>| 2915 | 9013349019 | irock.com | presence | a.1308527728.29012.38.7 |  
>1308538476 | 1308534876 | <?xml version='1.0' encoding='UTF-8'?><presence  
>xmlns='urn:ietf:params:xml:ns:pidf'  
>xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
>xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
>xmlns:c='urn:ietf:params:xml:ns:pidf:cipid'  
>xmlns:lt='urn:ietf:params:xml:ns:location-type'  
>xmlns:caps='urn:ietf:params:xml:ns:pidf:caps'  
>entity='sip:9013349019 at irock.com'><tuple  
>id='t5762491b'><status><basic>open</basic></status></tuple><dm:person  
>id='pb4ae929f'><dm:note>Available</dm:note></dm:person></presence> | | |
>| 2917 | 9013349018 | irock.com | presence | a.1308527728.29013.33.2 |  
>1308538770 | 1308535170 | <?xml version='1.0' encoding='UTF-8'?><presence  
>xmlns='urn:ietf:params:xml:ns:pidf'  
>xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
>xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
>xmlns:c='urn:ietf:params:xml:ns:pidf:cipid'  
>xmlns:lt='urn:ietf:params:xml:ns:location-type'  
>xmlns:caps='urn:ietf:params:xml:ns:pidf:caps'  
>entity='sip:9013349018 at irock.com'><tuple  
>id='t4246cfbe'><status><basic>closed</basic></status></tuple><dm:person  
>id='p49e1604e'></dm:person></presence> | | |
>| 2918 | 9013349018 | irock.com | presence | a.1308527728.29012.42.1 |  
>1308538823 | 1308535223 | <?xml version='1.0' encoding='UTF-8'?><presence  
>xmlns='urn:ietf:params:xml:ns:pidf'  
>xmlns:dm='urn:ietf:params:xml:ns:pidf:data-model'  
>xmlns:rpid='urn:ietf:params:xml:ns:pidf:rpid'  
>xmlns:c='urn:ietf:params:xml:ns:pidf:cipid'  
>xmlns:lt='urn:ietf:params:xml:ns:location-type'  
>xmlns:caps='urn:ietf:params:xml:ns:pidf:caps'  
>entity='sip:9013349018 at irock.com'><tuple  
>id='td9cbb9c2'><status><basic>open</basic></status></tuple><dm:person  
>id='p0f48c387'><dm:note>Available</dm:note></dm:person></presence> | | |
>+------+------------+-----------+----------+--------------------------+------------+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+--------+
>
>
>If I delete all the Presentity records in the presentity table that have  
>the <basic>closed</basic> in them then Presence status updates start  
>working like they should. Then when the Bria client is shut down it updates  
>the record in Presentity with <basic>closed</basic>.
>
>Where is the issue? What do I need to fix or is this a Counterpath Bria  
>issue???
>-------------- next part --------------
>An HTML attachment was scrubbed...
>URL: <http://lists.opensips.org/pipermail/users/attachments/20110620/c918b9df/attachment.htm>
>
>------------------------------
>
>_______________________________________________
>Users mailing list
>Users at lists.opensips.org
>http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>End of Users Digest, Vol 35, Issue 52
>*************************************


More information about the Users mailing list