Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Antony Stone]

On Wednesday 10 June 2020 at 16:33:53, Doug Lytle wrote:

> >>> Instead, the call still terminates if mysql cannot be reached.
> 
> I just tested this, I'm using cdr_odbc, by shutting down mysql and I did
> not experience the call being dropped.

That sounds different to me.

The OP is asking about a call which starts at a time when MySQL is not 
available.

It sounds as though you made a call, then terminated MySQL, and the call did 
not terminate.

> The console logged the mysql failure, but the call continued.
> 
> You may want to consider moving to cdr_odbc instead.

I certainly agree with that suggestion / recommendation.


Antony.

-- 
"Black holes are where God divided by zero."

 - Steven Wright

   Please reply to the list;
 please *don't* CC me.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Doug Lytle]

>>> Instead, the call still terminates if mysql cannot be reached.

I just tested this, I'm using cdr_odbc, by shutting down mysql and I did not 
experience the call being dropped.

The console logged the mysql failure, but the call continued.

You may want to consider moving to cdr_odbc instead.

Doug

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Fourhundred Thecat]

> On 2020-06-08 16:37, Sean Bright wrote:
>
> In the case of cdr_mysql, the connect timeout is configurable by putting
> the following in cdr_mysql.conf:
>
> [global]
> timeout = 5 ; Set connect timeout to 5 seconds

OK, so i changed the timeout to 2 sec, but it does not have the desired
effect. I expected, if mysql cannot be reached, after 2 seconds the call
will progress normally.

Instead, the call still terminates if mysql cannot be reached.

Is it possible to set in asterisk, if mysql is unreachable then skip the
step and simply ignore mysql logging ?


-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Sean Bright]

On 6/7/2020 2:54 AM, Fourhundred Thecat wrote:

I would still like to know where the Aterisk mysql timeout duration
comes from, and whether it can be configured.


In the case of cdr_mysql, the connect timeout is configurable by putting 
the following in cdr_mysql.conf:


[global]
timeout = 5 ; Set connect timeout to 5 seconds

For app_mysql, setting the connection timeout is shown in the documentation:

*CLI> core show application MYSQL

Kind regards,
Sean


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Jeff LaCoursiere]

Isn't the MySQL stuff deprecated in favor of odbc?  You may be barking up
the wrong tree if you plan to make source changes.

j

On Sun, Jun 7, 2020, 1:55 AM Fourhundred Thecat <400the...@gmx.ch> wrote:

>  > On 2020-06-06 10:38, Antony Stone wrote:
> > On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:
> >
> >> In a situation when I start asterisk, and the remote database is
> >> unreachable, asterisk waits for several minutes before it actually
> >> starts (before it loads sip module, etc).
> >>
> >> And when database is unreachable during operation, when call happens,
> >> sometimes the call is connected, other times it waits for mysql and call
> >> times out.
> >
> >> or what would be the best solution in my case ?
> >
> > I would install a local copy of MySQL (to the same machine as Asterisk)
> so
> > that it is definitely available, tell Asterisk to write to that, and
> then set
> > up replication to the remote MySQL instance which is sometimes
> unavailable.
>
> That is an interesting suggestion, which I'll consider.
>
> But I would still like to know where the Aterisk mysql timeout duration
> comes from, and whether it can be configured.
>
> thanks,
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at:
> https://community.asterisk.org/
>
> New to Asterisk? Start here:
>   https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> 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 --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Fourhundred Thecat]

> On 2020-06-06 10:38, Antony Stone wrote:

On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:


In a situation when I start asterisk, and the remote database is
unreachable, asterisk waits for several minutes before it actually
starts (before it loads sip module, etc).

And when database is unreachable during operation, when call happens,
sometimes the call is connected, other times it waits for mysql and call
times out.



or what would be the best solution in my case ?


I would install a local copy of MySQL (to the same machine as Asterisk) so
that it is definitely available, tell Asterisk to write to that, and then set
up replication to the remote MySQL instance which is sometimes unavailable.


That is an interesting suggestion, which I'll consider.

But I would still like to know where the Aterisk mysql timeout duration
comes from, and whether it can be configured.

thanks,

--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
 https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql: timeout when remote database unavailable

[Antony Stone]

On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote:

> In a situation when I start asterisk, and the remote database is
> unreachable, asterisk waits for several minutes before it actually
> starts (before it loads sip module, etc).
> 
> And when database is unreachable during operation, when call happens,
> sometimes the call is connected, other times it waits for mysql and call
> times out.

> or what would be the best solution in my case ?

I would install a local copy of MySQL (to the same machine as Asterisk) so 
that it is definitely available, tell Asterisk to write to that, and then set 
up replication to the remote MySQL instance which is sometimes unavailable.

Replication will sort itself out automatically after almost any duration of 
non-connectivity.

If you are using MySQL, the traditional Master-Slave replication is easy to 
set up and works well.  If you're using MariaDB (which is installed in some 
distributions even when you ask for MySQL) then the new method of replication 
is Galera, although standard Master-Slave is still fully supported.


Regards,


Antony.

-- 
If my advice was worth anything, I wouldn't just give it away.

   Please reply to the list;
 please *don't* CC me.

-- 
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

Check out the new Asterisk community forum at: https://community.asterisk.org/

New to Asterisk? Start here:
  https://wiki.asterisk.org/wiki/display/AST/Getting+Started

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql with asterisk 1.4

[A J Stiles]

** THIS IS NOT THE RIGHT PLACE TO POST A REPLY **

On Tuesday 29 November 2011, salaheddine elharit wrote:
> i use centos 5.5 if i install mysql-devel i can still use the version of
> mysql installed now in my server because i use it with a database and Im
> afraid to install this mysql-devel and i lost the version of mysql reunning
> actually
> 
> please advice

Yes, it will work fine.  mysql-devel doesn't *replace* an existing mysql 
package; it merely adds some "development" files.

The -devel packages are a throwback to the bad old days, when Internet 
connectivity was by dial-up modem and hard disk space was scarce.

Basically, when you build a package from Source Code, there are some files that 
get left behind and aren't needed just for day-to-day use of the program, but 
are essential if you need to build something else that works with the package.

To trim down the size of downloadable packages, these "development" files were 
abstracted away into separate packages.

Nine out of ten Linux users have to compile a package from source at some 
stage and the tenth one is probably lying.  Most people wouldn't notice the 
extra space taken up by -devel packages, and the ones that would -- perhaps 
because they're building embedded systems, or have other disk space 
constraints -- are smart enough to know what to do.  Yet distributions 
continue to separate out these packages and in the process, make the whole 
process of compiling from source unnecessarily complicated.

Even an option in the installer to select "always install -devel package if it 
exists" would be a good beginning.  Distro maintainers -- are you listening? 
Please?

-- 
AJS

Answers come *after* questions.

--
_
-- 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] CDR mysql with asterisk 1.4

[salaheddine elharit]

ok thank you so much

2011/11/29 Ishfaq Malik 

> Don't be afraid, it will not cause any problems at all. The *-devel
> packages contain the libraries and header files that are needed for
> developing the application and some of these are used by the asterisk
> addons. It will in no way replace anything you currently have or use.
>
> Regards
>
> Ish
>
> On Tue, 2011-11-29 at 17:30 +, salaheddine elharit wrote:
> > i use centos 5.5 if i install mysql-devel i can still use the version
> > of mysql installed now in my server because i use it with a database
> > and Im afraid to install this mysql-devel and i lost the version of
> > mysql reunning actually
> >
> >
> > please advice
> >
> >
> > 2011/11/29 A J Stiles 
> > On Tuesday 29 November 2011, salaheddine elharit wrote:
> > > after
> > >
> > > ./configure –with-mysql=/usr 
> > >
> > > Make menuselect
> > >
> > > **  **same result but i found in module embedding the below
> > options i check
> > > the cdr and i get the same result
> > >
> > > [ ] 1. apps
> > > [*] 2. cdr
> > > [ ] 3. channels
> > > [ ] 4. codecs
> > > [ ] 5. formats
> > > [ ] 6. funcs
> > > [ ] 7. pbx
> > > [ ] 8. res
> >
> >
> > Unless you built your MySQL from Source Code, you need to have
> > the developers'
> > package for MySQL installed.  That would be mysql-devel (on
> > CentOS / Fedora)
> > or libmysqlclient-dev (on Ubuntu / Debian).  Then
> > run ./configure again.
> >
> > --
> > AJS
> >
> > Answers come *after* questions.
> >
> >
> > --
> >
> _
> > -- 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
>
> --
> Ishfaq Malik
> Software Developer
> PackNet Ltd
>
> Office:   0161 660 3062
>
>
>  --
> _
> -- 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] CDR mysql with asterisk 1.4

[Ishfaq Malik]

Don't be afraid, it will not cause any problems at all. The *-devel
packages contain the libraries and header files that are needed for
developing the application and some of these are used by the asterisk
addons. It will in no way replace anything you currently have or use.

Regards

Ish

On Tue, 2011-11-29 at 17:30 +, salaheddine elharit wrote:
> i use centos 5.5 if i install mysql-devel i can still use the version
> of mysql installed now in my server because i use it with a database
> and Im afraid to install this mysql-devel and i lost the version of
> mysql reunning actually
> 
>  
> please advice 
> 
> 
> 2011/11/29 A J Stiles 
> On Tuesday 29 November 2011, salaheddine elharit wrote:
> > after
> >
> > ./configure –with-mysql=/usr 
> >
> > Make menuselect
> >
> > **  **same result but i found in module embedding the below
> options i check
> > the cdr and i get the same result
> >
> > [ ] 1. apps
> > [*] 2. cdr
> > [ ] 3. channels
> > [ ] 4. codecs
> > [ ] 5. formats
> > [ ] 6. funcs
> > [ ] 7. pbx
> > [ ] 8. res
> 
> 
> Unless you built your MySQL from Source Code, you need to have
> the developers'
> package for MySQL installed.  That would be mysql-devel (on
> CentOS / Fedora)
> or libmysqlclient-dev (on Ubuntu / Debian).  Then
> run ./configure again.
> 
> --
> AJS
> 
> Answers come *after* questions.
> 
> 
> --
> _
> -- 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

-- 
Ishfaq Malik
Software Developer
PackNet Ltd

Office:   0161 660 3062


--
_
-- 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] CDR mysql with asterisk 1.4

[salaheddine elharit]

i use centos 5.5 if i install mysql-devel i can still use the version of
mysql installed now in my server because i use it with a database and Im
afraid to install this mysql-devel and i lost the version of mysql reunning
actually

please advice

2011/11/29 A J Stiles 

> On Tuesday 29 November 2011, salaheddine elharit wrote:
> > after
> >
> > ./configure –with-mysql=/usr 
> >
> > Make menuselect
> >
> > **  **same result but i found in module embedding the below options i
> check
> > the cdr and i get the same result
> >
> > [ ] 1. apps
> > [*] 2. cdr
> > [ ] 3. channels
> > [ ] 4. codecs
> > [ ] 5. formats
> > [ ] 6. funcs
> > [ ] 7. pbx
> > [ ] 8. res
>
> Unless you built your MySQL from Source Code, you need to have the
> developers'
> package for MySQL installed.  That would be mysql-devel (on CentOS /
> Fedora)
> or libmysqlclient-dev (on Ubuntu / Debian).  Then run ./configure again.
>
> --
> AJS
>
> Answers come *after* questions.
>
> --
> _
> -- 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] CDR mysql with asterisk 1.4

[Warren Selby]

In order to install MySQL support for asterisk 1.4, you'll need to download
the asterisk-addons-1.4 tarball, extract it to it's own folder.  Go to that
folder, run ./configure, make menuselect, and select the cdr_addon_mysql
and the res_config_mysql options.  Exit make menuselect, then run make,
make install, and make samples.  This should add the necessary modules to
asterisk, as well as the sample config files.

This of course assumes you've got mysql and it's development packages
installed.

-- 
Thanks,
--Warren Selby, dCAP
http://www.SelbyTech.com 
--
_
-- 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] CDR mysql with asterisk 1.4

[A J Stiles]

On Tuesday 29 November 2011, salaheddine elharit wrote:
> after
> 
> ./configure –with-mysql=/usr 
> 
> Make menuselect
> 
> **  **same result but i found in module embedding the below options i check
> the cdr and i get the same result
> 
> [ ] 1. apps
> [*] 2. cdr
> [ ] 3. channels
> [ ] 4. codecs
> [ ] 5. formats
> [ ] 6. funcs
> [ ] 7. pbx
> [ ] 8. res

Unless you built your MySQL from Source Code, you need to have the developers' 
package for MySQL installed.  That would be mysql-devel (on CentOS / Fedora) 
or libmysqlclient-dev (on Ubuntu / Debian).  Then run ./configure again.

-- 
AJS

Answers come *after* questions.

--
_
-- 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] CDR mysql with asterisk 1.4

[salaheddine elharit]

ok thank you so much for your help and support

2011/11/29 Danny Nicholas 

