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

Asghar Mohammad asghar144 at gmail.com
Mon Jun 3 14:35:21 CDT 2013


asterisk trying connect to mysql via socket remove that line from config
files.
1 check if port 3306 is open in iptables on both servers.
2 check permissions on db for user Asterisk.


On Mon, Jun 3, 2013 at 9:18 PM, Olivier CALVANO <o.calvano at gmail.com> 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
>>
>>
>>  after in extconfig.conf:
>> sipusers => mysql,general,Comptes_SIP
>> sippeers => mysql,general,Comptes_SIP
>> iaxusers => mysql,general,Comptes_IAX
>> iaxpeers => mysql,general,Comptes_IAX
>> extensions => mysql,general,Extensions
>> meetme => mysql,general,MeetMe
>> musiconhold => mysql,general,Musiconhold
>> voicemail => mysql,general,VoiceMail
>>
>>  and in cdr_mysql.conf
>>
>> [global]
>> hostname=myhost.mydomain.net
>> dbname=MyDB
>> table=Cdr
>> password=MyPassword
>> user=MyUser
>> port=3306
>> sock=/tmp/mysql.sock
>>
>> [aliases]
>> start=calldate
>> end=callend
>> callerid=clid
>> src=src
>> dst=dst
>> dcontext=dcontext
>> channel=channel
>> dstchannel=dstchannel
>> lastapp=lastapp
>> lastdata=lastdata
>> duration=duration
>> billsec=billsec
>> disposition=disposition
>> amaflags=amaflags
>> accountcode=accountcode
>> userfield=userfield
>> uniqueid=uniqueid
>> CodeTier=CodeTier
>>
>>
>>
>>     you know what file I forgot to configure?
>>  Olivier
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> 2013/6/3 Ron Wheeler <rwheeler at artifact-software.com>
>>
>>>  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>
>>>
>>>>    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
>>>
>>
>>
>>
>> --
>> _____________________________________________________________________
>> -- 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
>>
>>
>>
>> --
>> _____________________________________________________________________
>> -- 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
>>
>
>
> --
> _____________________________________________________________________
> -- 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/88b4df3b/attachment.htm>


More information about the asterisk-users mailing list