<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">It looks like your database
configuration is missing in Asterisk.<br>
<br>
It is making up information about the connection using defaault
values as if it did not find any database configuration.<br>
<br>
Ron<br>
<br>
On 03/06/2013 10:49 AM, Olivier CALVANO wrote:<br>
</div>
<blockquote
cite="mid:CAJajPefHidBF1kngJ=+pX4A8iYicPsUXWW4-h-0S3vPEjwNwgA@mail.gmail.com"
type="cite">
<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">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">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">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">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<br>
olivier<br>
<br>
<div>
<div>
<div><br>
</div>
</div>
</div>
</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>