Re: [us...@httpd] dbd syntax

2008-12-27 Thread ernst schoen-rene
Oh, one other thing that should be cleared up in the documentation. The example sql syntax for selecting the pass is this: select password from users where user_id = %s One would normally expect to have to put quotes around the %s as in: select password from users where user_id = '%s' but that

Re: [us...@httpd] dbd syntax

2008-12-27 Thread ernst schoen-rene
I did have the mysql driver, and after many clean install attempts, I installed apache 2.2.11 from apache 2.2.10 without re-compiling apr or apr-util and bam, it worked. My log files showed "could not connect to mysql server" error. mod_dbd only began connecting when I added a socket or port opt

Re: [us...@httpd] dbd syntax

2008-12-27 Thread Nick Kew
On Sat, 27 Dec 2008 09:10:25 -0800 "ernst schoen-rene" wrote: > I have solved this problem. > I am running fedora64 on amd64. > mod_dbd with mysql simply doesn't work on my install of apache > 2.2.10. I installed 2.2.11 and it works, but there are elements that > I think are under-documented or

Re: [us...@httpd] dbd syntax

2008-12-27 Thread ernst schoen-rene
I have solved this problem. I am running fedora64 on amd64. mod_dbd with mysql simply doesn't work on my install of apache 2.2.10. I installed 2.2.11 and it works, but there are elements that I think are under-documented or poorly documented. First, the DBDParams command for mysql requires that yo

Re: [us...@httpd] dbd syntax

2008-12-26 Thread ernst schoen-rene
I don't want a dbname param, because different servers ask different databases for passwords. However, it doesn't make a difference if I do add a dbname param. Also, I really only have limited skill in C and compiling and running the entire apache server under a debugger seems daunting. It seems

Re: [us...@httpd] dbd syntax

2008-12-26 Thread Nick Kew
ernst schoen-rene wrote: Ah, thanks. That's good to know. I still cannot get this damn thing to connect to the database, and I've been sticking bits of debug code in mod_dbd and apr-util to no avail. I use this: DPDParams "host=localhost user=someuser pass=somepass" Don't you want to add a db

Re: [us...@httpd] dbd syntax

2008-12-26 Thread ernst schoen-rene
Ah, thanks. That's good to know. I still cannot get this damn thing to connect to the database, and I've been sticking bits of debug code in mod_dbd and apr-util to no avail. I use this: DPDParams "host=localhost user=someuser pass=somepass" but all I get in the error log is: [Fri Dec 26 16:09:

Re: [us...@httpd] dbd syntax

2008-12-26 Thread Nick Kew
ernst schoen-rene wrote: I'm trying to get mod_dbd and mod_authn_dbd to work. What happened when you tried? Can someone please post an example of the correct syntax for the DBDParam statement to use with MySQL? The mod_dbd page says that it should be in this format: You seem to have done

[us...@httpd] dbd syntax

2008-12-26 Thread ernst schoen-rene
I'm trying to get mod_dbd and mod_authn_dbd to work. Can someone please post an example of the correct syntax for the DBDParam statement to use with MySQL? The mod_dbd page says that it should be in this format: DBDParam host=localhost,user=userid,pass=password but the mod_authn_dbd uses this f