[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
Bakko
asannucci at gmail.com
Mon Jun 3 12:56:04 CDT 2013
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 <http://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 <http://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
> <mailto: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
>> <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 byhttp://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 <mailto:rwheeler at artifact-software.com>
> skype: ronaldmwheeler
> phone:866-970-2435, ext 102 <tel:866-970-2435%2C%20ext%20102>
>
>
> --
> _____________________________________________________________________
> -- 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/a3cea5b8/attachment.htm>
More information about the asterisk-users
mailing list