Olivier CALVANO
2013-Jun-03 14:49 UTC
[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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 at 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130603/f4d31379/attachment.htm>
Ron Wheeler
2013-Jun-03 15:02 UTC
[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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 at 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: rwheeler at artifact-software.com skype: ronaldmwheeler phone: 866-970-2435, ext 102 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130603/3cd17d9a/attachment.htm>
Olivier CALVANO
2013-Jun-03 16:19 UTC
[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
No other idea ? 2013/6/3 Olivier CALVANO <o.calvano at 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 at 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 > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130603/42169b99/attachment.htm>