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 Application>>System>>Service 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 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 Application>>System>>Service 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.indiati
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 Application>>System>>Service 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.dig