[asterisk-users] Verifying if Asterisk is connected using ODBC?

[Bryant Zimmerman]

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>