Displaying 20 results from an estimated 6000 matches similar to: "CDR mysql: timeout when remote database unavailable"
2020 Jun 07
3
CDR mysql: timeout when remote database unavailable
> On 2020-06-06 10:38, Antony Stone wrote:
> On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:
>
>> In a situation when I start asterisk, and the remote database is
>> unreachable, asterisk waits for several minutes before it actually
>> starts (before it loads sip module, etc).
>>
>> And when database is unreachable during operation, when call
2020 Jun 08
0
CDR mysql: timeout when remote database unavailable
On 6/7/2020 2:54 AM, Fourhundred Thecat wrote:
> I would still like to know where the Aterisk mysql timeout duration
> comes from, and whether it can be configured.
In the case of cdr_mysql, the connect timeout is configurable by putting
the following in cdr_mysql.conf:
[global]
timeout = 5 ; Set connect timeout to 5 seconds
For app_mysql, setting the connection timeout is shown in the
2020 Jun 02
2
problem with logger: syslog vs. file
In article <94191802-6c9c-bdab-615b-001786a2a0ca at gmx.ch>,
Fourhundred Thecat <400thecat at gmx.ch> wrote:
> > On 2019-11-16 03:29, Fourhundred Thecat wrote:
> > Hello,
> >
> > I am logging directly into file and also to syslog.
> > Here is snippet from my /etc/asterisk/logger.conf:
> >
> > messages => notice,warning,error,verbose
2020 May 31
4
CLI color prompt
> On 2020-05-31 15:59, Antony Stone wrote:
> On Sunday 31 May 2020 at 15:44:46, Fourhundred Thecat wrote:
>
> "%Cn[;n] - Change terminal foreground (and optional background) color to
> specified A full list of colors may be found in include/asterisk/term.h"
>
> So, try:
>
> export ASTERISK_PROMPT="%C31[%H]: "
>
> (I got 31 from reading the
2020 May 31
5
CLI color prompt
Hello,
how can I change the color of the asterisk prompt to red ?
I read in the wiki that I can use %Cn[;n]
https://wiki.asterisk.org/wiki/display/AST/Asterisk+CLI+Configuration
But what does this mean ?
There is no example how to actually use it.
where do I put it?
What syntax is that anyway?
How do I specify red ?
I currently have this in my environment:
export ASTERISK_PROMPT="[%H]:
2020 Jun 06
0
CDR mysql: timeout when remote database unavailable
On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:
> In a situation when I start asterisk, and the remote database is
> unreachable, asterisk waits for several minutes before it actually
> starts (before it loads sip module, etc).
>
> And when database is unreachable during operation, when call happens,
> sometimes the call is connected, other times it waits for
2019 Oct 12
3
setting up ODBC for cdr logging into MariaDB
Hello,
I am trying to set up cdr logging into MariaDB through ODBC.
I have installed unixodbc unixodbc-dev and now I am struggling with
configuring /etc/odbcinst.ini
All the examples online use non-existent libraries, ie:
[MySQL]
Description = MySQL ODBC MyODBC Driver
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmaodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1
I have
2020 Jun 10
2
CDR mysql: timeout when remote database unavailable
> On 2020-06-08 16:37, Sean Bright wrote:
>
> In the case of cdr_mysql, the connect timeout is configurable by putting
> the following in cdr_mysql.conf:
>
> [global]
> timeout = 5 ; Set connect timeout to 5 seconds
OK, so i changed the timeout to 2 sec, but it does not have the desired
effect. I expected, if mysql cannot be reached, after 2 seconds the call
will progress
2019 Nov 16
2
problem with logger
Hello,
I am logging directly into file and also to syslog.
Here is snippet from my /etc/asterisk/logger.conf:
messages => notice,warning,error,verbose
syslog.local0 => notice,warning,error,verbose
But the logs look different:
VERBOSE[7609][C-00000013] pbx.c:
NOTICE[3042] chan_sip.c: Peer '1111' is now UNREACHABLE!
vs.
VERBOSE[7609][C-00000013]: pbx.c:2925 in
2023 Apr 14
2
couldn't allocate a port for RTP instance
Hello,
my logs are flooded with:
WARNING: The 'stasis/m:cdr:aggregator-00000005' task processor queue
reached 5000 scheduled tasks again.
and then, when call came, I got this:
ERROR: Oh dear... we couldn't allocate a port for RTP instance
'0x6e1e680fd670'
WARNING: Unable to cancel schedule ID 0. This is probably a bug
(res_rtp_asterisk.c: dtls_srtp_stop_timeout_timer,
2019 Oct 30
3
email notification on missed call
Hello,
what is the best way to implement email notification on missed call ?
So far, I have been using a solution that I hacked together. I create a
hangup-handler, inside which I check for "${DIALSTATUS}" and use System():
System(/bin/echo ... | /usr/bin/mail ....)
I have pasted the block here, for better formating:
https://pastebin.com/Sf8raPD6
My question is:
Do I have to
2023 Aug 04
2
print only first level directory name when copying files
Hello,
I am copying /mnt/foo to /mnt/bar/
rsync --info=name1,del2 -rl /mnt/foo /mnt/bar/
/mnt/foo contains deep directory structure, ie:
/mnt/foo/aaa/
/mnt/foo/aaa/somestuff/
/mnt/foo/aaa/somestuff/file1
/mnt/foo/bbb/
/mnt/foo/bbb/someotherstuff/
/mnt/foo/bbb/someotherstuff/file2
I am not interested in details which individual files were copied, just
the main directory.
2020 Jun 08
3
cdr_mysql: Cannot connect to database server - SSL error: SSL_CTX_set_default_verify_paths failed
Hi list!
I'm getting this error frequently:
ERROR[25193][C-0004f387]: cdr_mysql.c:203 mysql_log: Cannot connect to
database server localhost: (2026) SSL connection error:
SSL_CTX_set_default_verify_paths failed
Right now, as a workaround, I reload Asterisk via cron once an hour, and
after the reload everything is fine again _for a while_. Still, over the
course of a month I lose about
2020 Jun 03
2
problem with logger: syslog vs. file
In article <88f96e46-e6bb-a7ef-bebb-5588ef6cd6c1 at gmx.ch>,
Fourhundred Thecat <400thecat at gmx.ch> wrote:
> > On 2020-06-02 17:48, Tony Mountifield wrote:
> > In article <94191802-6c9c-bdab-615b-001786a2a0ca at gmx.ch>,
> > Fourhundred Thecat <400thecat at gmx.ch> wrote:
> >> > On 2019-11-16 03:29, Fourhundred Thecat wrote:
>
>
2023 Apr 14
1
couldn't allocate a port for RTP instance
On Fri, Apr 14, 2023 at 5:44 AM Fourhundred Thecat <400thecat at gmx.ch> wrote:
> Hello,
>
> my logs are flooded with:
>
> WARNING: The 'stasis/m:cdr:aggregator-00000005' task processor queue
> reached 5000 scheduled tasks again.
>
This means there's a ton of channel events being created.
>
> and then, when call came, I got this:
>
> ERROR: Oh
2023 Apr 14
1
couldn't allocate a port for RTP instance
> On 2023-04-14 11:06, Joshua C. Colp wrote:
> On Fri, Apr 14, 2023 at 5:44 AM Fourhundred Thecat <400thecat at gmx.ch
> <mailto:400thecat at gmx.ch>> wrote:
>
> Hello,
>
> my logs are flooded with:
>
> WARNING: The 'stasis/m:cdr:aggregator-00000005' task processor queue
> reached 5000 scheduled tasks again.
>
>
> This
2023 Mar 04
2
cdr_sqlite3
On Sat, Mar 4, 2023 at 1:29 PM, Fourhundred Thecat <400thecat at gmx.ch> wrote:
> /var/log/asterisk/master.db
>
> how can I change the location ?
>
> If this is not possible to change in the config file, where in the
> source code would I change that?
cdr/cdr_sqlite3_custom.c line 311
Kind regards,
Sean
-------------- next part --------------
An HTML attachment was
2023 Aug 04
1
print only first level directory name when copying files
Fourhundred Thecat via rsync <400thecat at lists.samba.org> wrote:
> I am copying /mnt/foo to /mnt/bar/
>
> rsync --info=name1,del2 -rl /mnt/foo /mnt/bar/
>
> /mnt/foo contains deep directory structure, ie:
>
> /mnt/foo/aaa/
> /mnt/foo/aaa/somestuff/
> /mnt/foo/aaa/somestuff/file1
>
> /mnt/foo/bbb/
> /mnt/foo/bbb/someotherstuff/
>
2023 Apr 06
1
log custom variable in cdr
Hello,
in my extensions.conf, I have a custom macro which I use at the
beginning of incoming call, and then I turn on cdr recording:
exten => 123456789,1,Macro(record)
...
same => n,Set(CDR_PROP(disable)=0)
...
the macro is defined later, and sets one filename variable:
[macro-record]
exten => s,1,Set(FILE=${CDR(src)}-${CDR(dst)}.wav)
.....
my question is, how can I log
2020 Jun 03
2
problem with logger: syslog vs. file
On Wed, 3 Jun 2020, Fourhundred Thecat wrote:
>> On 2020-06-03 12:18, Tony Mountifield wrote:
>> In article <88f96e46-e6bb-a7ef-bebb-5588ef6cd6c1 at gmx.ch>,
>>
>> However, the conversation would then be: should both logging types include
>> line number and function? should both logging types omit them? should
>> it be a configuration option in