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

[Stefan at WPF]

Ah, thank you, that example helped. I would have expected the output to be
"Connected: No" instead of no output - the current way of (not) displaying
it is somehow confusing.

2012/8/19 Bryant Zimmerman <BryantZ at zktech.com>

> 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
>
>
> --
> _____________________________________________________________________
> -- 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/6ff03a85/attachment.htm>