[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
Olivier CALVANO
o.calvano at gmail.com
Mon Jun 3 12:16:20 CDT 2013
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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20130603/28ec9431/attachment.htm>
More information about the asterisk-users
mailing list