[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
Olivier CALVANO
o.calvano at gmail.com
Mon Jun 3 10:12:00 CDT 2013
Strange too, in the logs:
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database user found, using 'asterisk' as default.
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database password found, using 'asterisk' as default.
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database host found, using localhost via socket.
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database name found, using 'asterisk' as default.
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database port found, using 3306 as default.
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: MySQL RealTime: No
database socket found (and unable to detect a suitable path).
[Jun 3 17:09:49] NOTICE[3464] config.c: Registered Config Engine mysql
[Jun 3 17:09:49] ERROR[3464] res_config_mysql.c: MySQL RealTime: Failed to
connect database server SSI on xxxx (err 2003). Check debug for more info.
[Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: Table Comptes_IAX not
found in database. This table should exist if you're using realtime.
Hi said "No database host found" but in the log i have "Failed to connect
database server SSI on xxxx" with SSI and xxxx correct into my config file
2013/6/3 Olivier CALVANO <o.calvano at gmail.com>
> 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/dff40b51/attachment.htm>
More information about the asterisk-users
mailing list