[OpenSIPS-Users] Load Balancer looses Load on Reboot

2011-06-06 Thread Robert Thomas
Hi,

We are implementing a Active, Standby redundancy setup for out load balancer
using pacemaker.

We have dialog support on our config file, and db_mode setup to 1 ( realtime
) to keep the ongoing dialogs in the database.

I can restart opensips ( using the init.d / not sure why my opensipsctl
restart fails) and I can see my dialogs after the restart using, opensipsctl
fifo dlg_list.

However, when I check the lb module, opensipsctl fifo lb_list, the load
values are empty. Like the module didn't read from the dialog the
preserved dialogs.

I found this discussion
http://www.openser.org/pipermail/users/2010-March/011360.html where it seems
like bogdan fixed it.  They talk about the SVN on times 1.6.2 was out

I'm running stable 1.6.4.

Does anyone else has a problem with this, or is it just me? Could I be
missing something else from the lb module?

I really appreciate your help,

-- 
Robert
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] OpenSips always returning cause code 503

2011-06-06 Thread Aman
Thanks Mario for taking time to replay.

Its resolved now by using scripting variable return code '$rc', it is
returning the carrier release code to caller.


Now i am looking how can i display time in siptrace window of CDRTool ...
will you advice me about this.


-- 
*Cheers,
Amanpreet Singh


*
On Sun, Jun 5, 2011 at 3:30 PM, users-requ...@lists.opensips.org wrote:

 Send Users mailing list submissions to
users@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-requ...@lists.opensips.org

 You can reach the person managing the list at
users-ow...@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: /etc/init.d/opensips restart returns OK when opensips is
  down... (Advantia VoIP Systems)
   2. Re: OpenSips always returning cause code 503
  (Advantia VoIP Systems)


 --

 Message: 1
 Date: Sat, 4 Jun 2011 08:08:56 -0700
 From: Advantia VoIP Systems i...@advantia.ca
 Subject: Re: [OpenSIPS-Users] /etc/init.d/opensips restart returns OK
when opensips is down...
 To: OpenSIPS users mailling list users@lists.opensips.org
 Message-ID: banlktik1pehj+wdnlmpyq34mugkh7h8...@mail.gmail.com
 Content-Type: text/plain; charset=utf-8

 Hi Toyima,

 The start-stop-daemon function of the init script returns successfully when
 launching OpenSIPS as long as your script is syntactically correct and a
 pidfile can be created.  You likely have an external resource (database
 perhaps) that is required but not available (database credentials??)
 causing
 OpenSIPS to exit after the init script exits.

 Cheers,

 Mario
 http://advantia.ca

 On Fri, Jun 3, 2011 at 4:46 AM, Toyima Dias toyim...@gmail.com wrote:

  Hello,
 
  I've a doubt regarding opensips.init script; it use to happend that
  restarting opensips with:
 
  /etc/init.d/opensips restart
 
  It returns OK, but checking with ps -ef | grep opensips does not show
  opensips running, by the way, checking the opensips.log shows many errors
  for example that the DB does not exist or whatever the issue, my doubt is
  not regarding why opensips is not able tu up for X reason, my doubt is
 why
  /etc/init.d/opensips restart returns OK even if this is not true?
 
  Thanks in advance for any help!
 
  ___
  Users mailing list
  Users@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/20110604/3f29b971/attachment.html
 

 --

 Message: 2
 Date: Sat, 4 Jun 2011 08:39:16 -0700
 From: Advantia VoIP Systems i...@advantia.ca
 Subject: Re: [OpenSIPS-Users] OpenSips always returning cause code 503
 To: OpenSIPS users mailling list users@lists.opensips.org
 Message-ID: BANLkTi=wr9_4lybps-s56nucngt8m8j...@mail.gmail.com
 Content-Type: text/plain; charset=UTF-8

 Amanpreet
 This may be because of where you are calling t_reply(code,
 reason); in your routing script. ?t_reply(code, reason); works
 if there is an established transaction to reply to. ?You may be at a
 point in your routing where sl_send_reply(code, reason); is more
 appropriate.

 Cheers,

 Mario
 http://advantia.ca

 On Thu, Jun 2, 2011 at 1:21 AM, Tushar Jain tusshar.j...@gmail.com
 wrote:
 
  Hi Duane,
  We have loadmodule tm.so in our configuration
 but?t_reply($T_reply_code); is giving error.
  Regards
  Tushar
  On Thu, Jun 2, 2011 at 2:03 AM, Duane Larson duane.lar...@gmail.com
 wrote:
 
  In your config do you have the following
 
  loadmodule tm.so
 
 
 
  On Wed, Jun 1, 2011 at 9:20 AM, Aman gofora...@gmail.com wrote:
 
  Hi All,
 
  I am facing some challenges in the testing of the OpenSIPs
 (V:1.6.2-tls), OpenSips always returning cause code '503 Service not
 available, no more gateways' to caller doesn't matter whatever it is getting
 from the carrier (Screenshot as below) ... i guess its happening due to
 following code in opensips.cfg,
 
 
  ??? else {
  ??? t_reply(503, Service not available, no more
 gateways);
  ??? exit;
  ??? }
 
 
  ?I looked into the forums and tried ?t_reply($T_reply_code);, but its
 giving error,
 
  ??? unknown command t_reply, missing loadmodule?
  ??? Jun? 1 12:59:46 [21787] ERROR:core:main: bad config
 file (1 errors)
 
 
  One more thing, its not showing the time in the field 'Time', do i need
 to add some code to get the time print in the CDRToll SIP trace.
 
 
 
 
 
 
 
 
  Any suggestions will really be helpful.
 
 
  --
  Cheers,
  Amanpreet Singh
 
 
  ___
 

