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

Mon Jun 3 23:55:07 CDT 2013

What is the best commande for put the debug ? because with core set debug,
i don't have a return.

voip-2*CLI> realtime mysql status
Vop configured for MyDB at MyHost.MyDomain.net, port 3306 with username
Asterisk.
[Jun  4 06:48:25] ERROR[27879]: res_config_mysql.c:1577 mysql_reconnect:
MySQL RealTime: Failed to connect database server Vop on
vop.phibee-telecom.net (err 2003). Check debug for more info.

He read correctly the config because it's the good DB, Server and username

in /var/log/asterisk/message i have:

[Jun  4 06:46:21] Asterisk 11.4.0 built by mockbuild @
buildvm-12.phx2.fedoraproject.org on a x86_64 running Linux on 2013-05-20
15:47:05 UTC
[Jun  4 06:46:21] NOTICE[27825] loader.c: 1 modules will be loaded.
[Jun  4 06:46:21] NOTICE[27825] config.c: Registered Config Engine mysql
[Jun  4 06:46:21] NOTICE[27825] cdr.c: CDR simple logging enabled.
[Jun  4 06:46:21] NOTICE[27825] loader.c: 192 modules will be loaded.
[Jun  4 06:46:21] NOTICE[27825] res_smdi.c: No SMDI interfaces are
available to listen on, not starting SMDI listener.
[Jun  4 06:46:21] WARNING[27825] res_musiconhold.c: No music on hold
classes configured, disabling music on hold.
[Jun  4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net<http://myhost.mydomain.net/>(err 2003). Check
debug for more info.
[Jun  4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_IAX not
found in database.  This table should exist if you're using realtime.
[Jun  4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net<http://myhost.mydomain.net/>(err 2003). Check
debug for more info.
[Jun  4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net<http://myhost.mydomain.net/>(err 2003). Check
debug for more info.
[Jun  4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_SIP not
found in database.  This table should exist if you're using realtime.
[Jun  4 06:46:21] NOTICE[27825] confbridge/conf_config_parser.c: Adding
default_user profile to app_confbridge
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: Starting AEL load process.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: parsed config
file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: checked config
file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: compiled
config file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: merged config
file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: verified
config file name '/etc/asterisk/extensions.ael'.
[Jun  4 06:46:22] ERROR[27825] cdr_mysql.c: Failed to connect to mysql
database MyDB on MyHost.MyDomain.net <http://myhost.mydomain.net/>.
[Jun  4 06:47:51] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net<http://myhost.mydomain.net/>(err 2003). Check
debug for more info.
[Jun  4 06:48:25] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed
to connect database server MyDB on
MyHost.MyDomain.net<http://myhost.mydomain.net/>(err 2003). Check
debug for more info.

Asterisk have the good information, but i don't understand why he can't
connect to the DB, if i use:
mysql -h MyHost.MyDomain.net <http://myhost.mydomain.net/> -u Aserisk -p
MyDB
i have a full access to my MySQL server.

may be missing in a Fedora package ?

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

>  Well, at least you are making progress.
> What is the error in the debug log?
>
> Ron
>
>
>
> On 03/06/2013 8:03 PM, Olivier CALVANO wrote:
>
>  grrr no in asterisk -d i have no error, but when i start normaly
> asterisk i have :
>
> [Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server xxx on xxx.xxx.net (err 2003). Check debug for
> more info.
> [Jun  4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed
> to connect database server xxx on xxx.xxx.net (err 2003). Check debug for
> more info.
>
>
>  what is the command in asterisk for i see the SQL query ?
>
>
>
>
> 2013/6/4 Olivier CALVANO <o.calvano at gmail.com>
>
>>  oh ron thanks for your help :
>>
>>  We have deleted all commented line, only put the configuration and now
>> that's work !
>>
>>
>>
>>
>>  2013/6/3 Ron Wheeler <rwheeler at artifact-software.com>
>>
>>>   Do you have this problem in your conf file?
>>>
>>> http://forums.digium.com/viewtopic.php?p=63736
>>>
>>> "The parser won't accept an ; (semicolon) for remarks! So he found at
>>> the first the old remarks and tried to access my database with the false
>>> data."
>>>
>>>
>>>
>>>
>>> Ron
>>>
>>>
>>> On 03/06/2013 3:18 PM, Olivier CALVANO wrote:
>>>
>>>  on this server we don't have mysql.socket because he don't have mysql
>>> server
>>>
>>>  we want access to a mysql based on a other server
>>>
>>>
>>>
>>>
>>>  2013/6/3 Bakko <asannucci at gmail.com>
>>>
>>>>  Hello,
>>>>
>>>> are you sure MySQL socket is in /tmp directory?
>>>>
>>>> dbsock = /tmp/mysql.sock
>>>>
>>>> Regards
>>>>
>>>> El 03/06/2013 12:16, Olivier CALVANO escribió:
>>>>
>>>>   Thanks for your help Ron,
>>>>
>>>> Do you know where is the confirguration ?
>>>>
>>>>  Because i have put into res_config_mysql.conf:
>>>>
>>>> [general]
>>>> dbhost = myhost.mydomain.net
>>>> dbname = MyDB
>>>> dbuser = MyUser
>>>> dbpass = MyPassword
>>>> dbport = 3306
>>>> dbsock = /tmp/mysql.sock
>>>> dbcharset = latin1
>>>> requirements = warn
>>>>
>>>>
>>>  --
>>> 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
>>>
>>
>>
>
>
> --
> 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/20130604/14b19a1e/attachment.htm>