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

[Olivier CALVANO]

The database schema (table) is different in Asterisk 11.4 ?

because i have configured:

cdr_mysql.conf
extconfig.conf
res_config_mysql.conf

and on the mysql server, it's the old database of 1.6.x

i see:

[Jun  3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to
connect database server xxx on xxx (err 2003). Check debug for more info.

can i put debug ? i don't know where

thanks
olivier




2013/6/3 Ron Wheeler <rwheeler at artifact-software.com>

>  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 (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
>
>
>
>
> --
> _____________________________________________________________________
> -- 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
>
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130603/1ab36067/attachment-0001.htm>