<!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.3790.2706" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=937584413-23062006>That is what I have in my config file. Pretty
much the same thing as the CDR file</SPAN></FONT></FONT></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=937584413-23062006></SPAN></FONT></FONT></FONT> </DIV>
<DIV dir=ltr align=left><FONT><FONT><SPAN class=937584413-23062006></SPAN><FONT
face=Arial color=#0000ff size=2>[general]<BR>dbhost=localhost<BR>dbname=<SPAN
class=937584413-23062006>db</SPAN><BR>dbuser=<SPAN
class=937584413-23062006>user</SPAN><BR>dbpass=<SPAN
class=937584413-23062006>pw</SPAN><BR>;dbport=3306<BR>;dbsock =
/tmp/mysql.sock</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=937584413-23062006><FONT face=Arial color=#0000ff
size=2>Mike</FONT></SPAN></DIV>
<DIV><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] <B>On Behalf Of </B>Benjamin
Stocker<BR><B>Sent:</B> June 23, 2006 9:07 AM<BR><B>To:</B> Asterisk Users
Mailing List - Non-Commercial Discussion<BR><B>Subject:</B> Re: [Asterisk-Users]
Realtime voicemail not working<BR></FONT><BR></DIV>
<DIV></DIV><BR><BR>
<DIV><SPAN class=gmail_quote>2006/6/23, Mike <<A
href="mailto:list@virtutel.ca">list@virtutel.ca</A>>:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hi,<BR><BR>I've
been using MySql with the CDR for awhile with no issues at all, but
I<BR>figured I'd try putting voicemail users in a DB. Using the
same DB (very<BR>low load), and a user that has been proven to work well using
a client GUI, <BR>I inserted one user and tried to use
realtime. This is what I get in
the<BR>console:<BR><BR>ERROR[30517]: res_config_mysql.c:615 mysql_reconnect:
MySQL RealTime: Failed<BR>to connect database server asterisk on localhost.
Check debug for more info. <BR><BR></BLOCKQUOTE></DIV><BR>What's in your
res_mysql.conf file? You need to place the connection settings there like you
did in cdr_mysql.conf. If you still get errors, start asterisk using the -d
option and check /var/log/asterisk. Also check logger.conf to make sure
debugging is enabled.<BR><BR><BR></BODY></HTML>