asterisk users - Aug 2004 - CDR problems with MySQL

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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20040820/c5d7b8df/attachment.htm

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
>