>  ./configure is not finding your mysql install and accounting for it
>
> I would try
>
> ./configure –with-mysql=/usr/bin
>
> Make menuselect
>
> ** **
>
> I’m not the resource you want for this one as I don’t use mysql or any
> databases with my asterisk (prefer to keep things as simple as possible).*
> ***
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 9:30 AM
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>   ** **
>
> yes is installad and is running 
>
>  
>
> mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql
> /usr/share/man/man1/mysql.1.gz
>
> 
>
> 2011/11/29 Danny Nicholas 
>
> Mysql is installed and running on your box?  What it the path to it?
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 9:20 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> after 
>
> ./configure –with-mysql=/usr 
>
> Make menuselect
>
>   same result but i found in module embedding the below options i check
> the cdr and i get the same result 
>
> [ ] 1. apps
> [*] 2. cdr
> [ ] 3. channels
> [ ] 4. codecs
> [ ] 5. formats
> [ ] 6. funcs
> [ ] 7. pbx
> [ ] 8. res
>
> 2011/11/29 Danny Nicholas 
>
> Try running 
>
> ./configure –with-mysql=/usr 
>
> Make menuselect
>
>  
>
>  
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 9:06 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
>
> what i have in “Call Detail Recording” is 
>
>  
>
> [*] 1. cdr_csv
> [*] 2. cdr_custom
> [*] 3. cdr_manager
> xxx 4. cdr_odbc
> xxx 5. cdr_pgsql
> xxx 6. cdr_radius
> xxx 7. cdr_sqlite
> xxx 8. cdr_tds
>
>  
>
>
>  
>
> 2011/11/29 Danny Nicholas 
>
> It “should” be a “Call Detail Recording” option, not an add-on.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 8:45 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i didn't find him in the menu i have installed the add-ons but i can not
> load the cd_mysql :<
>
>  
>
> please advice 
>
> 2011/11/29 Danny Nicholas 
>
> It should at least be on the menu although the selection may have XXX
> instead of [ ] or [*] if the dependencies aren’t proper when you run
> ./configure.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 5:37 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> Hello Danny 
>
>  
>
> i try to flow your email but when i do make menuselect i didn't find
> add-ons in order to check the cdr_mysql
>
>  
>
> i use asterisk 1.4
>
>  
>
> 1-how can i do to install this add-ons 
>
>  
>
> 2 i want to do this installation without touching the original
> configuration of asterisk
>
>  
>
> thanks and regards
>
>  
>
>
>
>  
>
> 2011/11/21 Danny Nicholas 
>
> From what I read you are running a pre-compiled asterisk – what you can do
> in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 

Re: [asterisk-users] CDR mysql with asterisk 1.4

[Danny Nicholas]

./configure is not finding your mysql install and accounting for it

I would try

./configure -with-mysql=/usr/bin

Make menuselect

 

I'm not the resource you want for this one as I don't use mysql or any
databases with my asterisk (prefer to keep things as simple as possible).

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:30 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

yes is installad and is running 

 

mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql
/usr/share/man/man1/mysql.1.gz



2011/11/29 Danny Nicholas 

Mysql is installed and running on your box?  What it the path to it?

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:20 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

after 

./configure -with-mysql=/usr 

Make menuselect

  same result but i found in module embedding the below options i check the
cdr and i get the same result 

[ ] 1. apps
[*] 2. cdr
[ ] 3. channels
[ ] 4. codecs
[ ] 5. formats
[ ] 6. funcs
[ ] 7. pbx
[ ] 8. res

2011/11/29 Danny Nicholas 

Try running 

./configure -with-mysql=/usr 

Make menuselect

 

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:06 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 


what i have in "Call Detail Recording" is 

 

[*] 1. cdr_csv
[*] 2. cdr_custom
[*] 3. cdr_manager
xxx 4. cdr_odbc
xxx 5. cdr_pgsql
xxx 6. cdr_radius
xxx 7. cdr_sqlite
xxx 8. cdr_tds

 


 

2011/11/29 Danny Nicholas 

It "should" be a "Call Detail Recording" option, not an add-on.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 8:45 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i didn't find him in the menu i have installed the add-ons but i can not
load the cd_mysql :<

 

please advice 

2011/11/29 Danny Nicholas 

It should at least be on the menu although the selection may have XXX
instead of [ ] or [*] if the dependencies aren't proper when you run
./configure.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 5:37 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

Hello Danny 

 

i try to flow your email but when i do make menuselect i didn't find add-ons
in order to check the cdr_mysql

 

i use asterisk 1.4

 

1-how can i do to install this add-ons 

 

2 i want to do this installation without touching the original configuration
of asterisk

 

thanks and regards

 



 

2011/11/21 Danny Nicholas 

>From what I read you are running a pre-compiled asterisk - what you can do
in that instance is this

1 create a directory like /usr/local/src/asterisk/1.4-update

2 wget the matching version as indicated by "core show version"

3 extract the tar to the directory from step 1

4 run ./configure

5 run make menuselect

6 run make - DO NOT RUN make install

7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
CLI

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect 

 

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk 

 

BTW i can restart asterisk without issue

 

thanks for your response

2011/11/21 Ryan Wagoner 

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn't check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to
use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make
menuselect
&g

Re: [asterisk-users] CDR mysql with asterisk 1.4

[salaheddine elharit]

yes is installad and is running

mysql: /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql
/usr/share/man/man1/mysql.1.gz


2011/11/29 Danny Nicholas 

>  Mysql is installed and running on your box?  What it the path to it?
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 9:20 AM
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>   ** **
>
> after 
>
> ./configure –with-mysql=/usr 
>
> Make menuselect
>
>   same result but i found in module embedding the below options i check
> the cdr and i get the same result 
>
> [ ] 1. apps
> [*] 2. cdr
> [ ] 3. channels
> [ ] 4. codecs
> [ ] 5. formats
> [ ] 6. funcs
> [ ] 7. pbx
> [ ] 8. res
>
> 2011/11/29 Danny Nicholas 
>
> Try running 
>
> ./configure –with-mysql=/usr 
>
> Make menuselect
>
>  
>
>  
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 9:06 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
>
> what i have in “Call Detail Recording” is 
>
>  
>
> [*] 1. cdr_csv
> [*] 2. cdr_custom
> [*] 3. cdr_manager
> xxx 4. cdr_odbc
> xxx 5. cdr_pgsql
> xxx 6. cdr_radius
> xxx 7. cdr_sqlite
> xxx 8. cdr_tds
>
>  
>
>
>  
>
> 2011/11/29 Danny Nicholas 
>
> It “should” be a “Call Detail Recording” option, not an add-on.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 8:45 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i didn't find him in the menu i have installed the add-ons but i can not
> load the cd_mysql :<
>
>  
>
> please advice 
>
> 2011/11/29 Danny Nicholas 
>
> It should at least be on the menu although the selection may have XXX
> instead of [ ] or [*] if the dependencies aren’t proper when you run
> ./configure.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 5:37 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> Hello Danny 
>
>  
>
> i try to flow your email but when i do make menuselect i didn't find
> add-ons in order to check the cdr_mysql
>
>  
>
> i use asterisk 1.4
>
>  
>
> 1-how can i do to install this add-ons 
>
>  
>
> 2 i want to do this installation without touching the original
> configuration of asterisk
>
>  
>
> thanks and regards
>
>  
>
>
>
>  
>
> 2011/11/21 Danny Nicholas 
>
> From what I read you are running a pre-compiled asterisk – what you can do
> in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 run make – DO NOT RUN make install
>
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
> CLI
>
>  
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Monday, November 21, 2011 8:52 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i try to run make menuselect without configure  but he give me an error
> and he tell me that i must run ./configure before launch make menuselect *
> ***
>
>  
>
> i'm afraid if i launch ./configure and after make menuselet to lost all
> configuration related to asterisk 
>
>  
>
> BTW i can restart asterisk without issue**

Re: [asterisk-users] CDR mysql with asterisk 1.4

[Danny Nicholas]

Mysql is installed and running on your box?  What it the path to it?

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:20 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

after 

./configure -with-mysql=/usr 

Make menuselect

  same result but i found in module embedding the below options i check the
cdr and i get the same result 

[ ] 1. apps
[*] 2. cdr
[ ] 3. channels
[ ] 4. codecs
[ ] 5. formats
[ ] 6. funcs
[ ] 7. pbx
[ ] 8. res

2011/11/29 Danny Nicholas 

Try running 

./configure -with-mysql=/usr 

Make menuselect

 

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:06 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 


what i have in "Call Detail Recording" is 

 

[*] 1. cdr_csv
[*] 2. cdr_custom
[*] 3. cdr_manager
xxx 4. cdr_odbc
xxx 5. cdr_pgsql
xxx 6. cdr_radius
xxx 7. cdr_sqlite
xxx 8. cdr_tds

 


 

2011/11/29 Danny Nicholas 

It "should" be a "Call Detail Recording" option, not an add-on.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 8:45 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i didn't find him in the menu i have installed the add-ons but i can not
load the cd_mysql :<

 

please advice 

2011/11/29 Danny Nicholas 

It should at least be on the menu although the selection may have XXX
instead of [ ] or [*] if the dependencies aren't proper when you run
./configure.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 5:37 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

Hello Danny 

 

i try to flow your email but when i do make menuselect i didn't find add-ons
in order to check the cdr_mysql

 

i use asterisk 1.4

 

1-how can i do to install this add-ons 

 

2 i want to do this installation without touching the original configuration
of asterisk

 

thanks and regards

 



 

2011/11/21 Danny Nicholas 

>From what I read you are running a pre-compiled asterisk - what you can do
in that instance is this

1 create a directory like /usr/local/src/asterisk/1.4-update

2 wget the matching version as indicated by "core show version"

3 extract the tar to the directory from step 1

4 run ./configure

5 run make menuselect

6 run make - DO NOT RUN make install

7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
CLI

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect 

 

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk 

 

BTW i can restart asterisk without issue

 

thanks for your response

2011/11/21 Ryan Wagoner 

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn't check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to
use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make
menuselect
> to install cdr because this server is very important for me and i can't
stop
> it
>

How did you initially install Asterisk? When compiling from source
./configure is the first step before you can run make. It shouldn't
prompt to run ./configure for make menuselect if you are just changing
some options from a previously compile and install.

If you were able to run make menuselect without configure you might be
able to load the module while Asterisk is running. You would copy the
cdr_mysql.so to the lib directory and run module load cdr_mysql.
However I would still plan this for after hours in case of an issue.

Ryan


--
_
-- Bandwidth and Colocation Pro

Re: [asterisk-users] CDR mysql with asterisk 1.4

[salaheddine elharit]

after

./configure –with-mysql=/usr 

Make menuselect

**  **same result but i found in module embedding the below options i check
the cdr and i get the same result

[ ] 1. apps
[*] 2. cdr
[ ] 3. channels
[ ] 4. codecs
[ ] 5. formats
[ ] 6. funcs
[ ] 7. pbx
[ ] 8. res
2011/11/29 Danny Nicholas 

>  Try running 
>
> ./configure –with-mysql=/usr 
>
> Make menuselect
>
> ** **
>
> ** **
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 9:06 AM
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>   ** **
>
>
> what i have in “Call Detail Recording” is 
>
>  
>
> [*] 1. cdr_csv
> [*] 2. cdr_custom
> [*] 3. cdr_manager
> xxx 4. cdr_odbc
> xxx 5. cdr_pgsql
> xxx 6. cdr_radius
> xxx 7. cdr_sqlite
> xxx 8. cdr_tds
>
>  
>
>
>  
>
> 2011/11/29 Danny Nicholas 
>
> It “should” be a “Call Detail Recording” option, not an add-on.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 8:45 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i didn't find him in the menu i have installed the add-ons but i can not
> load the cd_mysql :<
>
>  
>
> please advice 
>
> 2011/11/29 Danny Nicholas 
>
> It should at least be on the menu although the selection may have XXX
> instead of [ ] or [*] if the dependencies aren’t proper when you run
> ./configure.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 5:37 AM 
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> Hello Danny 
>
>  
>
> i try to flow your email but when i do make menuselect i didn't find
> add-ons in order to check the cdr_mysql
>
>  
>
> i use asterisk 1.4
>
>  
>
> 1-how can i do to install this add-ons 
>
>  
>
> 2 i want to do this installation without touching the original
> configuration of asterisk
>
>  
>
> thanks and regards
>
>  
>
>
>
>  
>
> 2011/11/21 Danny Nicholas 
>
> From what I read you are running a pre-compiled asterisk – what you can do
> in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 run make – DO NOT RUN make install****
>
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
> CLI
>
>  
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Monday, November 21, 2011 8:52 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i try to run make menuselect without configure  but he give me an error
> and he tell me that i must run ./configure before launch make menuselect *
> ***
>
>  
>
> i'm afraid if i launch ./configure and after make menuselet to lost all
> configuration related to asterisk 
>
>  
>
> BTW i can restart asterisk without issue
>
>  
>
> thanks for your response
>
> 2011/11/21 Ryan Wagoner 
>
> On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql  during the
> > installation i didn’t check the cdr mysql with  make menuselect
> >
> >
> >
> > my question : i want to check this option now  after the installtion and
> > configuration of all options but he asks me to do. /configure before to
> use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and make
> menuselect
> > to ins

Re: [asterisk-users] CDR mysql with asterisk 1.4

[Danny Nicholas]

Try running 

./configure -with-mysql=/usr 

Make menuselect

 

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 9:06 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 


what i have in "Call Detail Recording" is 

 

[*] 1. cdr_csv
[*] 2. cdr_custom
[*] 3. cdr_manager
xxx 4. cdr_odbc
xxx 5. cdr_pgsql
xxx 6. cdr_radius
xxx 7. cdr_sqlite
xxx 8. cdr_tds

 


 

