Difference MySQL Between 1.6.x And 11.4.x

Home » Asterisk Users » Difference MySQL Between 1.6.x And 11.4.x
Asterisk Users 14 Comments

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

14 thoughts on - Difference MySQL Between 1.6.x And 11.4.x