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

[Olivier CALVANO]

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>