[Asterisk-Users] How do you disable realtime?

[Bruce Ferrell]

Check the mysql logs.  I would suspect from this one of several things:

1.) the userid/password is incorrect.

    on the db host use the command lin e mysql client like so:

     mysql -h localhost -u <asterisk user> -p

     you'll be prompted for a password.  If that works, go to the next
     possible problem

2.) the userid doesn't have correct permissions to the DB

      from the mysql client, issues the use command to try to access the
      realtime DB.  if that works, go to the next possible problem.

3.) the userid is not permitted from the host the asterisk box is on

      as the mysql superuser look at mysql.user to see what hosts are
      permitted access by the asterisk userid/password.  If you have to
      add a host, be sure to issue the flush priviledges command

Pedro wrote:
> Yeah - tried that.  Here are 2 lines I have in my modules.conf file:
> 
> noload => pbx_realtime.so
> noload => app_realtime.so
> 
> For some reason, I still get the following in my logs even after a 
> restart of Asterisk.
> 
> Nov 21 13:17:08 ERROR[31192] res_config_mysql.c: MySQL RealTime: Failed 
> to connect database server  on . Check debug for more info.
> Nov 21 13:17:08 WARNING[31192] res_config_mysql.c: MySQL RealTime: 
> Couldn't establish connection. Check debug.
> 
> Any thoughts?
> 
> - Pedro
> 
> On 11/21/05, Alexander Lopez <alex.lopez at opsys.com 
> <mailto:alex.lopez at opsys.com>> wrote:
> 
>     It is a better practice to use a noload option in modules.conf. That
>     way if and when you upgrade you wont need to remove them again they
>     will just continue to not load....
>      
>     Alex
>      
> 
>         ------------------------------------------------------------------------
>         From: asterisk-users-bounces at lists.digium.com
>         <mailto:asterisk-users-bounces at lists.digium.com>
>         [mailto:asterisk-users-bounces at lists.digium.com
>         <mailto:asterisk-users-bounces at lists.digium.com>] On Behalf Of Pedro
>         Sent: Monday, November 21, 2005 12:11 PM
>         To: Asterisk Users Mailing List - Non-Commercial Discussion
>         Subject: [Asterisk-Users] How do you disable realtime?
> 
>         Am I correct in assuming that if I am not running Realtime on my
>         asterisk 1.2 server, the proper way to disable it is to remove
>         the following 2 files:
> 
>         /usr/lib/asterisk/modules/pbx_realtime.so
>         /usr/lib/asterisk/modules/app_realtime.so
> 
>         I am just testing out the default installation and am getting
>         these errors on the console:
> 
>         Nov 21 12:05:29 ERROR[30656] res_config_mysql.c: MySQL RealTime:
>         Failed to connect database server  on . Check debug for more info.
>         Nov 21 12:05:29 WARNING[30656] res_config_mysql.c: MySQL
>         RealTime: Couldn't establish connection. Check debug.
> 
>         Any help will be appreciated.
> 
>         - Pedro
> 
> 
>     _______________________________________________
>     --Bandwidth and Colocation sponsored by Easynews.com
>     <http://Easynews.com> --
> 
>     Asterisk-Users mailing list
>     Asterisk-Users at lists.digium.com <mailto:Asterisk-Users at lists.digium.com>
>     http://lists.digium.com/mailman/listinfo/asterisk-users
>     To UNSUBSCRIBE or update options visit:
>       http://lists.digium.com/mailman/listinfo/asterisk-users
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> --Bandwidth and Colocation sponsored by Easynews.com --
> 
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users