2011/11/29 Danny Nicholas 

It "should" be a "Call Detail Recording" option, not an add-on.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 8:45 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i didn't find him in the menu i have installed the add-ons but i can not
load the cd_mysql :<

 

please advice 

2011/11/29 Danny Nicholas 

It should at least be on the menu although the selection may have XXX
instead of [ ] or [*] if the dependencies aren't proper when you run
./configure.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 5:37 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

Hello Danny 

 

i try to flow your email but when i do make menuselect i didn't find add-ons
in order to check the cdr_mysql

 

i use asterisk 1.4

 

1-how can i do to install this add-ons 

 

2 i want to do this installation without touching the original configuration
of asterisk

 

thanks and regards

 



 

2011/11/21 Danny Nicholas 

>From what I read you are running a pre-compiled asterisk - what you can do
in that instance is this

1 create a directory like /usr/local/src/asterisk/1.4-update

2 wget the matching version as indicated by "core show version"

3 extract the tar to the directory from step 1

4 run ./configure

5 run make menuselect

6 run make - DO NOT RUN make install

7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
CLI

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect 

 

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk 

 

BTW i can restart asterisk without issue

 

thanks for your response

2011/11/21 Ryan Wagoner 

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn't check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to
use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make
menuselect
> to install cdr because this server is very important for me and i can't
stop
> it
>

How did you initially install Asterisk? When compiling from source
./configure is the first step before you can run make. It shouldn't
prompt to run ./configure for make menuselect if you are just changing
some options from a previously compile and install.

If you were able to run make menuselect without configure you might be
able to load the module while Asterisk is running. You would copy the
cdr_mysql.so to the lib directory and run module load cdr_mysql.
However I would still plan this for after hours in case of an issue.

Ryan


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com
<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
<http://www.api-digital.com/>  --
New to Asterisk? Join us for a live introductory webinar every Thurs:
  http:/

Re: [asterisk-users] CDR mysql with asterisk 1.4

[salaheddine elharit]

what i have in “Call Detail Recording” is

[*] 1. cdr_csv
[*] 2. cdr_custom
[*] 3. cdr_manager
xxx 4. cdr_odbc
xxx 5. cdr_pgsql
xxx 6. cdr_radius
xxx 7. cdr_sqlite
xxx 8. cdr_tds



2011/11/29 Danny Nicholas 

>  It “should” be a “Call Detail Recording” option, not an add-on.
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 8:45 AM
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>   ** **
>
> i didn't find him in the menu i have installed the add-ons but i can not
> load the cd_mysql :<
>
>  
>
> please advice 
>
> 2011/11/29 Danny Nicholas 
>
> It should at least be on the menu although the selection may have XXX
> instead of [ ] or [*] if the dependencies aren’t proper when you run
> ./configure.
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 5:37 AM ****
>
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> Hello Danny 
>
>  
>
> i try to flow your email but when i do make menuselect i didn't find
> add-ons in order to check the cdr_mysql
>
>  
>
> i use asterisk 1.4
>
>  
>
> 1-how can i do to install this add-ons 
>
>  
>
> 2 i want to do this installation without touching the original
> configuration of asterisk
>
>  
>
> thanks and regards
>
>  
>
>
>
>  
>
> 2011/11/21 Danny Nicholas 
>
> From what I read you are running a pre-compiled asterisk – what you can do
> in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 run make – DO NOT RUN make install
>
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
> CLI
>
>  
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Monday, November 21, 2011 8:52 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i try to run make menuselect without configure  but he give me an error
> and he tell me that i must run ./configure before launch make menuselect *
> ***
>
>  
>
> i'm afraid if i launch ./configure and after make menuselet to lost all
> configuration related to asterisk 
>
>  
>
> BTW i can restart asterisk without issue
>
>  
>
> thanks for your response
>
> 2011/11/21 Ryan Wagoner 
>
> On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql  during the
> > installation i didn’t check the cdr mysql with  make menuselect
> >
> >
> >
> > my question : i want to check this option now  after the installtion and
> > configuration of all options but he asks me to do. /configure before to
> use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and make
> menuselect
> > to install cdr because this server is very important for me and i can’t
> stop
> > it
> >
>
> How did you initially install Asterisk? When compiling from source
> ./configure is the first step before you can run make. It shouldn't
> prompt to run ./configure for make menuselect if you are just changing
> some options from a previously compile and install.
>
> If you were able to run make menuselect without configure you might be
> able to load the module while Asterisk is running. You would copy the
> cdr_mysql.so to the lib directory and run module load cdr_mysql.
> However I would still plan this for after hours in case of an issue.
>
> Ryan
>
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
&g

Re: [asterisk-users] CDR mysql with asterisk 1.4

[Danny Nicholas]

It "should" be a "Call Detail Recording" option, not an add-on.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 8:45 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i didn't find him in the menu i have installed the add-ons but i can not
load the cd_mysql :<

 

please advice 

2011/11/29 Danny Nicholas 

It should at least be on the menu although the selection may have XXX
instead of [ ] or [*] if the dependencies aren't proper when you run
./configure.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 5:37 AM 


To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

Hello Danny 

 

i try to flow your email but when i do make menuselect i didn't find add-ons
in order to check the cdr_mysql

 

i use asterisk 1.4

 

1-how can i do to install this add-ons 

 

2 i want to do this installation without touching the original configuration
of asterisk

 

thanks and regards

 



 

2011/11/21 Danny Nicholas 

>From what I read you are running a pre-compiled asterisk - what you can do
in that instance is this

1 create a directory like /usr/local/src/asterisk/1.4-update

2 wget the matching version as indicated by "core show version"

3 extract the tar to the directory from step 1

4 run ./configure

5 run make menuselect

6 run make - DO NOT RUN make install

7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
CLI

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect 

 

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk 

 

BTW i can restart asterisk without issue

 

thanks for your response

2011/11/21 Ryan Wagoner 

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn't check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to
use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make
menuselect
> to install cdr because this server is very important for me and i can't
stop
> it
>

How did you initially install Asterisk? When compiling from source
./configure is the first step before you can run make. It shouldn't
prompt to run ./configure for make menuselect if you are just changing
some options from a previously compile and install.

If you were able to run make menuselect without configure you might be
able to load the module while Asterisk is running. You would copy the
cdr_mysql.so to the lib directory and run module load cdr_mysql.
However I would still plan this for after hours in case of an issue.

Ryan


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com
<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
<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
<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 

Re: [asterisk-users] CDR mysql with asterisk 1.4

[salaheddine elharit]

i didn't find him in the menu i have installed the add-ons but i can not
load the cd_mysql :<

please advice

2011/11/29 Danny Nicholas 

>  It should at least be on the menu although the selection may have XXX
> instead of [ ] or [*] if the dependencies aren’t proper when you run
> ./configure.
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Tuesday, November 29, 2011 5:37 AM
>
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>   ** **
>
> Hello Danny 
>
>  
>
> i try to flow your email but when i do make menuselect i didn't find
> add-ons in order to check the cdr_mysql
>
>  
>
> i use asterisk 1.4
>
>  
>
> 1-how can i do to install this add-ons 
>
>  
>
> 2 i want to do this installation without touching the original
> configuration of asterisk
>
>  
>
> thanks and regards
>
>  
>
>
>
>  
>
> 2011/11/21 Danny Nicholas 
>
> From what I read you are running a pre-compiled asterisk – what you can do
> in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 run make – DO NOT RUN make install
>
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
> CLI
>
>  
>
>  
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Monday, November 21, 2011 8:52 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
>  
>
> i try to run make menuselect without configure  but he give me an error
> and he tell me that i must run ./configure before launch make menuselect *
> ***
>
>  
>
> i'm afraid if i launch ./configure and after make menuselet to lost all
> configuration related to asterisk 
>
>  
>
> BTW i can restart asterisk without issue
>
>  
>
> thanks for your response
>
> 2011/11/21 Ryan Wagoner 
>
> On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql  during the
> > installation i didn’t check the cdr mysql with  make menuselect
> >
> >
> >
> > my question : i want to check this option now  after the installtion and
> > configuration of all options but he asks me to do. /configure before to
> use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and make
> menuselect
> > to install cdr because this server is very important for me and i can’t
> stop
> > it
> >
>
> How did you initially install Asterisk? When compiling from source
> ./configure is the first step before you can run make. It shouldn't
> prompt to run ./configure for make menuselect if you are just changing
> some options from a previously compile and install.
>
> If you were able to run make menuselect without configure you might be
> able to load the module while Asterisk is running. You would copy the
> cdr_mysql.so to the lib directory and run module load cdr_mysql.
> However I would still plan this for after hours in case of an issue.
>
> Ryan
>
>
> --
> _
> -- 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] CDR mysql with asterisk 1.4

[Danny Nicholas]

It should at least be on the menu although the selection may have XXX
instead of [ ] or [*] if the dependencies aren't proper when you run
./configure.

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Tuesday, November 29, 2011 5:37 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

Hello Danny 

 

i try to flow your email but when i do make menuselect i didn't find add-ons
in order to check the cdr_mysql

 

i use asterisk 1.4

 

1-how can i do to install this add-ons 

 

2 i want to do this installation without touching the original configuration
of asterisk

 

thanks and regards

 



 

2011/11/21 Danny Nicholas 

>From what I read you are running a pre-compiled asterisk - what you can do
in that instance is this

1 create a directory like /usr/local/src/asterisk/1.4-update

2 wget the matching version as indicated by "core show version"

3 extract the tar to the directory from step 1

4 run ./configure

5 run make menuselect

6 run make - DO NOT RUN make install

7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
CLI

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect 

 

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk 

 

BTW i can restart asterisk without issue

 

thanks for your response

2011/11/21 Ryan Wagoner 

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn't check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to
use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make
menuselect
> to install cdr because this server is very important for me and i can't
stop
> it
>

How did you initially install Asterisk? When compiling from source
./configure is the first step before you can run make. It shouldn't
prompt to run ./configure for make menuselect if you are just changing
some options from a previously compile and install.

If you were able to run make menuselect without configure you might be
able to load the module while Asterisk is running. You would copy the
cdr_mysql.so to the lib directory and run module load cdr_mysql.
However I would still plan this for after hours in case of an issue.

Ryan


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com
<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
<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] CDR mysql with asterisk 1.4

[Ishfaq Malik]

The addons are not part of the source in 1.4 or 1.6

You need to install the addons separately.

If you installed asterisk from a package maintainer (e.g yum, apt) then
check for asterisk 1.4 addons packages.

Otherwise download, compile and install the addons from source. They can
be found here

http://www.asterisk.org/downloads

under the section Asterisk Add-Ons.

I don't think installing this will have any effect on your current
config files but I'm not 100% sure on that. It is always wise to backup
your config files before doing anything like this anyway.

Regards

Ish


