Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th August 2007, 23:06
4integration 4integration is offline
Member
 
Join Date: Dec 2006
Posts: 44
Thanks: 0
Thanked 2 Times in 1 Post
Default MySQL, IP address and bind-address

Hello,

I have a server where I am running MySQL, Postfix, Dovecot and postfixAdmin. This setup is done according to the guide http://www.howtoforge.com/virtual_us...ix_debian_etch (and other). This setup are based upon MySQL configuration with
Quote:
bind-address = 127.0.0.1
and Postfix are using the database towards localhost/127.0.0.1.

I have also HTTP server with applications that are using MySQL without problem.

Now I want to run a multimedia server (MythTV backend) since the server have unused capacity and also fit my need. This will also use MySQL (which works fine with the bind-address above.

Then the media players/clients (MythTV frontends) have also need of connecting the database but then I get problems with the bind-address since that are configured to 127.0.0.1.

Without thinking I changed it to the real IP (192.168.1.2) and MythTV started to work (remote clients could connect) BUT didn't realize that Postfix stopped working

Will it be any problem of changing the IP address that Postfix and Amavis are using to the real IP??
__________________
Best Regards
4 Integration
Reply With Quote
Sponsored Links
  #2  
Old 28th August 2007, 20:20
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

Just comment out the bind-address line and restart MySQL.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 28th August 2007, 23:05
4integration 4integration is offline
Member
 
Join Date: Dec 2006
Posts: 44
Thanks: 0
Thanked 2 Times in 1 Post
Default

And it becomes less secure, right?!
__________________
Best Regards
4 Integration
Reply With Quote
  #4  
Old 29th August 2007, 19:58
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
 
Default

Connections from outside would then be possible, yes. But you can use the mysql.host table to define what system is allowed to do what.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Loop To Myself With Postfix, Courier, MySQL Setup asyadiqin Server Operation 13 12th November 2010 06:35
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 13:20
External DNS request BIND jdhaig Installation/Configuration 6 17th July 2007 21:32
saslauthd problem: bind: Address already in use fitti70 Server Operation 4 14th May 2007 22:51
Question about Bind and ISP-COnfig Firewall denmaus Installation/Configuration 1 23rd February 2007 17:00


All times are GMT +2. The time now is 22:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.