[asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
It looks like your database configuration is missing in Asterisk. It is making up information about the connection using defaault values as if it did not find any database configuration. Ron On 03/06/2013 10:49 AM, Olivier CALVANO wrote: 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@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 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
The database schema (table) is different in Asterisk 11.4 ? because i have configured: cdr_mysql.conf extconfig.conf res_config_mysql.conf and on the mysql server, it's the old database of 1.6.x i see: [Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx (err 2003). Check debug for more info. can i put debug ? i don't know where thanks olivier 2013/6/3 Ron Wheeler rwhee...@artifact-software.com It looks like your database configuration is missing in Asterisk. It is making up information about the connection using defaault values as if it did not find any database configuration. Ron On 03/06/2013 10:49 AM, Olivier CALVANO wrote: 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:
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
Strange too, in the logs: [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). [Jun 3 17:09:49] NOTICE[3464] config.c: Registered Config Engine mysql [Jun 3 17:09:49] ERROR[3464] res_config_mysql.c: MySQL RealTime: Failed to connect database server SSI on (err 2003). Check debug for more info. [Jun 3 17:09:49] WARNING[3464] res_config_mysql.c: Table Comptes_IAX not found in database. This table should exist if you're using realtime. Hi said No database host found but in the log i have Failed to connect database server SSI on with SSI and correct into my config file 2013/6/3 Olivier CALVANO o.calv...@gmail.com The database schema (table) is different in Asterisk 11.4 ? because i have configured: cdr_mysql.conf extconfig.conf res_config_mysql.conf and on the mysql server, it's the old database of 1.6.x i see: [Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx (err 2003). Check debug for more info. can i put debug ? i don't know where thanks olivier 2013/6/3 Ron Wheeler rwhee...@artifact-software.com It looks like your database configuration is missing in Asterisk. It is making up information about the connection using defaault values as if it did not find any database configuration. Ron On 03/06/2013 10:49 AM, Olivier CALVANO wrote: 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 |
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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 mailto: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 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@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 | +--+-+--++--+--+---+---+-+++-+--++--+--+-+--+---++--+---++-+-+ ..
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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;
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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 rwhee...@artifact-software.com mailto: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 mailto: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 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@voip-2 log]# !mys mysql -h myhost.myserver.com http://myhost.myserver.com -u Asterisk -p SSI Enter password: Reading table
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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 asannu...@gmail.com 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 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
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 o.calv...@gmail.com 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 asannu...@gmail.com 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 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
Do you have this problem in your conf file? http://forums.digium.com/viewtopic.php?p=63736 The parser won't accept an ; (semicolon) for remarks! So he found at the first the old remarks and tried to access my database with the false data. Ron On 03/06/2013 3:18 PM, Olivier CALVANO 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 asannu...@gmail.com mailto:asannu...@gmail.com 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 -- 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
oh ron thanks for your help : We have deleted all commented line, only put the configuration and now that's work ! 2013/6/3 Ron Wheeler rwhee...@artifact-software.com Do you have this problem in your conf file? http://forums.digium.com/viewtopic.php?p=63736 The parser won't accept an ; (semicolon) for remarks! So he found at the first the old remarks and tried to access my database with the false data. Ron On 03/06/2013 3:18 PM, Olivier CALVANO 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 asannu...@gmail.com 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 -- 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
grrr no in asterisk -d i have no error, but when i start normaly asterisk i have : [Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx.xxx.net (err 2003). Check debug for more info. [Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx.xxx.net (err 2003). Check debug for more info. what is the command in asterisk for i see the SQL query ? 2013/6/4 Olivier CALVANO o.calv...@gmail.com oh ron thanks for your help : We have deleted all commented line, only put the configuration and now that's work ! 2013/6/3 Ron Wheeler rwhee...@artifact-software.com Do you have this problem in your conf file? http://forums.digium.com/viewtopic.php?p=63736 The parser won't accept an ; (semicolon) for remarks! So he found at the first the old remarks and tried to access my database with the false data. Ron On 03/06/2013 3:18 PM, Olivier CALVANO 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 asannu...@gmail.com 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 -- 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
Well, at least you are making progress. What is the error in the debug log? Ron On 03/06/2013 8:03 PM, Olivier CALVANO wrote: grrr no in asterisk -d i have no error, but when i start normaly asterisk i have : [Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx.xxx.net http://xxx.xxx.net (err 2003). Check debug for more info. [Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx.xxx.net http://xxx.xxx.net (err 2003). Check debug for more info. what is the command in asterisk for i see the SQL query ? 2013/6/4 Olivier CALVANO o.calv...@gmail.com mailto:o.calv...@gmail.com oh ron thanks for your help : We have deleted all commented line, only put the configuration and now that's work ! 2013/6/3 Ron Wheeler rwhee...@artifact-software.com mailto:rwhee...@artifact-software.com Do you have this problem in your conf file? http://forums.digium.com/viewtopic.php?p=63736 The parser won't accept an ; (semicolon) for remarks! So he found at the first the old remarks and tried to access my database with the false data. Ron On 03/06/2013 3:18 PM, Olivier CALVANO 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 asannu...@gmail.com mailto:asannu...@gmail.com 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 -- Ron Wheeler President Artifact Software Inc email:rwhee...@artifact-software.com mailto:rwhee...@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 -- 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
Re: [asterisk-users] Difference MySQL between 1.6.x and 11.4.x
What is the best commande for put the debug ? because with core set debug, i don't have a return. voip-2*CLI realtime mysql status Vop configured for m...@myhost.mydomain.net, port 3306 with username Asterisk. [Jun 4 06:48:25] ERROR[27879]: res_config_mysql.c:1577 mysql_reconnect: MySQL RealTime: Failed to connect database server Vop on vop.phibee-telecom.net (err 2003). Check debug for more info. He read correctly the config because it's the good DB, Server and username in /var/log/asterisk/message i have: [Jun 4 06:46:21] Asterisk 11.4.0 built by mockbuild @ buildvm-12.phx2.fedoraproject.org on a x86_64 running Linux on 2013-05-20 15:47:05 UTC [Jun 4 06:46:21] NOTICE[27825] loader.c: 1 modules will be loaded. [Jun 4 06:46:21] NOTICE[27825] config.c: Registered Config Engine mysql [Jun 4 06:46:21] NOTICE[27825] cdr.c: CDR simple logging enabled. [Jun 4 06:46:21] NOTICE[27825] loader.c: 192 modules will be loaded. [Jun 4 06:46:21] NOTICE[27825] res_smdi.c: No SMDI interfaces are available to listen on, not starting SMDI listener. [Jun 4 06:46:21] WARNING[27825] res_musiconhold.c: No music on hold classes configured, disabling music on hold. [Jun 4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on MyHost.MyDomain.nethttp://myhost.mydomain.net/(err 2003). Check debug for more info. [Jun 4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_IAX not found in database. This table should exist if you're using realtime. [Jun 4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on MyHost.MyDomain.nethttp://myhost.mydomain.net/(err 2003). Check debug for more info. [Jun 4 06:46:21] ERROR[27825] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on MyHost.MyDomain.nethttp://myhost.mydomain.net/(err 2003). Check debug for more info. [Jun 4 06:46:21] WARNING[27825] res_config_mysql.c: Table Comptes_SIP not found in database. This table should exist if you're using realtime. [Jun 4 06:46:21] NOTICE[27825] confbridge/conf_config_parser.c: Adding default_user profile to app_confbridge [Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: Starting AEL load process. [Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: parsed config file name '/etc/asterisk/extensions.ael'. [Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: checked config file name '/etc/asterisk/extensions.ael'. [Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: compiled config file name '/etc/asterisk/extensions.ael'. [Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: merged config file name '/etc/asterisk/extensions.ael'. [Jun 4 06:46:21] NOTICE[27825] pbx_ael.c: AEL load process: verified config file name '/etc/asterisk/extensions.ael'. [Jun 4 06:46:22] ERROR[27825] cdr_mysql.c: Failed to connect to mysql database MyDB on MyHost.MyDomain.net http://myhost.mydomain.net/. [Jun 4 06:47:51] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on MyHost.MyDomain.nethttp://myhost.mydomain.net/(err 2003). Check debug for more info. [Jun 4 06:48:25] ERROR[27879] res_config_mysql.c: MySQL RealTime: Failed to connect database server MyDB on MyHost.MyDomain.nethttp://myhost.mydomain.net/(err 2003). Check debug for more info. Asterisk have the good information, but i don't understand why he can't connect to the DB, if i use: mysql -h MyHost.MyDomain.net http://myhost.mydomain.net/ -u Aserisk -p MyDB i have a full access to my MySQL server. may be missing in a Fedora package ? 2013/6/4 Ron Wheeler rwhee...@artifact-software.com Well, at least you are making progress. What is the error in the debug log? Ron On 03/06/2013 8:03 PM, Olivier CALVANO wrote: grrr no in asterisk -d i have no error, but when i start normaly asterisk i have : [Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx.xxx.net (err 2003). Check debug for more info. [Jun 4 02:01:45] ERROR[6563] res_config_mysql.c: MySQL RealTime: Failed to connect database server xxx on xxx.xxx.net (err 2003). Check debug for more info. what is the command in asterisk for i see the SQL query ? 2013/6/4 Olivier CALVANO o.calv...@gmail.com oh ron thanks for your help : We have deleted all commented line, only put the configuration and now that's work ! 2013/6/3 Ron Wheeler rwhee...@artifact-software.com Do you have this problem in your conf file? http://forums.digium.com/viewtopic.php?p=63736 The parser won't accept an ; (semicolon) for remarks! So he found at the first the old remarks and tried to access my database with the false data. Ron On 03/06/2013 3:18 PM, Olivier CALVANO 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 asannu...@gmail.com Hello, are you sure
