Hi, I try to connect with -h and is working. Now I will try to create other db and I will see... :(
Chris HARIGA -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joshua McClintock Sent: Friday, August 20, 2004 4:23 PM To: [EMAIL PROTECTED] Subject: RE: [Asterisk-Users] CDR problems with MySQL 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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Malcolm Bader > Sent: Friday, August 20, 2004 4:02 PM > To: [EMAIL PROTECTED] > 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 > [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 _______________________________________________ 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