I don't know if I have something screwed up with my MYSQL installation/Asterisk install or a bad configuration. I have imported the tables into a MYSQL database residing on localhost. I have check permissions on the user as well as the password and I have the same error comin up. I have succesfully connected to the database remotely and with MYPHPAdmin with the same setting below is a copy of my cdr_mysql.conf [global] hostname=192.168.2.9 dbname=asteriskcdr user=asteriskcdr password=<password> port=3306 sock=/tmp/mysql.sock The error I am getting is: ERROR[1209214400]: File cdr_mysql.c, Line 71 (mysql_log): cdr_mysql: cannot connect to database server localhost. Call will not be logged. I am also getting this message though it might be unrelated: WARNING[1142106560]: File chan_sip.c, Line 435 (retrans_pkt): Maximum retries exceeded on call 1ec6564257f5e18b15c350742dcc5e68@192.168.2.9 for seqno 102 (Request)
Hi, There is a feature on our current voicemail system that we have become very used to using. We can set a phone number and when a message is received in the mailbox, it calls that phone number and when the call is answered, it asks for the password for that mailbox and then allows the person into the administration of their mailbox. We have this setup now with our cell phone numbers, so when we receive a voicemail at the office, it calls us immediately and allows us to listen to the messages. Any chance of getting this "feature" added (preferrable as another option on each mailbox setting in voicemail.conf (after the pager # maybe))? I know it could be "hacked", but I am trying to avoid those type of improvements. :) Travis Microserv
On Sunday 14 September 2003 20:36, asterisk@kcwebpro.net wrote:> I don't know if I have something screwed up with my MYSQL > installation/Asterisk install or a bad configuration. I have > imported the tables into a MYSQL database residing on localhost. I > have check permissions on the user as well as the password and I have > the same error comin up. I have succesfully connected to the > database remotely and with MYPHPAdmin with the same setting below is > a copy of my cdr_mysql.conf > > [global] > hostname=192.168.2.9 > dbname=asteriskcdr > user=asteriskcdr > password=<password> > port=3306 > sock=/tmp/mysql.sock > > > The error I am getting is: > ERROR[1209214400]: File cdr_mysql.c, Line 71 (mysql_log): cdr_mysql: > cannot connect to database server localhost. Call will not be > logged.Uh, are you sure this is your configuration? It says it's trying to connect to localhost, but you have a non-localhost IP in the hostname field. Try changing that to the word "localhost". Also try from the command line: mysql -uasteriskcdr -h 192.168.2.9 -p asteriskcdr and see if it connects (or denies you). Also, check to see if /tmp/mysql.sock is the connecting sock file and not /var/lib/mysql/run/mysql.sock (which is the case on some distros).> I am also getting this message though it might be unrelated: > WARNING[1142106560]: File chan_sip.c, Line 435 (retrans_pkt): Maximum > retries exceeded on call 1ec6564257f5e18b15c350742dcc5e68@192.168.2.9 > for seqno 102 (Request)Nope, unrelated. -Tilghman