Thanks Bruce - but the whole point I am trying to accomplish is that I don't want to use Realtime and don't want asterisk to try to establish the connection.  Was just chatting in IRC about this and it seems that Realtime may not be able to be truly disabled (not sure how accurate that is, but that was what I was told).  Basically I just want to have asterisk load without those 2 errors popping up on the console and in the logs.

On 11/21/05, Bruce Ferrell <[EMAIL PROTECTED]> wrote:
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 <[EMAIL PROTECTED]
> <mailto: [EMAIL PROTECTED]>> 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: [EMAIL PROTECTED]
>         <mailto:[EMAIL PROTECTED]>
>         [mailto: [EMAIL PROTECTED]
>         <mailto:[EMAIL PROTECTED]>] 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
>     [email protected] <mailto: [email protected]>
>     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
> [email protected]
> 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
[email protected]
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
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Reply via email to