mod_dbd and Windows

[Steffen <in...@apachelounge.com>]

Hi,

Maybe there is some help for the Windows community,
we are still struggling to get mod_dbd working with Windows.

Several ppl tried it, but it crashes Apache or it looses connections,
see: http://www.apachelounge.com/forum/viewtopic.php?t=52

To get it compiled, as i told you before, mysql.h has to be changed, 
see: http://www.apachelounge.com/forum/viewtopic.php?p=280#280

Thanks,

Steffen

Re: mod_dbd and Windows

[Steffen <in...@apachelounge.com>]

mod_dbd together with the apr_dbd framework, is listed in the "new features"
document for 2.2, which rather implies that it should work and is to some
degree supported.

As far as my and other win users experience, I hade to conclude that
mod_dbd/mod_authn_dbd is experimental.

Steffen
----- Original Message ----- 
From: "Carsten Wiedmann" <ca...@gmx.de>
To: <de...@httpd.apache.org>
Sent: Wednesday, January 11, 2006 11:42 PM
Subject: Re: mod_dbd and Windows


> Nick Kew schrieb:
>
>> On Friday 06 January 2006 19:20, Steffen wrote:
>> > Several ppl tried it, but it crashes Apache or it looses connections,
>> > see: http://www.apachelounge.com/forum/viewtopic.php?t=52
>> >
>> > To get it compiled, as i told you before, mysql.h has to be changed,
>> > see: http://www.apachelounge.com/forum/viewtopic.php?p=280#280
>>
>> Looking at your URL, you've changed __WIN__ to __WIN32__ in mysql.h.
>> That seems to be something internal to MySQL itself, outside the
>> reach of the apr_dbd_mysql driver.
>
> I've also tried to use mod_dbd and MySQL on Windows with no luck.  I don't
> must change "mysql.h" to compile the modules. Instead I must add this line
> in "apr_dbd_mysql.c":
> | #include <mysql/my_global.h>
> before:
> | #include <mysql/mysql.h>
>
> All build fine (Apache 2.2.0 / MySQL 5.0.18). But every time I access a
> secured page the Apache child process give up with:
> | [notice] Parent: child process exited with status 3221225477 --
> Restarting.
>
> After the automatic restart of the child process and a refresh in the
> browser I can see the page. Next (an other) page the same thing. I don't
> know where is the problem. "mod_dbd" or "apr_dbd*"?
>
> BTW:
> Have you ever try to use mod_dbd with sqlite2 or sqlite3 on Windows? When
> i try to use this, I get this message at server startup (and during
> accessing a page):
> | [crit] (20014)Internal error: DBD: failed to initialise
>
> But I don't realy know if my configuration in "httpd.conf" is correct for
> SQLite (there are no examples...).
>
> Regards,
> Carsten Wiedmann
>
>
>

Re: mod_dbd and Windows

[Carsten Wiedmann <ca...@gmx.de>]

Nick Kew schrieb:

> On Friday 06 January 2006 19:20, Steffen wrote:
> > Several ppl tried it, but it crashes Apache or it looses connections,
> > see: http://www.apachelounge.com/forum/viewtopic.php?t=52
> >
> > To get it compiled, as i told you before, mysql.h has to be changed,
> > see: http://www.apachelounge.com/forum/viewtopic.php?p=280#280
>
> Looking at your URL, you've changed __WIN__ to __WIN32__ in mysql.h.
> That seems to be something internal to MySQL itself, outside the
> reach of the apr_dbd_mysql driver.

I've also tried to use mod_dbd and MySQL on Windows with no luck.  I don't 
must change "mysql.h" to compile the modules. Instead I must add this line 
in "apr_dbd_mysql.c":
| #include <mysql/my_global.h>
before:
| #include <mysql/mysql.h>

All build fine (Apache 2.2.0 / MySQL 5.0.18). But every time I access a 
secured page the Apache child process give up with:
| [notice] Parent: child process exited with status 3221225477 --  
Restarting.

After the automatic restart of the child process and a refresh in the 
browser I can see the page. Next (an other) page the same thing. I don't 
know where is the problem. "mod_dbd" or "apr_dbd*"?

BTW:
Have you ever try to use mod_dbd with sqlite2 or sqlite3 on Windows? When i 
try to use this, I get this message at server startup (and during accessing 
a page):
| [crit] (20014)Internal error: DBD: failed to initialise

But I don't realy know if my configuration in "httpd.conf" is correct for 
SQLite (there are no examples...).

Regards,
Carsten Wiedmann

Re: mod_dbd and Windows

[Nick Kew <ni...@webthing.com>]

On Friday 06 January 2006 19:20, Steffen wrote:
> Hi,
>
> Maybe there is some help for the Windows community,
> we are still struggling to get mod_dbd working with Windows.

You seem to be equating dbd with mysql here?

> Several ppl tried it, but it crashes Apache or it looses connections,
> see: http://www.apachelounge.com/forum/viewtopic.php?t=52
>
> To get it compiled, as i told you before, mysql.h has to be changed,
> see: http://www.apachelounge.com/forum/viewtopic.php?p=280#280

I thought you said it worked with MySQL 4.1 but caused trouble with 5.0?

Looking at your URL, you've changed __WIN__ to __WIN32__ in mysql.h.
That seems to be something internal to MySQL itself, outside the
reach of the apr_dbd_mysql driver.

Anyway, as far as I'm concerned, the MySQL driver was only ever a quick
clone of the PostgreSQL driver (which I use myself).  If you or anyone else
would like to take over maintenance of it (under the GPL), that's fine by me.
Or of course you could fork a Windows version of it.

Alternatively, it's now under subversion, and (round tuits permitting) should
also come under bug tracking in the not-too-distant future.  If you think
you have something to contribute, let me know.

-- 
Nick Kew

Re: mod_dbd and Windows

[Nick Kew <ni...@webthing.com>]

On Friday 06 January 2006 19:20, Steffen wrote:
> Hi,
>
> Maybe there is some help for the Windows community,
> we are still struggling to get mod_dbd working with Windows.

FWIW, I've just (coincidentally) got a genuine bug report from
another user, and fixed the bug.  It's in dbd_mysql_open, so
if that's what gives you trouble, try again!

http://apache.webthing.com/svn/apache/apr/

-- 
Nick Kew