News & Reviews
More How-To's & Tips More News
More Reviews Device Configuration Tools
No account yet? Create one
Forgot your Username or Password?

Welcome to the Voxilla VoIP Forum.

Voxilla has been a trusted source for accurate, up-to-date information on the IP Communications industry since 2002. A dedicated staff of reporters and engineers produce feature articles and product reviews to keep industry watchers abreast of the people, companies, and trends driving a fast moving market.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.





Closed Thread
 
LinkBack Thread Tools Rate Thread Display Modes
  #1 (permalink)  
Old January 23rd, 2007, 11:12 AM
kozmik007 kozmik007 is offline
Junior Member
 
Join Date: Dec 2006
Posts: 7
kozmik007 is on a distinguished road
Unhappy Asterisk Realtime Architecture with MySQL

I have configured Asterisk Realtime with MySQL database which worked well for a while. Now i'm beginning to get this error and i'm not also able to load sip.conf

[Jan 23 10:54:13] WARNING[16489]: res_config_mysql.c:413 config_mysql: MySQL RealTime: Failed to query database. Check debug for more info.

Can anyone help me out??
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2 (permalink)  
Old January 29th, 2007, 01:07 PM
kunal kunal is offline
Junior Member
 
Join Date: Jan 2007
Posts: 3
kunal is on a distinguished road
Smile Re: Asterisk Realtime Architecture with MySQL

I am also having same problems

my sip.conf file contains 5 registered users,
and I have done all the entries of the five users in my testing table in MySQL
also i have added one more user in Database but the Asterisk CLI does not show single user

CLI>sip show peers command shows
0 sip peers [ 0 online, 0 offline ]

Somebody help both of us. Please I am wating for all replies

Thanks in Advance,
kunal
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3 (permalink)  
Old January 31st, 2007, 01:56 PM
kunal kunal is offline
Junior Member
 
Join Date: Jan 2007
Posts: 3
kunal is on a distinguished road
Thumbs up Re: Asterisk Realtime Architecture with MySQL

Hi,

I think I have got the solution for U.

Now I am able to see why the query failed in my and yr case.

It shows that you have some problem with the updating of the tables.
To be able to see the debug information, open /etc/asterisk/logger.conf and make the changes below:

console => notice,warning,error,debug


And then try the reload command and see the Asterisk cli You will see the debugging of the SQL query and then reply me what had got wrong with U


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread


Thread Tools
Display Modes Rate This Thread
Rate This Thread:



Similar Threads for: Asterisk Realtime Architecture with MySQL
Thread Thread Starter Forum Replies Last Post
In Asterisk@Home mysql & perl connectivity problem mr_mehul_shah Asterisk Support Forum 0 April 25th, 2006 06:34 AM
Asterisk Realtime Problems with MYSQL Stevo Asterisk Support Forum 1 March 21st, 2006 06:50 AM
Asterisk@Home and AMP(?) Security Hole in MySQL AlexanderBell Asterisk Support Forum 0 October 17th, 2005 11:53 AM
Frustrated trying to get Asterisk to read MySQL VM config beonice Asterisk Support Forum 2 April 29th, 2005 06:03 AM
Does Asterisk support MySQL database in v1? achaniotis Asterisk Support Forum 1 December 8th, 2004 07:24 AM



All times are GMT. The time now is 05:26 AM.


vBulletin, Copyright ©2000 - 2009, Jelsoft Enterprises Ltd. SEO by vBSEO 3.0.0 ©2007, Crawlability, Inc. Logos and trademarks are the property of Voxilla or their respective owner. All other content © 2003-2007 by Voxilla, Inc.