Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Daniel-Constantin Mierla
Hello, it doesn't have to be from kamailio.cfg, but any query from external tools, like cron jobs, billing applications, etc ... Can you measure how long it takes to do a query from the command line? Just try to select the records by a call-id. Also, there are some core parameters that will prin

[SR-Users] Refreshing: info about private emails

2017-02-14 Thread Daniel-Constantin Mierla
As I still receive a lot, I am re-posting the notification about private emails, either initiating a topic or sent directly after a discussion started on public mailing lists (subject with mailing lists prefix, but the sender header is not the mailing list daemon). I would like to remind that, at

Re: [SR-Users] TOPOH MODULE

2017-02-14 Thread Daniel-Constantin Mierla
Can you provide a pcap with such call, taken on kamailio server, starting with the first invite to the last sip message of the call? Cheers, Daniel On 14/02/2017 14:58, Annus Fictus wrote: > Thank you, > > I'm searching this parameter without seen it :( > > The result is the same: > > SIP/2.0 48

Re: [SR-Users] TOPOH MODULE

2017-02-14 Thread Annus Fictus
Thank you, I'm searching this parameter without seen it :( The result is the same: SIP/2.0 481 Call/Transaction Does Not Exist the Flow is: Softphone -> Kamailio -> MediaServer Mediaserver send BYE to Kamailio and Kamailio Answer with: SIP/2.0 481 Call/Transaction Does Not Exist Dialog M

Re: [SR-Users] TOPOH MODULE

2017-02-14 Thread Daniel Tryba
On Tue, Feb 14, 2017 at 08:32:27AM -0500, Annus Fictus wrote: > In the parameter description, I read i have to use "lreq_callee_headers" > dialog parameter to resolve this kind of issues, but I can't find this > parameter on the module description. > > I'm using Kamailio 4.4.5 It is in the dialog

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Daniel Tryba
On Tue, Feb 14, 2017 at 02:27:59PM +0100, Igor Potjevlesch wrote: > Looks to be a good idea. > I use MySQL and MyISAM, so I understand that async is supported. Async (db_insert_mode=2) is supported with any (acc)backend. With myisam you can use delayed inserts (db_insert_mode=1). But without even

[SR-Users] TOPOH MODULE

2017-02-14 Thread Annus Fictus
Hello, I'm using TOPOH module but I have a problem with Call-ID. If I use: modparam("topoh", "mask_callid", 1) and send the INVITE to a media server, when media server send BYE to KAMAILIO, Kamailio answer like transaction not exist. In the parameter description, I read i have to use "lreq_

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Igor Potjevlesch
Hi, Looks to be a good idea. I use MySQL and MyISAM, so I understand that async is supported. How should I dimension the number of async_workers? Regards, -- Adrien LEMOINE alemo...@legos.fr Tel : +33 1 75 85 00 11 Mob : +33 7 55 50 00 11 Fax : +33 1 75 85 00 01 Skype : pcman-vdh Local Exchan

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Igor Potjevlesch
Hello, There is only queries on a replication server, so not the one reported in the errors, to make some fraud detections. But, directly from Kamailio config file, there's no queries. The structure is: id as primary and callid is an index. Regards, Igor. De : Daniel-Constantin Mierl

[SR-Users] Cleaning wiki accounts

2017-02-14 Thread Daniel-Constantin Mierla
Hello, I noticed a lot of random usernames for the accounts created to edit the wiki. Apart of several which did some which did some edits to add spam, most of them are inactive. Not sure what would be the real purpose behind them, but I am going to remove anything that doesn't look as a community

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Daniel Tryba
On Tue, Feb 14, 2017 at 09:54:42AM +0100, Igor Potjevlesch wrote: [mysql query fails] > These errors are repeated many times and cause Kamailio to hang and don't > reply to SIP requests. A reboot of Kamailio solves the issue. > > Anyone has already had this issue and had solved it? This is "norma

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Daniel-Constantin Mierla
Hello, it is a lot if you have over 9 million records. Do you run other periodical queries over acc, like generating full cdrs every N minutes? Have you created other constraints (e.g., unique keys) over the table? Cheers, Daniel On 14/02/2017 11:51, Igor Potjevlesch wrote: > > Hello Daniel, >

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Igor Potjevlesch
Hello Daniel, Actually 9 031 181. Regards, Igor. De : sr-users [mailto:sr-users-boun...@lists.sip-router.org] De la part de Daniel-Constantin Mierla Envoyé : mardi 14 février 2017 10:57 À : Kamailio (SER) - Users Mailing List Objet : Re: [SR-Users] Lost of connection with MySQL? Hell

Re: [SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Daniel-Constantin Mierla
Hello, do you have a lot of records inside the acc table? Cheers, Daniel On 14/02/2017 09:54, Igor Potjevlesch wrote: > > Hello, > > > > Two times in the last week, Kamailio reports MySQL errors like these: > > > > /usr/local/sbin/kamailio[19225]: ERROR: db_mysql [km_dbase.c:126]: > db_mysql

[SR-Users] Lost of connection with MySQL?

2017-02-14 Thread Igor Potjevlesch
Hello, Two times in the last week, Kamailio reports MySQL errors like these: /usr/local/sbin/kamailio[19225]: ERROR: db_mysql [km_dbase.c:126]: db_mysql_submit_query(): driver error on query: Can't connect to MySQL server on '192.168.2.6' (4) (2003) /usr/local/sbin/kamailio[19225]: ERROR: [