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.<br><br><div><span class="gmail_quote">On 11/21/05, <b class="gmail_sendername">Bruce Ferrell</b> <<a href="mailto:bferrell@baywinds.org">bferrell@baywinds.org</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Check the mysql logs. I would suspect from this one of several things:<br><br>1.) the userid/password is incorrect.<br><br> on the db host use the command lin e mysql client like so:<br><br> mysql -h localhost -u <asterisk user> -p
<br><br> you'll be prompted for a password. If that works, go to the next<br> possible problem<br><br>2.) the userid doesn't have correct permissions to the DB<br><br> from the mysql client, issues the use command to try to access the
<br> realtime DB. if that works, go to the next possible problem.<br><br>3.) the userid is not permitted from the host the asterisk box is on<br><br> as the mysql superuser look at mysql.user to see what hosts are
<br> permitted access by the asterisk userid/password. If you have to<br> add a host, be sure to issue the flush priviledges command<br><br>Pedro wrote:<br>> Yeah - tried that. Here are 2 lines I have in my
modules.conf file:<br>><br>> noload => pbx_realtime.so<br>> noload => app_realtime.so<br>><br>> For some reason, I still get the following in my logs even after a<br>> restart of Asterisk.<br>><br>
> Nov 21 13:17:08 ERROR[31192] res_config_mysql.c: MySQL RealTime: Failed<br>> to connect database server on . Check debug for more info.<br>> Nov 21 13:17:08 WARNING[31192] res_config_mysql.c: MySQL RealTime:<br>
> Couldn't establish connection. Check debug.<br>><br>> Any thoughts?<br>><br>> - Pedro<br>><br>> On 11/21/05, Alexander Lopez <<a href="mailto:alex.lopez@opsys.com">alex.lopez@opsys.com</a><br>> <mailto:
<a href="mailto:alex.lopez@opsys.com">alex.lopez@opsys.com</a>>> wrote:<br>><br>> It is a better practice to use a noload option in modules.conf. That<br>> way if and when you upgrade you wont need to remove them again they
<br>> will just continue to not load....<br>><br>> Alex<br>><br>><br>> ------------------------------------------------------------------------<br>> From: <a href="mailto:asterisk-users-bounces@lists.digium.com">
asterisk-users-bounces@lists.digium.com</a><br>> <mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>><br>> [mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">
asterisk-users-bounces@lists.digium.com</a><br>> <mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com">asterisk-users-bounces@lists.digium.com</a>>] On Behalf Of Pedro<br>> Sent: Monday, November 21, 2005 12:11 PM
<br>> To: Asterisk Users Mailing List - Non-Commercial Discussion<br>> Subject: [Asterisk-Users] How do you disable realtime?<br>><br>> Am I correct in assuming that if I am not running Realtime on my
<br>> asterisk 1.2 server, the proper way to disable it is to remove<br>> the following 2 files:<br>><br>> /usr/lib/asterisk/modules/pbx_realtime.so<br>> /usr/lib/asterisk/modules/app_realtime.so
<br>><br>> I am just testing out the default installation and am getting<br>> these errors on the console:<br>><br>> Nov 21 12:05:29 ERROR[30656] res_config_mysql.c: MySQL RealTime:<br>
>
Failed to connect database server on . Check debug for more
info.<br>> Nov 21 12:05:29 WARNING[30656] res_config_mysql.c: MySQL<br>> RealTime: Couldn't establish connection. Check debug.<br>><br>> Any help will be appreciated.<br>><br>> - Pedro
<br>><br>><br>> _______________________________________________<br>> --Bandwidth and Colocation sponsored by <a href="http://Easynews.com">Easynews.com</a><br>> <<a href="http://Easynews.com">
http://Easynews.com</a>> --<br>><br>> Asterisk-Users mailing list<br>> <a href="mailto:Asterisk-Users@lists.digium.com">Asterisk-Users@lists.digium.com</a> <mailto:<a href="mailto:Asterisk-Users@lists.digium.com">
Asterisk-Users@lists.digium.com</a>><br>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>> To UNSUBSCRIBE or update options visit:
<br>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>><br>><br>><br>> ------------------------------------------------------------------------
<br>><br>> _______________________________________________<br>> --Bandwidth and Colocation sponsored by <a href="http://Easynews.com">Easynews.com</a> --<br>><br>> Asterisk-Users mailing list<br>> <a href="mailto:Asterisk-Users@lists.digium.com">
Asterisk-Users@lists.digium.com</a><br>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>> To UNSUBSCRIBE or update options visit:<br>
> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>_______________________________________________<br>--Bandwidth and Colocation sponsored by
<a href="http://Easynews.com">Easynews.com</a> --<br><br>Asterisk-Users mailing list<br><a href="mailto:Asterisk-Users@lists.digium.com">Asterisk-Users@lists.digium.com</a><br><a href="http://lists.digium.com/mailman/listinfo/asterisk-users">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users
</a><br></blockquote></div><br>