Re: mod_vhost_dbd

2009-02-15 Thread Dave Ingram
Hi Jorge, Something with the same name: http://code.google.com/p/dbd-modules/wiki/mod_vhost_dbd I don't know if that's what you're after, but I've written something vaguely similar but more flexible: http://www.dmi.me.uk/code/apache/mod_sqltemplate/ Hope this helps! Dave Jorge Bastos wro

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
Hi dave, Thanks, I'm looking at your proj also. What I am looking is, a completely independent module, so that I can create, decreate any virtualhost, just inserting and removing records from the DB. The values can be apache configurations, or any other. Yours can? I didn't got time to look at it

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
> Hi dave, > Thanks, > > I'm looking at your proj also. > > What I am looking is, a completely independent module, so that I can > create, > decreate any virtualhost, just inserting and removing records from the > DB. > The values can be apache configurations, or any other. > Yours can? I didn't

Re: mod_vhost_dbd

2009-02-15 Thread Dave Ingram
Jorge Bastos wrote: > Hi again Dave, > > Your is better than dbd! > Thanks -- it's always nice to be appreciated. Let me know if you hit any problems, as I don't have the resources to test it in lots of different situations. > I just see a problem for me, I have the need to tune values for php

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
> Thanks -- it's always nice to be appreciated. Let me know if you hit > any > problems, as I don't have the resources to test it in lots of different > situations. I'll :) > This is possible using mod_sqltemplate. Suppose in your database, you > have a "php_register_globals" column, which is eit

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
Dave, You could have a Install.txt file to explain how to compile. I'm not very familiar with apxs2 :) Can you post here?

Re: mod_vhost_dbd

2009-02-15 Thread Dave Ingram
Jorge Bastos wrote: >> This is possible using mod_sqltemplate. Suppose in your database, you >> have a "php_register_globals" column, which is either "On" or "Off". >> Then this will work: >> >> [snip] > > So I think my problem is resolved! > Resuming, I can have as many columns I want in the hosts

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
> Yup. I place no restrictions at all. It doesn't even have to be a > single > table -- it can be the result of a multi-table join, as long as all of > the columns have different names. They can be renamed using "AS", like > "SELECT a.id, a.name, h.name AS hname FROM table1 a, table2 h" for > examp

Re: mod_vhost_dbd

2009-02-15 Thread Dave Ingram
Jorge Bastos wrote: > Dave, > You could have a Install.txt file to explain how to compile. > I'm not very familiar with apxs2 :) > > Can you post here? > Erm. I think all you need to use is: apxs2 -i -c mod_sqltemplate.c as root, to compile and install in one step. Don't forget to add the Loa

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
> > Erm. I think all you need to use is: > > apxs2 -i -c mod_sqltemplate.c > > as root, to compile and install in one step. Don't forget to add the > LoadModule line! I won't! Sorry about apxs. I'm just curious, libmysql shouldn't be linked agains the .so module?

Re: mod_vhost_dbd

2009-02-15 Thread Dave Ingram
Jorge Bastos wrote: > Sorry about apxs. > That's fine -- everyone has to learn somewhere. > I'm just curious, libmysql shouldn't be linked agains the .so module Nope - it uses the built-in APR DBD in Apache, which already links against MySQL. Dave

RE: mod_vhost_dbd

2009-02-15 Thread Jorge Bastos
> > I'm just curious, libmysql shouldn't be linked agains the .so module > Nope - it uses the built-in APR DBD in Apache, which already links > against MySQL. > Oh right. Stupid question, and I saw it on the source the apr_dbd, I'm sleepy :| I do use mod_dbd for http auth, stupid question :P Ok