asterisk users - Aug 2005 - RealTime ignoringswitch=>Realtime/context@re altime_ext

On Wed, 24 Aug 2005 14:47:25 -0400
  "Araba, Michael" <maraba@QuikCAT.com>
wrote:
> Thanks John, You are my savior. This is such a great 
>relief. Apparently
> realtime will not use either '127.0.0.1' or 'localhost' 
>to connect to the
> database. I had to use the actual IP address attached to 
>the NIC before it
> worked. 
> 
<SNIP>

You claim it is an Asterisk issue, did you by any chance 
make sure that database was allowing connections on 
127.0.0.1 and localhost and not just the actual IP??

Robert

Thanks John, You are my savior. This is such a great relief. Apparently
realtime will not use either '127.0.0.1' or 'localhost' to
connect to the
database. I had to use the actual IP address attached to the NIC before it
worked. 

My OS is Debian just a note and Asterisk HEAD from August 20, 2005

Details below for those who might be swimming in the same pool with me.
________________________________
res_mysql.conf settings
[general]
dbhost = <IP Address>
dbname = RealTimeMaster
dbuser = xxxxxxx
dbpass = xxxxxxx
dbport = 3306
dbsock = /tmp/mysql.sock

extconf.conf
[settings]
voicemail => mysql,RealTimeMaster,voicemail
sipusers => mysql,RealTimeMaster,sip_buddies
sippeers => mysql,RealTimeMaster,sip_buddies
queues => mysql,RealTimeMaster,queue
queue_members => mysql,RealTimeMaster,queue_member

cdr_mysql.conf
[global]
hostname=localhost
dbname=RealTimeMaster
table=cdr
password=xxxxx
user=xxxxxx
;port=3306
;sock=/tmp/mysql.sock
;userfield=1

Two of us swam in that pool for some hours.
Trying every possible combo until we  hit on the correct one.
I was simply trying to get the CDR to work with mysql, and my buddy 
wanted that as well as realtime. It isn't JUST realtime, but something 
in Asterisk. He has HEAD from late January, I from late February, and 
yours is pretty current.

Perhaps someone smarter than us can add that information to the Wiki, or 
report it as a bug, or SOMETHING?

John Novack

Araba, Michael wrote:
>Thanks John, You are my savior. This is such a great relief. Apparently
>realtime will not use either '127.0.0.1' or 'localhost' to
connect to the
>database. I had to use the actual IP address attached to the NIC before it
>worked. 
>
>My OS is Debian just a note and Asterisk HEAD from August 20, 2005
>
>Details below for those who might be swimming in the same pool with me.
>________________________________
>res_mysql.conf settings
>[general]
>dbhost = <IP Address>
>dbname = RealTimeMaster
>dbuser = xxxxxxx
>dbpass = xxxxxxx
>dbport = 3306
>dbsock = /tmp/mysql.sock
>
>extconf.conf
>[settings]
>voicemail => mysql,RealTimeMaster,voicemail
>sipusers => mysql,RealTimeMaster,sip_buddies
>sippeers => mysql,RealTimeMaster,sip_buddies
>queues => mysql,RealTimeMaster,queue
>queue_members => mysql,RealTimeMaster,queue_member
>
>cdr_mysql.conf
>[global]
>hostname=localhost
>dbname=RealTimeMaster
>table=cdr
>password=xxxxx
>user=xxxxxx
>;port=3306
>;sock=/tmp/mysql.sock
>;userfield=1
>
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users@lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
>
>  
>