On Tue, 2011-11-29 at 11:37 +, salaheddine elharit wrote:
> Hello Danny 
>  
> i try to flow your email but when i do make menuselect i didn't find
> add-ons in order to check the cdr_mysql
>  
> i use asterisk 1.4
>  
> 1-how can i do to install this add-ons 
>  
> 2 i want to do this installation without touching the original
> configuration of asterisk
>  
> thanks and regards
>  
> 
> 
>  
> 2011/11/21 Danny Nicholas 
> From what I read you are running a pre-compiled asterisk –
> what you can do in that instance is this
> 
> 1 create a directory like /usr/local/src/asterisk/1.4-update
> 
> 2 wget the matching version as indicated by “core show
> version”
> 
> 3 extract the tar to the directory from step 1
> 
> 4 run ./configure
> 
> 5 run make menuselect
> 
> 6 run make – DO NOT RUN make install
> 
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the
> module from CLI
> 
>  
> 
>  
> 
> From: asterisk-users-boun...@lists.digium.com
> [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of
> salaheddine elharit
>     Sent: Monday, November 21, 2011 8:52 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4
> 
> 
>  
> 
> i try to run make menuselect without configure  but he give me
> an error and he tell me that i must run ./configure before
> launch make menuselect 
> 
> 
>  
> 
> 
> i'm afraid if i launch ./configure and after make menuselet to
> lost all configuration related to asterisk 
> 
> 
>  
> 
> 
> BTW i can restart asterisk without issue
> 
> 
>  
> 
> 
> thanks for your response
> 
> 
> 2011/11/21 Ryan Wagoner 
> 
> On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql
> during the
> > installation i didn’t check the cdr mysql with  make
> menuselect
> >
> >
> >
> > my question : i want to check this option now  after the
> installtion and
> > configuration of all options but he asks me to
> do. /configure before to use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and
> make menuselect
> > to install cdr because this server is very important for me
> and i can’t stop
> > it
> >
> 
> 
> How did you initially install Asterisk? When compiling from
> source
> ./configure is the first step before you can run make. It
> shouldn't
> prompt to run ./configure for make menuselect if you are just
> changing
> some options from a previously compile and install.
> 
> If you were able to run make menuselect without configure you
> might be
> able to load the module while Asterisk is running. You would
> copy the
> cdr_mysql.so to the lib directory and run module load
> cdr_mysql.
> However I would still plan this for after hours in case of an
> issue.
> 
> Ryan
> 
> 
> --
> _
> -- Bandwidth and Colocation Provided by
> http://www.api-digital.com --
> New to Asterisk? Join u

Re: [asterisk-users] CDR mysql with asterisk 1.4

[salaheddine elharit]

Hello Danny

i try to flow your email but when i do make menuselect i didn't find
add-ons in order to check the cdr_mysql

i use asterisk 1.4

1-how can i do to install this add-ons

2 i want to do this installation without touching the original
configuration of asterisk

thanks and regards




2011/11/21 Danny Nicholas 

>  From what I read you are running a pre-compiled asterisk – what you can
> do in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 run make – DO NOT RUN make install
>
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
> CLI
>
> ** **
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Monday, November 21, 2011 8:52 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
> ** **
>
> i try to run make menuselect without configure  but he give me an error
> and he tell me that i must run ./configure before launch make menuselect *
> ***
>
>  
>
> i'm afraid if i launch ./configure and after make menuselet to lost all
> configuration related to asterisk 
>
>  
>
> BTW i can restart asterisk without issue
>
>  
>
> thanks for your response
>
> 2011/11/21 Ryan Wagoner 
>
> On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql  during the
> > installation i didn’t check the cdr mysql with  make menuselect
> >
> >
> >
> > my question : i want to check this option now  after the installtion and
> > configuration of all options but he asks me to do. /configure before to
> use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and make
> menuselect
> > to install cdr because this server is very important for me and i can’t
> stop
> > it
> >
>
> How did you initially install Asterisk? When compiling from source
> ./configure is the first step before you can run make. It shouldn't
> prompt to run ./configure for make menuselect if you are just changing
> some options from a previously compile and install.
>
> If you were able to run make menuselect without configure you might be
> able to load the module while Asterisk is running. You would copy the
> cdr_mysql.so to the lib directory and run module load cdr_mysql.
> However I would still plan this for after hours in case of an issue.
>
> Ryan
>
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>   http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
> ** **
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>   http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql with asterisk 1.4

[salaheddine elharit]

thanks danny and thanks all i will test this solution and i will update you
by the result

kind regards

2011/11/21 Danny Nicholas 

>  From what I read you are running a pre-compiled asterisk – what you can
> do in that instance is this
>
> 1 create a directory like /usr/local/src/asterisk/1.4-update
>
> 2 wget the matching version as indicated by “core show version”
>
> 3 extract the tar to the directory from step 1
>
> 4 run ./configure
>
> 5 run make menuselect
>
> 6 run make – DO NOT RUN make install
>
> 7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
> CLI
>
> ** **
>
> ** **
>
> *From:* asterisk-users-boun...@lists.digium.com [mailto:
> asterisk-users-boun...@lists.digium.com] *On Behalf Of *salaheddine
> elharit
> *Sent:* Monday, November 21, 2011 8:52 AM
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR mysql with asterisk 1.4
>
> ** **
>
> i try to run make menuselect without configure  but he give me an error
> and he tell me that i must run ./configure before launch make menuselect *
> ***
>
>  
>
> i'm afraid if i launch ./configure and after make menuselet to lost all
> configuration related to asterisk 
>
>  
>
> BTW i can restart asterisk without issue
>
>  
>
> thanks for your response
>
> 2011/11/21 Ryan Wagoner 
>
> On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql  during the
> > installation i didn’t check the cdr mysql with  make menuselect
> >
> >
> >
> > my question : i want to check this option now  after the installtion and
> > configuration of all options but he asks me to do. /configure before to
> use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and make
> menuselect
> > to install cdr because this server is very important for me and i can’t
> stop
> > it
> >
>
> How did you initially install Asterisk? When compiling from source
> ./configure is the first step before you can run make. It shouldn't
> prompt to run ./configure for make menuselect if you are just changing
> some options from a previously compile and install.
>
> If you were able to run make menuselect without configure you might be
> able to load the module while Asterisk is running. You would copy the
> cdr_mysql.so to the lib directory and run module load cdr_mysql.
> However I would still plan this for after hours in case of an issue.
>
> Ryan
>
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>   http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
> ** **
>
> --
> _
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>   http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
   http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR mysql with asterisk 1.4

[Danny Nicholas]

>From what I read you are running a pre-compiled asterisk - what you can do
in that instance is this

1 create a directory like /usr/local/src/asterisk/1.4-update

2 wget the matching version as indicated by "core show version"

3 extract the tar to the directory from step 1

4 run ./configure

5 run make menuselect

6 run make - DO NOT RUN make install

7 copy cdr_mysql.so to /usr/lib/asterisk/modules and load the module from
CLI

 

 

From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of salaheddine
elharit
Sent: Monday, November 21, 2011 8:52 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR mysql with asterisk 1.4

 

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect 

 

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk 

 

BTW i can restart asterisk without issue

 

thanks for your response

2011/11/21 Ryan Wagoner 

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn't check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to
use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make
menuselect
> to install cdr because this server is very important for me and i can't
stop
> it
>

How did you initially install Asterisk? When compiling from source
./configure is the first step before you can run make. It shouldn't
prompt to run ./configure for make menuselect if you are just changing
some options from a previously compile and install.

If you were able to run make menuselect without configure you might be
able to load the module while Asterisk is running. You would copy the
cdr_mysql.so to the lib directory and run module load cdr_mysql.
However I would still plan this for after hours in case of an issue.

Ryan


--
_
-- Bandwidth and Colocation Provided by http://www.api-digital.com
<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] CDR mysql with asterisk 1.4

[salaheddine elharit]

i try to run make menuselect without configure  but he give me an error and
he tell me that i must run ./configure before launch make menuselect

i'm afraid if i launch ./configure and after make menuselet to lost all
configuration related to asterisk

BTW i can restart asterisk without issue

thanks for your response

2011/11/21 Ryan Wagoner 

>  On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
>  wrote:
> > hello list
> >
> >
> >
> > i have asterisk 1.4 installed and i want to use CDR mysql  during the
> > installation i didn’t check the cdr mysql with  make menuselect
> >
> >
> >
> > my question : i want to check this option now  after the installtion and
> > configuration of all options but he asks me to do. /configure before to
> use
> > make menuselect
> >
> >
> >
> > i want to know if there any problem if i do. / configure and make
> menuselect
> > to install cdr because this server is very important for me and i can’t
> stop
> > it
> >
>
> How did you initially install Asterisk? When compiling from source
> ./configure is the first step before you can run make. It shouldn't
> prompt to run ./configure for make menuselect if you are just changing
> some options from a previously compile and install.
>
> If you were able to run make menuselect without configure you might be
> able to load the module while Asterisk is running. You would copy the
> cdr_mysql.so to the lib directory and run module load cdr_mysql.
> However I would still plan this for after hours in case of an issue.
>
> Ryan
>
> --
> _
> -- 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] CDR mysql with asterisk 1.4

[Ryan Wagoner]

On Mon, Nov 21, 2011 at 7:13 AM, salaheddine elharit
 wrote:
> hello list
>
>
>
> i have asterisk 1.4 installed and i want to use CDR mysql  during the
> installation i didn’t check the cdr mysql with  make menuselect
>
>
>
> my question : i want to check this option now  after the installtion and
> configuration of all options but he asks me to do. /configure before to use
> make menuselect
>
>
>
> i want to know if there any problem if i do. / configure and make menuselect
> to install cdr because this server is very important for me and i can’t stop
> it
>

How did you initially install Asterisk? When compiling from source
./configure is the first step before you can run make. It shouldn't
prompt to run ./configure for make menuselect if you are just changing
some options from a previously compile and install.

If you were able to run make menuselect without configure you might be
able to load the module while Asterisk is running. You would copy the
cdr_mysql.so to the lib directory and run module load cdr_mysql.
However I would still plan this for after hours in case of an issue.

Ryan

--
_
-- 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] CDR mysql with asterisk 1.4

[Doug Lytle]

salaheddine elharit wrote:


because this server is very important for me and i can’t stop it



This is one of those "schedule for after hours" things then. I don't 
believe you can do this without a restart of the Asterisk service. But, 
down time should be minimal.


Doug


--
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary Safety, 
deserve neither Liberty nor Safety."


--
_
-- 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] CDR Mysql adaptive Colum

[Henrique Fernandes]

Sorry, just use to click on the same botton.

Thanks, i guess i would figure out something now!!

Thanks a lot!

[]'sf.rique


On Thu, Mar 31, 2011 at 3:37 PM, Tilghman Lesher wrote:

> Do NOT copy me on replies.  I do NOT need two copies of your message.
>
> On Thursday 31 March 2011 12:08:53 Henrique Fernandes wrote:
> > Found something now! i need first to set the CDR and after make the Dial
> >
> > Like this.
> >
> > [default]
> > exten=> _X.,1,set(CDR(teste)=${CHANNEL(useragent)})
> > exten=> _X.,2,Dial(SIP/${EXTEN})
> >
> > Like this, this would work!!
> >
> > Now i have a question, if i do not use EXTEN and add an entry for each
> > number like this
> >
> > [default]
> > exten=> _600.,1,set(CDR(teste)=${CHANNEL(useragent)})
> > exten=> _600.,2,Dial(SIP/600)
> > exten=> _700.,1,set(CDR(teste)=${CHANNEL(useragent)})
> > exten=> _700.,2,Dial(SIP/700)
> > exten=> _800.,1,set(CDR(teste)=${CHANNEL(useragent)})
> > exten=> _800.,2,Dial(SIP/800)
> >
> > I would have to do like this or thre is an easier way to set the CDR for
> > all my calls ?
>
> Simple pattern matching:
>
> exten => _[678]00.,1,set(CDR(teste)=)
> exten => _600.,2,Dial(...)
> exten => _700.,2,Dial(...)
> exten => _800.,2,Dial(...)
>
> Or, better:
> exten => _[678]00.,1,set(CDR(teste)=)
> exten => _[678]00.,n,Dial(SIP/${EXTEN:0:3})
>
> --
> Tilghman
>
> --
> _
> -- 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] CDR Mysql adaptive Colum

[Tilghman Lesher]

Do NOT copy me on replies.  I do NOT need two copies of your message.

On Thursday 31 March 2011 12:08:53 Henrique Fernandes wrote:
> Found something now! i need first to set the CDR and after make the Dial
> 
> Like this.
> 
> [default]
> exten=> _X.,1,set(CDR(teste)=${CHANNEL(useragent)})
> exten=> _X.,2,Dial(SIP/${EXTEN})
> 
> Like this, this would work!!
> 
> Now i have a question, if i do not use EXTEN and add an entry for each
> number like this
> 
> [default]
> exten=> _600.,1,set(CDR(teste)=${CHANNEL(useragent)})
> exten=> _600.,2,Dial(SIP/600)
> exten=> _700.,1,set(CDR(teste)=${CHANNEL(useragent)})
> exten=> _700.,2,Dial(SIP/700)
> exten=> _800.,1,set(CDR(teste)=${CHANNEL(useragent)})
> exten=> _800.,2,Dial(SIP/800)
> 
> I would have to do like this or thre is an easier way to set the CDR for
> all my calls ?

Simple pattern matching:

exten => _[678]00.,1,set(CDR(teste)=)
exten => _600.,2,Dial(...)
exten => _700.,2,Dial(...)
exten => _800.,2,Dial(...)

Or, better:
exten => _[678]00.,1,set(CDR(teste)=)
exten => _[678]00.,n,Dial(SIP/${EXTEN:0:3})

-- 
Tilghman

--
_
-- 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] CDR Mysql adaptive Colum

[Henrique Fernandes]

Found something now! i need first to set the CDR and after make the Dial

Like this.

[default]
exten=> _X.,1,set(CDR(teste)=${CHANNEL(useragent)})
exten=> _X.,2,Dial(SIP/${EXTEN})

Like this, this would work!!

Now i have a question, if i do not use EXTEN and add an entry for each
number like this

[default]
exten=> _600.,1,set(CDR(teste)=${CHANNEL(useragent)})
exten=> _600.,2,Dial(SIP/600)
exten=> _700.,1,set(CDR(teste)=${CHANNEL(useragent)})
exten=> _700.,2,Dial(SIP/700)
exten=> _800.,1,set(CDR(teste)=${CHANNEL(useragent)})
exten=> _800.,2,Dial(SIP/800)

I would have to do like this or thre is an easier way to set the CDR for all
my calls ?



[]'sf.rique


On Thu, Mar 31, 2011 at 10:47 AM, Henrique Fernandes wrote:

> I got something with this line.
>
> exten=> _X.,2,set(CDR(teste)=${CHANNEL(useragent)})
>
> But only wen the first cal fail!
>
> I wil setuo asterisk to show the log in the console.
>
>
> []'sf.rique
>
>
> On Thu, Mar 31, 2011 at 6:17 AM, Tilghman Lesher wrote:
>
>> On Wednesday 30 March 2011 14:34:29 Henrique Fernandes wrote:
>> > exten => s,1,set(CDR(teste)=${CHANNEL(audioreadformat)})
>> >
>> > And is not working, i thought the only diference it i would need the
>> > colum teste in my cdr table right ?
>>
>> Correct.  Did you restart Asterisk after modifying the table?  If you set
>> core debug to 2 (core set debug 2 cdr_mysql), does it spit out any
>> messages
>> regarding the MySQL CDR driver?  (Note that you'll need to have debug
>> lines
>> going to the console in logger.conf for this to work.)
>>
>> --
>> Tilghman
>>
>> --
>> _
>> -- 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] CDR Mysql adaptive Colum

[Henrique Fernandes]

I got something with this line.

exten=> _X.,2,set(CDR(teste)=${CHANNEL(useragent)})

But only wen the first cal fail!

