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 <rwhee...@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.calv...@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@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: rwhee...@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