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

[Olivier CALVANO]

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>