Re: [OpenSIPS-Users] Send 487 request terminbated while a cancel recieved from UAC

2012-12-08 Thread Dani Popa
As far as I know, opensips send 487, when receiving 200ok, when forking
On Dec 5, 2012 8:19 AM, M.Khaled W Chehab kche...@icucall.com wrote:

 Dears ,



 How to send a  487 request terminated   and drop the call directly  if
the UA send a cancel ,since now I am sending 200  canceling to UA and send
a cancel for the Trunk and wait for his  reply  .



 Regards

 Khaled Chehab

 Senior NGN Engineer

 Operations Office - Lebanon

 Office: +961 1 515155 ext 300

 Mobile  : +961 3 045212

 E-mail: kche...@icucall.com

 MSN ID :khalidche...@hotmail.com

 Skype: k_chehab

 Web Site: http://www.icucall.com

  http://www.allohi.com




 ___
 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


[OpenSIPS-Users] having problems installing opensips-cp opensips.acc doesn't exist

2012-12-08 Thread Paul Snom




Hi; I'm having problems installing opensips-cp, these are my steps1. I manually 
create an empty MySQL 5.5 table 'opensips' I execute mysql -D opensips -p  
cdrs.mysql  - this creates 1 table 'cdrs'2. mysql -D opensips -p  
opensips_cdrs_1_6.mysql when I exucute step 2 I get the error: ERROR 1146 
(42S02) at line 2: Table 'opensips.acc' doens't exist Is there something I'm 
missing or overlooking?  Thanks___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


Re: [OpenSIPS-Users] having problems installing opensips-cp opensips.acc doesn't exist

2012-12-08 Thread Mimi Cafe

Hi,
it says table acc does not exist (this is probably true). If you have 
followed all the steps correctly, then you shouldn't have this issue. 
Perhaps,  you should go on and create the acc table and then load the 
SQL again.


Mimi

On 08/12/2012 19:19, Paul Snom wrote:

Hi;

I'm having problems installing opensips-cp, these are my steps
1. I manually create an empty MySQL 5.5 table 'opensips' I execute 
mysql -D opensips -p  cdrs.mysql  - this creates 1 table 'cdrs'

2. mysql -D opensips -p  opensips_cdrs_1_6.mysql

when I exucute step 2 I get the error: ERROR 1146 (42S02) at line 2: 
Table 'opensips.acc' doens't exist


Is there something I'm missing or overlooking?

Thanks




___
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] having problems installing opensips-cp opensips.acc doesn't exist

2012-12-08 Thread Paul Snom

thanks for the input, I will try to create this table manually,  but at what 
point/step is this table created?  thanksP
 Date: Sat, 8 Dec 2012 19:26:36 +
From: mimic...@gmail.com
To: users@lists.opensips.org
Subject: Re: [OpenSIPS-Users] having problems installing opensips-cp 
opensips.acc doesn't exist


  

  
  
Hi, 

it says table acc does not exist (this is probably true). If you
have followed all the steps correctly, then you shouldn't have
this issue. Perhaps,  you should go on and create the acc table
and then load the SQL again.



Mimi

  

  On 08/12/2012 19:19, Paul Snom wrote:



  
  
Hi;

 

I'm having problems installing opensips-cp, these are my steps

1. I manually create an empty MySQL 5.5 table 'opensips' I
execute mysql -D opensips -p  cdrs.mysql  - this creates
1 table 'cdrs'

2. mysql -D opensips -p  opensips_cdrs_1_6.mysql

 

when I exucute step 2 I get the error: ERROR 1146 (42S02) at
line 2: Table 'opensips.acc' doens't exist

 

Is there something I'm missing or overlooking? 

 

Thanks

 

 

  
  

  
  

  ___
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] having problems installing opensips-cp opensips.acc doesn't exist

2012-12-08 Thread Mimi Cafe
Normally you would run opensipsdbctl create  to create the opensips 
database (including tables) during installation. I believe you can still 
go back and use it to create the tables because they are to omany of 
them and this makes life easier.


If you run it and it give an error that the db exist, then clonsider 
dropping the existing one (if it doesn't contain data) and have 
opensipsdbctl create it.


Hoper this helps

Mimi

On 08/12/2012 19:59, Paul Snom wrote:
thanks for the input, I will try to create this table manually,  but 
at what point/step is this table created?


thanks
P


Date: Sat, 8 Dec 2012 19:26:36 +
From: mimic...@gmail.com
To: users@lists.opensips.org
Subject: Re: [OpenSIPS-Users] having problems installing opensips-cp 
opensips.acc doesn't exist


Hi,
it says table acc does not exist (this is probably true). If you have 
followed all the steps correctly, then you shouldn't have this issue. 
Perhaps,  you should go on and create the acc table and then load the 
SQL again.


Mimi

On 08/12/2012 19:19, Paul Snom wrote:

Hi;

I'm having problems installing opensips-cp, these are my steps
1. I manually create an empty MySQL 5.5 table 'opensips' I execute
mysql -D opensips -p  cdrs.mysql  - this creates 1 table 'cdrs'
2. mysql -D opensips -p  opensips_cdrs_1_6.mysql

when I exucute step 2 I get the error: ERROR 1146 (42S02) at line
2: Table 'opensips.acc' doens't exist

Is there something I'm missing or overlooking?

Thanks




___
Users mailing list
Users@lists.opensips.org  mailto: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


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


[OpenSIPS-Users] osipsconsole address failed

2012-12-08 Thread Mimi Cafe
I attempted using osipsconsole to add a gateway address, but it failed 
because there is no data in the dbaliases table. How is this linked to 
the dbaliases tables? What is the prerequisite to adding a gateway 
address in addresses table?


osipsconsole address add 0 192.168.18.89 255.255.255.255 5060 UDP

Control engine FIFO loaded
Used database is mysql
Retrieving data from table failedYou have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near 'WHERE ip='192.168.18.89'' at line 1
Introducing the address rule 0 192.168.18.89 255.255.255.255 5060 UDP to 
the database failed
You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near '( grp, 
ip, mask, port, proto , context_info ) VALUES ( 0, '192.168.18.89', 
'255.' at line 1



Mimi

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