I wil setuo asterisk to show the log in the console.


[]'sf.rique


On Thu, Mar 31, 2011 at 6:17 AM, Tilghman Lesher wrote:

> On Wednesday 30 March 2011 14:34:29 Henrique Fernandes wrote:
> > exten => s,1,set(CDR(teste)=${CHANNEL(audioreadformat)})
> >
> > And is not working, i thought the only diference it i would need the
> > colum teste in my cdr table right ?
>
> Correct.  Did you restart Asterisk after modifying the table?  If you set
> core debug to 2 (core set debug 2 cdr_mysql), does it spit out any messages
> regarding the MySQL CDR driver?  (Note that you'll need to have debug lines
> going to the console in logger.conf for this to work.)
>
> --
> Tilghman
>
> --
> _
> -- 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] CDR Mysql adaptive Colum

[Tilghman Lesher]

On Wednesday 30 March 2011 14:34:29 Henrique Fernandes wrote:
> exten => s,1,set(CDR(teste)=${CHANNEL(audioreadformat)})
> 
> And is not working, i thought the only diference it i would need the
> colum teste in my cdr table right ?

Correct.  Did you restart Asterisk after modifying the table?  If you set
core debug to 2 (core set debug 2 cdr_mysql), does it spit out any messages
regarding the MySQL CDR driver?  (Note that you'll need to have debug lines
going to the console in logger.conf for this to work.)

-- 
Tilghman

--
_
-- 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] CDR MYSQL missing field data

[Warren Selby]

On Thu, Mar 31, 2011 at 1:52 AM, Tilghman Lesher wrote:

>
> I was incorrect, here, and there's nobody to blame but myself.  The
> field is ACTUALLY named "clid" internally, so when I, by default, set
> ANOTHER field to the "clid" column, I shut out the default logic which
> would have put the callerid into the "clid" column.  This has now been
> fixed
> in 1.8 SVN, as a default configuration file fix.  If you comment out the
> line
> marked "alias callerid => clid", it should work fine.
>
>
I can confirm this - I just tested it on my system and the clid column is
properly filled in now.  Thanks for the quick fix Tilghman!

-- 
Thanks,
--Warren Selby, dCAP
http://www.selbytech.com
--
_
-- 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] CDR MYSQL missing field data

[Tilghman Lesher]

On Monday 28 March 2011 14:23:25 Tilghman Lesher wrote:
> On Monday 28 March 2011 07:57:10 Eric W. Davenport wrote:
> > alias start => calldate
> > alias callerid => clid
> 
> These are fine.

I was incorrect, here, and there's nobody to blame but myself.  The
field is ACTUALLY named "clid" internally, so when I, by default, set
ANOTHER field to the "clid" column, I shut out the default logic which
would have put the callerid into the "clid" column.  This has now been fixed
in 1.8 SVN, as a default configuration file fix.  If you comment out the line
marked "alias callerid => clid", it should work fine.

-- 
Tilghman

--
_
-- 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] CDR MYSQL missing field data

[Eric W. Davenport]

Warren,

Thank you

Eric

--
Eric W. Davenport
Cert-In Software Systems, Inc.
P.O. Box 346
Bakersville, NC 28705
800-873-0110
ewdavenp...@certin.com
www.certin.com


--
_
-- 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] CDR MYSQL missing field data

[bayardo . sanchez]

I listened to your email using DriveCarefully and will respond as soon as I can.
 Download DriveCarefully for free at www.drivecarefully.com
--
Sent from my BlackBerry®
Senior Support Engineer
US Numbers: 561-886-0664
Nicaragua Mobile: +505.8488.6876
--
_
-- 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] CDR MYSQL missing field data

[Warren Selby]

On Tue, Mar 29, 2011 at 4:03 PM, Warren Selby  wrote:

> That information does indeed look like what I want and it appears to be
> setup correctly.  I will be building a comparable test system later today
> (using all the same software versions as you) and I'll test to see if I get
> the same issue.  If I do, I'll open a new bug on the issue tracker, and I'll
> post my results here on the list.


Well, after recreating your environment in a virtual machine tonight, I was
able to reproduce the issue, so I created a bug on the issue tracker:

https://issues.asterisk.org/view.php?id=19040

Hopefully someone a little closer to the development will be able to take a
look and see what's going on.

-- 
Thanks,
--Warren Selby, dCAP
http://www.selbytech.com
--
_
-- 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] CDR MYSQL missing field data

[Warren Selby]

On Tue, Mar 29, 2011 at 3:52 PM, Eric W. Davenport
wrote:

>  Hi Warren,
>
> Thanks for your help,
>
> I think this is what you want
>
>
Please don't mail me (or anyone else) off the list directly without being
specifically asked to.  The idea is to keep things on the mailing list in
order to help other people who may have the same issues.  That being said...

That information does indeed look like what I want and it appears to be
setup correctly.  I will be building a comparable test system later today
(using all the same software versions as you) and I'll test to see if I get
the same issue.  If I do, I'll open a new bug on the issue tracker, and I'll
post my results here on the list.

-- 
Thanks,
--Warren Selby, dCAP
http://www.selbytech.com
--
_
-- 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] CDR MYSQL missing field data

[Warren Selby]

On Tue, Mar 29, 2011 at 12:32 PM, Eric W. Davenport
wrote:

> I restarted Asterisk and I still have all the fields outgoing and incoming
> except for the CLID field.
> Clid is populated in the CSV Simple file as well as the CSV Custom file.
>
>
Please, if you would, copy and paste the output of a 'describe' of your cdr
table (in my environment this would be 'describe asterisk.cdr' from the
mysql shell).  Then, copy and paste the output of 'cat
/etc/asterisk/cdr_mysql.conf'.  Delete any passwords that file may contain
before posting, of course.

This will enable us to better troubleshoot your exact issue.

-- 
Thanks,
--Warren Selby, dCAP
http://www.selbytech.com
--
_
-- 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] CDR MYSQL missing field data

[Tilghman Lesher]

On Monday 28 March 2011 07:57:10 Eric W. Davenport wrote:
> Thanks Tilghman for your response.
> 
> I have the following in my cdr_mysql.conf
> 
> I put it in sometime yesterday and did not have it till then.
> 
> However, it did not make any difference.

Did you reload after making the change to the config file?

> [columns]
> static "" => 
> alias  => 

These are bogus and should never have been uncommented.

> alias start => calldate
> alias callerid => clid

These are fine.

> alias src => src
> alias dst => dst
> alias dcontext => dcontext
> alias channel => channel
> alias dstchannel => dstchannel
> alias lastapp => lastapp
> alias lastdata => lastdata
> alias duration => duration
> alias billsec => billsec
> alias disposition => disposition
> alias amaflags => amaflags
> alias accountcode => accountcode
> alias userfield => userfield
> alias uniqueid => uniqueid

There is no reason to have any of these uncommented, unless the column
specified after the arrow is different from the field specified before.

-- 
Tilghman

--
_
-- 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] CDR MYSQL missing field data

[Eric W. Davenport]

Thanks Tilghman for your response.

I have the following in my cdr_mysql.conf

I put it in sometime yesterday and did not have it till then.

However, it did not make any difference.

[columns]
static "" => 
alias  => 
alias start => calldate
alias callerid => clid
alias src => src
alias dst => dst
alias dcontext => dcontext
alias channel => channel
alias dstchannel => dstchannel
alias lastapp => lastapp
alias lastdata => lastdata
alias duration => duration
alias billsec => billsec
alias disposition => disposition
alias amaflags => amaflags
alias accountcode => accountcode
alias userfield => userfield
alias uniqueid => uniqueid

Thanks again

Eric

--
Eric W. Davenport
Cert-In Software Systems, Inc.
P.O. Box 346
Bakersville, NC 28705
800-873-0110
ewdavenp...@certin.com
www.certin.com


--
_
-- 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] CDR MYSQL missing field data

[Tilghman Lesher]

On Sunday 27 March 2011 19:36:45 Eric W. Davenport wrote:
> Hello,
> 
> I have Asterisk-1.8.3.2, dahdi-linux-complete-2.4.1+2.4.1, and
> libpri-1.4.11.5 installed and running on a Ubuntu 10.04 server all built
> from source.
> 
> Everything is working nicely except one small issue.
> 
> The CDR records are stored in the CSV file correctly and complete.
> 
> The MySQL storage is working as it should and is automatically updating
> all the fields except the CLID field.
> 
> I have compared and constructed and destructed the system 3 times since
> Thursday and I cannot figure out why the field does not get populated.
> 
> If I run the import from csv script it correctly populates the CLID so I
> believe that tables are setup correct.
> 
> Has any one seen this and could possibly point me at the offending conf
> file.
> 
> I am more familiar than I want to be with cdr_.conf files and I
> cannot find where the problem is.
> 
> I have browsed all the wiki's, blogs, and emails looking for a hint and
> I did not find anything.
> 
> Anything would be appreciated.

Do you have "alias callerid => clid" in your cdr_mysql.conf file (in the
[columns] context)?

-- 
Tilghman

--
_
-- 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] CDR: MySQL query

[RSCL Mumbai]

Thx Rudi. but this query results in *Empty set (0.32 sec)
src AND dst like number  *seems to be the problem area.
*
*
Also, how can I get the hold time & talk time as separate values OR may be
total call connect time & talk time (the difference of the 2 will be hold
time).

Thx
Sans


On Wed, Aug 4, 2010 at 6:18 PM, Rudi Oosthuizen
wrote:

> Mysql
> Use asteriskcdrdb;
> Select calldate,src,dst,disposition,duration,billsec,uniqueid from cdr
> where src like 'NUMBER' and dst like 'NUMBER' order by calldate;
>
>
> Rudi Oosthuzen
>
>
>
>
>
> >   Hi,
>
> >   Can someone help me formulate MySQL Query(s) which will help me
> extract the
> >   following details for a given DID (date range can be excluded for
> >   simplicity).
>
> >   Date-Time
> >   DNID (I am recording this is `userfield`)
> >   CLID
> >   time-1 (when call was received)
> >   time-2 (when call was answered by agent)
> >   time-3 (when call was hung-up)
>
> >   My Call flow is as follows:
> >   - Caller dials a DNID
> >   - Call enters queue
> >   - Call rings in round-robin format to all logged in agents
> >   - Agent answers call
> >   - Both parties hand-up
>
> >   Any help with MySQL queries or pointers are deeply appreciated.
>
> >   Thx
> >   Sans
>
-- 
_
-- 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] cdr mysql error

[Jai Rangi]

Increase the timeout in my.cnf in mysql.

-Jai
"Buy unmetered VoIP DIDs www.didforsale.com Free Trail"


On Mon, Nov 24, 2008 at 11:10 PM, Nhadie <[EMAIL PROTECTED]> wrote:

>
> Hi,
>
> Need help on mysql cdr, i keep on seeing this log on the console.
> but my db is up and i see the calls being logged on the cdr table. is
> there a timeout when there is no activity? can i remove the timeout if
> there is any? thanks
>
> [Nov 25 13:22:37] ERROR[21026]: cdr_addon_mysql.c:171 mysql_log:
> cdr_mysql: Server has gone away. Attempting to reconnect.
> [Nov 25 14:20:32] ERROR[21061]: cdr_addon_mysql.c:171 mysql_log:
> cdr_mysql: Server has gone away. Attempting to reconnect.
>
> regards,
> nhadie
>
> ___
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> 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 --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR/MySQL basic config

[Alessandro Russo]

Hi,
this is my cdr_mysql.conf

[global]
hostname=localhost
dbname=asterisk
table=cdr
password= mypassword
user=asteriskcdr
;port=3306
;sock=/tmp/mysql.sock
;userfield=1

as you can see, the last three are comment out, try to comment these rows,
your system could be able to retrieve the sock in same way...maybe.
My debian :)

/var/run/mysqld/mysqld.sock

bye

