| View previous topic :: View next topic |
| Author |
Message |
isrlgb at gmail.com
Guest
|
 Posted: Tue Nov 11, 2014 4:52 am Post subject: [asterisk-users] odbc connection timeout varable |
 |
|
Hi allDoes anyone know of a variable that i could check to see if the reason func odbc didnt return results was because of a timeout error so i could play a audio file about that
thanks |
|
| Back to top |
|
 |
webaccounts173 at jgoe...
Guest
|
|
| Back to top |
|
|
isrlgb at gmail.com
Guest
|
| Posted: Tue Nov 11, 2014 8:10 am Post subject: [asterisk-users] odbc connection timeout varable |
|
|
On Tuesday, November 11, 2014, jg <webaccounts173@jgoettgens.de (webaccounts173@jgoettgens.de)> wrote:
I would like to tell callers the system is down as apposed to saying no info in system when the system is up or saying the info in the system |
|
| Back to top |
|
|
webaccounts173 at jgoe...
Guest
|
| Posted: Tue Nov 11, 2014 8:36 am Post subject: [asterisk-users] odbc connection timeout varable |
|
|
It takes a small fraction of second to reconnect. You should not experience any missing info.
jg
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
|
asterisk at voipbusine...
Guest
|
| Posted: Tue Nov 11, 2014 10:28 am Post subject: [asterisk-users] odbc connection timeout varable |
|
|
Unless of course the database server is not running at all for some reason.
Regards;
JVC
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of jg
Sent: Tuesday, November 11, 2014 8:36 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] odbc connection timeout varable
It takes a small fraction of second to reconnect. You should not experience
any missing info.
jg
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to
Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
|
ish at pack-net.co.uk
Guest
|
| Posted: Tue Nov 11, 2014 10:34 am Post subject: [asterisk-users] odbc connection timeout varable |
|
|
On 11 November 2014 15:27, Tech Support <asterisk@voipbusiness.us (asterisk@voipbusiness.us)> wrote:
| Quote: | Unless of course the database server is not running at all for some reason.
Regards;
JVC
|
Surely that should be monitored by some system designed for that purpose such as Nagios?
--
| Quote: | Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: ish@pack-net.co.uk (ish@pack-net.co.uk)
w: http://www.pack-net.co.uk
Registered Address: PACKNET LIMITED, Duplex 2, Ducie House
37 Ducie Street
Manchester, M1 2JW
COMPANY REG NO. 04920552
|
|
|
| Back to top |
|
|
webaccounts173 at jgoe...
Guest
|
| Posted: Tue Nov 11, 2014 10:38 am Post subject: [asterisk-users] odbc connection timeout varable |
|
|
| Quote: | Unless of course the database server is not running at all for some reason.
|
But that's not exactly an Asterisk problem.
jg
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
|
isrlgb at gmail.com
Guest
|
| Posted: Tue Nov 11, 2014 11:32 am Post subject: [asterisk-users] odbc connection timeout varable |
|
|
right but that is the problem and i was wondering if there is way for asterisk to set a variable when that happens just like curl
On Tue, Nov 11, 2014 at 5:37 PM, jg <webaccounts173@jgoettgens.de (webaccounts173@jgoettgens.de)> wrote:
|
|
| Back to top |
|
|
webaccounts173 at jgoe...
Guest
|
| Posted: Tue Nov 11, 2014 2:34 pm Post subject: [asterisk-users] odbc connection timeout varable |
|
|
It should not happen. I have a couple of Asterisk servers using the ODBC connection. I never
ever had any problem with ODBC or the database. What database are you using?
jg
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
|
isrlgb at gmail.com
Guest
|
| Posted: Tue Nov 11, 2014 2:43 pm Post subject: [asterisk-users] odbc connection timeout varable |
|
|
well it should but this morning my database hosted at a remote location was down due to conditions at the remote site
the question isnt if it should happen or not
the questions is there a way for me to know that the odbc query retruned empty because of a connection timeout?
in curl i could get that info is there a way also for odbc?
On Tue, Nov 11, 2014 at 9:33 PM, jg <webaccounts173@jgoettgens.de (webaccounts173@jgoettgens.de)> wrote:
|
|
| Back to top |
|
|
webaccounts173 at jgoe...
Guest
|
|
| Back to top |
|
|
mjordan at digium.com
Guest
|
| Posted: Wed Nov 12, 2014 1:04 pm Post subject: [asterisk-users] odbc connection timeout varable |
|
|
On Tue, Nov 11, 2014 at 1:43 PM, Israel Gottlieb <isrlgb@gmail.com> wrote:
| Quote: | well it should but this morning my database hosted at a remote location was
down due to conditions at the remote site
the question isnt if it should happen or not
the questions is there a way for me to know that the odbc query retruned
empty because of a connection timeout?
in curl i could get that info is there a way also for odbc?
|
To just answer your question:
No, there is no channel variable for this, nor anything in Asterisk
that does this automatically.
You would need to have something else monitoring your databases, and
use it to inform Asterisk of the failure.
--
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users |
|
| Back to top |
|
|
isrlgb at gmail.com
Guest
|
| Posted: Wed Nov 12, 2014 1:19 pm Post subject: [asterisk-users] odbc connection timeout varable |
|
|
thanks for the reply
On Wed, Nov 12, 2014 at 8:03 PM, Matthew Jordan <mjordan@digium.com (mjordan@digium.com)> wrote:
| Quote: | On Tue, Nov 11, 2014 at 1:43 PM, Israel Gottlieb <isrlgb@gmail.com (isrlgb@gmail.com)> wrote:
| Quote: | well it should but this morning my database hosted at a remote location was
down due to conditions at the remote site
the question isnt if it should happen or not
the questions is there a way for me to know that the odbc query retruned
empty because of a connection timeout?
in curl i could get that info is there a way also for odbc?
|
To just answer your question:
No, there is no channel variable for this, nor anything in Asterisk
that does this automatically.
You would need to have something else monitoring your databases, and
use it to inform Asterisk of the failure.
--
Matthew Jordan
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: http://digium.com & http://asterisk.org
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
|
|
|
| Back to top |
|
|
|
Search
