Stefan at WPF
2012-Aug-19 13:26 UTC
[asterisk-users] Verifying if Asterisk is connected using ODBC?
Hello all, how can I verify if Asterisk is connected to a database using the ODBC connection I configured? According to http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html-chunk/installing_configuring_odbc.html (at the end of the page) "*odbc show" on the console should output an information about this. However, when I run "odbc show" on my asterisk console (1.8.10.1), the output is:*> *CLI> odbc show > > >> ODBC DSN Settings > > ----------------- > > >> Name: asterisk > > DSN: asterisk-connector > > Last connection attempt: 2012-08-19 15:16:52 > > > So, no information if it is currently connected or not!?Thanks for any hint and best regards Stefan -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120819/bedb27a4/attachment.htm>
Doug Lytle
2012-Aug-19 14:03 UTC
[asterisk-users] Verifying if Asterisk is connected using ODBC?
Stefan at WPF wrote:> how can I verify if Asterisk is connected to a database using the ODBC > connection I configured?Mine shows: odbc show ODBC DSN Settings ----------------- Name: MySQL-Administration DSN: MySQL-Administration Last connection attempt: 1969-12-31 19:00:00 Name: MySQL-CID DSN: MySQL-CID Last connection attempt: 1969-12-31 19:00:00 Name: MySQL-Conferencing DSN: MySQL-Conferencing Last connection attempt: 1969-12-31 19:00:00 Name: MySQL-blacklisted DSN: MySQL-blacklisted Last connection attempt: 1969-12-31 19:00:00 Doug -- Ben Franklin quote: "Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."
Bryant Zimmerman
2012-Aug-19 14:11 UTC
[asterisk-users] Verifying if Asterisk is connected using ODBC?
Dough
Here is an example from one of our production server. You can see the
connection info in red. If you are not connected you don't usually get
that.
ODBC DSN Settings
-----------------
Name: AsteriskCxxxxx
DSN: Ast_Cxxxxx
Last connection attempt: 1969-12-31 19:00:00
Pooled: No
Connected: Yes
Name: AsteriskFxxxxx
DSN: Ast_Fxxxxx
Last connection attempt: 1969-12-31 19:00:00
Pooled: No
Connected: Yes
NOT CONNECTED:
Name: AsteriskFxxxxx_B1
DSN: Ast_Fxxxxx_B1
Last connection attempt: 2012-08-10 09:19:52
Name: AsteriskVOIPxxxxx
DSN: AST_MxxxxxVOIP
Last connection attempt: 1969-12-31 19:00:00
Pooled: No
Connected: Yes
Name: AsteriskVOIPxxxxx_B1
DSN: AST_MxxxxxVOIP_B1
Last connection attempt: 1969-12-31 19:00:00
Pooled: No
Connected: Yes
zktech
----------------------------------------
From: "Doug Lytle" <support at drdos.info>
Sent: Sunday, August 19, 2012 10:02 AM
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
<asterisk-users at lists.digium.com>
Subject: Re: [asterisk-users] Verifying if Asterisk is connected using
ODBC?
Stefan at WPF wrote:> how can I verify if Asterisk is connected to a database using the ODBC
> connection I configured?
Mine shows:
odbc show
ODBC DSN Settings
-----------------
Name: MySQL-Administration
DSN: MySQL-Administration
Last connection attempt: 1969-12-31 19:00:00
Name: MySQL-CID
DSN: MySQL-CID
Last connection attempt: 1969-12-31 19:00:00
Name: MySQL-Conferencing
DSN: MySQL-Conferencing
Last connection attempt: 1969-12-31 19:00:00
Name: MySQL-blacklisted
DSN: MySQL-blacklisted
Last connection attempt: 1969-12-31 19:00:00
Doug
--
Ben Franklin quote:
"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."
--
_____________________________________________________________________
-- 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120819/b00b364d/attachment.htm>