Re: [OpenSIPS-Users] Dialogs remain stale on status 5

2011-06-06 Thread Vlad Paiu

Hello Marcello,

If the dialog is in state 1 or 2, it means that there was no 200 Ok 
received. From dialog point of view, it doesn't make sense to send BYEs 
both ways, because there is no confirmed dialog.


This was fixed in trunk and in the 1.6 branch, in the sense that you can 
not terminate the dialog if it is not at least in state 3 ( received 200 
Ok but no ACK yet ). Please update and let us know if the problem persists.



Regards,

--
Vlad Paiu
OpenSIPS Developer




On 06/03/2011 02:08 PM, Marcello Lupo wrote:

Hi to all,
using opensips 1.6.4 sometimes happen to me that some dialogs remains stale in 
the list of dlg_list command in state 5.
In my case if i try to end a dialog that is not in state 3 or 4. May be now it 
is a problem of cleaning the code (i'm still developing the implementation of 
dialogs at the moment)
Can someone tell me why it happen and most of all if there is a way to delete 
them without restarting the Opensips?
I'm working on a web interface to manage the calls of our system and don't want 
to have lot of stale dialogs to appear there.
Thank you
Regards
Marcello


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

   



___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] /etc/init.d/opensips restart returns OK when opensips is down...

2011-06-06 Thread Toyima Dias
Let me see if i understand,

If opensips has not started (ps -ef | grep opensips doesn't show any
opensips pid), how is possible that /etc/init.d/opensips returns [OK] when
you execute /etc/init.d/opensips restart...is this beacuse of mysql? is that
what you mean...this script should return 1 (not succesfull, different than
0) it no pid file has been created, am i right?

