<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">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">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">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">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>