No other idea ?
2013/6/3 Olivier CALVANO <o.calv...@gmail.com> > 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