<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello. I have been trying to setup Asterisk with
the realtime MySql with sip users descibed at <A
href="http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip">http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip</A><A
href="http://www.voip-info.org/tiki-index.php?page=Asterisk+RealTime"></A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have made a Mysql database called "asterisk" and
a table inside called "sip_buddies" as descibed at the wiki page.</FONT></DIV>
<DIV><FONT face=Arial size=2>The Mysqluser "root" has all rights to the
"asterisk" database.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have edited the Extconfig.conf to
this:</FONT></DIV>
<DIV><FONT face=Arial size=2>sippeers => mysql,asterisk,sip_buddies
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and in res_mysql.conf looks like this:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>[general]</FONT></DIV>
<DIV><FONT face=Arial size=2>dbhost = localhost</FONT></DIV>
<DIV><FONT face=Arial size=2>dbname = asterisk</FONT></DIV>
<DIV><FONT face=Arial size=2>dbuser = root</FONT></DIV>
<DIV><FONT face=Arial size=2>dbpass = passwd</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>When I reload Asterisk, I get this
error:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ERROR[8280]: res_config_mysql.c:615
mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on
localhost. Check debug for more info. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>The Cdr with mysql works fine, and it also
connects using the MySql user "root", so it should not be something wring with
the Mysql part.</FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT size=2></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT size=2>Does anyone see any obvious error I've made
?</FONT></DIV></FONT></BODY></HTML>