2011/6/4 Advantia VoIP Systems i...@advantia.ca

 Hi Toyima,

 The start-stop-daemon function of the init script returns successfully when
 launching OpenSIPS as long as your script is syntactically correct and a
 pidfile can be created.  You likely have an external resource (database
 perhaps) that is required but not available (database credentials??) causing
 OpenSIPS to exit after the init script exits.

 Cheers,

 Mario
 http://advantia.ca

 On Fri, Jun 3, 2011 at 4:46 AM, Toyima Dias toyim...@gmail.com wrote:

 Hello,

 I've a doubt regarding opensips.init script; it use to happend that
 restarting opensips with:

 /etc/init.d/opensips restart

 It returns OK, but checking with ps -ef | grep opensips does not show
 opensips running, by the way, checking the opensips.log shows many errors
 for example that the DB does not exist or whatever the issue, my doubt is
 not regarding why opensips is not able tu up for X reason, my doubt is why
 /etc/init.d/opensips restart returns OK even if this is not true?

 Thanks in advance for any help!

 ___
 Users mailing list
 Users@lists.opensips.org
 http://lists.opensips.org/cgi-bin/mailman/listinfo/users



 ___
 Users mailing list
 Users@lists.opensips.org
 http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] OpenXCAP - failed to create OpenXCAP 2.0.0: Document is empty

2011-06-06 Thread Dani Popa
when start openxcap, it try to take schema from www.w3.org/2001/xml.xsd 
and www.w3.org doesn't responde.


I changed schemaLocation  in 
/usr/local/pymodules/python2.6/xcap/appusage/xml-schemas/xcap-directory.xsd 
and pointed to local file.


Dani

On 06/06/11 03:01, duane.lar...@gmail.com wrote:
That was missing from the file on the first line, but it still 
crashes. Here is what it looks like now


/usr/share/pyshared/xcap/appusage/xml-schemas/xcap-directory.xsd


?xml version=1.0 encoding=UTF-8?
xs:schema targetNamespace=urn:oma:xml:xdm:xcap-directory
xmlns=urn:oma:xml:xdm:xcap-directory
xmlns:xs=http://www.w3.org/2001/XMLSchema;
elementFormDefault=qualified attributeFormDefault=unqualified

xs:import namespace=http://www.w3.org/XML/1998/namespace;
schemaLocation=http://www.w3.org/2001/xml.xsd/

xs:element name=xcap-directory
xs:complexType
xs:sequence minOccurs=0 maxOccurs=unbounded
xs:element name=folder
xs:complexType
xs:choice
xs:sequence minOccurs=0 maxOccurs=unbounded
xs:element name=entry
xs:complexType
xs:attribute name=uri type=xs:anyURI use=required/
xs:attribute name=etag type=xs:string use=required/
xs:attribute name=last-modified type=xs:dateTime/
xs:attribute name=size type=xs:nonNegativeInteger/
xs:anyAttribute processContents=lax/
/xs:complexType
/xs:element
/xs:sequence
xs:element name=error-code type=xs:string/
/xs:choice
xs:attribute name=auid type=xs:string use=required/
/xs:complexType
/xs:element
/xs:sequence
/xs:complexType
/xs:element
/xs:schema





And here is what the syslog says when it crashes.

Jun 5 18:58:15 xcap01 openxcap[5705]: fatal error: failed to create 
OpenXCAP 2.0.0: Document is empty, line 1, column 1

Jun 5 18:58:15 xcap01 openxcap[5705]: Traceback (most recent call last):
Jun 5 18:58:15 xcap01 openxcap[5705]: File /usr/bin/openxcap, line 
64, in module

Jun 5 18:58:15 xcap01 openxcap[5705]: from xcap.server import XCAPServer
Jun 5 18:58:15 xcap01 openxcap[5705]: File 
/usr/lib/pymodules/python2.6/xcap/server.py, line 20, in module

Jun 5 18:58:15 xcap01 openxcap[5705]: from xcap import authentication
Jun 5 18:58:15 xcap01 openxcap[5705]: File 
/usr/lib/pymodules/python2.6/xcap/authentication.py, line 28, in 
module
Jun 5 18:58:15 xcap01 openxcap[5705]: from xcap.appusage import 
getApplicationForURI, namespaces, public_get_applications
Jun 5 18:58:15 xcap01 openxcap[5705]: File 
/usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 357, in 
module
Jun 5 18:58:15 xcap01 openxcap[5705]: XCAPDirectoryApplication.id: 
XCAPDirectoryApplication(storage)
Jun 5 18:58:15 xcap01 openxcap[5705]: File 
/usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 59, in 
__init__
Jun 5 18:58:15 xcap01 openxcap[5705]: self.xml_schema = 
etree.XMLSchema(xml_schema_doc)
Jun 5 18:58:15 xcap01 openxcap[5705]: File xmlschema.pxi, line 105, 
in lxml.etree.XMLSchema.__init__ (src/lxml/lxml.etree.c:128508)
Jun 5 18:58:15 xcap01 openxcap[5705]: XMLSchemaParseError: Document is 
empty, line 1, column 1





