Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[Callweaver-users] MySQL Bind IP


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> CallWeaver Users
View previous topic :: View next topic  
Author Message
dst_u at yahoo.com
Guest





PostPosted: Fri Feb 06, 2009 8:39 am    Post subject: [Callweaver-users] MySQL Bind IP Reply with quote

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
Back to top
vabdulla at gmail.com
Guest





PostPosted: Fri Feb 06, 2009 4:09 pm    Post subject: [Callweaver-users] MySQL Bind IP Reply with quote

Hello David,

On Fri, Feb 6, 2009 at 2:38 PM, David <dst_u@yahoo.com> wrote:
Quote:
[...]

Can I do anything to force the queries to go from one IP?

I am not sure to fully understand your need but if you want to force
traffic through one iface, you should set the linux kernel routing
accordingly: with the "route add" command you can specify through
which iface to send traffic for a specific ip or sub-network.

Regards,
- vma
.
_______________________________________________
Callweaver-users mailing list
Callweaver-users@callweaver.org
http://lists.callweaver.org/mailman/listinfo/callweaver-users
Back to top
Alex.Lopez at opsys.com
Guest





PostPosted: Sat Feb 07, 2009 11:51 am    Post subject: [Callweaver-users] MySQL Bind IP Reply with quote

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: callweaver-users-bounces@callweaver.org [mailto:callweaver-users-bounces@callweaver.org] 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
Back to top
dst_u at yahoo.com
Guest





PostPosted: Sat Feb 07, 2009 4:37 pm    Post subject: [Callweaver-users] MySQL Bind IP Reply with quote

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 <Alex.Lopez@opsys.com>
To: Users Mailing List - Non-Commercial Discussion <callweaver-users@callweaver.org>
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: callweaver-users-bounces@callweaver.org [mailto:callweaver-users-bounces@callweaver.org] 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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> CallWeaver Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services