On 8/7/07, Jaswinder Singh <[EMAIL PROTECTED]> wrote:
>
> sock=/tmp/mysql.sock
>
> Is this path for socket correct ?
> In some distro it is /var/lib/mysql/mysql.sock . Type "locate mysql.sock"
> in shell .  Also remove  uncomment port=3306  if using socket to connect .
>
> On 07/08/07, Alessandro Russo <[EMAIL PROTECTED]> wrote:
> >
> > Hi, try to login as asteriskcdruser to mysql
> >
> > 
> > # mysql -u asteriskcdruser -p
> > Enter password: password
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 12
> > Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql>
> >
> >
> > 
> > Can you login with asteriskcdruser?
> > If you cannot login there are some problems with privileges or...I don't
> > know :(
> >
> >
> > On 8/7/07, Adrian Marsh < [EMAIL PROTECTED]> wrote:
> > >
> > >  Hi Alessandro,
> > >
> > >
> > >
> > > Thanks for that.. I'm pretty sure about the user. I used Webmin to
> > > confirm the user configs, but I ran your commands anyway:
> > >
> > >
> > >
> > >
> > >
> > > mysql> use mysql ;
> > >
> > > Reading table information for completion of table and column names
> > >
> > > You can turn off this feature to get a quicker startup with -A
> > >
> > >
> > >
> > > Database changed
> > >
> > > mysql> select Host from user where User = 'asteriskcdruser' ;
> > >
> > > +---+
> > >
> > > | Host  |
> > >
> > > +---+
> > >
> > > | localhost |
> > >
> > > +---+
> > >
> > > 1 row in set (0.00 sec)
> > >
> > >
> > >
> > > mysql> grant insert on asteriskcdrdb.* to [EMAIL PROTECTED] by 
> > > 'asteriskcdruser';
> > >
> > > Query OK, 0 rows affected (0.00 sec)
> > >
> > >
> > >
> > > But I still get the failure:
> > >
> > >
> > >
> > > [Aug  7 15:14:10] ERROR[29103]: cdr_addon_mysql.c:436 my_load_module:
> > > Failed to connect to mysql database asteriskcdrdb on localhost.
> > >
> > > cdr_addon_mysql.so => (MySQL CDR Backend)
> > >
> > > [Aug  7 15:14:10] ERROR[29103]: res_config_mysql.c:627
> > > mysql_reconnect: MySQL RealTime: Failed to connect database server  on  
> > > (err
> > > 2002). Check debug for more info.
> > >
> > > [Aug  7 15:14:10] WARNING[29103]: res_config_mysql.c:474 load_module:
> > > MySQL RealTime: Couldn't establish connection. Check debug.
> > >
> > > [Aug  7 15:14:10] NOTICE[29103]: config.c:1171
> > > ast_config_engine_register: Registered Config Engine mysql
> > >
> > > MySQL RealTime driver loaded.
> > >
> > > res_config_mysql.so => (MySQL RealTime Configuration Driver)
> > >
> > >
> > >
> > > This box also das Cacti installed on it, which makes use of the MySql
> > > server as well (and all is ok there).
> > >
> > >
> > >
> > >
> > >
> > > Adrian Marsh
> > >
> > >
> > >   --
> > >
> > > *From:* [EMAIL PROTECTED] [mailto:
> > > [EMAIL PROTECTED] *On Behalf Of *Alessandro
> > > Russo
> > > *Sent:* 07 August 2007 14:13
> > > *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> > > *Subject:* Re: [asterisk-users] CDR/MySQL basic config
> > >
> > >
> > >
> > > Hi,
> > > first step is correct
> > >
> > > Hmm.. This is what I get:
> > >
> > > [EMAIL PROTECTED] ~]# mysql -u root -p
> >

Re: [asterisk-users] CDR/MySQL basic config

[Jaswinder Singh]

sock=/tmp/mysql.sock

Is this path for socket correct ?
In some distro it is /var/lib/mysql/mysql.sock . Type "locate mysql.sock" in
shell .  Also remove  uncomment port=3306  if using socket to connect .

On 07/08/07, Alessandro Russo <[EMAIL PROTECTED]> wrote:
>
> Hi, try to login as asteriskcdruser to mysql
>
> 
> # mysql -u asteriskcdruser -p
> Enter password: password
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 12
> Server version: 5.0.32-Debian_7etch1-log Debian etch distribution
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql>
>
>
> 
> Can you login with asteriskcdruser?
> If you cannot login there are some problems with privileges or...I don't
> know :(
>
>
> On 8/7/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
> >
> >  Hi Alessandro,
> >
> >
> >
> > Thanks for that.. I'm pretty sure about the user. I used Webmin to
> > confirm the user configs, but I ran your commands anyway:
> >
> >
> >
> >
> >
> > mysql> use mysql ;
> >
> > Reading table information for completion of table and column names
> >
> > You can turn off this feature to get a quicker startup with -A
> >
> >
> >
> > Database changed
> >
> > mysql> select Host from user where User = 'asteriskcdruser' ;
> >
> > +---+
> >
> > | Host  |
> >
> > +---+
> >
> > | localhost |
> >
> > +---+
> >
> > 1 row in set (0.00 sec)
> >
> >
> >
> > mysql> grant insert on asteriskcdrdb.* to [EMAIL PROTECTED] by 
> > 'asteriskcdruser';
> >
> > Query OK, 0 rows affected (0.00 sec)
> >
> >
> >
> > But I still get the failure:
> >
> >
> >
> > [Aug  7 15:14:10] ERROR[29103]: cdr_addon_mysql.c:436 my_load_module:
> > Failed to connect to mysql database asteriskcdrdb on localhost.
> >
> > cdr_addon_mysql.so => (MySQL CDR Backend)
> >
> > [Aug  7 15:14:10] ERROR[29103]: res_config_mysql.c:627 mysql_reconnect:
> > MySQL RealTime: Failed to connect database server  on  (err 2002). Check
> > debug for more info.
> >
> > [Aug  7 15:14:10] WARNING[29103]: res_config_mysql.c:474 load_module:
> > MySQL RealTime: Couldn't establish connection. Check debug.
> >
> > [Aug  7 15:14:10] NOTICE[29103]: config.c:1171
> > ast_config_engine_register: Registered Config Engine mysql
> >
> > MySQL RealTime driver loaded.
> >
> > res_config_mysql.so => (MySQL RealTime Configuration Driver)
> >
> >
> >
> > This box also das Cacti installed on it, which makes use of the MySql
> > server as well (and all is ok there).
> >
> >
> >
> >
> >
> > Adrian Marsh
> >
> >
> >   --
> >
> > *From:* [EMAIL PROTECTED] [mailto:
> > [EMAIL PROTECTED] *On Behalf Of *Alessandro Russo
> > *Sent:* 07 August 2007 14:13
> > *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> > *Subject:* Re: [asterisk-users] CDR/MySQL basic config
> >
> >
> >
> > Hi,
> > first step is correct
> >
> > Hmm.. This is what I get:
> >
> > [EMAIL PROTECTED] ~]# mysql -u root -p
> > Enter password:
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 187143 to server version: 4.1.20
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> >  You make an errore here : mysql> use asteriskcdrdb
> >
> > users' information are stored in mysql db
> >
> > mysql> use mysql;
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> >
> > Database changed
> > mysql
> >
> > mysql> select Host from user where User = 'asteriskcdruser' ;
> > +---+
> > | Host  |
> > +---+
> > | localhost |
> > +---+
> > 1 row in set (0.00 sec)
> >
> > mysql>
> >
> > Are you sure that user 'asteriskcdruser' has the privileges to insert
> > record in DB "asteriskcdrdb&q

Re: [asterisk-users] CDR/MySQL basic config

[Alessandro Russo]

Hi, try to login as asteriskcdruser to mysql

# mysql -u asteriskcdruser -p
Enter password: password
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


Can you login with asteriskcdruser?
If you cannot login there are some problems with privileges or...I don't
know :(


On 8/7/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
>
>  Hi Alessandro,
>
>
>
> Thanks for that.. I'm pretty sure about the user. I used Webmin to confirm
> the user configs, but I ran your commands anyway:
>
>
>
>
>
> mysql> use mysql ;
>
> Reading table information for completion of table and column names
>
> You can turn off this feature to get a quicker startup with -A
>
>
>
> Database changed
>
> mysql> select Host from user where User = 'asteriskcdruser' ;
>
> +---+
>
> | Host  |
>
> +---+
>
> | localhost |
>
> +---+
>
> 1 row in set (0.00 sec)
>
>
>
> mysql> grant insert on asteriskcdrdb.* to [EMAIL PROTECTED] by 
> 'asteriskcdruser';
>
> Query OK, 0 rows affected (0.00 sec)
>
>
>
> But I still get the failure:
>
>
>
> [Aug  7 15:14:10] ERROR[29103]: cdr_addon_mysql.c:436 my_load_module:
> Failed to connect to mysql database asteriskcdrdb on localhost.
>
> cdr_addon_mysql.so => (MySQL CDR Backend)
>
> [Aug  7 15:14:10] ERROR[29103]: res_config_mysql.c:627 mysql_reconnect:
> MySQL RealTime: Failed to connect database server  on  (err 2002). Check
> debug for more info.
>
> [Aug  7 15:14:10] WARNING[29103]: res_config_mysql.c:474 load_module:
> MySQL RealTime: Couldn't establish connection. Check debug.
>
> [Aug  7 15:14:10] NOTICE[29103]: config.c:1171 ast_config_engine_register:
> Registered Config Engine mysql
>
> MySQL RealTime driver loaded.
>
> res_config_mysql.so => (MySQL RealTime Configuration Driver)
>
>
>
> This box also das Cacti installed on it, which makes use of the MySql
> server as well (and all is ok there).
>
>
>
>
>
> Adrian Marsh
>
>
>   --
>
> *From:* [EMAIL PROTECTED] [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Alessandro Russo
> *Sent:* 07 August 2007 14:13
> *To:* Asterisk Users Mailing List - Non-Commercial Discussion
> *Subject:* Re: [asterisk-users] CDR/MySQL basic config
>
>
>
> Hi,
> first step is correct
>
> Hmm.. This is what I get:
>
> [EMAIL PROTECTED] ~]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 187143 to server version: 4.1.20
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
>  You make an errore here : mysql> use asteriskcdrdb
>
> users' information are stored in mysql db
>
> mysql> use mysql;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql
>
> mysql> select Host from user where User = 'asteriskcdruser' ;
> +---+
> | Host  |
> +---+
> | localhost |
> +---+
> 1 row in set (0.00 sec)
>
> mysql>
>
> Are you sure that user 'asteriskcdruser' has the privileges to insert
> record in DB "asteriskcdrdb"?
> If not...allow 'asteriskcdruser' to insert record ^_^
>
> mysql> grant insert on asteriskcdrdb.* to [EMAIL PROTECTED] by 
> 'asteriskcdruser';
> mysql> exit
>
> Reload asterisk and try
>
>
>  On 8/7/07, *Adrian Marsh* < [EMAIL PROTECTED]> wrote:
>
>
> Hmm.. This is what I get:
>
> [EMAIL PROTECTED] ~]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 187143 to server version: 4.1.20
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use asteriskcdrdb ;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> select Host from user where User = 'asteriskcdruser' ;
> ERROR 1146 (42S02): Table 'asteriskcdrdb.user' doesn&#x

Re: [asterisk-users] CDR/MySQL basic config

[Adrian Marsh]

Hi Alessandro,

 

Thanks for that.. I'm pretty sure about the user. I used Webmin to
confirm the user configs, but I ran your commands anyway:

 

 

mysql> use mysql ;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

 

Database changed

mysql> select Host from user where User = 'asteriskcdruser' ;

+---+

| Host  |

+---+

| localhost |

+---+

1 row in set (0.00 sec)

 

mysql> grant insert on asteriskcdrdb.* to [EMAIL PROTECTED]
identified by 'asteriskcdruser';

Query OK, 0 rows affected (0.00 sec)

 

But I still get the failure:

 

[Aug  7 15:14:10] ERROR[29103]: cdr_addon_mysql.c:436 my_load_module:
Failed to connect to mysql database asteriskcdrdb on localhost.

cdr_addon_mysql.so => (MySQL CDR Backend)

[Aug  7 15:14:10] ERROR[29103]: res_config_mysql.c:627 mysql_reconnect:
MySQL RealTime: Failed to connect database server  on  (err 2002). Check
debug for more info.

[Aug  7 15:14:10] WARNING[29103]: res_config_mysql.c:474 load_module:
MySQL RealTime: Couldn't establish connection. Check debug.

[Aug  7 15:14:10] NOTICE[29103]: config.c:1171
ast_config_engine_register: Registered Config Engine mysql

MySQL RealTime driver loaded.

res_config_mysql.so => (MySQL RealTime Configuration Driver)

 

This box also das Cacti installed on it, which makes use of the MySql
server as well (and all is ok there).

 

 

Adrian Marsh

  



From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alessandro
Russo
Sent: 07 August 2007 14:13
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR/MySQL basic config

 

Hi, 
first step is correct 

Hmm.. This is what I get:

[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 187143 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer. 

You make an errore here : mysql> use asteriskcdrdb 

users' information are stored in mysql db

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed 
mysql   

mysql> select Host from user where User = 'asteriskcdruser' ;
+---+
| Host  |
+---+
| localhost |
+---+
1 row in set (0.00 sec)

mysql> 

Are you sure that user 'asteriskcdruser' has the privileges to insert
record in DB "asteriskcdrdb"?
If not...allow 'asteriskcdruser' to insert record ^_^

mysql> grant insert on asteriskcdrdb.* to [EMAIL PROTECTED]
identified by 'asteriskcdruser';
mysql> exit

Reload asterisk and try 




On 8/7/07, Adrian Marsh < [EMAIL PROTECTED]> wrote:


Hmm.. This is what I get:

[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 187143 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use asteriskcdrdb ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A 

Database changed
mysql> select Host from user where User = 'asteriskcdruser' ;
ERROR 1146 (42S02): Table 'asteriskcdrdb.user' doesn't exist
mysql>


Adrian Marsh
-----Original Message- 
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] ] On Behalf Of Forrest
Beck
Sent: 07 August 2007 02:59
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR/MySQL basic config

Adrian,

What host/ip did you specify when you created the user? 

#> mysql --user=root --password

#mysql> use mysql;

#mysql> select Host from user where User = 'asteriskcdruser'
(this line is case sensitive)

Does it return 127.0.0.1 or localhost.  Make cdr_mysql reflect that.

You should also check out cdr_odbc, asterisk can connect through an
ODBC connection which in turn is a connection to the MySQL database.
There seems to be more suport for the ODBC driver. 

Hope this helps some



On 8/6/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install.  The
> add-ons pack has been installed for a while, so now I'm trying to add
> the Mysql config.
>
> I've created a mysql database, added the grants for a user acces, and
> can run a mysql -u asteriskcdruser -p and can connect to the database.

>
> I've been using this as a guide:
>
http://www.757.org/~joat/wiki/index.php/Asterisk#Viewing_C

Re: [asterisk-users] CDR/MySQL basic config

[Alessandro Russo]

Hi,
first step is correct

> Hmm.. This is what I get:
>
> [EMAIL PROTECTED] ~]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 187143 to server version: 4.1.20
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> You make an errore here : mysql> use asteriskcdrdb
>
users' information are stored in mysql db

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql

mysql> select Host from user where User = 'asteriskcdruser' ;
+---+
| Host  |
+---+
| localhost |
+---+
1 row in set (0.00 sec)

mysql>

Are you sure that user 'asteriskcdruser' has the privileges to insert record
in DB "asteriskcdrdb"?
If not...allow 'asteriskcdruser' to insert record ^_^

mysql> grant insert on asteriskcdrdb.* to
[EMAIL PROTECTED] by 'asteriskcdruser';
mysql> exit

Reload asterisk and try



On 8/7/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
>
>
> Hmm.. This is what I get:
>
> [EMAIL PROTECTED] ~]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 187143 to server version: 4.1.20
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> use asteriskcdrdb ;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> select Host from user where User = 'asteriskcdruser' ;
> ERROR 1146 (42S02): Table 'asteriskcdrdb.user' doesn't exist
> mysql>
>
>
> Adrian Marsh
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Forrest
> Beck
> Sent: 07 August 2007 02:59
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [asterisk-users] CDR/MySQL basic config
>
> Adrian,
>
> What host/ip did you specify when you created the user?
>
> #> mysql --user=root --password
>
> #mysql> use mysql;
>
> #mysql> select Host from user where User = 'asteriskcdruser'
> (this line is case sensitive)
>
> Does it return 127.0.0.1 or localhost.  Make cdr_mysql reflect that.
>
> You should also check out cdr_odbc, asterisk can connect through an
> ODBC connection which in turn is a connection to the MySQL database.
> There seems to be more suport for the ODBC driver.
>
> Hope this helps some
>
>
>
> On 8/6/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install.  The
> > add-ons pack has been installed for a while, so now I'm trying to add
> > the Mysql config.
> >
> > I've created a mysql database, added the grants for a user acces, and
> > can run a mysql -u asteriskcdruser -p and can connect to the database.
> >
> > I've been using this as a guide:
> >
> http://www.757.org/~joat/wiki/index.php/Asterisk#Viewing_CDR_Data_with_A
> > sterisk:_CDR_Analyzer
> >
> > I've created cdr_mysql.conf:
> >
> > [global]
> > hostname=localhost
> > dbname=asteriskcdrdb
> > table=cdr
> > password=password
> > user=asteriskcdruser
> > port=3306
> > sock=/tmp/mysql.sock
> > userfield=1
> >
> > But when I start asterisk (1.4 on my test machine), I get:
> >
> >   == Parsing '/etc/asterisk/cdr_mysql.conf': Found
> > [Aug  6 21:01:14] ERROR[32512]: cdr_addon_mysql.c:436 my_load_module:
> > Failed to connect to mysql database asteriskcdrdb on localhost.
> > cdr_addon_mysql.so => (MySQL CDR Backend)
> > [Aug  6 21:01:14] ERROR[32512]: res_config_mysql.c:627
> mysql_reconnect:
> > MySQL RealTime: Failed to connect database server  on  (err 2002).
> Check
> > debug for more info.
> > [Aug  6 21:01:14] WARNING[32512]: res_config_mysql.c:474 load_module:
> > MySQL RealTime: Couldn't establish connection. Check debug.
> > [Aug  6 21:01:14] NOTICE[32512]: config.c:1171
> > ast_config_engine_register: Registered Config Engine mysql
> > MySQL RealTime driver loaded.
> > res_config_mysql.so => (MySQL RealTime Configuration Driver)
> >
> >
> > I'm also looking as to what CDR viewers there are available, and which
> > people think are best.  I want to view/report on the calls made within
> > A*k.
> >
> > Thanks,
>