On Jun 3, 2011 5:33am, Saúl Ibarra Corretgé s...@ag-projects.com wrote:
 Hi,





 On May 25, 2011, at 5:28 PM, duane.lar...@gmail.com wrote:





  I am trying to start up openxcap on a server that it used to work 
on without issue. It starts up and then after 20 seconds or so it 
crashes. In syslog I am seeing the following error



 


 


  May 25 10:18:00 xcap01 openxcap[701]: Starting OpenXCAP 2.0.0


  May 25 10:18:01 xcap01 openxcap[701]: using set_wakeup_fd


  May 25 10:18:32 xcap01 openxcap[701]: fatal error: failed to 
create OpenXCAP 2.0.0: Document is empty, line 1, column 1



  May 25 10:18:32 xcap01 openxcap[701]: Traceback (most recent call 
last):



  May 25 10:18:32 xcap01 openxcap[701]: File /usr/bin/openxcap, 
line 64, in



  May 25 10:18:32 xcap01 openxcap[701]: from xcap.server import 
XCAPServer



  May 25 10:18:32 xcap01 openxcap[701]: File 
/usr/lib/pymodules/python2.6/xcap/server.py, line 20, in



  May 25 10:18:32 xcap01 openxcap[701]: from xcap import authentication


  May 25 10:18:32 xcap01 openxcap[701]: File 
/usr/lib/pymodules/python2.6/xcap/authentication.py, line 28, in



  May 25 10:18:32 xcap01 openxcap[701]: from xcap.appusage import 
getApplicationForURI, namespaces, public_get_applications



  May 25 10:18:32 xcap01 openxcap[701]: File 
/usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 357, in



  May 25 10:18:32 xcap01 openxcap[701]: XCAPDirectoryApplication.id: 
XCAPDirectoryApplication(storage)



  May 25 10:18:32 xcap01 openxcap[701]: File 
/usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 59, in 
__init__



  May 25 10:18:32 xcap01 openxcap[701]: self.xml_schema = 
etree.XMLSchema(xml_schema_doc)



  May 25 10:18:32 xcap01 openxcap[701]: File xmlschema.pxi, line 
105, in lxml.etree.XMLSchema.__init__ (src/lxml/lxml.etree.c:128508)



  May 25 10:18:32 xcap01 openxcap[701]: XMLSchemaParseError: 
Document is empty, line 1, column






 Looks like xcap-directory.xsd schema file lacks the initial 

Re: [OpenSIPS-Users] OpenXCAP - failed to create OpenXCAP 2.0.0: Document is empty

2011-06-06 Thread Saúl Ibarra Corretgé
Hi Dani,

On Jun 6, 2011, at 3:07 PM, Dani Popa wrote:

 when start openxcap, it try to take schema from www.w3.org/2001/xml.xsd and 
 www.w3.org doesn't responde. 
 
 I changed schemaLocation  in 
 /usr/local/pymodules/python2.6/xcap/appusage/xml-schemas/xcap-directory.xsd 
 and pointed to local file.
 

Thanks for the pointer, I'll modify the schemas so that it takes the local copy 
from now on.


Regards,

--
Saúl Ibarra Corretgé
AG Projects




___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] /etc/init.d/opensips restart returns OK when opensips is down...

2011-06-06 Thread Andrew Pogrebennyk

On 06.06.2011 14:15, Toyima Dias wrote:

If opensips has not started (ps -ef | grep opensips doesn't show any
opensips pid), how is possible that /etc/init.d/opensips returns [OK]
when you execute /etc/init.d/opensips restart...is this beacuse of
mysql? is that what you mean...this script should return 1 (not
succesfull, different than 0) it no pid file has been created, am i right?


