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

Ron Wheeler rwheeler at artifact-software.com
Mon Jun 3 11:40:04 CDT 2013


Fix this.

[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).

Asterisk is telling you that you have not configured ANY database.

It is not worrying about what tables are in it because you have not even 
defined the database itself.
There is NO database at all so worrying about versions is not Asterisk's 
big problem..

The rest of the messages after that are a bit screwy because the 
routines producing the error are not aware that there is no database at 
all so they just complain about the piece that they know about.


Ron


On 03/06/2013 12:19 PM, Olivier CALVANO wrote:
> No other idea ?
>
>
>
>
> 2013/6/3 Olivier CALVANO <o.calvano at gmail.com 
> <mailto: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
>     <http://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
>     <http://myhost.myserver.com>.
>     [Jun  3 16:30:14] ERROR[3220] cdr_mysql.c: Failed to connect to
>     mysql database SSI on myhost.myserver.com
>     <http://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 <http://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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130603/c64d163a/attachment.htm>


More information about the asterisk-users mailing list