Re: [asterisk-users] CDR/MySQL basic config

[Adrian Marsh]

Hmm.. This is what I get:

[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 187143 to server version: 4.1.20

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use asteriskcdrdb ;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select Host from user where User = 'asteriskcdruser' ;
ERROR 1146 (42S02): Table 'asteriskcdrdb.user' doesn't exist
mysql>


Adrian Marsh
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Forrest
Beck
Sent: 07 August 2007 02:59
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] CDR/MySQL basic config

Adrian,

What host/ip did you specify when you created the user?

#> mysql --user=root --password

#mysql> use mysql;

#mysql> select Host from user where User = 'asteriskcdruser'
(this line is case sensitive)

Does it return 127.0.0.1 or localhost.  Make cdr_mysql reflect that.

You should also check out cdr_odbc, asterisk can connect through an
ODBC connection which in turn is a connection to the MySQL database.
There seems to be more suport for the ODBC driver.

Hope this helps some



On 8/6/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install.  The
> add-ons pack has been installed for a while, so now I'm trying to add
> the Mysql config.
>
> I've created a mysql database, added the grants for a user acces, and
> can run a mysql -u asteriskcdruser -p and can connect to the database.
>
> I've been using this as a guide:
>
http://www.757.org/~joat/wiki/index.php/Asterisk#Viewing_CDR_Data_with_A
> sterisk:_CDR_Analyzer
>
> I've created cdr_mysql.conf:
>
> [global]
> hostname=localhost
> dbname=asteriskcdrdb
> table=cdr
> password=password
> user=asteriskcdruser
> port=3306
> sock=/tmp/mysql.sock
> userfield=1
>
> But when I start asterisk (1.4 on my test machine), I get:
>
>   == Parsing '/etc/asterisk/cdr_mysql.conf': Found
> [Aug  6 21:01:14] ERROR[32512]: cdr_addon_mysql.c:436 my_load_module:
> Failed to connect to mysql database asteriskcdrdb on localhost.
> cdr_addon_mysql.so => (MySQL CDR Backend)
> [Aug  6 21:01:14] ERROR[32512]: res_config_mysql.c:627
mysql_reconnect:
> MySQL RealTime: Failed to connect database server  on  (err 2002).
Check
> debug for more info.
> [Aug  6 21:01:14] WARNING[32512]: res_config_mysql.c:474 load_module:
> MySQL RealTime: Couldn't establish connection. Check debug.
> [Aug  6 21:01:14] NOTICE[32512]: config.c:1171
> ast_config_engine_register: Registered Config Engine mysql
> MySQL RealTime driver loaded.
> res_config_mysql.so => (MySQL RealTime Configuration Driver)
>
>
> I'm also looking as to what CDR viewers there are available, and which
> people think are best.  I want to view/report on the calls made within
> A*k.
>
> Thanks,
>
> Adrian
>
> ___
> --Bandwidth and Colocation Provided by http://www.api-digital.com--
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>http://lists.digium.com/mailman/listinfo/asterisk-users
>


-- 
***
Forrest Beck
IAXTEL: 17002871718
[EMAIL PROTECTED]
http://www.shift8.biz

___
--Bandwidth and Colocation Provided by http://www.api-digital.com--

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--

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR/MySQL basic config

[Forrest Beck]

Adrian,

What host/ip did you specify when you created the user?

#> mysql --user=root --password

#mysql> use mysql;

#mysql> select Host from user where User = 'asteriskcdruser'
(this line is case sensitive)

Does it return 127.0.0.1 or localhost.  Make cdr_mysql reflect that.

You should also check out cdr_odbc, asterisk can connect through an
ODBC connection which in turn is a connection to the MySQL database.
There seems to be more suport for the ODBC driver.

Hope this helps some



On 8/6/07, Adrian Marsh <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install.  The
> add-ons pack has been installed for a while, so now I'm trying to add
> the Mysql config.
>
> I've created a mysql database, added the grants for a user acces, and
> can run a mysql -u asteriskcdruser -p and can connect to the database.
>
> I've been using this as a guide:
> http://www.757.org/~joat/wiki/index.php/Asterisk#Viewing_CDR_Data_with_A
> sterisk:_CDR_Analyzer
>
> I've created cdr_mysql.conf:
>
> [global]
> hostname=localhost
> dbname=asteriskcdrdb
> table=cdr
> password=password
> user=asteriskcdruser
> port=3306
> sock=/tmp/mysql.sock
> userfield=1
>
> But when I start asterisk (1.4 on my test machine), I get:
>
>   == Parsing '/etc/asterisk/cdr_mysql.conf': Found
> [Aug  6 21:01:14] ERROR[32512]: cdr_addon_mysql.c:436 my_load_module:
> Failed to connect to mysql database asteriskcdrdb on localhost.
> cdr_addon_mysql.so => (MySQL CDR Backend)
> [Aug  6 21:01:14] ERROR[32512]: res_config_mysql.c:627 mysql_reconnect:
> MySQL RealTime: Failed to connect database server  on  (err 2002). Check
> debug for more info.
> [Aug  6 21:01:14] WARNING[32512]: res_config_mysql.c:474 load_module:
> MySQL RealTime: Couldn't establish connection. Check debug.
> [Aug  6 21:01:14] NOTICE[32512]: config.c:1171
> ast_config_engine_register: Registered Config Engine mysql
> MySQL RealTime driver loaded.
> res_config_mysql.so => (MySQL RealTime Configuration Driver)
>
>
> I'm also looking as to what CDR viewers there are available, and which
> people think are best.  I want to view/report on the calls made within
> A*k.
>
> Thanks,
>
> Adrian
>
> ___
> --Bandwidth and Colocation Provided by http://www.api-digital.com--
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>http://lists.digium.com/mailman/listinfo/asterisk-users
>


-- 
***
Forrest Beck
IAXTEL: 17002871718
[EMAIL PROTECTED]
http://www.shift8.biz

___
--Bandwidth and Colocation Provided by http://www.api-digital.com--

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

Re: [asterisk-users] CDR - mysql with asterisk 1.2.12 not working

[Brian Rogan]

I know that this is a silly suggestion but you should check to make sure
that you actually have the cdr_mysql module, because at some point (I
believe at the 1.2 release or shortly thereafter), it was moved into
asterisk-addons.

--Brian

On Tue, Oct 10, 2006 at 08:31:43AM +0200, Garth van Sittert wrote:
> Joseph wrote:
> >On Mon, 2006-10-09 at 01:45 -0300, Hermann Wecke wrote:
> >  
> >>On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:
> >>
> >>>I have bind-address  = 127.0.0.1 in my.cnf
> >>>the cdr was working find with asterisk 1.0.1 just after upgrade
> >>>something is not connecting.
> >>>  
> >>I don't know if asterisk will use the localhost or the "network" IP to
> >>connect. Just try to comment your line and see what happens. This is 
> >>really
> >>a guess... 
> >>
> >
> >Make no difference if I use IP or "localhost" it is still not
> >connecting; it could be something with the cdr_addon_mysql.so
> >
> >Anybody has any other ideas / suggestions?
> >
> >  
> Have you tried turning on debug in logger.conf.  You should be able to 
> see what is wrong from there.
> 
> Kind Regards
> Garth
> 
> ___
> --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 with asterisk 1.2.12 not working

[Garth van Sittert]

Joseph wrote:

On Mon, 2006-10-09 at 01:45 -0300, Hermann Wecke wrote:
  

On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:


I have bind-address  = 127.0.0.1 in my.cnf
the cdr was working find with asterisk 1.0.1 just after upgrade
something is not connecting.
  

I don't know if asterisk will use the localhost or the "network" IP to
connect. Just try to comment your line and see what happens. This is really
a guess... 



Make no difference if I use IP or "localhost" it is still not
connecting; it could be something with the cdr_addon_mysql.so

Anybody has any other ideas / suggestions?

  
Have you tried turning on debug in logger.conf.  You should be able to 
see what is wrong from there.


Kind Regards
Garth

___
--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 with asterisk 1.2.12 not working

[Joseph]

On Mon, 2006-10-09 at 01:45 -0300, Hermann Wecke wrote:
> On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:
> > I have bind-address  = 127.0.0.1 in my.cnf
> > the cdr was working find with asterisk 1.0.1 just after upgrade
> > something is not connecting.
> 
> I don't know if asterisk will use the localhost or the "network" IP to
> connect. Just try to comment your line and see what happens. This is really
> a guess... 

Make no difference if I use IP or "localhost" it is still not
connecting; it could be something with the cdr_addon_mysql.so

Anybody has any other ideas / suggestions?

-- 
#Joseph
___
--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 with asterisk 1.2.12 not working

[Hermann Wecke]

On Sun, Oct 08, 2006 at 10:39:26PM -0600, Joseph wrote:
> I have bind-address  = 127.0.0.1 in my.cnf
> the cdr was working find with asterisk 1.0.1 just after upgrade
> something is not connecting.

I don't know if asterisk will use the localhost or the "network" IP to
connect. Just try to comment your line and see what happens. This is really
a guess... 
___
--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 with asterisk 1.2.12 not working

[Joseph]

On Mon, 2006-10-09 at 01:13 -0300, Hermann Wecke wrote:
> On Sun, Oct 08, 2006 at 10:04:51PM -0600, Joseph wrote:
> > What am I missing?
> 
> Maybe your /etc/mysql/my.cnf ?
> 
> # Instead of skip-networking you can listen only on
> # localhost which is more compatible and is not less secure.
> # bind-address  = 127.0.0.1
> #skip-networking

