RE: [Asterisk-Users] cdr mysql problem
Hi All, Thank you all. As you all mentioned it wasnt so serious and was just a simple authentication problem. Its been solved. Regards. From: Diyanat Ali [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users@lists.digium.com To: asterisk-users@lists.digium.com Subject: RE: [Asterisk-Users] cdr mysql problem Date: Fri, 16 Dec 2005 07:14:05 -0600 MIME-Version: 1.0 X-Originating-IP: [202.65.140.108] X-Originating-Email: [EMAIL PROTECTED] X-Sender: [EMAIL PROTECTED] Received: from lists.digium.com ([69.16.138.164]) by bay0-mc12-f6.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 16 Dec 2005 05:20:09 -0800 Received: from digium-69-16-138-164.phx1.puregig.net (localhost [127.0.0.1])by lists.digium.com (Postfix) with ESMTP id 3F3FE4419;Fri, 16 Dec 2005 06:14:02 -0700 (MST) Received: from psmtp.com (exprod5mx26.postini.com [64.18.0.181])by lists.digium.com (Postfix) with SMTP id CA1AA4415for asterisk-users@lists.digium.com;Fri, 16 Dec 2005 06:13:57 -0700 (MST) Received: from source ([65.54.162.38]) by exprod5mx26.postini.com([64.18.4.10]) with SMTP; Fri, 16 Dec 2005 08:14:06 EST Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;Fri, 16 Dec 2005 05:14:06 -0800 Received: from 65.54.162.200 by by108fd.bay108.hotmail.msn.com with HTTP;Fri, 16 Dec 2005 13:14:05 GMT X-Message-Info: LGjzam7y+LuXeCVcGsTIL6sfvJRsVs3A23oEsKN3m/A= X-Original-To: asterisk-users@lists.digium.com Delivered-To: asterisk-users@lists.digium.com X-OriginalArrivalTime: 16 Dec 2005 13:14:06.0023 (UTC)FILETIME=[978B6570:01C60242] X-pstn-levels: (S:99.9/99.9 ) X-pstn-settings: 1 (0.1500:0.1500) gt3 gt2 gt1 X-pstn-addresses: from [EMAIL PROTECTED] [90/4] X-BeenThere: asterisk-users@lists.digium.com X-Mailman-Version: 2.1.5 Precedence: list List-Id: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users.lists.digium.com List-Unsubscribe: http://lists.digium.com/mailman/listinfo/asterisk-users,mailto:[EMAIL PROTECTED] List-Archive: http://lists.digium.com/pipermail/asterisk-users List-Post: mailto:asterisk-users@lists.digium.com List-Help: mailto:[EMAIL PROTECTED] List-Subscribe: http://lists.digium.com/mailman/listinfo/asterisk-users,mailto:[EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Return-Path: [EMAIL PROTECTED] i am using asterisk 1.2.1 with mysql 5 without any issues, please check your configuration again, make sure you have hostname=localhost too and the dbname, user, password are correct [global] hostname=localhost dbname=databasename user=user password=password port=3306 sock=/var/lib/mysql/mysql.sock Diyanat From: Mohammad Shokuie [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users@lists.digium.com To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] cdr mysql problem Return-Path: [EMAIL PROTECTED] Dear folks, I've just compiled asterisk-addon1.2.1 after installing MySQL and MySQl-devel packages. and adjust my cdr_mysql.conf to use the defined database using username and password. But as soon as starting asterisk i get error messages informing me of error, error message is as follows : cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost and res_config_mysql.c : Failed to connect database server on . Im realy lost and dont know whats wrong. I've checked the connection to MySql in command line using the same user and host and its been connected without any problem. Anyone has any idea whats wrong here. Regards. --- M. Shokuie Nia. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr mysql problem
Mohammad Shokuie wrote: error messages informing me of error, error message is as follows : cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost and res_config_mysql.c : Failed to connect database server on . Im realy lost and dont know whats wrong. I've checked the connection to MySql in command line using the same user and host and its been connected without any problem. I had this problem after upgrading mysql. I had to move back to version *4.0.20. If you do a nmap on the mysql system, you'll probably not see it listening on port 3306. Doug * ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr mysql problem
I've just compiled asterisk-addon1.2.1 after installing MySQL and MySQl-devel packages. and adjust my cdr_mysql.conf to use the defined database using username and password. But as soon as starting asterisk i get error messages informing me of error, error message is as follows : cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost and res_config_mysql.c : Failed to connect database server on . Im realy lost and dont know whats wrong. I've checked the connection to MySql in command line using the same user and host and its been connected without any problem. Anyone has any idea whats wrong here. Regards. --- At least the second is just the usual error message when you don't use MySQL for realtime configuartion. Shouldn't affect your cdr_mysql. Is the name of the _database_ really cdr? By default it is asteriskcdrdb. Chris ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr mysql problem
i am using asterisk 1.2.1 with mysql 5 without any issues, please check your configuration again, make sure you have hostname=localhost too and the dbname, user, password are correct [global] hostname=localhost dbname=databasename user=user password=password port=3306 sock=/var/lib/mysql/mysql.sock Diyanat From: Mohammad Shokuie [EMAIL PROTECTED] Reply-To: Asterisk Users Mailing List - Non-Commercial Discussionasterisk-users@lists.digium.com To: asterisk-users@lists.digium.com Subject: [Asterisk-Users] cdr mysql problem Return-Path: [EMAIL PROTECTED] Dear folks, I've just compiled asterisk-addon1.2.1 after installing MySQL and MySQl-devel packages. and adjust my cdr_mysql.conf to use the defined database using username and password. But as soon as starting asterisk i get error messages informing me of error, error message is as follows : cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost and res_config_mysql.c : Failed to connect database server on . Im realy lost and dont know whats wrong. I've checked the connection to MySql in command line using the same user and host and its been connected without any problem. Anyone has any idea whats wrong here. Regards. --- M. Shokuie Nia. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr mysql problem
error messages informing me of error, error message is as follows : cdr_addon_mysql.c : Failed to connect mysql database cdr on localhost and res_config_mysql.c : Failed to connect database server on . Im realy lost and dont know whats wrong. I've checked the connection to MySql in command line using the same user and host and its been connected without any problem. I had this problem after upgrading mysql. I had to move back to version *4.0.20. If you do a nmap on the mysql system, you'll probably not see it listening on port 3306. Or, simply do 'netstat -an | more'. Should see something like: tcp0 0 0.0.0.0:3306 If that is not seen, then mysql is not listening on a tcp port. ___ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] CDR MySQL Problem
Come on man...I know you are smarter than this; you're using asterisk. Take a minute to actually READ the error. MySQL database sock file not specified How much more simple can you get? If you are using localhost, you need to define a socket file in the cdr_mysql.conf file. -Matthew - Original Message - From: Geraldo Fco. do Espírito Santo Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 12, 2004 9:21 AM Subject: [Asterisk-Users] CDR MySQL Problem Hi everyone, I am try to install a CDR using MySQL but I receive the follow message: [app_db.so] = (Database access functions for Asterisk extension logic) == Registered application 'DBget' == Registered application 'DBput' == Registered application 'DBdel' == Registered application 'DBdeltree' [cdr_addon_mysql.so] = (MySQL CDR Backend) == Parsing '/etc/asterisk/cdr_mysql.conf': Found Nov 12 13:13:41 WARNING[2438]: cdr_addon_mysql.c:330 my_load_module: MySQL database sock file not specified. Using default Nov 12 13:13:41 ERROR[2438]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. I am using a SuSE 8.0 (kernel 2.4.19), * 1.0.2 (Asterisk CVS-HEAD-11/07/04-23:06:58) and MySQL 4.1.7-standard. Here are the configuration file == Cdr_mysql.conf [global] hostname=localhost dbname=asteriskcdrdb password=test user=asteriskuser Thanks Geraldo ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] CDR MySQL Problem
I think the error is not the sock file error (this is just a harmless warning I believe), but rather the second failure to connect message. Make sure that you can log on yourself to MySql using the mysql command line with the same username and password that you specified in your conf file. Regards Scott Stingel Scott M. Stingel President, Emerging Voice Technology, Inc. Palo Alto California London England www.evtmedia.com - Original Message - From: Geraldo Fco. do Espírito Santo Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 12, 2004 9:21 AM Subject: [Asterisk-Users] CDR MySQL Problem Hi everyone, I am try to install a CDR using MySQL but I receive the follow message: [app_db.so] = (Database access functions for Asterisk extension logic) == Registered application 'DBget' == Registered application 'DBput' == Registered application 'DBdel' == Registered application 'DBdeltree' [cdr_addon_mysql.so] = (MySQL CDR Backend) == Parsing '/etc/asterisk/cdr_mysql.conf': Found Nov 12 13:13:41 WARNING[2438]: cdr_addon_mysql.c:330 my_load_module: MySQL database sock file not specified. Using default Nov 12 13:13:41 ERROR[2438]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. I am using a SuSE 8.0 (kernel 2.4.19), * 1.0.2 (Asterisk CVS-HEAD-11/07/04-23:06:58) and MySQL 4.1.7-standard. Here are the configuration file == Cdr_mysql.conf [global] hostname=localhost dbname=asteriskcdrdb password=test user=asteriskuser Thanks Geraldo ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr mysql problem
Hi, here it is... [EMAIL PROTECTED] asterisk]# cat cdr_mysql.conf ; ; Note - if the database server is hosted on the same machine as the ; asterisk server, you can achieve a local Unix socket connection by ; setting hostname=localhost ; ; port and sock are both optional parameters. If hostname is specified ; and is not localhost, then cdr_mysql will attempt to connect to the ; port specified or use the default port. If hostname is not specified ; or if hostname is localhost, then cdr_mysql will attempt to connect ; to the socket file specified by sock or otherwise use the default socket ; file. ; [global] hostname=localhost dbname=asteriskcdrdb password=** user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock sock=/var/lib/mysql/mysql.sock srwxrwxrwx1 mysqlmysql 0 Feb 2 19:37 /var/lib/mysql/mysql.sock Tomica -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Tuesday, February 03, 2004 12:32 AM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr mysql problem On Monday 02 February 2004 15:27, Tomica Crnek wrote: Yes, I have checked the logs. There is nothing there. I think asterisk doesn't try to connect. Please paste the contents of /etc/asterisk/cdr_mysql.conf. Also, paste the output of: ls -l /tmp/mysql.sock /var/lib/mysql/mysql.sock ; locate mysql.sock -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr mysql problem
On Tuesday 03 February 2004 01:44, Tomica Crnek wrote: [global] hostname=localhost dbname=asteriskcdrdb password=** user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock sock=/var/lib/mysql/mysql.sock Okay, and so does this work? bash$ echo select max(calldate) from cdr; | \ mysql -uasteriskcdruser -S/var/lib/mysql/mysql.sock \ -p asteriskcdrdb Enter password: max(calldate) 2004-02-02 19:19:22 bash$ -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: RE: [Asterisk-Users] cdr mysql problem
Thanks, I don't know what is different from all steps I have followed several times. I did all this before, believe me. Now, I said to myself that I'll do it once again, and it worked. Thanks once again! Tomica -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of dipak0105 Sent: Tuesday, February 03, 2004 1:47 PM To: [EMAIL PROTECTED] Subject: Re: RE: [Asterisk-Users] cdr mysql problem Hi You have to follow this steps and obviously you got success because we have followed this steps and got success. Configure the cdr_mysql.conf file in the location /etc/asterisk. The configuration is as follows: [global] hostname=localhost ;This is the host name of MySql dbname=asteriskcdrdb;This is the database name of MySql password=password ;This is the password of user user=asteriskcdruser;This is the user in MySql port=3306 ;This is the port number running the MySql sock=/var/lib/mysql/mysql.sock ;This is the socket of MySql and the location Then follow the steps in the MySql server 1. Go to Start ApplicationSystemService Configuration. Check the mysqld box. Click the save button Then click the start button. 2. Open a kolsole. 3. Type: mysql -u root to enter into mysql. 4. Type: SET PASSWORD FOR root = PASSWORD(password); for setting the root password. 5. Type: GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY password WITH GRANT OPTION; 6. Type: \q; to Quit mysql. 7. Type: In konsole mysql -u asteriskcdruser -p and use the password password, to reenter mysql as asteriskcdruser user. 8. Type: CREATE DATABASE asteriskcdrdb; 9. Type: CREATE TABLE cdr ( calldate datetime NOT NULL default '-00-00 00:00:00', clid varchar(45) NOT NULL default '', src varchar(45) NOT NULL default '', dst varchar(45) NOT NULL default '', dcontext varchar(45) NOT NULL default '', channel varchar(45) NOT NULL default '', dstchannel varchar(45) NOT NULL default '', lastapp varchar(45) NOT NULL default '', lastdata varchar(45) NOT NULL default '', duration int(11) NOT NULL default '0', billsec int(11) NOT NULL default '0', disposition varchar(45) NOT NULL default '', amaflags int(11) NOT NULL default '0', accountcode varchar(45) NOT NULL default '', uniqueid varchar(45) NOT NULL default '' ); for create a table cdr. 10. To reload the configuration, type reload from the Asterisk command prompt. These are the steps of Configuration of MySql with Asterisk server. Contact me if you need any further clarifications. Dipak Kumar Paul. Sigmabit Technology India. [EMAIL PROTECTED] wrote: Hi, here it is... [EMAIL PROTECTED] asterisk]# cat cdr_mysql.conf ; ; Note - if the database server is hosted on the same machine as the ; asterisk server, you can achieve a local Unix socket connection by ; setting hostname=localhost ; ; port and sock are both optional parameters. If hostname is specified ; and is not localhost, then cdr_mysql will attempt to connect to the ; port specified or use the default port. If hostname is not specified ; or if hostname is localhost, then cdr_mysql will attempt to connect ; to the socket file specified by sock or otherwise use the default socket ; file. ; [global] hostname=localhost dbname=asteriskcdrdb password=** user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock sock=/var/lib/mysql/mysql.sock srwxrwxrwx1 mysqlmysql 0 Feb 2 19:37 /var/lib/mysql/mysql.sock Tomica -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Tuesday, February 03, 2004 12:32 AM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr mysql problem On Monday 02 February 2004 15:27, Tomica Crnek wrote: Yes, I have checked the logs. There is nothing there. I think asterisk doesn't try to connect. Please paste the contents of /etc/asterisk/cdr_mysql.conf. Also, paste the output of: ls -l /tmp/mysql.sock /var/lib/mysql/mysql.sock ; locate mysql.sock -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy The Best In BOOKS at http://www.bestsellers.indiatimes.com Bid for for Air Tickets @ Re.1 on Air Sahara Flights. Just log on to http://airsahara.indiatimes.com and Bid Now! ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update
RE: RE: [Asterisk-Users] cdr mysql problem
I just followed those steps and its working wonderfully. I did have to download and compile asterisk-addons from CVS, as well as the steps illustrated above. Now I'm going to make some PHP Web Reports so the users can view the CDR. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tomica Crnek Sent: Tuesday, February 03, 2004 2:54 PM To: [EMAIL PROTECTED] Subject: RE: RE: [Asterisk-Users] cdr mysql problem Thanks, I don't know what is different from all steps I have followed several times. I did all this before, believe me. Now, I said to myself that I'll do it once again, and it worked. Thanks once again! Tomica -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of dipak0105 Sent: Tuesday, February 03, 2004 1:47 PM To: [EMAIL PROTECTED] Subject: Re: RE: [Asterisk-Users] cdr mysql problem Hi You have to follow this steps and obviously you got success because we have followed this steps and got success. Configure the cdr_mysql.conf file in the location /etc/asterisk. The configuration is as follows: [global] hostname=localhost ;This is the host name of MySql dbname=asteriskcdrdb;This is the database name of MySql password=password ;This is the password of user user=asteriskcdruser;This is the user in MySql port=3306 ;This is the port number running the MySql sock=/var/lib/mysql/mysql.sock ;This is the socket of MySql and the location Then follow the steps in the MySql server 1. Go to Start ApplicationSystemService Configuration. Check the mysqld box. Click the save button Then click the start button. 2. Open a kolsole. 3. Type: mysql -u root to enter into mysql. 4. Type: SET PASSWORD FOR root = PASSWORD(password); for setting the root password. 5. Type: GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY password WITH GRANT OPTION; 6. Type: \q; to Quit mysql. 7. Type: In konsole mysql -u asteriskcdruser -p and use the password password, to reenter mysql as asteriskcdruser user. 8. Type: CREATE DATABASE asteriskcdrdb; 9. Type: CREATE TABLE cdr ( calldate datetime NOT NULL default '-00-00 00:00:00', clid varchar(45) NOT NULL default '', src varchar(45) NOT NULL default '', dst varchar(45) NOT NULL default '', dcontext varchar(45) NOT NULL default '', channel varchar(45) NOT NULL default '', dstchannel varchar(45) NOT NULL default '', lastapp varchar(45) NOT NULL default '', lastdata varchar(45) NOT NULL default '', duration int(11) NOT NULL default '0', billsec int(11) NOT NULL default '0', disposition varchar(45) NOT NULL default '', amaflags int(11) NOT NULL default '0', accountcode varchar(45) NOT NULL default '', uniqueid varchar(45) NOT NULL default '' ); for create a table cdr. 10. To reload the configuration, type reload from the Asterisk command prompt. These are the steps of Configuration of MySql with Asterisk server. Contact me if you need any further clarifications. Dipak Kumar Paul. Sigmabit Technology India. [EMAIL PROTECTED] wrote: Hi, here it is... [EMAIL PROTECTED] asterisk]# cat cdr_mysql.conf ; ; Note - if the database server is hosted on the same machine as the ; asterisk server, you can achieve a local Unix socket connection by ; setting hostname=localhost ; ; port and sock are both optional parameters. If hostname is specified ; and is not localhost, then cdr_mysql will attempt to connect to the ; port specified or use the default port. If hostname is not specified ; or if hostname is localhost, then cdr_mysql will attempt to connect ; to the socket file specified by sock or otherwise use the default socket ; file. ; [global] hostname=localhost dbname=asteriskcdrdb password=** user=asteriskcdruser ;port=3306 ;sock=/tmp/mysql.sock sock=/var/lib/mysql/mysql.sock srwxrwxrwx1 mysqlmysql 0 Feb 2 19:37 /var/lib/mysql/mysql.sock Tomica -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Tuesday, February 03, 2004 12:32 AM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr mysql problem On Monday 02 February 2004 15:27, Tomica Crnek wrote: Yes, I have checked the logs. There is nothing there. I think asterisk doesn't try to connect. Please paste the contents of /etc/asterisk/cdr_mysql.conf. Also, paste the output of: ls -l /tmp/mysql.sock /var/lib/mysql/mysql.sock ; locate mysql.sock -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman
Re: [Asterisk-Users] cdr mysql problem
On Mon, 2004-02-02 at 12:49, Tomica Crnek wrote: Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Have you checked your mysql logs to see if it was contacted, and maybe turned away? -- Steven Critchfield [EMAIL PROTECTED] ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
RE: [Asterisk-Users] cdr mysql problem
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven Critchfield Sent: Monday, February 02, 2004 8:02 PM To: [EMAIL PROTECTED] Subject: Re: [Asterisk-Users] cdr mysql problem On Mon, 2004-02-02 at 12:49, Tomica Crnek wrote: Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Have you checked your mysql logs to see if it was contacted, and maybe turned away? -- Steven Critchfield [EMAIL PROTECTED] Yes, I have checked the logs. There is nothing there. I think asterisk doesn't try to connect. Tomica ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [Asterisk-Users] cdr mysql problem
On Monday 02 February 2004 15:27, Tomica Crnek wrote: Yes, I have checked the logs. There is nothing there. I think asterisk doesn't try to connect. Please paste the contents of /etc/asterisk/cdr_mysql.conf. Also, paste the output of: ls -l /tmp/mysql.sock /var/lib/mysql/mysql.sock ; locate mysql.sock -Tilghman ___ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users