Hi Alex, It seems to me that the bind address in this file is for listening only and not for sending queries, but I'll test it anyway.
Thank you for your help. David ________________________________ From: Alexander Lopez <[email protected]> To: Users Mailing List - Non-Commercial Discussion <[email protected]> Sent: Saturday, February 7, 2009 6:51:14 PM Subject: Re: [Callweaver-users] MySQL Bind IP A bit OT but lokk in you’re my.cnf file weither under /etc or /etc/mysql, etc, (Depends on your distro) Add 'bind-address = 127.0.0.1' Or the address of your NIC instead of the loopback. Alex ________________________________ From:[email protected] [mailto:[email protected]] On Behalf Of David Sent: Friday, February 06, 2009 8:39 AM To: Users Mailing List - Non-Commercial Discussion Subject: [Callweaver-users] MySQL Bind IP Hello, My CW server is running on a server with 2 Network Interface Cards, and each of the cards has a unique IP address. Unlike the sip.conf, where I can force CW to use only one of the NICs in my server, MySQL queries are sent from the other NIC/IP address to the database server. This is my mysql conf file: # cat /etc/callweaver/res_mysql.conf ; ; Sample configuration for res_config_mysql.c ; ; The value of dbhost may be either a hostname or an IP address. ; If dbhost is commented out or the string "localhost", a connection ; to the local host is assumed and dbsock is used instead of TCP/IP ; to connect to the server. ; [general] dbhost = db2.mydmain.com dbname = callweaver dbuser = callweaver dbpass = callweaver dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock Can I do anything to force the queries to go from one IP? Thanks, David
_______________________________________________ Callweaver-users mailing list [email protected] http://lists.callweaver.org/mailman/listinfo/callweaver-users
