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
