mnogosearch 3.1.8, mysql 3.23.22
This happened:
The search worked fine. Then I re-installed MySQL (3.23 instead
of 3.22) and Apache, and the directory structure of both changed.
I moved the old search.cgi to the new cgi-bin. I exported the old
database with mysqldump and re-imported it in the new MYI/MYD
format in the same (deleted and re-created) database. The indexer
works fine in the new setup with the old configuration. The search
does not; it returns "an error occured".
This is what I tried:
- Searched the Apache and MySQL error logs. Nothing there. Most
important, there are no "access denied" messages in the mysql log,
meaning that the search never even reaches mysql before it fails.
- Recompiled and reinstalled mnogosearch and copied the new search.cgi
to cgi-bin. It didn't help.
- Double-checked search.htm. This shouldn't be necessary since both
the database and search.htm are the same as before, but anyway. The
DBAddr statement is identical to the one in indexer.conf, including
trailing slash. So are the DBMode and charset statements.
- Beat my wife, screamed to the dog, kicked my children and broke my
monitor. That didn't help either.
Finally I straced search.cgi, but I don't understand the output. If
you do, you'll find it below.
Any ideas?
Z
=================================strace.out=============================
execve("/var/www/cgi-bin/search.cgi", ["/var/www/cgi-bin/search.cgi"], [/* 24 vars
*/]) = 0
_sysctl({{CTL_KERN, KERN_OSRELEASE}, 2, "2.2.16-22", 9, NULL, 0}) = 0
brk(0) = 0x80908c0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40016000
open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 4
fstat64(4, 0xbffff32c) = -1 ENOSYS (Function not implemented)
fstat(4, {st_mode=S_IFREG|0644, st_size=21769, ...}) = 0
old_mmap(NULL, 21769, PROT_READ, MAP_PRIVATE, 4, 0) = 0x40017000
close(4) = 0
open("/usr/lib/mysql/libmysqlclient.so.9", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0755, st_size=196204, ...}) = 0
read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 d\0\000"..., 4096) = 4096
old_mmap(NULL, 172480, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4, 0) = 0x4001d000
mprotect(0x40036000, 70080, PROT_NONE) = 0
old_mmap(0x40036000, 69632, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 4, 0x18000) =
0x40036000
old_mmap(0x40047000, 448, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS,
-1, 0) = 0x40047000
close(4) = 0
open("/lib/libm.so.6", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0755, st_size=493588, ...}) = 0
read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\300I\0"..., 4096) = 4096
old_mmap(NULL, 125352, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4, 0) = 0x40048000
mprotect(0x40066000, 2472, PROT_NONE) = 0
old_mmap(0x40066000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 4, 0x1d000) =
0x40066000
close(4) = 0
open("/usr/lib/libz.so.1", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0755, st_size=58940, ...}) = 0
read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0000\36\0"..., 4096) = 4096
old_mmap(NULL, 54064, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4, 0) = 0x40067000
mprotect(0x40073000, 4912, PROT_NONE) = 0
old_mmap(0x40073000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 4, 0xb000) =
0x40073000
close(4) = 0
open("/lib/libc.so.6", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0755, st_size=4686077, ...}) = 0
read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\230\270"..., 4096) = 4096
old_mmap(NULL, 1167368, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4, 0) = 0x40075000
mprotect(0x40189000, 36872, PROT_NONE) = 0
old_mmap(0x40189000, 24576, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 4, 0x113000)
= 0x40189000
old_mmap(0x4018f000, 12296, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS,
-1, 0) = 0x4018f000
close(4) = 0
open("/lib/libnsl.so.1", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0755, st_size=392107, ...}) = 0
read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p?\0\000"..., 4096) = 4096
old_mmap(NULL, 93120, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4, 0) = 0x40193000
mprotect(0x401a7000, 11200, PROT_NONE) = 0
old_mmap(0x401a7000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 4, 0x13000) =
0x401a7000
old_mmap(0x401a8000, 7104, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS,
-1, 0) = 0x401a8000
close(4) = 0
open("/lib/libcrypt.so.1", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0755, st_size=82333, ...}) = 0
read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200\17"..., 4096) = 4096
old_mmap(NULL, 184252, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4, 0) = 0x401aa000
mprotect(0x401af000, 163772, PROT_NONE) = 0
old_mmap(0x401af000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED, 4, 0x4000) =
0x401af000
old_mmap(0x401b0000, 159676, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401b0000
close(4) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x401d7000
mprotect(0x40067000, 49152, PROT_READ|PROT_WRITE) = 0
mprotect(0x40067000, 49152, PROT_READ|PROT_EXEC) = 0
munmap(0x40017000, 21769) = 0
getpid() = 17493
brk(0) = 0x80908c0
brk(0x8090918) = 0x8090918
brk(0x8091000) = 0x8091000
open("/etc/localtime", O_RDONLY) = 4
fstat64(4, 0xbfff7ec0) = -1 ENOSYS (Function not implemented)
fstat(4, {st_mode=S_IFREG|0644, st_size=1058, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40017000
read(4, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\v\0\0\0\v\0"..., 4096) = 1058
close(4) = 0
munmap(0x40017000, 4096) = 0
brk(0x80a1000) = 0x80a1000
brk(0x80a3000) = 0x80a3000
time(NULL) = 974000906
open("/usr/local/mnogosearch/etc/search.htm", O_RDONLY) = 4
fstat(4, {st_mode=S_IFREG|0644, st_size=5277, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40017000
read(4, "<!--\n\n This is default templa"..., 4096) = 4096
brk(0x80a4000) = 0x80a4000
read(4, "$DC) $DM\n<!--/clone-->\n\n<!--navi"..., 4096) = 1181
read(4, "", 4096) = 0
close(4) = 0
munmap(0x40017000, 4096) = 0
brk(0x80a5000) = 0x80a5000
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(4, 2), ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) =
0x40017000
ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0
write(1, "<HTML>\n", 7) = 7
write(1, "<HEAD>\n", 7) = 7
write(1, " <TITLE>ARSCC (wdne) search: </T"..., 38) = 38
write(1, "</HEAD>\n", 8) = 8
write(1, "\n", 1) = 1
write(1, "\n", 1) = 1
write(1, "<body BGCOLOR=\"#FFFFFF\" LINK=\"#0"..., 72) = 72
write(1, "<center>\n", 9) = 9
write(1, "<FORM METHOD=GET ACTION=\"\">\n", 28) = 28
write(1, "<table bgcolor=#eeeee0 order=1 w"..., 43) = 43
write(1, "<tr><td>\n", 9) = 9
write(1, "<BR>\n", 5) = 5
write(1, "Search for: <INPUT TYPE=\"text\" N"..., 58) = 58
write(1, "<INPUT TYPE=\"submit\" VALUE=\"Sear"..., 42) = 42
write(1, "\n", 1) = 1
write(1, "Results per page:\n", 18) = 18
write(1, "<SELECT NAME=\"ps\">\n", 19) = 19
write(1, "<OPTION VALUE=\"10\">10\n", 22) = 22
write(1, "<OPTION VALUE=\"20\" SELECTED>20\n", 31) = 31
write(1, "<OPTION VALUE=\"50\">50\n", 22) = 22
write(1, "</SELECT>\n", 10) = 10
write(1, "\n", 1) = 1
write(1, "Output format:\n", 15) = 15
write(1, "<SELECT NAME=\"o\">\n", 18) = 18
write(1, "<OPTION VALUE=\"0\" SELECTED>Long\n", 32) = 32
write(1, "<OPTION VALUE=\"1\">Short\n", 24) = 24
write(1, "<OPTION VALUE=\"2\">URL\n", 22) = 22
write(1, "</SELECT>\n", 10) = 10
write(1, "\n", 1) = 1
write(1, "\n", 1) = 1
write(1, "Match:\n", 7) = 7
write(1, "<SELECT NAME=\"m\">\n", 18) = 18
write(1, "<OPTION VALUE=\"all\" SELECTED>All"..., 33) = 33
write(1, "<OPTION VALUE=\"any\">Any\n", 24) = 24
write(1, "<OPTION VALUE=\"bool\">Boolean\n", 29) = 29
write(1, "</SELECT>\n", 10) = 10
write(1, "\n", 1) = 1
write(1, "<!-- Use this to limit URL match"..., 37) = 37
write(1, "\n", 1) = 1
write(1, " <!-- Search through:\n", 27) = 27
write(1, "<SELECT NAME=\"ul\">\n", 19) = 19
write(1, "<OPTION VALUE=\"\" SELECTED>Entire"..., 38) = 38
write(1, "<OPTION VALUE=\"/manual/\">Manual\n", 32) = 32
write(1, "<OPTION VALUE=\"/products/\">Produ"..., 36) = 36
write(1, "<OPTION VALUE=\"/support/\">Suppor"..., 34) = 34
write(1, "</SELECT> -->\n", 15) = 15
write(1, "\n", 1) = 1
write(1, "<!-- Uncomment this to limit dat"..., 62) = 62
write(1, "Search through:\n", 16) = 16
write(1, "<SELECT NAME=\"t\">\n", 18) = 18
write(1, "<OPTION VALUE=\"\" SELECTED>All si"..., 36) = 36
write(1, "<OPTION VALUE=\"A\">Critics\n", 26) = 26
write(1, "<OPTION VALUE=\"B\">Free zone\n", 28) = 28
write(1, "<OPTION VALUE=\"C\">Reserved\n", 27) = 27
write(1, "</SELECT> \n", 12) = 12
write(1, "\n", 1) = 1
write(1, "\n", 1) = 1
write(1, "</td></tr>\n", 11) = 11
write(1, "</table>\n", 9) = 9
write(1, "</form>\n", 8) = 8
write(1, "</center>\n", 10) = 10
write(1, "<CENTER>\nYou haven\'t typed any w"..., 271) = 271
munmap(0x40017000, 4096) = 0
_exit(0) = ?
______________
If you want to unsubscribe send "unsubscribe udmsearch"
to [EMAIL PROTECTED]