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