Correct, but there can be a case when opensips starts but then some 
module's initialization function fails due to mysql connect error or 
incompatible table version and the opensips will exit.


--
Sincerely,
Andrew Pogrebennyk

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] OpenXCAP - failed to create OpenXCAP 2.0.0: Document is empty

2011-06-06 Thread Duane Larson
That fixed it.  OpenXCAP worked a while back so I am not sure how it got
messed up.

Thanks for the fix Dani

On Mon, Jun 6, 2011 at 8:07 AM, Dani Popa dani.p...@gmail.com wrote:

 when start openxcap, it try to take schema from www.w3.org/2001/xml.xsdand
 www.w3.org doesn't responde.

 I changed schemaLocation  in
 /usr/local/pymodules/python2.6/xcap/appusage/xml-schemas/xcap-directory.xsd
 and pointed to local file.

 Dani


 On 06/06/11 03:01, duane.lar...@gmail.com wrote:

  That was missing from the file on the first line, but it still crashes.
 Here is what it looks like now

 /usr/share/pyshared/xcap/appusage/xml-schemas/xcap-directory.xsd


 ?xml version=1.0 encoding=UTF-8?
 xs:schema targetNamespace=urn:oma:xml:xdm:xcap-directory
 xmlns=urn:oma:xml:xdm:xcap-directory
 xmlns:xs=http://www.w3.org/2001/XMLSchema;http://www.w3.org/2001/XMLSchema
 elementFormDefault=qualified attributeFormDefault=unqualified

 xs:import 
 namespace=http://www.w3.org/XML/1998/namespace;http://www.w3.org/XML/1998/namespace
 schemaLocation=http://www.w3.org/2001/xml.xsd;http://www.w3.org/2001/xml.xsd/


 xs:element name=xcap-directory
 xs:complexType
 xs:sequence minOccurs=0 maxOccurs=unbounded
 xs:element name=folder
 xs:complexType
 xs:choice
 xs:sequence minOccurs=0 maxOccurs=unbounded
 xs:element name=entry
 xs:complexType
 xs:attribute name=uri type=xs:anyURI use=required/
 xs:attribute name=etag type=xs:string use=required/
 xs:attribute name=last-modified type=xs:dateTime/
 xs:attribute name=size type=xs:nonNegativeInteger/
 xs:anyAttribute processContents=lax/
 /xs:complexType
 /xs:element
 /xs:sequence
 xs:element name=error-code type=xs:string/
 /xs:choice
 xs:attribute name=auid type=xs:string use=required/
 /xs:complexType
 /xs:element
 /xs:sequence
 /xs:complexType
 /xs:element
 /xs:schema





 And here is what the syslog says when it crashes.

 Jun 5 18:58:15 xcap01 openxcap[5705]: fatal error: failed to create
 OpenXCAP 2.0.0: Document is empty, line 1, column 1
 Jun 5 18:58:15 xcap01 openxcap[5705]: Traceback (most recent call last):
 Jun 5 18:58:15 xcap01 openxcap[5705]: File /usr/bin/openxcap, line 64, in
 module
 Jun 5 18:58:15 xcap01 openxcap[5705]: from xcap.server import XCAPServer
 Jun 5 18:58:15 xcap01 openxcap[5705]: File
 /usr/lib/pymodules/python2.6/xcap/server.py, line 20, in module
 Jun 5 18:58:15 xcap01 openxcap[5705]: from xcap import authentication
 Jun 5 18:58:15 xcap01 openxcap[5705]: File
 /usr/lib/pymodules/python2.6/xcap/authentication.py, line 28, in module
 Jun 5 18:58:15 xcap01 openxcap[5705]: from xcap.appusage import
 getApplicationForURI, namespaces, public_get_applications
 Jun 5 18:58:15 xcap01 openxcap[5705]: File
 /usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 357, in
 module
 Jun 5 18:58:15 xcap01 openxcap[5705]: XCAPDirectoryApplication.id:
 XCAPDirectoryApplication(storage)
 Jun 5 18:58:15 xcap01 openxcap[5705]: File
 /usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 59, in
 __init__
 Jun 5 18:58:15 xcap01 openxcap[5705]: self.xml_schema =
 etree.XMLSchema(xml_schema_doc)
 Jun 5 18:58:15 xcap01 openxcap[5705]: File xmlschema.pxi, line 105, in
 lxml.etree.XMLSchema.__init__ (src/lxml/lxml.etree.c:128508)
 Jun 5 18:58:15 xcap01 openxcap[5705]: XMLSchemaParseError: Document is
 empty, line 1, column 1




 On Jun 3, 2011 5:33am, Saúl Ibarra Corretgé 
 s...@ag-projects.coms...@ag-projects.comwrote:
  Hi,
 
 
 
 
 
  On May 25, 2011, at 5:28 PM, duane.lar...@gmail.com wrote:
 
 
 
 
 
   I am trying to start up openxcap on a server that it used to work on
 without issue. It starts up and then after 20 seconds or so it crashes. In
 syslog I am seeing the following error
 
 
  
 
 
  
 
 
   May 25 10:18:00 xcap01 openxcap[701]: Starting OpenXCAP 2.0.0
 
 
   May 25 10:18:01 xcap01 openxcap[701]: using set_wakeup_fd
 
 
   May 25 10:18:32 xcap01 openxcap[701]: fatal error: failed to create
 OpenXCAP 2.0.0: Document is empty, line 1, column 1
 
 
   May 25 10:18:32 xcap01 openxcap[701]: Traceback (most recent call
 last):
 
 
   May 25 10:18:32 xcap01 openxcap[701]: File /usr/bin/openxcap, line
 64, in
 
 
   May 25 10:18:32 xcap01 openxcap[701]: from xcap.server import
 XCAPServer
 
 
   May 25 10:18:32 xcap01 openxcap[701]: File
 /usr/lib/pymodules/python2.6/xcap/server.py, line 20, in
 
 
   May 25 10:18:32 xcap01 openxcap[701]: from xcap import authentication
 
 
   May 25 10:18:32 xcap01 openxcap[701]: File
 /usr/lib/pymodules/python2.6/xcap/authentication.py, line 28, in
 
 
   May 25 10:18:32 xcap01 openxcap[701]: from xcap.appusage import
 getApplicationForURI, namespaces, public_get_applications
 
 
   May 25 10:18:32 xcap01 openxcap[701]: File
 /usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 357, in
 
 
   May 25 10:18:32 xcap01 openxcap[701]: XCAPDirectoryApplication.id:
 XCAPDirectoryApplication(storage)
 
 
   May 25 10:18:32 xcap01 openxcap[701]: File
 /usr/lib/pymodules/python2.6/xcap/appusage/__init__.py, line 59, in
 

