<div dir="ltr"><div><div><div>Thanks for your help Ron,<br><br>Do you know where is the confirguration ?<br><br></div>Because i have put into res_config_mysql.conf:<br><br>[general]<br>dbhost = <a href="http://myhost.mydomain.net">myhost.mydomain.net</a><br>
dbname = MyDB<br>dbuser = MyUser<br>dbpass = MyPassword<br>dbport = 3306<br>dbsock = /tmp/mysql.sock<br>dbcharset = latin1<br>requirements = warn<br><br><br></div>after in extconfig.conf:<br>sipusers => mysql,general,Comptes_SIP<br>
sippeers => mysql,general,Comptes_SIP<br>iaxusers => mysql,general,Comptes_IAX<br>iaxpeers => mysql,general,Comptes_IAX<br>extensions => mysql,general,Extensions<br>meetme => mysql,general,MeetMe<br>musiconhold => mysql,general,Musiconhold<br>
voicemail => mysql,general,VoiceMail<br><br></div>and in cdr_mysql.conf<br><br>[global]<br>hostname=<a href="http://myhost.mydomain.net">myhost.mydomain.net</a><br>dbname=MyDB<br>table=Cdr<br>password=MyPassword<br>user=MyUser<br>
port=3306<br>sock=/tmp/mysql.sock<br><br>[aliases]<br>start=calldate<br>end=callend<br>callerid=clid<br>src=src<br>dst=dst<br>dcontext=dcontext<br>channel=channel<br>dstchannel=dstchannel<br>lastapp=lastapp<br>lastdata=lastdata<br>
duration=duration<br>billsec=billsec<br>disposition=disposition<br>amaflags=amaflags<br>accountcode=accountcode<br>userfield=userfield<br>uniqueid=uniqueid<br>CodeTier=CodeTier<br><br><br><br><div id="gt-src-tools"><div id="gt-src-tools-l">
<div style="display:inline-block" id="gt-input-tool"><div id="itamenu"><span class=""></span></div></div></div></div> <div id="gt-res-content" class=""><div dir="ltr" style><span id="result_box" class="" lang="en"><span class="">you</span> <span class="">know</span> <span class="">what file</span> <span class="">I forgot to</span> <span class="">configure</span><span class="">?<br>
</span></span></div><div style><span id="result_box" class="" lang="en"><span class="">Olivier<br><br></span></span></div></div><br><br><br><br><div><br><div><br><br><br><br></div></div></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">2013/6/3 Ron Wheeler <span dir="ltr"><<a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Fix this.<br>
<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database user found, using 'asterisk' as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database password found, using 'asterisk' as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database host found, using localhost via socket.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database name found, using 'asterisk' as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database port found, using 3306 as default.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL
RealTime: No database socket found (and unable to detect a
suitable path).<br>
<br>
Asterisk is telling you that you have not configured ANY database.<br>
<br>
It is not worrying about what tables are in it because you have
not even defined the database itself. <br>
There is NO database at all so worrying about versions is not
Asterisk's big problem.. <br>
<br>
The rest of the messages after that are a bit screwy because the
routines producing the error are not aware that there is no
database at all so they just complain about the piece that they
know about.<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
Ron</font></span><div><div class="h5"><br>
<br>
<br>
On 03/06/2013 12:19 PM, Olivier CALVANO wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">No other idea ?<br>
<br>
<br>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">2013/6/3 Olivier CALVANO <span dir="ltr"><<a href="mailto:o.calvano@gmail.com" target="_blank">o.calvano@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>Hi<br>
<br>
</div>
i have installed a new Asterisk server on Fedora.
My first server use Asterisk 1.6.x with a MySQL
CDR and<br>
realtime.<br>
<br>
</div>
I have a small problems, when i configure on the new
server, the same information in MySQL, we have a
error:<br>
<br>
[Jun 3 16:27:59] ERROR[3140] res_config_mysql.c:
MySQL RealTime: Failed to connect database server
SSI on <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>
(err 2003). Check debug for more info.<br>
[Jun 3 16:27:59] WARNING[3140] res_config_mysql.c:
Table VoiceMail not found in database. This table
should exist if you're using realtime.<br>
[Jun 3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to
connect to mysql database SSI on <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>.<br>
[Jun 3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to
connect to mysql database SSI on <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>.<br>
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c:
MySQL RealTime: No database user found, using
'asterisk' as default.<br>
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c:
MySQL RealTime: No database password found, using
'asterisk' as default.<br>
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c:
MySQL RealTime: No database host found, using
localhost via socket.<br>
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c:
MySQL RealTime: No database name found, using
'asterisk' as default.<br>
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c:
MySQL RealTime: No database port found, using 3306
as default.<br>
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c:
MySQL RealTime: No database socket found (and unable
to detect a suitable path).<br>
<br>
</div>
The exacly same config work on 1.6.x<br>
<br>
and from the new server, the database access is Ok:<br>
<br>
[root@voip-2 log]# !mys<br>
mysql -h <a href="http://myhost.myserver.com" target="_blank">myhost.myserver.com</a>
-u Asterisk -p SSI<br>
Enter password:<br>
Reading table information for completion of table and
column names<br>
You can turn off this feature to get a quicker startup
with -A<br>
<br>
Welcome to the MySQL monitor. Commands end with ; or
\g.<br>
Your MySQL connection id is 5185<br>
Server version: 5.1.42-log Mandriva Linux - MySQL
Standard Edition (GPL)<br>
<br>
Copyright (c) 2000, 2013, Oracle and/or its
affiliates. All rights reserved.<br>
<br>
Oracle is a registered trademark of Oracle Corporation
and/or its<br>
affiliates. Other names may be trademarks of their
respective<br>
owners.<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.<br>
<br>
mysql> select * from VoiceMail;<br>
+----------+-------------+--------------+------------+----------+--------------+-----------------------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+<br>
| uniqueid | customer_id | context | mailbox |
password | fullname | email |
pager | tz | attach | saycid | dialout | callback
| review | operator | envelope | sayduration |
saydurationm | sendvoicemail | delete | nextaftercmd |
forcename | forcegreetings | hidefromdir |
stamp |<br>
+----------+-------------+--------------+------------+----------+--------------+-----------------------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+<br>
</div>
<..><br>
<br>
<br>
</div>
anyone know the problems ?<br>
<br>
thanks<span><font color="#888888"><br>
olivier<br>
<br>
<div>
<div>
<div><br>
</div>
</div>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><div class="im"><pre>--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</div></blockquote><div class="im">
<br>
<br>
<pre cols="72">--
Ron Wheeler
President
Artifact Software Inc
email: <a href="mailto:rwheeler@artifact-software.com" target="_blank">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: <a href="tel:866-970-2435%2C%20ext%20102" value="+18669702435" target="_blank">866-970-2435, ext 102</a></pre>
</div></div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>