It looks like your database configuration is missing in Asterisk.
It is making up information about the connection using defaault values
as if it did not find any database configuration.
Ron
On 03/06/2013 10:49 AM, Olivier CALVANO wrote:
Hi
i have installed a new Asterisk server on Fedora. My first server use
Asterisk 1.6.x with a MySQL CDR and
realtime.
I have a small problems, when i configure on the new server, the same
information in MySQL, we have a error:
[Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime:
Failed to connect database server SSI on myhost.myserver.com
<http://myhost.myserver.com> (err 2003). Check debug for more info.
[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.
[Jun 3 16:27:59] ERROR[3140] cdr_mysql.c: Failed to connect to mysql
database SSI on myhost.myserver.com <http://myhost.myserver.com>.
[Jun 3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql
database SSI on myhost.myserver.com <http://myhost.myserver.com>.
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database user found, using 'asterisk' as default.
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database password found, using 'asterisk' as default.
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database host found, using localhost via socket.
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database name found, using 'asterisk' as default.
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database port found, using 3306 as default.
[Jun 3 16:30:34] WARNING[3220] res_config_mysql.c: MySQL RealTime: No
database socket found (and unable to detect a suitable path).
The exacly same config work on 1.6.x
and from the new server, the database access is Ok:
[root@voip-2 log]# !mys
mysql -h myhost.myserver.com <http://myhost.myserver.com> -u Asterisk
-p SSI
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5185
Server version: 5.1.42-log Mandriva Linux - MySQL Standard Edition (GPL)
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights
reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> select * from VoiceMail;
+----------+-------------+--------------+------------+----------+--------------+-----------------------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+
| 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 |
+----------+-------------+--------------+------------+----------+--------------+-----------------------+-------+---------+--------+--------+---------+----------+--------+----------+----------+-------------+--------------+---------------+--------+--------------+-----------+----------------+-------------+---------------------+
<..>
anyone know the problems ?
thanks
olivier
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
--
Ron Wheeler
President
Artifact Software Inc
email: [email protected]
skype: ronaldmwheeler
phone: 866-970-2435, ext 102
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