[OpenSIPS-Users] CDRTool - Database error's

2011-06-06 Thread Duane Larson
I am having some database errors with a new install of CDRTool.  One error I
keep seeing in my syslog is

Database error: Invalid SQL: select *, UNIX_TIMESTAMP(AcctStartTime) as
timestamp#012from radacct201105 where  (1=1)  and  Normalized = '0'
and AcctStopTime not like '-00-00 00:00:00%'  order by RadAcctId asc


I don't see any issues with this log, but I don't know why it is trying to
look for radacct201105.  It was never created and the database doesn't exist
since this month is 201106.


Then I see another issue and this does cause issues with the CDRTool
application.  With this I am not able to log into the CDRTool and see the
following error at the bottom of the login page


MySQL error: 1036 (Table 'active_sessions' is read only) Session halted.

When I look in the syslog I see the following error

Database error: Invalid SQL: update active_sessions set
val='Q0RSYzokdGhpcy0+aW4gPSAnJzsgJHRoaXMtP
nB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICRHTE9CQUxTWydhdXRoJ10gPSBuZXcgQ0RSVG9vbF9BdXRoO
yAkR0xPQkFMU1snYXV0aCddLT5hdXRoID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2F1dGgnXS0+YXV0aFsndWlkJ10gPSAnZm9ybSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nX
SA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydzb3VyY2UnXSA9ICcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydleHAnXSA9ICcyMTQ3NDgzNjQ3JzsgJEdMT0JBTFNbJ2F1d
GgnXS0+YXV0aFsncmVmcmVzaCddID0gJzIxNDc0ODM2NDcnOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnJzsg',
changed='20110606111425', count=count+1 where sid=
'99eeb2a6426095d5708d0a5149196bae' and name='CDRc'




