<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">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.<br>
<br>
<br>
Ron<br>
<br>
<br>
On 03/06/2013 12:19 PM, Olivier CALVANO wrote:<br>
</div>
<blockquote
cite="mid:CAJajPee1SFh0cjd-1N_P2NvdwBid6ppWmXFy4FzRf=gBfjJMpg@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 class="HOEnZb"><font color="#888888"><br>
olivier<br>
<br>
<div>
<div>
<div><br>
</div>
</div>
</div>
</font></span></div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a class="moz-txt-link-freetext" href="http://www.api-digital.com">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a class="moz-txt-link-freetext" href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Ron Wheeler
President
Artifact Software Inc
email: <a class="moz-txt-link-abbreviated" href="mailto:rwheeler@artifact-software.com">rwheeler@artifact-software.com</a>
skype: ronaldmwheeler
phone: 866-970-2435, ext 102</pre>
</body>
</html>