[asterisk-users] Difference MySQL between 1.6.x and 11.4.x

[Ron Wheeler]

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>