Joseph
2006-Oct-08 21:07 UTC
[asterisk-users] CDR - mysql with asterisk 1.2.12 not working
I just upgraded to asterisk 1.2.12 from 1.0.1 and I can not get cdr - mysql to load I've install asterisk-addon and have cdr_addon_mysql.so in module directory In modules.conf I have: preload => cdr_addon_mysql.so Should it be "load" or "preload"? In cdr_mysql.conf (nothing has changed) [global] hostname=localhost dbname=asteriskcdrdb password=123654 user=asteriskcdruser In logs I can see the error: cdr_addon_mysql.c: cdr_mysql: cannot connect to database server localhost Though when I type from commend line: mysql -uasteriskcdruser -h localhost -p123654 mysql> I can get in just fine. What am I missing? -- #Joseph
Hermann Wecke
2006-Oct-08 21:14 UTC
[asterisk-users] CDR - mysql with asterisk 1.2.12 not working
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
Joseph
2006-Oct-08 21:38 UTC
[asterisk-users] CDR - mysql with asterisk 1.2.12 not working
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-networkingI 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