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

Olivier CALVANO o.calvano at gmail.com
Mon Jun 3 14:18:51 CDT 2013 

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

More information about the asterisk-users mailing list