I have bind-address  = 127.0.0.1 in my.cnf

the cdr was working find with asterisk 1.0.1 just after upgrade
something is not connecting.

-- 
#Joseph
___
--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 with asterisk 1.2.12 not working

[Hermann Wecke]

On Sun, Oct 08, 2006 at 10:04:51PM -0600, Joseph wrote:
> What am I missing?

Maybe your /etc/mysql/my.cnf ?

# Instead of skip-networking you can listen only on
# localhost which is more compatible and is not less secure.
# bind-address  = 127.0.0.1
#skip-networking
___
--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]

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 
Discussion

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 
;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 
Discussion
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 
Discussion

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

[Rich Adamson]

> > 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

[Diyanat Ali]

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 
Discussion

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

[Christian Victor]

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

[Doug Lytle]

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

[Juanjo Portela]

Thank you Traci,I put this two variables in my .conf file and it works!!!Well, It seems that this variables are not necessaries in old versions, but in newest ones.Thank you again,Juanjo
>I believe you are missing 2 variables in your conf file:>>>table=cdr>(the table your cdrs should be stored)>>sock=/var/lib/mysql/mysql.sock>(the location to your mysql.sock
)>>try something like this:>>[global]>hostname=localhost>dbname=dbasterisk>table=cdr>password=dbpassword>user=dbuser>sock=/var/lib/mysql/mysql.sock
>userfield=1
___
--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

[tracinet]

Instead of hostname=localhost, it would be hostname=IP address of MySQL server.On 12/12/05, 
Innocent Evil <[EMAIL PROTECTED]> wrote:
I was also following this thread.
Would anybody please tell, what would be configuration file if mysql is a different machine than asterisk box?
 
Thanks,
 
 
--You don't have any choice, you already made it before you came here.

-Original Message-From: [EMAIL PROTECTED]Sent: Mon, 12 Dec 2005 21:16:23 -0500
To: asterisk-users@lists.digium.comSubject: Re: [Asterisk-Users] CDR MySQL


I believe you are missing 2 variables in your conf file:table=cdr(the table your cdrs should be stored)sock=/var/lib/mysql/mysql.sock(the location to your mysql.sock)try something like this:
[global]hostname=localhostdbname=dbasterisktable=cdrpassword=dbpassworduser=dbusersock=/var/lib/mysql/mysql.sockuserfield=1
On 12/12/05, Juanjo Portela <[EMAIL PROTECTED]
> wrote:
My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow[global]
hostname=localhostdbname=dbasteriskpassword=dbpassworduser=dbuseruserfield=1Any ideas?Thank you in advance, Juanjo___--Bandwidth and Colocation provided by 
Easynews.com --Asterisk-Users mailing listTo UNSUBSCRIBE or update options visit:    
http://lists.digium.com/mailman/listinfo/asterisk-users
___--Bandwidth and Colocation provided by Easynews.com
 --Asterisk-Users mailing listTo 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

[Innocent Evil]

I was also following this thread.
Would anybody please tell, what would be configuration file if mysql is a different machine than asterisk box?
 
Thanks,
 
 
--You don't have any choice, you already made it before you came here.

-Original Message-From: [EMAIL PROTECTED]Sent: Mon, 12 Dec 2005 21:16:23 -0500To: asterisk-users@lists.digium.comSubject: Re: [Asterisk-Users] CDR MySQL

I believe you are missing 2 variables in your conf file:table=cdr(the table your cdrs should be stored)sock=/var/lib/mysql/mysql.sock(the location to your mysql.sock)try something like this:[global]hostname=localhostdbname=dbasterisktable=cdrpassword=dbpassworduser=dbusersock=/var/lib/mysql/mysql.sockuserfield=1
On 12/12/05, Juanjo Portela <[EMAIL PROTECTED]> wrote:
My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow[global]hostname=localhostdbname=dbasteriskpassword=dbpassworduser=dbuseruserfield=1Any ideas?Thank you in advance, Juanjo___--Bandwidth and Colocation provided by Easynews.com --Asterisk-Users mailing listTo 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

[tracinet]

I believe you are missing 2 variables in your conf file:


table=cdr
(the table your cdrs should be stored)

sock=/var/lib/mysql/mysql.sock
(the location to your mysql.sock)

try something like this:

[global]
hostname=localhost
dbname=dbasterisk
table=cdr
password=dbpassword
user=dbuser
sock=/var/lib/mysql/mysql.sock
userfield=1On 12/12/05, Juanjo Portela <[EMAIL PROTECTED]> wrote:
My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow[global]hostname=localhostdbname=dbasteriskpassword=dbpassworduser=dbuseruserfield=1Any ideas?Thank you in advance,
Juanjo___--Bandwidth and Colocation provided by Easynews.com --Asterisk-Users mailing listTo 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

[Patrick]

On Mon, 2005-12-12 at 20:33 -0500, Robert Webb wrote:
[snip]
> Maybe if people weren't so quick to jump to conclusions, 
> they would see that some did actually ask a question 
> before and were now supplying the answer.
> 
> http://lists.digium.com/pipermail/asterisk-users/2005-December/138183.html

That message had not arrived in my mailbox. I saw mine on the list at
2:25 and that one arrived at 2.34. If I had seen the reply before
sending mine than you definitely would have had a point. But then again
you would not have seen my reply :)

Regards,
Patrick
___
--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

[KRTorio]

Is your mysql server running locally the same time your starting asterisk?On 12/12/05, Juanjo Portela <[EMAIL PROTECTED]
> wrote:My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow
[global]hostname=localhostdbname=dbasteriskpassword=dbpassworduser=dbuseruserfield=1Any ideas?Thank you in advance,Juanjo___--Bandwidth and Colocation provided by 
Easynews.com --Asterisk-Users mailing listTo 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

[Robert Webb]

On Tue, 13 Dec 2005 02:25:50 +0100
 Patrick <[EMAIL PROTECTED]> wrote:

On Mon, 2005-12-12 at 22:08 -0300, Juanjo Portela wrote:
My cdr_mysql.conf is the same I was using for 
version.1.0.9 and it is as follow

[global]
hostname=localhost
dbname=dbasterisk
password=dbpassword
user=dbuser
userfield=1
Any ideas?


Any ideas about what? The weather? Specify your question 
in more detail

so people don't have to guess what you are asking.

Regards,
Patrick



Maybe if people weren't so quick to jump to conclusions, 
they would see that some did actually ask a question 
before and were now supplying the answer.


http://lists.digium.com/pipermail/asterisk-users/2005-December/138183.html
___
--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

[Patrick]

On Mon, 2005-12-12 at 22:08 -0300, Juanjo Portela wrote:
> My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as 
> follow
> [global]
> hostname=localhost
> dbname=dbasterisk
> password=dbpassword
> user=dbuser
> userfield=1
> Any ideas?

Any ideas about what? The weather? Specify your question in more detail
so people don't have to guess what you are asking.

Regards,
Patrick
___
--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

[Juanjo Portela]

My cdr_mysql.conf is the same I was using for version.1.0.9 and it is as follow
[global]
hostname=localhost
dbname=dbasterisk
password=dbpassword
user=dbuser
userfield=1
Any ideas?
Thank you in advance,
Juanjo
___
--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

[tracinet]

What does your /etc/asterisk/cdr_mysql.conf look like?
On 12/12/05, Juanjo Portela <[EMAIL PROTECTED]> wrote:
Dear Tomislav & Colleagues,
 
I read your post in the Astersik-list about you can not compile the cdr_mysql on Asterisk 1.2
Well, I have a similar problem.
I compiled the cdr_mysql module, but when i start Asterisk the following error appears:
 
Dec 12 18:03:33 WARNING[7237]: loader.c:325 __load_resource: /usr/lib/asterisk/modules/cdr_addon_mysql.so: undefined symbol: ast_loadDec 12 18:03:33 WARNING[7237]: loader.c:554 load_modules: Loading module cdr_addon_mysql.so failed!

 
And Asterisk stops.
 
Any ideas?
 
Thank you in advance,
Juanjo

___--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing listTo 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

[Jozeph Brasil]

Hi Steve,

Thank you for reply! :) Do you know if anyone have been patched to solve this?

Quoting Steve Davies <[EMAIL PROTECTED]>:


I do not know for sure, but in my experience, the most common cause of
this error is an application which assumes a database connection will
stay open forever.

Some MySQL installs have a timeout on idle connections. It should be
possible to set this to a very-long or infinite timeout.

Hope that helps,
Steve

On 10/5/05, Jozeph Brasil <[EMAIL PROTECTED]> wrote:




Hi Asteriskers!



I've enable CDR to store data on a remote machine using MySQL. But I have a
problem. Analyzing the log, I see some ERROR messages as:



-- SIP/21-3787 is ringing

  == Spawn extension (default, 21, 1) exited non-zero on 'SIP/21-ce14'

Oct  5 13:22:54 ERROR[8576]: cdr_addon_mysql.c:161 mysql_log: cdr_mysql:
Unknown connection error: (2013) Lost connection to MySQL server during
query



This occurs every time that extension hangs up the call. Anyone know why
asterisk lost connection during query?
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:

http://lists.digium.com/mailman/listinfo/asterisk-users



___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users





___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
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

[Steve Davies]

I do not know for sure, but in my experience, the most common cause of
this error is an application which assumes a database connection will
stay open forever.

Some MySQL installs have a timeout on idle connections. It should be
possible to set this to a very-long or infinite timeout.

Hope that helps,
Steve

On 10/5/05, Jozeph Brasil <[EMAIL PROTECTED]> wrote:
>
>
>
> Hi Asteriskers!
>
>
>
> I've enable CDR to store data on a remote machine using MySQL. But I have a
> problem. Analyzing the log, I see some ERROR messages as:
>
>
>
> -- SIP/21-3787 is ringing
>
>   == Spawn extension (default, 21, 1) exited non-zero on 'SIP/21-ce14'
>
> Oct  5 13:22:54 ERROR[8576]: cdr_addon_mysql.c:161 mysql_log: cdr_mysql:
> Unknown connection error: (2013) Lost connection to MySQL server during
> query
>
>
>
> This occurs every time that extension hangs up the call. Anyone know why
> asterisk lost connection during query?
> ___
> --Bandwidth and Colocation sponsored by Easynews.com --
>
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
___
--Bandwidth and Colocation sponsored by Easynews.com --

Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
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

[Scott Stingel]

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

[Matthew Boehm]

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

[Guido Rebert]

Did you checkout permissions, mysql running?

Guido Rebert
Network Manager
GrupoPyD - +54 11 4800


-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] En nombre de Altus Snyman
Enviado el: Viernes, 12 de Noviembre de 2004 08:30 a.m.
Para: Asterisk Users Mailing List - Non-Commercial Discussion
Asunto: [Asterisk-Users] cdr mysql


Good day all
What do i need,and need to do,from the beginig to get the cdr into a 
database
I installed asteris,mysql and mysl-dev..
I got the asterisk-addons
I made a make and it said it could not find asterisk.h
so I copyed asteris.h from my installed file to /user/include
I then followed theis howto http://www.voip-info.org/wiki-Asterisk+cdr+mysql
and chane the conf files with the same usernames ens.But this is the 
error I get"
Nov 12 13:52:04 ERROR[79866800]: cdr_addon_mysql.c:122 mysql_log: 
cdr_mysql: cannot connect to database server 192.168.21.127.  Call will 
not be logged"
Please Help



___
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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004
 

___
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

[Tjapko Smits]

Maybe check the mysql log. Is there any usefull info here that can
trigger you to solve your problem? 
Tjapko.


On Wed, 2004-05-12 at 22:06, Eng. Vanzetti Walter wrote:
> Hi Roger!
> the databse i have created has all the immaginable permission.if i try to
> access it with dbtools with the
> username and the password of asterisk from another pc inside the network, i can
> see the table
> and i can read/write. Only * can't write into the table. So,cecking the conf
> file and the username, password and domain are ok. Need to configure other
> modules?or the information passed by sip are incorrect? I use a budgettone grand
> stream and msn client it make me crazy
> regards
> Walter
> 
> > Hi,
> >
> > when everthing is according to the Wiki's mysql_cdr pages,
> > it should work.
> >
> > Please check permissions!
> > (Insert permission granted to the user as defined in
> > cdr_mysql.conf? Even if other host, respectively even
> > if same host? Did you realize, that host '%' does not
> > include localhost in mysql?)
> >
> >
> > Roger.
> 
> 
> 
> ___
> 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

[Roger Schreiter]

Eng. Vanzetti Walter schrieb:
...
The cdr table is the same reported in Wiki's link.
where is the problem?
.
...
Hi,

when everthing is according to the Wiki's mysql_cdr pages,
it should work.
Please check permissions!
(Insert permission granted to the user as defined in
cdr_mysql.conf? Even if other host, respectively even
if same host? Did you realize, that host '%' does not
include localhost in mysql?)
Roger.

___
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

[Joe Dennick]

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

RE: RE: [Asterisk-Users] cdr mysql problem

[Tomica Crnek]

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: [Asterisk-Users] cdr mysql problem

[Tilghman Lesher]

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

[dipak0105]

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: [Asterisk-Users] cdr mysql problem

[Tomica Crnek]

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

[Tilghman Lesher]

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

RE: [Asterisk-Users] cdr mysql problem

[Tomica Crnek]

 

-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

[Steven Critchfield]

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