Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 18th December 2008, 11:12
barney.parker barney.parker is offline
Junior Member
 
Join Date: Jun 2007
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Apache VirtualHosts with mySQL

Hi,

I remember seeing a tutorial on howtoforge some time back about setting up apache to allow multiple web sites through the virtualhosts entries in it's conf files. The tutorial extended this by using data in a MySQL database nstead of the static conf file, so changes didn't require an apache restart.

After searching around all morning i can't seem to find it anywhere!!!

Does anyone have a link to this tutorial or something similar? I'm not bothered about email however if it's included in the tutorial thats OK.

Thanks in advance for any help anyone can give pointing me in the right direction!!!

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 18th December 2008, 11:35
zcworld zcworld is offline
Senior Member
 
Join Date: Jul 2006
Location: South Australia
Posts: 329
Thanks: 2
Thanked 37 Times in 37 Posts
Send a message via MSN to zcworld Send a message via Skype™ to zcworld
Default

as far as i know that cant be done ...
but thats only to what i know

maybe it could / can be done ... it will be diff to see apache vhost conf done via mysql backend but
you would still need to restart / rehash apache to get it to load the new sites / any changes that are made to the database conf file


so i done really see a point to trying to run apache vhost conf from mysql
.. just my pov on the topic sorry to be a tad down on it

as long as you tell apache to restart it shouldn't take any sites offline / any downloading file to stop downloading from your sites
__________________
Shane Ebert :: Facebok
Reply With Quote
  #3  
Old 18th December 2008, 12:28
barney.parker barney.parker is offline
Junior Member
 
Join Date: Jun 2007
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, maybe i have got something confused.

How would somehting such as ISPConfig handle a new domain being added? Would it Apache seriously expect a restart just to add a new site?

Essentially what i want to do is have a database back end which defines the domains pointing to this server, a list of users (associated to domains) with all their priviliges etc, and automatically have Apache, ProFTP, MySQL and probably a mail system automatically use this information to manage access.

Last edited by barney.parker; 18th December 2008 at 13:23.
Reply With Quote
  #4  
Old 18th December 2008, 13:39
zcworld zcworld is offline
Senior Member
 
Join Date: Jul 2006
Location: South Australia
Posts: 329
Thanks: 2
Thanked 37 Times in 37 Posts
Send a message via MSN to zcworld Send a message via Skype™ to zcworld
Default

i know the ISPconfig pack
runs two ver of apache
one is running the admin control panel
and one is running the normal www / sites

when you add new host / domain
as far as i know its restart apache on the fly

but you have to want and get a good answer from one of the ISPconfig dev
__________________
Shane Ebert :: Facebok
Reply With Quote
  #5  
Old 18th December 2008, 14:35
barney.parker barney.parker is offline
Junior Member
 
Join Date: Jun 2007
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, so potentially the only way would be to have a script that generates new conf files on every change....

seems like a shame really to have to activate a script to update things that are already updated elsewhere....

Am i right in thinking however that Postfix et al can use a MySQL Backend for mail delivery and management on multiple domains?

Also, from some of the how-to's on this site it seems ProFTP will do the same?

It seems a real shame you can't make all three work together in a simplified manner from a single database....

or have i missed something completely? (it wouldn't be the first time!!!)
Reply With Quote
  #6  
Old 19th December 2008, 17:03
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
Default

Quote:
Originally Posted by barney.parker View Post
Hi,

I remember seeing a tutorial on howtoforge some time back about setting up apache to allow multiple web sites through the virtualhosts entries in it's conf files. The tutorial extended this by using data in a MySQL database nstead of the static conf file, so changes didn't require an apache restart.

After searching around all morning i can't seem to find it anywhere!!!
I don't think we have such a tutorial (at least I don't remember). There once was a project that tried to create an Apache module that allowed to store vhosts in a MySQL database, but I think it's dead now.
__________________
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
  #7  
Old 19th December 2008, 18:18
Leszek Leszek is offline
Senior Member
 
Join Date: Nov 2006
Location: Poland,Włocławek
Posts: 369
Thanks: 22
Thanked 42 Times in 35 Posts
Send a message via Skype™ to Leszek
 
Default

As far as I remember there was a module like that for Apache 1.x but not for 2.x
I was looking for it to but gave up after some time.
There is a howto here about Lighttpd using MySQL.
Maybe at least that would be useful for You.
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
Problem Installing Apache 2.2.8, MySQL 5.0 Client and PHP 5.2.5 On Fedora 8 (64-Bit) asyadiqin Installation/Configuration 5 10th April 2008 18:40
CENTOS 5 Ping Problem gAnDo Server Operation 11 28th March 2008 20:58
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Problem with the installation of Dokeos (LMS) in ISPConfig jofranco General 4 28th April 2006 00:45
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 13:32.


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