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

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,

[SR-Users] Cleaning wiki accounts

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

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

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

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

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]: >

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

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

[SR-Users] Lost of connection with MySQL?

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:

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

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

Re: [SR-Users] TOPOH MODULE

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

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

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

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

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

Re: [SR-Users] TOPOH MODULE

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

[SR-Users] TOPOH MODULE

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

Re: [SR-Users] TOPOH MODULE

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

[SR-Users] Refreshing: info about private emails

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,

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

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