asterisk users - Apr 2005 - Asterisk Realtime - can't see sip friend

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

realtime load sippeers name 6000
No rows found

/var/log/asterisk/debug reports
Can't connect to local MySQL server through socket '/tmp/mysql.sock'

The file /tmp/mysql.sock doesn't exist so perhaps that's the problem.
What should create that file?
I have tried including the line "dbsock = /var/lib/mysql/mysql.sock"
in res_config_mysql.conf but that causes asterisk to core dump.

extconfig.conf
sipusers => mysql,asterisk,sip_buddies
sippeers => mysql,asterisk,sip_buddies

sip.conf
rtcachefriends=yes

res_config_mysql.conf
[general]
dbhost = localhost
dbname = asterisk
dbuser = root
dbpass = password
dbport = 3306

select * from sip_buddies where name = '6000'; retrieves the record
correctly.

Any help would be appreciated.

Regards

Cameron
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20050411/c77f18de/attachment.htm