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 <[email protected]> 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 <[email protected]> > >> 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 <[email protected]> >> >>> 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 <[email protected]> >>> >>>> 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: [email protected] >>> 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 >
-- _____________________________________________________________________ -- 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
