Topic: How to store VirtualHosts in MySQL

[blaze]

Hello!

Please, help me to solve the problem, how to store VitrualHosts in MySQL?

Apache: 2.2.9
OS: Windows

I saw that Apache has module mod_dbd, but I couldn't find any helpful information about that. If you know how does it works, or any other ways, please tell me!

Thank you!

[James Blond]

There is a good how to in our forum. http://www.apachelounge.com/viewtopic.php?t=2210

if you still have a question please post here again.

[blaze]

Thank you!
I found that topic very useful!

But I have a question.
How can I store other parameters of VirtualHost?

For example I have this VitrualHost:

[tdonovan]

If you use mod_vhost_dbd, you can only set the document root from the database.

ServerAlias is easily handled by creating two rows in the database: one for example.com and another row for www.example.com.
Both should return the same document root: C:/Apache/htdocs/example.com/www.

For directives which can accept httpd environment variables, like Header and Allow from env=, you can return extra columns in your SQL queries which are converted into environment variables.

Unfortunately, PHP directives like php_admin_value can only be set at Apache startup. They cannot be changed "on-the-fly" by a module like mod_vhost_dbd. That is why you cannot put php_admin_value in a .htaccess file either.

-tom-

[James Blond]

For me mod_macro was a good start for some fast standart configuration. There is only the pitty a of restart.

[randriese]

i'm having problems with the AllowOverride All.

i understand that the mod_vhost_dbd.so only adds the DocumentRoot, but is it also possible to add the AllowOverride directive? I really need it because otherwise this whole system doesn't work for me

I need to have dynamic vhosts, based on a MySQL result and each dynamic host should read the .htaccess file in it's folder.

anyone got any idea's?