Hallo,
installiere gerade Gemeinschaft auf debian und es hakt bei mysql.Bekomme
im asterisk.log folgende Fehlermeldungen:
[Oct 25 22:34:26] ERROR[2293] res_config_mysql.c: MySQL RealTime: Failed
to connect database server asterisk on localhost (err 2002). Check debug
for more info.
[Oct 25 22:34:26] WARNING[2293] res_config_mysql.c: MySQL RealTime:
Couldn't establish connection. Check debug.
[Oct 25 22:34:26] NOTICE[2293] config.c: Registered Config Engine mysql.
[Oct 25 22:34:26] ERROR[2293] cdr_addon_mysql.c: Failed to connect to
mysql database asterisk on localhost.
Meine res_mysql.conf:
[general]
dbhost = localhost
dbname = asterisk
dbuser = gemeinschaft
dbpass = geheim
dbport = 3306
dbsock = /var/run/mysqld/mysqld.sock
Meine cdr_mysql.conf:
[global]
hostname=localhost
dbname=asterisk
table=cdr
password=geheim
user=gemeinschaft
port=3306
sock=/var/run/mysqld/mysqld.sock
userfield=1
mysql> status
--------------
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
Connection id: 24
Current database: asterisk
Current user: [EMAIL PROTECTED]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.32-Debian_7etch6-log Debian etch distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: utf8
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/run/mysqld/mysqld.sock
Benutzer für die asterisk.sql:
Benutzer Host Typ Rechte Grant
debian-sys-maint localhost global ALL PRIVILEGES Ja
gemeinschaft % global ALL PRIVILEGES Nein
root % global ALL PRIVILEGES Nein
root asterisk global ALL PRIVILEGES Ja
root localhost global ALL PRIVILEGES Ja
Gruß
Andre
