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 (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. [Jun 3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to mysql database SSI on 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 -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