If I stop cdrtool and try to restart it I am not able to restart CDRTool and
see the following error in syslog
Database error: Invalid SQL: delete from memcache where `key` =
'destinations_sip' or `key` = 'destinations'

In order to get CDRTool to start up again I have to stop and restart MySQL
database.

Any ideas what could be wrong?  This is the latest version of CDRTool and I
am running it on Ubuntu Maverick.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] /etc/init.d/opensips restart returns OK when opensips is down...

2011-06-06 Thread Toyima Dias
Ok, but it any case, the script should return 1 if opensips failed to
initialize; i'm thinking to build a HA infraestructure with opensips
(heartbeat, cluster glue...) and this opensips init script behavior
seems not to be appropriate; i will have to take a deeper look at
the opensips.init script

2011/6/6 Andrew Pogrebennyk andrew.pogreben...@portaone.com

 On 06.06.2011 14:15, Toyima Dias wrote:

 If opensips has not started (ps -ef | grep opensips doesn't show any
 opensips pid), how is possible that /etc/init.d/opensips returns [OK]
 when you execute /etc/init.d/opensips restart...is this beacuse of
 mysql? is that what you mean...this script should return 1 (not
 succesfull, different than 0) it no pid file has been created, am i right?


 Correct, but there can be a case when opensips starts but then some
 module's initialization function fails due to mysql connect error or
 incompatible table version and the opensips will exit.

 --
 Sincerely,
 Andrew Pogrebennyk


 ___
 Users mailing list
 Users@lists.opensips.org
 http://lists.opensips.org/cgi-bin/mailman/listinfo/users

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] /etc/init.d/opensips restart returns OK when opensips is down...

2011-06-06 Thread Robert Thomas
I have an HA setup with Pacemaker using heartbeat stack.

I created a script that monitors opensips via the pid file. Eventhough the
start event succeed and then opensips crash due to a module. The next
monitor round will report an error, and the resource would be migrated to
the  next node.

I don't think the start stop daemon utility used to bring up opensips would
succeed, and then opensips would crash starting the modules.

On Mon, Jun 6, 2011 at 10:44 AM, Toyima Dias toyim...@gmail.com wrote:

 Ok, but it any case, the script should return 1 if opensips failed to
 initialize; i'm thinking to build a HA infraestructure with opensips
 (heartbeat, cluster glue...) and this opensips init script behavior
 seems not to be appropriate; i will have to take a deeper look at
 the opensips.init script

 2011/6/6 Andrew Pogrebennyk andrew.pogreben...@portaone.com

 On 06.06.2011 14:15, Toyima Dias wrote:

 If opensips has not started (ps -ef | grep opensips doesn't show any
 opensips pid), how is possible that /etc/init.d/opensips returns [OK]
 when you execute /etc/init.d/opensips restart...is this beacuse of
 mysql? is that what you mean...this script should return 1 (not
 succesfull, different than 0) it no pid file has been created, am i
 right?


 Correct, but there can be a case when opensips starts but then some
 module's initialization function fails due to mysql connect error or
 incompatible table version and the opensips will exit.

 --
 Sincerely,
 Andrew Pogrebennyk


 ___
 Users mailing list
 Users@lists.opensips.org
 http://lists.opensips.org/cgi-bin/mailman/listinfo/users



 ___
 Users mailing list
 Users@lists.opensips.org
 http://lists.opensips.org/cgi-bin/mailman/listinfo/users




-- 
Robert
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users