<!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.2604" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I have configured realtime according to the wiki.
However Asterisk can't see the new sip friend that is created in the table. I'm
sure I have failed to do something very basic which allows Asterisk to see
the records in mysql</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>realtime load sippeers name 6000</FONT></DIV>
<DIV><FONT face=Arial size=2>No rows found</FONT></DIV>
<DIV> </DIV>
<DIV>/var/log/asterisk/debug reports</DIV>
<DIV>Can't connect to local MySQL server through socket '/tmp/mysql.sock'</DIV>
<DIV> </DIV>
<DIV>The file /tmp/mysql.sock doesn't exist so perhaps that's the problem. What
should create that file?
<DIV><FONT face=Arial size=2>I have tried including the line "<FONT face=Arial
size=2>dbsock = /var/lib/mysql/mysql.sock" in res_config_mysql.conf but that
causes asterisk to core dump.</FONT></FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>extconfig.conf</FONT></DIV>
<DIV><FONT face=Arial size=2>sipusers =>
mysql,asterisk,sip_buddies</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>sip.conf</FONT></DIV>
<DIV><FONT face=Arial size=2>rtcachefriends=yes</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>res_config_mysql.conf</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 = password</FONT></DIV>
<DIV><FONT face=Arial size=2>dbport = 3306</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>select * from sip_buddies where name = '6000';
retrieves the record correctly.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any help would be appreciated.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Cameron</FONT></DIV></BODY></HTML>