[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