You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Daniel Campbell <ca...@on2.com> on 2007/11/19 16:52:58 UTC
[users@httpd] dbd mysql segmentation fault in 2.2.6
After quite a bit of trouble I finally got the dbd mysql compiled but
now as soon as I put the "DBDriver mysql" directive into the httpd.conf
file I get endless Segmentation Fault messages in the error log. I set
the LogLevel to debug but that doesn't help any. Any suggestions?
Below is my DBDriver call:
DBDriver mysql
#Connection string: database name and login credentials
DBDParams "host=mysql.my.domain.com dbname=stats user=stats password=stats"
#Parameters for Connection Pool Management
DBDMin 1
DBDKeep 2
DBDMax 10
DBDExptime 60
#Authentication Section
<Directory /home/websites/my.domain.com/htdocs/stats>
#mod_auth configuration for authn_dbd
Options All
AllowOverride none
AuthType Basic
AuthName "Statistics"
AuthBasicProvider dbd
#authz configuration
Require valid-user
#SQL query to verify a user
#(note: DBD drivers recognise both stdio-like %s and native syntax)
AuthDBDUserPWQuery "select linux_password from employees where username
= %s AND on2admin = 'Y'"
</Directory>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
At server startup. Not even with any requests to it. I will install
gdb and try it out.
Nick Kew wrote:
> On Mon, 19 Nov 2007 10:52:58 -0500
> Daniel Campbell <ca...@on2.com> wrote:
>
>
>> After quite a bit of trouble I finally got the dbd mysql compiled but
>> now as soon as I put the "DBDriver mysql" directive into the
>> httpd.conf file I get endless Segmentation Fault messages in the
>> error log.
>>
>
> At server startup or when it tries to authenticate a request?
>
> Can you get a traceback from that? Run the server under gdb
> (with the -X flag to prevent it detaching), until you get a
> crash. Then you can get a backtrace from gdb. Or get a
> coredump and backtrace from that.
>
>
>> Any suggestions? Below is my DBDriver call:
>>
>
> That looks OK to me.
>
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Nick Kew <ni...@webthing.com>.
On Mon, 19 Nov 2007 10:52:58 -0500
Daniel Campbell <ca...@on2.com> wrote:
> After quite a bit of trouble I finally got the dbd mysql compiled but
> now as soon as I put the "DBDriver mysql" directive into the
> httpd.conf file I get endless Segmentation Fault messages in the
> error log.
At server startup or when it tries to authenticate a request?
Can you get a traceback from that? Run the server under gdb
(with the -X flag to prevent it detaching), until you get a
crash. Then you can get a backtrace from gdb. Or get a
coredump and backtrace from that.
> Any suggestions? Below is my DBDriver call:
That looks OK to me.
--
Nick Kew
Application Development with Apache - the Apache Modules Book
http://www.apachetutor.org/
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Monday, November 19, 2007 11:29 AM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
> No I have not. What is the difference?
>
worker is the multi-threaded and you only need smaller number of processes
for the same amount of traffic. Each process has a bunch of threads which
share a connection pool for backend storage like mysql or ldap. The
connections in the pool can be re-used which save the cost of establishing
and destroying these connections. This is a big performance improvement if
put on a busy server.
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
No I have not. What is the difference?
Danie Qian wrote:
>
> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
> To: <us...@httpd.apache.org>
> Sent: Monday, November 19, 2007 10:55 AM
> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>
>
>> By the way the actual error message in the error_log is
>> [Mon Nov 19 15:55:22 2007] [notice] child pid 21426 exit signal
>> Segmentation fault (11)
>>
>> and after a while I see
>> [Mon Nov 19 15:55:22 2007] [info] server seems busy, (you may need to
>> increase StartServers, or Min/MaxSpareServers), spawning 32 children,
>> there are 1 idle, and 1 total children
>>
>
> Have you considered using --mpm=worker instead of prefork to take
> advantage of the dbd has to offer?
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Monday, November 19, 2007 10:55 AM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
> By the way the actual error message in the error_log is
> [Mon Nov 19 15:55:22 2007] [notice] child pid 21426 exit signal
> Segmentation fault (11)
>
> and after a while I see
> [Mon Nov 19 15:55:22 2007] [info] server seems busy, (you may need to
> increase StartServers, or Min/MaxSpareServers), spawning 32 children,
> there are 1 idle, and 1 total children
>
Have you considered using --mpm=worker instead of prefork to take advantage
of the dbd has to offer?
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
By the way the actual error message in the error_log is
[Mon Nov 19 15:55:22 2007] [notice] child pid 21426 exit signal
Segmentation fault (11)
and after a while I see
[Mon Nov 19 15:55:22 2007] [info] server seems busy, (you may need to
increase StartServers, or Min/MaxSpareServers), spawning 32 children,
there are 1 idle, and 1 total children
Daniel Campbell wrote:
> After quite a bit of trouble I finally got the dbd mysql compiled but
> now as soon as I put the "DBDriver mysql" directive into the
> httpd.conf file I get endless Segmentation Fault messages in the error
> log. I set the LogLevel to debug but that doesn't help any. Any
> suggestions? Below is my DBDriver call:
>
> DBDriver mysql
> #Connection string: database name and login credentials
> DBDParams "host=mysql.my.domain.com dbname=stats user=stats
> password=stats"
>
> #Parameters for Connection Pool Management
> DBDMin 1
> DBDKeep 2
> DBDMax 10
> DBDExptime 60
>
> #Authentication Section
> <Directory /home/websites/my.domain.com/htdocs/stats>
> #mod_auth configuration for authn_dbd
> Options All
> AllowOverride none
> AuthType Basic
> AuthName "Statistics"
> AuthBasicProvider dbd
>
> #authz configuration
> Require valid-user
> #SQL query to verify a user
> #(note: DBD drivers recognise both stdio-like %s and native syntax)
> AuthDBDUserPWQuery "select linux_password from employees where
> username = %s AND on2admin = 'Y'"
> </Directory>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Tuesday, November 20, 2007 4:34 PM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
> My ldd looks like
> linux-gate.so.1 => (0xffffe000)
> libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0xb7fbf000)
> libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0xb7f8c000)
> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7f75000)
> libresolv.so.2 => /lib/libresolv.so.2 (0xb7f62000)
> liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0xb7f56000)
> libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7e10000)
> libnsl.so.1 => /lib/libnsl.so.1 (0xb7df9000)
> libm.so.6 => /lib/libm.so.6 (0xb7dd2000)
> libz.so.1 => /usr/lib/libz.so.1 (0xb7dbe000)
> libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0xb7d81000)
> libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0xb7c55000)
> libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb7c35000)
> libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0xb7c13000)
> libuuid.so.1 => /lib/libuuid.so.1 (0xb7c10000)
> librt.so.1 => /lib/librt.so.1 (0xb7c08000)
> libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bda000)
> libpthread.so.0 => /lib/libpthread.so.0 (0xb7bc2000)
> libdl.so.2 => /lib/libdl.so.2 (0xb7bbe000)
> libc.so.6 => /lib/libc.so.6 (0xb7a7c000)
> /lib/ld-linux.so.2 (0xb7fdd000)
>
> Can you supply a copy of yours for comparison?
>
Actually I have another running box that has exactly what you want to do -
httpd-2.2.6 with included apr(-utils). Here it is:
[root@stp-fe11 bin]# ldd httpd
libssl.so.4 => /lib/libssl.so.4 (0x005b1000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0x00437000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x001d4000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00522000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x0040f000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00414000)
libresolv.so.2 => /lib/libresolv.so.2 (0x001bf000)
libaprutil-1.so.0 => /usr/local/etc/httpd/lib/libaprutil-1.so.0
(0x006ae000)
libnsl.so.1 => /lib/libnsl.so.1 (0x003e3000)
libm.so.6 => /lib/tls/libm.so.6 (0x00367000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x00111000)
libapr-1.so.0 => /usr/local/etc/httpd/lib/libapr-1.so.0 (0x00cee000)
libuuid.so.1 => /lib/libuuid.so.1 (0x00130000)
librt.so.1 => /lib/tls/librt.so.1 (0x0039e000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00133000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x003fb000)
libdl.so.2 => /lib/libdl.so.2 (0x00361000)
libc.so.6 => /lib/tls/libc.so.6 (0x00233000)
libz.so.1 => /usr/lib/libz.so.1 (0x0038c000)
/lib/ld-linux.so.2 (0x00219000)
[root@stp-fe11 lib]# ldd libaprutil-1.so.0.2.11
libnsl.so.1 => /lib/libnsl.so.1 (0x003f7000)
libm.so.6 => /lib/tls/libm.so.6 (0x00111000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x00b59000)
libapr-1.so.0 => /usr/local/etc/httpd/lib/libapr-1.so.0 (0x00cfd000)
libuuid.so.1 => /lib/libuuid.so.1 (0x0034d000)
librt.so.1 => /lib/tls/librt.so.1 (0x00536000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00134000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x0049c000)
libdl.so.2 => /lib/libdl.so.2 (0x00f51000)
libc.so.6 => /lib/tls/libc.so.6 (0x006dc000)
/lib/ld-linux.so.2 (0x00219000)
strangely `ldd libaprutil` doesnt show libmysql-client which I dont
understand. but the whole setup is working for me.
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
My database has passwords stored in linux crypt format like
$1$0.$a4M88f1CCRU80Ik6OOGEF0
Does the authentication support this? If so can someone give me an
example of a query? I am a little confused as to how the password
entered would get translated into this format in order to do the select
and compare the two values....
Res wrote:
> On Wed, 21 Nov 2007, Res wrote:
>
>> On Tue, 20 Nov 2007, Daniel Campbell wrote:
>>
>>> More progress. I can now see traffic going out and coming back from the
>>> sql server for authentication requests but they are failing some how and
>>> I still get a seg fault when this happens. What type of "(encrypted
>>> password)" does this support? Is there a way to set it so it
>>> automatically succeeds just as a test? Thanks.
>>
>> ENCRYPT (not MD5 which is mysql default)
>>
>
>
> However I doubt this is on fact the problem.. enable full logging on
> your sql server
>
> Also can you show me the output of
> /path/to/httpd -t -D DUMP_MODULES
>
>
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Res <re...@ausics.net>.
On Wed, 21 Nov 2007, Res wrote:
> On Tue, 20 Nov 2007, Daniel Campbell wrote:
>
>> More progress. I can now see traffic going out and coming back from the
>> sql server for authentication requests but they are failing some how and
>> I still get a seg fault when this happens. What type of "(encrypted
>> password)" does this support? Is there a way to set it so it
>> automatically succeeds just as a test? Thanks.
>
> ENCRYPT (not MD5 which is mysql default)
>
However I doubt this is on fact the problem.. enable full logging on your
sql server
Also can you show me the output of
/path/to/httpd -t -D DUMP_MODULES
--
Cheers
Res
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Res <re...@ausics.net>.
On Tue, 20 Nov 2007, Daniel Campbell wrote:
> More progress. I can now see traffic going out and coming back from the
> sql server for authentication requests but they are failing some how and
> I still get a seg fault when this happens. What type of "(encrypted
> password)" does this support? Is there a way to set it so it
> automatically succeeds just as a test? Thanks.
ENCRYPT (not MD5 which is mysql default)
>
> Danie Qian wrote:
>>
>> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
>> To: <us...@httpd.apache.org>
>> Sent: Tuesday, November 20, 2007 10:48 PM
>> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>>
>>
>>> Well I take that back some what. It still seg faults but only once
>>> per request instead of a continuous loop. Oh well....I keep plugging
>>> away at it...any more tips would be greatly appreciated...
>>>
>>> Daniel Campbell wrote:
>>>> FINALLY, I found the problem and it was so simple.....I could shoot
>>>> myself. I forgot DBDPersist off in the conf file. This was causing
>>>> the seg faults.
>>>>
>>
>> Looks like you are missing one option in your configuration: --enable-dbd
>>
>> To take advantage of dbd you actually need to turn DBDPersist on and
>> use --with-mpm=worker configuration option. But for now try adding
>> --enable-dbd option first to see if it gets rid of your errors.
>>
>> ---------------------------------------------------------------------
>> The official User-To-User support forum of the Apache HTTP Server
>> Project.
>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>> For additional commands, e-mail: users-help@httpd.apache.org
>>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
--
Cheers
Res
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
More progress. I can now see traffic going out and coming back from the
sql server for authentication requests but they are failing some how and
I still get a seg fault when this happens. What type of "(encrypted
password)" does this support? Is there a way to set it so it
automatically succeeds just as a test? Thanks.
Danie Qian wrote:
>
> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
> To: <us...@httpd.apache.org>
> Sent: Tuesday, November 20, 2007 10:48 PM
> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>
>
>> Well I take that back some what. It still seg faults but only once
>> per request instead of a continuous loop. Oh well....I keep plugging
>> away at it...any more tips would be greatly appreciated...
>>
>> Daniel Campbell wrote:
>>> FINALLY, I found the problem and it was so simple.....I could shoot
>>> myself. I forgot DBDPersist off in the conf file. This was causing
>>> the seg faults.
>>>
>
> Looks like you are missing one option in your configuration: --enable-dbd
>
> To take advantage of dbd you actually need to turn DBDPersist on and
> use --with-mpm=worker configuration option. But for now try adding
> --enable-dbd option first to see if it gets rid of your errors.
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Res <re...@ausics.net>.
On Tue, 20 Nov 2007, Danie Qian wrote:
> Looks like you are missing one option in your configuration: --enable-dbd
>
no he's not, if it wasnt he wouldnt be getting anywhere
at all and would not be hitting the sql server r and the errors would
be much more nasty.
I understand hes using now enable-modules-all which by default includes
dbd.
--
Cheers
Res
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Tuesday, November 20, 2007 10:48 PM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
> Well I take that back some what. It still seg faults but only once per
> request instead of a continuous loop. Oh well....I keep plugging away at
> it...any more tips would be greatly appreciated...
>
> Daniel Campbell wrote:
>> FINALLY, I found the problem and it was so simple.....I could shoot
>> myself. I forgot DBDPersist off in the conf file. This was causing the
>> seg faults.
>>
Looks like you are missing one option in your configuration: --enable-dbd
To take advantage of dbd you actually need to turn DBDPersist on and
use --with-mpm=worker configuration option. But for now try
adding --enable-dbd option first to see if it gets rid of your errors.
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
Well I take that back some what. It still seg faults but only once per
request instead of a continuous loop. Oh well....I keep plugging away
at it...any more tips would be greatly appreciated...
Daniel Campbell wrote:
> FINALLY, I found the problem and it was so simple.....I could shoot
> myself. I forgot DBDPersist off in the conf file. This was causing
> the seg faults.
>
> Res wrote:
>>
>> Daniel,
>>
>> Your slackware 12, you are installing apache from source from
>> httpd.apache.org ? if so ls /var/log/packages/http*
>> if it returns a package then "removepkg httpd "
>>
>> Then reinstall from source again, I have done a gazillion slackware
>> 11 and 12's with apache2 and mysql and none have ever shown me the
>> problem you are having. From our previous conversations, I know you
>> know the correct procedure for installing it all, theres just
>> somthing there thats interupting it.
>>
>> If none of that applies, remove all dbd global options apart from the
>> DBDParams, then add "DBDPersist off" and "DBDriver mysql"
>> and try that
>>
>>
>> On Tue, 20 Nov 2007, Daniel Campbell wrote:
>>
>>> My ldd looks like
>>> linux-gate.so.1 => (0xffffe000)
>>> libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0xb7fbf000)
>>> libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0xb7f8c000)
>>> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7f75000)
>>> libresolv.so.2 => /lib/libresolv.so.2 (0xb7f62000)
>>> liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0xb7f56000)
>>> libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7e10000)
>>> libnsl.so.1 => /lib/libnsl.so.1 (0xb7df9000)
>>> libm.so.6 => /lib/libm.so.6 (0xb7dd2000)
>>> libz.so.1 => /usr/lib/libz.so.1 (0xb7dbe000)
>>> libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0xb7d81000)
>>> libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0xb7c55000)
>>> libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb7c35000)
>>> libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0xb7c13000)
>>> libuuid.so.1 => /lib/libuuid.so.1 (0xb7c10000)
>>> librt.so.1 => /lib/librt.so.1 (0xb7c08000)
>>> libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bda000)
>>> libpthread.so.0 => /lib/libpthread.so.0 (0xb7bc2000)
>>> libdl.so.2 => /lib/libdl.so.2 (0xb7bbe000)
>>> libc.so.6 => /lib/libc.so.6 (0xb7a7c000)
>>> /lib/ld-linux.so.2 (0xb7fdd000)
>>>
>>> Can you supply a copy of yours for comparison?
>>>
>>> Danie Qian wrote:
>>>>
>>>> ----- Original Message ----- From: "Daniel Campbell"
>>>> <ca...@on2.com>
>>>> To: <us...@httpd.apache.org>
>>>> Sent: Tuesday, November 20, 2007 3:59 PM
>>>> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>>>>
>>>>
>>>>> I have. I do the ldd on the httpd and it shows the mysql client
>>>>> lib in
>>>>> the list. I still get the segmentation fault as soon as I put the
>>>>> DBDriver mysql command into the httpd.conf file. I have installed the
>>>>> gdb but I am unsure exactly how to get it to produce the results I
>>>>> need.
>>>>>
>>>>
>>>> the mysql-client from `ldd httpd` might be from the option
>>>> --with-mysql=/usr/lib/mysql you put when compiling.
>>>>
>>>> In my working installation libmysql-client is from `ldd
>>>> libaprutil-x.x`. But I didnt use the included apr. You might try
>>>> installing apr-util before hand to see if it makes any difference for
>>>> you.
>>>>
>>>> ---------------------------------------------------------------------
>>>> The official User-To-User support forum of the Apache HTTP Server
>>>> Project.
>>>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>>>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>>>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>>>> For additional commands, e-mail: users-help@httpd.apache.org
>>>>
>>>
>>> ---------------------------------------------------------------------
>>> The official User-To-User support forum of the Apache HTTP Server
>>> Project.
>>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>>> For additional commands, e-mail: users-help@httpd.apache.org
>>>
>>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
FINALLY, I found the problem and it was so simple.....I could shoot
myself. I forgot DBDPersist off in the conf file. This was causing the
seg faults.
Res wrote:
>
> Daniel,
>
> Your slackware 12, you are installing apache from source from
> httpd.apache.org ? if so ls /var/log/packages/http*
> if it returns a package then "removepkg httpd "
>
> Then reinstall from source again, I have done a gazillion slackware 11
> and 12's with apache2 and mysql and none have ever shown me the
> problem you are having. From our previous conversations, I know you
> know the correct procedure for installing it all, theres just somthing
> there thats interupting it.
>
> If none of that applies, remove all dbd global options apart from the
> DBDParams, then add "DBDPersist off" and "DBDriver mysql"
> and try that
>
>
> On Tue, 20 Nov 2007, Daniel Campbell wrote:
>
>> My ldd looks like
>> linux-gate.so.1 => (0xffffe000)
>> libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0xb7fbf000)
>> libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0xb7f8c000)
>> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7f75000)
>> libresolv.so.2 => /lib/libresolv.so.2 (0xb7f62000)
>> liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0xb7f56000)
>> libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7e10000)
>> libnsl.so.1 => /lib/libnsl.so.1 (0xb7df9000)
>> libm.so.6 => /lib/libm.so.6 (0xb7dd2000)
>> libz.so.1 => /usr/lib/libz.so.1 (0xb7dbe000)
>> libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0xb7d81000)
>> libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0xb7c55000)
>> libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb7c35000)
>> libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0xb7c13000)
>> libuuid.so.1 => /lib/libuuid.so.1 (0xb7c10000)
>> librt.so.1 => /lib/librt.so.1 (0xb7c08000)
>> libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bda000)
>> libpthread.so.0 => /lib/libpthread.so.0 (0xb7bc2000)
>> libdl.so.2 => /lib/libdl.so.2 (0xb7bbe000)
>> libc.so.6 => /lib/libc.so.6 (0xb7a7c000)
>> /lib/ld-linux.so.2 (0xb7fdd000)
>>
>> Can you supply a copy of yours for comparison?
>>
>> Danie Qian wrote:
>>>
>>> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
>>> To: <us...@httpd.apache.org>
>>> Sent: Tuesday, November 20, 2007 3:59 PM
>>> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>>>
>>>
>>>> I have. I do the ldd on the httpd and it shows the mysql client lib in
>>>> the list. I still get the segmentation fault as soon as I put the
>>>> DBDriver mysql command into the httpd.conf file. I have installed the
>>>> gdb but I am unsure exactly how to get it to produce the results I
>>>> need.
>>>>
>>>
>>> the mysql-client from `ldd httpd` might be from the option
>>> --with-mysql=/usr/lib/mysql you put when compiling.
>>>
>>> In my working installation libmysql-client is from `ldd
>>> libaprutil-x.x`. But I didnt use the included apr. You might try
>>> installing apr-util before hand to see if it makes any difference for
>>> you.
>>>
>>> ---------------------------------------------------------------------
>>> The official User-To-User support forum of the Apache HTTP Server
>>> Project.
>>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>>> For additional commands, e-mail: users-help@httpd.apache.org
>>>
>>
>> ---------------------------------------------------------------------
>> The official User-To-User support forum of the Apache HTTP Server
>> Project.
>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>> For additional commands, e-mail: users-help@httpd.apache.org
>>
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Res <re...@ausics.net>.
Daniel,
Your slackware 12, you are installing apache from source from
httpd.apache.org ? if so ls /var/log/packages/http*
if it returns a package then "removepkg httpd "
Then reinstall from source again, I have done a gazillion slackware 11 and
12's with apache2 and mysql and none have ever shown me the problem you
are having. From our previous conversations, I know you know the correct
procedure for installing it all, theres just somthing there thats
interupting it.
If none of that applies, remove all dbd global options apart from the
DBDParams, then add "DBDPersist off" and "DBDriver mysql"
and try that
On Tue, 20 Nov 2007, Daniel Campbell wrote:
> My ldd looks like
> linux-gate.so.1 => (0xffffe000)
> libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0xb7fbf000)
> libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0xb7f8c000)
> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7f75000)
> libresolv.so.2 => /lib/libresolv.so.2 (0xb7f62000)
> liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0xb7f56000)
> libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7e10000)
> libnsl.so.1 => /lib/libnsl.so.1 (0xb7df9000)
> libm.so.6 => /lib/libm.so.6 (0xb7dd2000)
> libz.so.1 => /usr/lib/libz.so.1 (0xb7dbe000)
> libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0xb7d81000)
> libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0xb7c55000)
> libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb7c35000)
> libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0xb7c13000)
> libuuid.so.1 => /lib/libuuid.so.1 (0xb7c10000)
> librt.so.1 => /lib/librt.so.1 (0xb7c08000)
> libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bda000)
> libpthread.so.0 => /lib/libpthread.so.0 (0xb7bc2000)
> libdl.so.2 => /lib/libdl.so.2 (0xb7bbe000)
> libc.so.6 => /lib/libc.so.6 (0xb7a7c000)
> /lib/ld-linux.so.2 (0xb7fdd000)
>
> Can you supply a copy of yours for comparison?
>
> Danie Qian wrote:
>>
>> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
>> To: <us...@httpd.apache.org>
>> Sent: Tuesday, November 20, 2007 3:59 PM
>> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>>
>>
>>> I have. I do the ldd on the httpd and it shows the mysql client lib in
>>> the list. I still get the segmentation fault as soon as I put the
>>> DBDriver mysql command into the httpd.conf file. I have installed the
>>> gdb but I am unsure exactly how to get it to produce the results I need.
>>>
>>
>> the mysql-client from `ldd httpd` might be from the option
>> --with-mysql=/usr/lib/mysql you put when compiling.
>>
>> In my working installation libmysql-client is from `ldd
>> libaprutil-x.x`. But I didnt use the included apr. You might try
>> installing apr-util before hand to see if it makes any difference for
>> you.
>>
>> ---------------------------------------------------------------------
>> The official User-To-User support forum of the Apache HTTP Server
>> Project.
>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>> For additional commands, e-mail: users-help@httpd.apache.org
>>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
--
Cheers
Res
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Tuesday, November 20, 2007 4:34 PM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
> My ldd looks like
> linux-gate.so.1 => (0xffffe000)
> libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0xb7fbf000)
> libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0xb7f8c000)
> libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7f75000)
> libresolv.so.2 => /lib/libresolv.so.2 (0xb7f62000)
> liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0xb7f56000)
> libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7e10000)
> libnsl.so.1 => /lib/libnsl.so.1 (0xb7df9000)
> libm.so.6 => /lib/libm.so.6 (0xb7dd2000)
> libz.so.1 => /usr/lib/libz.so.1 (0xb7dbe000)
> libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0xb7d81000)
> libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0xb7c55000)
> libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb7c35000)
> libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0xb7c13000)
> libuuid.so.1 => /lib/libuuid.so.1 (0xb7c10000)
> librt.so.1 => /lib/librt.so.1 (0xb7c08000)
> libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bda000)
> libpthread.so.0 => /lib/libpthread.so.0 (0xb7bc2000)
> libdl.so.2 => /lib/libdl.so.2 (0xb7bbe000)
> libc.so.6 => /lib/libc.so.6 (0xb7a7c000)
> /lib/ld-linux.so.2 (0xb7fdd000)
>
> Can you supply a copy of yours for comparison?
>
[root@stp-fe09 bin]# ldd httpd
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x0093c000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x00c8f000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x0077b000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00919000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00976000)
libaprutil-1.so.0 => /usr/local/apr/lib/libaprutil-1.so.0
(0x00cfa000)
libssl.so.4 => /lib/libssl.so.4 (0x00aa0000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0x009b5000)
libmysqlclient_r.so.15 =>
/usr/local/mysql/lib/mysql/libmysqlclient_r.so.15 (0x00ee9000)
libnsl.so.1 => /lib/libnsl.so.1 (0x008ed000)
libm.so.6 => /lib/tls/libm.so.6 (0x0072f000)
libz.so.1 => /usr/lib/libz.so.1 (0x00754000)
libmysqlclient_r.so.14 => /usr/lib/mysql/libmysqlclient_r.so.14
(0x00111000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x00957000)
libapr-1.so.0 => /usr/local/apr/lib/libapr-1.so.0 (0x00442000)
libuuid.so.1 => /lib/libuuid.so.1 (0x00249000)
librt.so.1 => /lib/tls/librt.so.1 (0x008bd000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x0024c000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00905000)
libdl.so.2 => /lib/libdl.so.2 (0x00729000)
libc.so.6 => /lib/tls/libc.so.6 (0x0078f000)
/lib/ld-linux.so.2 (0x0070f000)
note I am using mysql-5.0 for dbd. libmysqlclient_r.so.14 is from the
pre-installed OS rpm packages that got linked automatically and you dont
need it.
[root@stp-fe09 lib]# ldd libaprutil-1.so.0.2.9
libz.so.1 => /usr/lib/libz.so.1 (0x002c7000)
libnsl.so.1 => /lib/libnsl.so.1 (0x00111000)
libm.so.6 => /lib/tls/libm.so.6 (0x00e94000)
libssl.so.4 => /lib/libssl.so.4 (0x00a68000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0x00b58000)
libmysqlclient_r.so.15 =>
/usr/local/mysql/lib/mysql/libmysqlclient_r.so.15 (0x00127000)
libexpat.so.0 => /usr/lib/libexpat.so.0 (0x00188000)
libapr-1.so.0 => /usr/local/apr/lib/libapr-1.so.0 (0x001a7000)
libuuid.so.1 => /lib/libuuid.so.1 (0x0066c000)
librt.so.1 => /lib/tls/librt.so.1 (0x002fd000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00faf000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00820000)
libdl.so.2 => /lib/libdl.so.2 (0x001c8000)
libc.so.6 => /lib/tls/libc.so.6 (0x00ca8000)
/lib/ld-linux.so.2 (0x0070f000)
libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x009b8000)
libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x001cc000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x00b18000)
libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x00546000)
libresolv.so.2 => /lib/libresolv.so.2 (0x008ec000)
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
My ldd looks like
linux-gate.so.1 => (0xffffe000)
libaprutil-1.so.0 => /usr/lib/libaprutil-1.so.0 (0xb7fbf000)
libldap-2.3.so.0 => /usr/lib/libldap-2.3.so.0 (0xb7f8c000)
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0xb7f75000)
libresolv.so.2 => /lib/libresolv.so.2 (0xb7f62000)
liblber-2.3.so.0 => /usr/lib/liblber-2.3.so.0 (0xb7f56000)
libmysqlclient_r.so.15 => /usr/lib/libmysqlclient_r.so.15 (0xb7e10000)
libnsl.so.1 => /lib/libnsl.so.1 (0xb7df9000)
libm.so.6 => /lib/libm.so.6 (0xb7dd2000)
libz.so.1 => /usr/lib/libz.so.1 (0xb7dbe000)
libssl.so.0.9.8 => /usr/lib/libssl.so.0.9.8 (0xb7d81000)
libcrypto.so.0.9.8 => /usr/lib/libcrypto.so.0.9.8 (0xb7c55000)
libexpat.so.1 => /usr/lib/libexpat.so.1 (0xb7c35000)
libapr-1.so.0 => /usr/lib/libapr-1.so.0 (0xb7c13000)
libuuid.so.1 => /lib/libuuid.so.1 (0xb7c10000)
librt.so.1 => /lib/librt.so.1 (0xb7c08000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0xb7bda000)
libpthread.so.0 => /lib/libpthread.so.0 (0xb7bc2000)
libdl.so.2 => /lib/libdl.so.2 (0xb7bbe000)
libc.so.6 => /lib/libc.so.6 (0xb7a7c000)
/lib/ld-linux.so.2 (0xb7fdd000)
Can you supply a copy of yours for comparison?
Danie Qian wrote:
>
> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
> To: <us...@httpd.apache.org>
> Sent: Tuesday, November 20, 2007 3:59 PM
> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>
>
>> I have. I do the ldd on the httpd and it shows the mysql client lib in
>> the list. I still get the segmentation fault as soon as I put the
>> DBDriver mysql command into the httpd.conf file. I have installed the
>> gdb but I am unsure exactly how to get it to produce the results I need.
>>
>
> the mysql-client from `ldd httpd` might be from the option
> --with-mysql=/usr/lib/mysql you put when compiling.
>
> In my working installation libmysql-client is from `ldd
> libaprutil-x.x`. But I didnt use the included apr. You might try
> installing apr-util before hand to see if it makes any difference for
> you.
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Tuesday, November 20, 2007 3:59 PM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>I have. I do the ldd on the httpd and it shows the mysql client lib in
> the list. I still get the segmentation fault as soon as I put the
> DBDriver mysql command into the httpd.conf file. I have installed the
> gdb but I am unsure exactly how to get it to produce the results I need.
>
the mysql-client from `ldd httpd` might be from the
option --with-mysql=/usr/lib/mysql you put when compiling.
In my working installation libmysql-client is from `ldd libaprutil-x.x`. But
I didnt use the included apr. You might try installing apr-util before hand
to see if it makes any difference for you.
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
I have. I do the ldd on the httpd and it shows the mysql client lib in
the list. I still get the segmentation fault as soon as I put the
DBDriver mysql command into the httpd.conf file. I have installed the
gdb but I am unsure exactly how to get it to produce the results I need.
Danie Qian wrote:
> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
> To: <us...@httpd.apache.org>
> Sent: Tuesday, November 20, 2007 1:42 PM
> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>
>
>> I removed the --with-mysql and added the --enable-modules=all but I
>> get the same result. One thing I am unsure of is the module itself.
>> Is it built in or should it be building apr_dbd_mysql.so? I don't see
>> that any place in the build tree.
>> Res wrote:
>>> On Mon, 19 Nov 2007, Daniel Campbell wrote:
>>>
>
> I thought you said you already installed it when I asked you
> yesterday. take a look into this:
>
> cd httpd-2.2.6/srclib/apr-util
> cat INSTALL.MySQL
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Tuesday, November 20, 2007 1:42 PM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>I removed the --with-mysql and added the --enable-modules=all but I get the
>same result. One thing I am unsure of is the module itself. Is it built
>in or should it be building apr_dbd_mysql.so? I don't see that any place
>in the build tree.
> Res wrote:
>> On Mon, 19 Nov 2007, Daniel Campbell wrote:
>>
I thought you said you already installed it when I asked you yesterday. take
a look into this:
cd httpd-2.2.6/srclib/apr-util
cat INSTALL.MySQL
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
I removed the --with-mysql and added the --enable-modules=all but I get
the same result. One thing I am unsure of is the module itself. Is it
built in or should it be building apr_dbd_mysql.so? I don't see that
any place in the build tree.
Res wrote:
> On Mon, 19 Nov 2007, Daniel Campbell wrote:
>
>> My configure opitions are:
>> CONFIGUREOPTS="--prefix=/usr --localstatedir=/var --enable-rewrite
>> --enable-http --enable-cgi --enable-so \
>> --enable-ssl --enable-headers --bindir=/usr/bin --sbindir=/usr/sbin
>> --libexecdir=/usr/libexec --datadir=/var/www \
>> --sysconfdir=/etc/apache --enable-dbd --with-ldap --enable-ldap
>> --enable-authnz-ldap --enable-authn-dbd \
>> --with-mysql=/usr/lib/mysql --with-included-apr"
>>
>> It is a Slackware 12.0 linux box.
>
>
> Where did you get the idea to configure like this?
> --with-mysql is not an apache option, so your example that you copied
> is wrong. Looks like a redhat bastardised version you may have copied.
>
> I've always used:
> configure --prefix=/usr/local/apache --enable-so --enable-modules=all
> --disable-dav --with-included-apr --enable-suexec
> --with-suexec-docroot=/var/www --with-suexec-caller=apache
> --with-suexec-logfile=/var/log/apache/suexec_log
>
> which works very well.
>
> <SNIP>
>
> Your conf file entries look good to me
>
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Res <re...@ausics.net>.
On Mon, 19 Nov 2007, Daniel Campbell wrote:
> My configure opitions are:
> CONFIGUREOPTS="--prefix=/usr --localstatedir=/var --enable-rewrite
> --enable-http --enable-cgi --enable-so \
> --enable-ssl --enable-headers --bindir=/usr/bin --sbindir=/usr/sbin
> --libexecdir=/usr/libexec --datadir=/var/www \
> --sysconfdir=/etc/apache --enable-dbd --with-ldap --enable-ldap
> --enable-authnz-ldap --enable-authn-dbd \
> --with-mysql=/usr/lib/mysql --with-included-apr"
>
> It is a Slackware 12.0 linux box.
Where did you get the idea to configure like this?
--with-mysql is not an apache option, so your example that you copied is
wrong. Looks like a redhat bastardised version you may have copied.
I've always used:
configure --prefix=/usr/local/apache --enable-so --enable-modules=all
--disable-dav --with-included-apr --enable-suexec
--with-suexec-docroot=/var/www --with-suexec-caller=apache
--with-suexec-logfile=/var/log/apache/suexec_log
which works very well.
<SNIP>
Your conf file entries look good to me
--
Cheers
Res
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
Yes
Danie Qian wrote:
> had you installed mysql driver before you compiled httpd?
>
>
> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
> To: <us...@httpd.apache.org>
> Sent: Monday, November 19, 2007 11:29 AM
> Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
>
>
>> My configure opitions are:
>> CONFIGUREOPTS="--prefix=/usr --localstatedir=/var --enable-rewrite
>> --enable-http --enable-cgi --enable-so \
>> --enable-ssl --enable-headers --bindir=/usr/bin --sbindir=/usr/sbin
>> --libexecdir=/usr/libexec --datadir=/var/www \
>> --sysconfdir=/etc/apache --enable-dbd --with-ldap --enable-ldap
>> --enable-authnz-ldap --enable-authn-dbd \
>> --with-mysql=/usr/lib/mysql --with-included-apr"
>>
>> It is a Slackware 12.0 linux box.
>>
>> Danie Qian wrote:
>>>
>>> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
>>> To: <us...@httpd.apache.org>
>>> Sent: Monday, November 19, 2007 10:52 AM
>>> Subject: [users@httpd] dbd mysql segmentation fault in 2.2.6
>>>
>>>
>>>> After quite a bit of trouble I finally got the dbd mysql compiled but
>>>> now as soon as I put the "DBDriver mysql" directive into the
>>>> httpd.conf file I get endless Segmentation Fault messages in the
>>>> error log. I set the LogLevel to debug but that doesn't help any. Any
>>>> suggestions? Below is my DBDriver call:
>>>>
>>>> DBDriver mysql
>>>> #Connection string: database name and login credentials
>>>> DBDParams "host=mysql.my.domain.com dbname=stats user=stats
>>>> password=stats"
>>>>
>>>> #Parameters for Connection Pool Management
>>>> DBDMin 1
>>>> DBDKeep 2
>>>> DBDMax 10
>>>> DBDExptime 60
>>>>
>>>> #Authentication Section
>>>> <Directory /home/websites/my.domain.com/htdocs/stats>
>>>> #mod_auth configuration for authn_dbd
>>>> Options All
>>>> AllowOverride none
>>>> AuthType Basic
>>>> AuthName "Statistics"
>>>> AuthBasicProvider dbd
>>>>
>>>> #authz configuration
>>>> Require valid-user
>>>> #SQL query to verify a user
>>>> #(note: DBD drivers recognise both stdio-like %s and native syntax)
>>>> AuthDBDUserPWQuery "select linux_password from employees where
>>>> username = %s AND on2admin = 'Y'"
>>>> </Directory>
>>>>
>>>
>>> How did you configure and compile httpd?
>>>
>>>
>>> ---------------------------------------------------------------------
>>> The official User-To-User support forum of the Apache HTTP Server
>>> Project.
>>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>>> For additional commands, e-mail: users-help@httpd.apache.org
>>>
>>
>> ---------------------------------------------------------------------
>> The official User-To-User support forum of the Apache HTTP Server
>> Project.
>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>> For additional commands, e-mail: users-help@httpd.apache.org
>>
>>
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
had you installed mysql driver before you compiled httpd?
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Monday, November 19, 2007 11:29 AM
Subject: Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
> My configure opitions are:
> CONFIGUREOPTS="--prefix=/usr --localstatedir=/var --enable-rewrite
> --enable-http --enable-cgi --enable-so \
> --enable-ssl --enable-headers --bindir=/usr/bin --sbindir=/usr/sbin
> --libexecdir=/usr/libexec --datadir=/var/www \
> --sysconfdir=/etc/apache --enable-dbd --with-ldap --enable-ldap
> --enable-authnz-ldap --enable-authn-dbd \
> --with-mysql=/usr/lib/mysql --with-included-apr"
>
> It is a Slackware 12.0 linux box.
>
> Danie Qian wrote:
>>
>> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
>> To: <us...@httpd.apache.org>
>> Sent: Monday, November 19, 2007 10:52 AM
>> Subject: [users@httpd] dbd mysql segmentation fault in 2.2.6
>>
>>
>>> After quite a bit of trouble I finally got the dbd mysql compiled but
>>> now as soon as I put the "DBDriver mysql" directive into the
>>> httpd.conf file I get endless Segmentation Fault messages in the
>>> error log. I set the LogLevel to debug but that doesn't help any. Any
>>> suggestions? Below is my DBDriver call:
>>>
>>> DBDriver mysql
>>> #Connection string: database name and login credentials
>>> DBDParams "host=mysql.my.domain.com dbname=stats user=stats
>>> password=stats"
>>>
>>> #Parameters for Connection Pool Management
>>> DBDMin 1
>>> DBDKeep 2
>>> DBDMax 10
>>> DBDExptime 60
>>>
>>> #Authentication Section
>>> <Directory /home/websites/my.domain.com/htdocs/stats>
>>> #mod_auth configuration for authn_dbd
>>> Options All
>>> AllowOverride none
>>> AuthType Basic
>>> AuthName "Statistics"
>>> AuthBasicProvider dbd
>>>
>>> #authz configuration
>>> Require valid-user
>>> #SQL query to verify a user
>>> #(note: DBD drivers recognise both stdio-like %s and native syntax)
>>> AuthDBDUserPWQuery "select linux_password from employees where
>>> username = %s AND on2admin = 'Y'"
>>> </Directory>
>>>
>>
>> How did you configure and compile httpd?
>>
>>
>> ---------------------------------------------------------------------
>> The official User-To-User support forum of the Apache HTTP Server
>> Project.
>> See <URL:http://httpd.apache.org/userslist.html> for more info.
>> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>> " from the digest: users-digest-unsubscribe@httpd.apache.org
>> For additional commands, e-mail: users-help@httpd.apache.org
>>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Daniel Campbell <ca...@on2.com>.
My configure opitions are:
CONFIGUREOPTS="--prefix=/usr --localstatedir=/var --enable-rewrite
--enable-http --enable-cgi --enable-so \
--enable-ssl --enable-headers --bindir=/usr/bin --sbindir=/usr/sbin
--libexecdir=/usr/libexec --datadir=/var/www \
--sysconfdir=/etc/apache --enable-dbd --with-ldap --enable-ldap
--enable-authnz-ldap --enable-authn-dbd \
--with-mysql=/usr/lib/mysql --with-included-apr"
It is a Slackware 12.0 linux box.
Danie Qian wrote:
>
> ----- Original Message ----- From: "Daniel Campbell" <ca...@on2.com>
> To: <us...@httpd.apache.org>
> Sent: Monday, November 19, 2007 10:52 AM
> Subject: [users@httpd] dbd mysql segmentation fault in 2.2.6
>
>
>> After quite a bit of trouble I finally got the dbd mysql compiled but
>> now as soon as I put the "DBDriver mysql" directive into the
>> httpd.conf file I get endless Segmentation Fault messages in the
>> error log. I set the LogLevel to debug but that doesn't help any. Any
>> suggestions? Below is my DBDriver call:
>>
>> DBDriver mysql
>> #Connection string: database name and login credentials
>> DBDParams "host=mysql.my.domain.com dbname=stats user=stats
>> password=stats"
>>
>> #Parameters for Connection Pool Management
>> DBDMin 1
>> DBDKeep 2
>> DBDMax 10
>> DBDExptime 60
>>
>> #Authentication Section
>> <Directory /home/websites/my.domain.com/htdocs/stats>
>> #mod_auth configuration for authn_dbd
>> Options All
>> AllowOverride none
>> AuthType Basic
>> AuthName "Statistics"
>> AuthBasicProvider dbd
>>
>> #authz configuration
>> Require valid-user
>> #SQL query to verify a user
>> #(note: DBD drivers recognise both stdio-like %s and native syntax)
>> AuthDBDUserPWQuery "select linux_password from employees where
>> username = %s AND on2admin = 'Y'"
>> </Directory>
>>
>
> How did you configure and compile httpd?
>
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server
> Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
> " from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org
Re: [users@httpd] dbd mysql segmentation fault in 2.2.6
Posted by Danie Qian <da...@bestningning.com>.
----- Original Message -----
From: "Daniel Campbell" <ca...@on2.com>
To: <us...@httpd.apache.org>
Sent: Monday, November 19, 2007 10:52 AM
Subject: [users@httpd] dbd mysql segmentation fault in 2.2.6
> After quite a bit of trouble I finally got the dbd mysql compiled but now
> as soon as I put the "DBDriver mysql" directive into the httpd.conf file I
> get endless Segmentation Fault messages in the error log. I set the
> LogLevel to debug but that doesn't help any. Any suggestions? Below is
> my DBDriver call:
>
> DBDriver mysql
> #Connection string: database name and login credentials
> DBDParams "host=mysql.my.domain.com dbname=stats user=stats
> password=stats"
>
> #Parameters for Connection Pool Management
> DBDMin 1
> DBDKeep 2
> DBDMax 10
> DBDExptime 60
>
> #Authentication Section
> <Directory /home/websites/my.domain.com/htdocs/stats>
> #mod_auth configuration for authn_dbd
> Options All
> AllowOverride none
> AuthType Basic
> AuthName "Statistics"
> AuthBasicProvider dbd
>
> #authz configuration
> Require valid-user
> #SQL query to verify a user
> #(note: DBD drivers recognise both stdio-like %s and native syntax)
> AuthDBDUserPWQuery "select linux_password from employees where username =
> %s AND on2admin = 'Y'"
> </Directory>
>
How did you configure and compile httpd?
---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
" from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org