<div dir="ltr"><div>Strange too, in the logs:<br><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>
[Jun 3 17:09:49] NOTICE[3464] config.c: Registered Config Engine mysql<br>[Jun 3 17:09:49] ERROR[3464] res_config_mysql.c: MySQL RealTime: Failed to connect database server SSI on xxxx (err 2003). Check debug for more info.<br>
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: Table Comptes_IAX not found in database. This table should exist if you're using realtime.<br><br><br></div>Hi said "No database host found" but in the log i have "Failed to connect database server SSI on xxxx" with SSI and xxxx correct into my config file<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>The database schema (table) is different in Asterisk 11.4 ?<br><br></div>because i have configured:<br><br></div>cdr_mysql.conf<br>extconfig.conf<br>res_config_mysql.conf<br><br></div>
and on the mysql server, it's the old database of 1.6.x<br><br></div>i see:<br><br>[Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx (err 2003). Check debug for more info.<br>
<br></div>can i put debug ? i don't know where<br><br>thanks<span class="HOEnZb"><font color="#888888"><br>olivier<br><br><br></font></span></div><div class="HOEnZb"><div class="h5"><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>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<div><div><br>
<br>
On 03/06/2013 10:49 AM, Olivier CALVANO wrote:<br>
</div></div></div>
<blockquote type="cite"><div><div>
<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<br>
olivier<br>
<br>
<div>
<div>
<div><br>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><span><font color="#888888"><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>
</font></span></blockquote><span><font color="#888888">
<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>
</font></span></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>
</div></div></blockquote></div><br></div>