Disclaimer: I am not a C programmer. I am guessing and attempting to be
intelligent!
Here follows an output of an strace on vuserinfo
Some interesting things are as follows.
102 open("/var/db/mysql/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) = -1
ENOENT (No such file or directory)
I dont know if this error is just my installation of mysql or something
else.
The file vuserinfo is looking for is in
/usr/local/mysql/share/mysql/charsets/
I don't think this the main problem though
109 write(3, "L\0\0\0\3select pw_name, pw_passwd, "..., 80) = 80
110 read(3, "9\0\0\1", 4) = 4
111 read(3, "\377(\4You have an error in your SQL"..., 57) = 57
This looks like vuserinfo has connected to mysql but issued a broken select
statement and will return "vsql_getpw: failed select"
Line 111 looks like the mysqld returning the error. Does any one know how I
can get the full error returned, or the full select statement?
1 execve("/home/vpopmail/bin/vuserinfo", ["vuserinfo",
"[EMAIL PROTECTED]"], [/* 19 vars */]) = 0
2 brk(0) = 0x80551a8
3 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40014000
4 open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such file or
directory)
5 open("/etc/ld.so.cache", O_RDONLY) = 3
6 fstat(3, {st_mode=S_IFREG|0644, st_size=12316, ...}) = 0
7 old_mmap(NULL, 12316, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40015000
8 close(3) = 0
9 open("/usr/local/mysql/lib/mysql/libmysqlclient.so.10", O_RDONLY) =
3
10 fstat(3, {st_mode=S_IFREG|0755, st_size=131537, ...}) = 0
11 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200Y\0"...,
4096) = 4096
12 old_mmap(NULL, 109216, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40019000
13 mprotect(0x40030000, 15008, PROT_NONE) = 0
14 old_mmap(0x40030000, 16384, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0x16000) = 0x40030000
15 close(3) = 0
16 open("/usr/lib/libz.so.1", O_RDONLY) = 3
17 fstat(3, {st_mode=S_IFREG|0755, st_size=63492, ...}) = 0
18 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\240\31"...,
4096) = 4096
19 old_mmap(NULL, 58700, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40034000
20 mprotect(0x40041000, 5452, PROT_NONE) = 0
21 old_mmap(0x40041000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0xc000) = 0x40041000
22 close(3) = 0
23 open("/lib/libnsl.so.1", O_RDONLY) = 3
24 fstat(3, {st_mode=S_IFREG|0755, st_size=370141, ...}) = 0
25 read(3,
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20?\0\000"..., 4096) = 4096
26 old_mmap(NULL, 88104, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40043000
27 mprotect(0x40055000, 14376, PROT_NONE) = 0
28 old_mmap(0x40055000, 8192, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0x11000) = 0x40055000
29 old_mmap(0x40057000, 6184, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40057000
30 close(3) = 0
31 open("/lib/libcrypt.so.1", O_RDONLY) = 3
32 fstat(3, {st_mode=S_IFREG|0755, st_size=66231, ...}) = 0
33 read(3,
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@\17\0\000"..., 4096) = 4096
34 old_mmap(NULL, 184412, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40059000
35 mprotect(0x4005e000, 163932, PROT_NONE) = 0
36 old_mmap(0x4005e000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0x4000) = 0x4005e000
37 old_mmap(0x4005f000, 159836, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4005f000
38 close(3) = 0
39 open("/lib/libm.so.6", O_RDONLY) = 3
40 fstat(3, {st_mode=S_IFREG|0755, st_size=527442, ...}) = 0
41 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320F\0"...,
4096) = 4096
42 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40087000
43 old_mmap(NULL, 117208, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x40088000
44 mprotect(0x400a4000, 2520, PROT_NONE) = 0
45 old_mmap(0x400a4000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0x1b000) = 0x400a4000
46 close(3) = 0
47 open("/lib/libc.so.6", O_RDONLY) = 3
48 fstat(3, {st_mode=S_IFREG|0755, st_size=4101836, ...}) = 0
49 read(3,
"\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\210\212"..., 4096) = 4096
50 old_mmap(NULL, 1001532, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x400a5000
51 mprotect(0x40192000, 30780, PROT_NONE) = 0
52 old_mmap(0x40192000, 16384, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0xec000) = 0x40192000
53 old_mmap(0x40196000, 14396, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40196000
54 close(3) = 0
55 mprotect(0x400a5000, 970752, PROT_READ|PROT_WRITE) = 0
56 mprotect(0x400a5000, 970752, PROT_READ|PROT_EXEC) = 0
57 munmap(0x40015000, 12316) = 0
58 personality(PER_LINUX) = 0
59 getpid() = 1941
60 brk(0) = 0x80551a8
61 brk(0x80555c0) = 0x80555c0
62 brk(0x8056000) = 0x8056000
63 open("/etc/nsswitch.conf", O_RDONLY) = 3
64 fstat64(0x3, 0xbffff9cc) = -1 ENOSYS (Function not
implemented)
65 fstat(3, {st_mode=S_IFREG|0644, st_size=1744, ...}) = 0
66 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40015000
67 read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1744
68 read(3, "", 4096) = 0
69 close(3) = 0
70 munmap(0x40015000, 4096) = 0
71 open("/etc/ld.so.cache", O_RDONLY) = 3
72 fstat(3, {st_mode=S_IFREG|0644, st_size=12316, ...}) = 0
73 old_mmap(NULL, 12316, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40015000
74 close(3) = 0
75 open("/lib/libnss_files.so.2", O_RDONLY) = 3
76 fstat(3, {st_mode=S_IFREG|0755, st_size=246652, ...}) = 0
77 read(3, "\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
78 old_mmap(NULL, 36384, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
0x4019a000
79 mprotect(0x401a2000, 3616, PROT_NONE) = 0
80 old_mmap(0x401a2000, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_FIXED, 3, 0x7000) = 0x401a2000
81 close(3) = 0
82 munmap(0x40015000, 12316) = 0
83 brk(0x8057000) = 0x8057000
84 open("/etc/services", O_RDONLY) = 3
85 fcntl(3, F_GETFD) = 0
86 fcntl(3, F_SETFD, FD_CLOEXEC) = 0
87 fstat(3, {st_mode=S_IFREG|0644, st_size=11349, ...}) = 0
88 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40015000
89 read(3, "# /etc/services:\n# $Id: services"..., 4096) = 4096
90 read(3, "\t\t# Protocol v3\nrpc2portmap\t369/"..., 4096) = 4096
91 close(3) = 0
92 munmap(0x40015000, 4096) = 0
93 rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0
94 socket(PF_UNIX, SOCK_STREAM, 0) = 3
95 fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
96 connect(3, {sin_family=AF_UNIX, path="
97 /tmp/mysql.sock"}, 110) = 0
98 brk(0x805a000) = 0x805a000
99 setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
100 read(3, ",\0\0\0", 4) = 4
101 read(3, "\n3.23.32-log\0\'K\0\0+7oMpoZV\0, \10\2\0\0"..., 44) = 44
102 open("/var/db/mysql/mysql/charsets/Index", O_RDONLY|O_LARGEFILE) =
-1 ENOENT (No such file or directory)
103 write(3, "\37\0\0\1\215 \0\0\0vpopmail\0[JKNQB]J\0vpopm"..., 35) =
35
104 read(3, "\5\0\0\2", 4) = 4
105 read(3, "\0\0\0\2\0", 5) = 5
106 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
107 read(3, 0x8055fd0, 8192) = -1 EAGAIN (Resource
temporarily unavailable)
108 fcntl(3, F_SETFL, O_RDWR) = 0
109 write(3, "L\0\0\0\3select pw_name, pw_passwd, "..., 80) = 80
110 read(3, "9\0\0\1", 4) = 4
111 read(3, "\377(\4You have an error in your SQL"..., 57) = 57
112 fstat(1, {st_mode=S_IFCHR|0600, st_rdev=makedev(136, 11), ...}) = 0
113 old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40015000
114 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0
115 write(1, "vsql_getpw: failed select\n", 26vsql_getpw: failed select
116 ) = 26
117 fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
118 read(3, 0x8055fd0, 8192) = -1 EAGAIN (Resource
temporarily unavailable)
119 fcntl(3, F_SETFL, O_RDWR) = 0
120 write(3, "\1\0\0\0\1", 5) = 5
121 shutdown(3, 2 /* send and receive */) = 0
122 close(3) = 0
123 munmap(0x40015000, 4096) = 0
124 _exit(0) = ?
--
Regards,
Kieran Barnes
Signum 1226 Ltd
Visit our website at http://www.1226.net
Phone: 01772 622889 || Fax: 01772 622558
