[Asterisk-Users] CDR problems with MySQL

[Joshua McClintock]

Can you connect to mysql from the command line with the user/pass you
setup?

Also, when you test make sure you add: -h localhost to the flags you
pass 'mysql'.  This will make sure it doesn't try connecting via the
unix domain socket.  The permissions in the 'mysql' db may be set not to
allow localhost connections, but unix domain sockets are allowed.

So try this:

mysql -h localhost -u <user> -p -d <dbname>

On Fri, 2004-08-20 at 13:14, Chris HARIGA wrote:
> Hi,
> 
> The same error:((
> 
> Aug 20 16:13:39 ERROR[278544]: cdr_addon_mysql.c:378 my_load_module: Failed
> to connect to mysql database asteriskcdrdb on localhost.
> 
> 
> Best regards,
> 
> Chris HARIGA
> 
> 
> -----Original Message-----
> From: asterisk-users-admin at lists.digium.com
> [mailto:asterisk-users-admin at lists.digium.com] On Behalf Of Malcolm Bader
> Sent: Friday, August 20, 2004 4:02 PM
> To: asterisk-users at lists.digium.com
> Subject: Re: [Asterisk-Users] CDR problems with MySQL
> 
> Did you create a user for the asteriskcdrbd?
> In my case I created a user asteriskuser with all priviages and gave it 
> a password.
> Then entered that info, user name and password, into 
> /etc/asterisk/cdr-mysql.conf
> Malcolm
> 
> Chris HARIGA wrote:
> 
> > Hi,
> >
> > I have Fedora Core 2 running with a T1 card. I try to put the log on 
> > db but I get the error:
> >
> > Aug 20 15:17:47 ERROR[262160]: cdr_addon_mysql.c:378 my_load_module: 
> > Failed to connect to mysql database asteriskcdrdb on localhost.
> >
> > The database exists and I try with "mysqlaccess localhost 
> > asteriskcdrdb" and I get:
> >
> > Access-rights for USER 'localhost', from HOST 'localhost', to DB 
> > 'asteriskcdrdb'
> >
> > BEWARE: Everybody can access your DB as user `localhost' from host 
> > `localhost'
> >
> > : WITHOUT supplying a password.
> >
> > : Be very careful about it!!
> >
> > BEWARE: Accessing the db as an anonymous user.
> >
> > : Your username has no relevance
> >
> > Any suggestions are welcome.
> >
> > Best regards,
> >
> > Chris HARIGA
> >
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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