[asterisk-users] error messages related to mysql in asterisk CLI

[Jody Gugelhupf]

hi there :)
i get this error in the asterisk CLI:

Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql:
Unknown connection error:
(2006) MySQL server has gone away

when I run 'cdr mysql status' i get:
Connected to voiceone at localhost, port 3306 using table cdr for 18 minutes, 24 seconds.
  Wrote 8 records since last restart and 1 records since last reconnect.

I checked my /etc/asterisk/cdr_mysql.conf but don't know what is wrong, here is my
/etc/asterisk/cdr_mysql.conf:

[global]
hostname=localhost
dbname=voiceone
table=cdr
user=username
password=XXXXX
port=3306
sock=/var/run/mysqld/mysqld.sock
userfield=1

any ideas what i'm doing wrong?
thx jody :)




>Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql:
>Unknown connection error:
>(2006) MySQL server has gone away
>
>This part is more like  mistake in /etc/asterisk/cdr_mysql.conf . Check it
>once and relaod asterisk , then you can type "cdr mysql status" in cli to
>check if it connects to mysql properly .
>
>
>
>
>Sep 21 20:31:49 ERROR[3774]: cdr_csv.c:237 csv_log: Unable to re-open master
>file
>/var/log/asterisk//cdr-csv//Master.csv : Permission denied
>
>Permission error try chowning the directory to user  which asterisk runs on
>OR chmod 777 /var/log/asterisk/* -R
>
>Sep 21 20:31:49 ERROR[3774]: cdr_custom.c:127 custom_log: Unable to re-open
>master file
>/var/log/asterisk/cdr-custom/Master.csv : Permission denied
>
>Same permission error .
>

On 22/09/2007, Jody Gugelhupf <knueffle at yahoo.com> wrote:
>
> hi ppl, i have a problem, i get these messages in the asterisk CLI:
>
> Sep 21 20:31:49 ERROR[3774]: cdr_addon_mysql.c:159 mysql_log: cdr_mysql:
> Unknown connection error:
> (2006) MySQL server has gone away
>
> Sep 21 20:31:49 ERROR[3774]: cdr_csv.c:237 csv_log: Unable to re-open
> master file
> /var/log/asterisk//cdr-csv//Master.csv : Permission denied
>
> Sep 21 20:31:49 ERROR[3774]: cdr_custom.c:127 custom_log: Unable to
> re-open master file
> /var/log/asterisk/cdr-custom/Master.csv : Permission denied
>
> how can i fix these errors?
> here some info about my system:
>
> debian etch 4.0
> kernel:
> 2.6.18-4-686
> Asterisk 1.2.13
> VoiceOne version is v. 0.5.0 using plugin subsystem v. 0.4pre3
> mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
> PHP 4.4.4-8+etch4 (cli) (built: Jun 30 2007 21:02:54)
> using grandstream(handytone) 486 as sip device, no other devices or PSTN
> connected, only using
> sip/voip providers
> behind router/NAT
>
> thx in advance :)
> jody :)


      Ask a question on any topic and get answers from real people. Go to Yahoo! Answers and share what you know at http://ca.answers.yahoo.com