[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: checkpassword



Hi Jason,

Can you verify that the login specified in 'popconnectionstring' has 
SELECT privileges on table 'passwd'.
Can you also give us the password stored for jason@xxxxxxxxxxx using 
this query:
select password from passwd where login='jason' and virtual_host='virtual.org';

Regards,
Michael


On Tue, Dec 09, 2003 at 08:07:16AM -0400, Jason King wrote:
> 
> Still no go with the newer one, here is the trace out put..
> 
> [root@MailMan checkpassword-0.90]# strace -fF -v
> /var/qmail/bin/qmail-popup virtual.org \
> > /bin/checkpassword pwd
> execve("/var/qmail/bin/qmail-popup", ["/var/qmail/bin/qmail-popup",
> "virtual.org", "/bin/checkpassword", "pwd"], [/* 25 vars */]) = 0
> uname({sysname="Linux", nodename="MailMan.freemotion.bb",
> release="2.4.7-10enterprise", version="#1 SMP Thu Sep 6 16:48:20 EDT
> 2001", machine="i686"}) = 0
> brk(0)                                  = 0x804c074
> open("/etc/ld.so.preload", O_RDONLY)    = -1 ENOENT (No such file or
> directory)
> open("/etc/ld.so.cache", O_RDONLY)      = 3
> fstat64(3, {st_dev=makedev(8, 2), st_ino=229340, st_mode=S_IFREG|0644,
> st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096, st_blocks=128,
> st_size=59137, st_atime=2003/12/09-07:41:28,
> st_mtime=2003/12/05-10:20:37, st_ctime=2003/12/05-10:20:37}) = 0
> old_mmap(NULL, 59137, PROT_READ, MAP_PRIVATE, 3, 0) = 0x40017000
> close(3)                                = 0
> open("/lib/i686/libc.so.6", O_RDONLY)   = 3
> read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0 \306\1"...,
> 1024) = 1024
> fstat64(3, {st_dev=makedev(8, 2), st_ino=586386, st_mode=S_IFREG|0755,
> st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096, st_blocks=11304,
> st_size=5772268, st_atime=2003/12/09-07:41:28,
> st_mtime=2001/09/04-15:46:11, st_ctime=2003/12/04-08:25:34}) = 0
> old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS,
> -1, 0) = 0x40026000
> old_mmap(NULL, 1290088, PROT_READ|PROT_EXEC, MAP_PRIVATE, 3, 0) =
> 0x40027000
> mprotect(0x40159000, 36712, PROT_NONE)  = 0
> old_mmap(0x40159000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED,
> 3, 0x131000) = 0x40159000
> old_mmap(0x4015e000, 16232, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4015e000
> close(3)                                = 0
> munmap(0x40017000, 59137)               = 0
> rt_sigaction(SIGALRM, {0x8048890, [], 0x4000000}, NULL, 8) = 0
> rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
> getpid()                                = 13644
> time(NULL)                              = 1070970088
> select(2, NULL, [1], NULL, {1200, 0})   = 1 (out [1], left {1200, 0})
> write(1, "+OK <13644.1070970088@xxxxxxxxxx"..., 36+OK
> <13644.1070970088@xxxxxxxxxxx>
> ) = 36
> select(1, [0], NULL, NULL, {1200, 0}user jason@xxxxxxxxxxx
> )   = 1 (in [0], left {1189, 280000})
> read(0, "user jason@xxxxxxxxxxx\n", 128) = 23
> select(2, NULL, [1], NULL, {1200, 0})   = 1 (out [1], left {1200, 0})
> write(1, "+OK \r\n", 6+OK 
> )                 = 6
> select(1, [0], NULL, NULL, {1200, 0}pass test
> )   = 1 (in [0], left {1195, 350000})
> read(0, "pass test\n", 128)             = 10
> fcntl64(0x1, 0x3, 0, 0x1)               = 32770
> close(2)                                = 0
> fcntl64(0x1, 0, 0x2, 0x1)               = 2
> close(3)                                = -1 EBADF (Bad file descriptor)
> pipe([3, 4])                            = 0
> fork()                                  = 13645
> [pid 13645] close(4 <unfinished ...>
> [pid 13644] close(3 <unfinished ...>
> [pid 13645] <... close resumed> )       = 0
> [pid 13644] <... close resumed> )       = 0
> [pid 13645] rt_sigaction(SIGPIPE, {SIG_DFL}, NULL, 8) = 0
> [pid 13645] execve("/bin/checkpassword", ["/bin/checkpassword", "pwd"],
> ["PWD=/downloads/checkpassword-0.9"...,
> "HOSTNAME=MailMan.freemotion.bb", "QTDIR=/usr/lib/qt-2.3.1",
> "LESSOPEN=|/usr/bin/lesspipe.sh %"..., "KDEDIR=/usr", "USER=root",
> "LS_COLORS=no=00:fi=00:di=01;34:l"..., "MACHTYPE=i386-redhat-linux-gnu",
> "MAIL=/var/spool/mail/root", "OLDPWD=/downloads/checkpassword-"...,
> "INPUTRC=/etc/inputrc", "BASH_ENV=/root/.bashrc", "LANG=en_US",
> "LOGNAME=root", "SHLVL=1", "SHELL=/bin/bash", "USERNAME=root",
> "HOSTTYPE=i386", "OSTYPE=linux-gnu", "HISTSIZE=1000", "HOME=/root",
> "TERM=vt100", "PATH=/usr/local/sbin:/usr/local/"...,
> "SSH_TTY=/dev/pts/0", "_=/usr/bin/strace"] <unfinished ...>
> [pid 13644] write(4, "jason@xxxxxxxxxxx\0test\0<13644.10"..., 54) = 54
> [pid 13645] <... execve resumed> )      = 0
> [pid 13644] close(4)                    = 0
> [pid 13645] uname( <unfinished ...>
> [pid 13644] wait4(13645,  <unfinished ...>
> [pid 13645] <... uname resumed> {sysname="Linux",
> nodename="MailMan.freemotion.bb", release="2.4.7-10enterprise",
> version="#1 SMP Thu Sep 6 16:48:20 EDT 2001", machine="i686"}) = 0
> [pid 13645] brk(0)                      = 0x804d290
> [pid 13645] open("/etc/ld.so.preload", O_RDONLY) = -1 ENOENT (No such
> file or directory)
> [pid 13645] open("/etc/ld.so.cache", O_RDONLY) = 4
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=229340,
> st_mode=S_IFREG|0644, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=128, st_size=59137, st_atime=2003/12/09-07:41:28,
> st_mtime=2003/12/05-10:20:37, st_ctime=2003/12/05-10:20:37}) = 0
> [pid 13645] old_mmap(NULL, 59137, PROT_READ, MAP_PRIVATE, 4, 0) =
> 0x40017000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/libcrypt.so.1", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\17\0\000"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=390948,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=176, st_size=85115, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:36:41, st_ctime=2003/12/04-08:25:35}) = 0
> [pid 13645] old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40026000
> [pid 13645] old_mmap(NULL, 183900, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x40027000
> [pid 13645] mprotect(0x4002c000, 163420, PROT_NONE) = 0
> [pid 13645] old_mmap(0x4002c000, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x4000) = 0x4002c000
> [pid 13645] old_mmap(0x4002d000, 159324, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x4002d000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/usr/lib/libmysqlclient.so.10", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\220q\0"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=325873,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=448, st_size=224606, st_atime=2003/12/09-07:41:43,
> st_mtime=2003/09/11-02:29:38, st_ctime=2003/12/05-07:38:54}) = 0
> [pid 13645] old_mmap(NULL, 199488, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x40054000
> [pid 13645] mprotect(0x40072000, 76608, PROT_NONE) = 0
> [pid 13645] old_mmap(0x40072000, 77824, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x1d000) = 0x40072000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/i686/libc.so.6", O_RDONLY) = 4
> [pid 13645] read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0
> \306\1"..., 1024) = 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=586386,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=11304, st_size=5772268, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:46:11, st_ctime=2003/12/04-08:25:34}) = 0
> [pid 13645] old_mmap(NULL, 1290088, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x40085000
> [pid 13645] mprotect(0x401b7000, 36712, PROT_NONE) = 0
> [pid 13645] old_mmap(0x401b7000, 20480, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x131000) = 0x401b7000
> [pid 13645] old_mmap(0x401bc000, 16232, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401bc000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/usr/lib/libz.so.1", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20\31\0"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=325875,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=128, st_size=59618, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/08/26-13:52:24, st_ctime=2003/12/04-08:27:22}) = 0
> [pid 13645] old_mmap(NULL, 54824, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x401c0000
> [pid 13645] mprotect(0x401cc000, 5672, PROT_NONE) = 0
> [pid 13645] old_mmap(0x401cc000, 8192, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0xb000) = 0x401cc000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/libnsl.so.1", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\20?\0\000"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=390955,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=864, st_size=436784, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:36:55, st_ctime=2003/12/04-08:25:35}) = 0
> [pid 13645] old_mmap(NULL, 89756, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x401ce000
> [pid 13645] mprotect(0x401e1000, 11932, PROT_NONE) = 0
> [pid 13645] old_mmap(0x401e1000, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x12000) = 0x401e1000
> [pid 13645] old_mmap(0x401e2000, 7836, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x401e2000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/i686/libm.so.6", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320H\0"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=586388,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=1224, st_size=622317, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:47:28, st_ctime=2003/12/04-08:25:34}) = 0
> [pid 13645] old_mmap(NULL, 142580, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x401e4000
> [pid 13645] mprotect(0x40206000, 3316, PROT_NONE) = 0
> [pid 13645] old_mmap(0x40206000, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x21000) = 0x40206000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/libnss_files.so.2", O_RDONLY) = 4
> [pid 13645] read(4, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200
> \0"..., 1024) = 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=390971,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=520, st_size=261460, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:36:51, st_ctime=2003/12/04-08:25:35}) = 0
> [pid 13645] old_mmap(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40207000
> [pid 13645] old_mmap(NULL, 42408, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x40208000
> [pid 13645] mprotect(0x40212000, 1448, PROT_NONE) = 0
> [pid 13645] old_mmap(0x40212000, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x9000) = 0x40212000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/libnss_dns.so.2", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320\r\0"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=390968,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=152, st_size=72296, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:36:47, st_ctime=2003/12/04-08:25:35}) = 0
> [pid 13645] old_mmap(NULL, 16224, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x40213000
> [pid 13645] mprotect(0x40216000, 3936, PROT_NONE) = 0
> [pid 13645] old_mmap(0x40216000, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0x2000) = 0x40216000
> [pid 13645] close(4)                    = 0
> [pid 13645] open("/lib/libresolv.so.2", O_RDONLY) = 4
> [pid 13645] read(4,
> "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\220\'\0"..., 1024) =
> 1024
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=390984,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=520, st_size=261196, st_atime=2003/12/09-07:41:43,
> st_mtime=2001/09/04-15:36:46, st_ctime=2003/12/04-08:25:35}) = 0
> [pid 13645] old_mmap(NULL, 72512, PROT_READ|PROT_EXEC, MAP_PRIVATE, 4,
> 0) = 0x40217000
> [pid 13645] mprotect(0x40225000, 15168, PROT_NONE) = 0
> [pid 13645] old_mmap(0x40225000, 8192, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED, 4, 0xd000) = 0x40225000
> [pid 13645] old_mmap(0x40227000, 6976, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x40227000
> [pid 13645] close(4)                    = 0
> [pid 13645] munmap(0x40017000, 59137)   = 0
> [pid 13645] read(3, "jason@xxxxxxxxxxx\0test\0<13644.10"..., 513) = 54
> [pid 13645] read(3, "", 459)            = 0
> [pid 13645] close(3)                    = 0
> [pid 13645] chdir("/var/qmail")         = 0
> [pid 13645] brk(0)                      = 0x804d290
> [pid 13645] brk(0x804d410)              = 0x804d410
> [pid 13645] brk(0x804e000)              = 0x804e000
> [pid 13645] open("control/sqlserver", O_RDONLY) = 3
> [pid 13645] fstat64(3, {st_dev=makedev(8, 2), st_ino=603815,
> st_mode=S_IFREG|0440, st_nlink=1, st_uid=506, st_gid=500,
> st_blksize=4096, st_blocks=8, st_size=566, st_atime=2003/12/09-07:40:29,
> st_mtime=2003/12/08-14:57:59, st_ctime=2003/12/08-14:57:59}) = 0
> [pid 13645] mmap2(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40017000
> [pid 13645] read(3, "check_host yes\nconnectionstring "..., 4096) = 566
> [pid 13645] read(3, "", 4096)           = 0
> [pid 13645] brk(0x8051000)              = 0x8051000
> [pid 13645] time([1070970103])          = 1070970103
> [pid 13645] open("/etc/localtime", O_RDONLY) = 4
> [pid 13645] fstat64(4, {st_dev=makedev(8, 2), st_ino=228108,
> st_mode=S_IFREG|0644, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=8, st_size=142, st_atime=2003/12/09-07:41:28,
> st_mtime=2003/12/04-09:47:09, st_ctime=2003/12/04-09:47:09}) = 0
> [pid 13645] mmap2(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000
> [pid 13645] read(4,
> "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\4\0\0\0\4\0"..., 4096) = 142
> [pid 13645] close(4)                    = 0
> [pid 13645] munmap(0x40018000, 4096)    = 0
> [pid 13645] rt_sigaction(SIGPIPE, {0x4016f0b0, [], 0x4000000},
> {SIG_DFL}, 8) = 0
> [pid 13645] socket(PF_UNIX, SOCK_DGRAM, 0) = 4
> [pid 13645] fcntl64(0x4, 0x2, 0x1, 0x4016ee80) = 0
> [pid 13645] connect(4, {sin_family=AF_UNIX, path="/dev/log"}, 16) = 0
> [pid 13645] send(4, "<21>Dec  9 07:41:43 checkpasswor"..., 88, 0) = 88
> [pid 13645] rt_sigaction(SIGPIPE, {SIG_DFL}, NULL, 8) = 0
> [pid 13645] open("/etc/nsswitch.conf", O_RDONLY) = 5
> [pid 13645] fstat64(5, {st_dev=makedev(8, 2), st_ino=228109,
> st_mode=S_IFREG|0644, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=8, st_size=1750, st_atime=2003/12/09-07:39:00,
> st_mtime=2003/12/04-09:47:09, st_ctime=2003/12/04-09:47:09}) = 0
> [pid 13645] mmap2(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000
> [pid 13645] read(5, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) =
> 1750
> [pid 13645] read(5, "", 4096)           = 0
> [pid 13645] close(5)                    = 0
> [pid 13645] munmap(0x40018000, 4096)    = 0
> [pid 13645] open("/etc/services", O_RDONLY) = 5
> [pid 13645] fcntl64(0x5, 0x1, 0, 0x1)   = 0
> [pid 13645] fcntl64(0x5, 0x2, 0x1, 0x1) = 0
> [pid 13645] fstat64(5, {st_dev=makedev(8, 2), st_ino=228105,
> st_mode=S_IFREG|0644, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=40, st_size=17884, st_atime=2003/12/09-07:39:00,
> st_mtime=2001/07/19-16:13:27, st_ctime=2003/12/04-08:25:32}) = 0
> 
> 
> [pid 13645] mmap2(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000
> [pid 13645] read(5, "# /etc/services:\n# $Id: services"..., 4096) = 4096
> [pid 13645] read(5, "\nnetbios-dgm\t138/tcp\t\t\t\t# NETBIO"..., 4096) =
> 4096
> [pid 13645] read(5, "cmd\t\t# no passwords used\nsyslog\t"..., 4096) =
> 4096
> [pid 13645] close(5)                    = 0
> [pid 13645] munmap(0x40018000, 4096)    = 0
> [pid 13645] rt_sigaction(SIGPIPE, {SIG_IGN}, {SIG_DFL}, 8) = 0
> [pid 13645] rt_sigaction(SIGALRM, {0x80498bc, [ALRM],
> SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0
> [pid 13645] rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
> [pid 13645] alarm(0)                    = 0
> [pid 13645] socket(PF_UNIX, SOCK_STREAM, 0) = 5
> [pid 13645] fcntl64(0x5, 0x3, 0xbfffedb8, 0x804e498) = 2
> [pid 13645] connect(5, {sin_family=AF_UNIX,
> path="/var/lib/mysql/mysql.sock"}, 110) = 0
> [pid 13645] brk(0x8054000)              = 0x8054000
> [pid 13645] setsockopt(5, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP
> (Operation not supported)
> [pid 13645] setsockopt(5, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
> [pid 13645] read(5, ",\0\0\0", 4)       = 4
> [pid 13645] read(5,
> "\n3.23.58-log\0\230\0\0\0$7+pspZQ\0,\0\10\2\0\0"..., 44) = 44
> [pid 13645] open("/usr/share/mysql/charsets/Index",
> O_RDONLY|O_LARGEFILE) = 6
> [pid 13645] fstat64(6, {st_dev=makedev(8, 2), st_ino=994596,
> st_mode=S_IFREG|0755, st_nlink=1, st_uid=0, st_gid=0, st_blksize=4096,
> st_blocks=8, st_size=549, st_atime=2003/12/09-07:39:00,
> st_mtime=2003/09/11-02:34:51, st_ctime=2003/12/05-07:38:51}) = 0
> [pid 13645] mmap2(NULL, 4096, PROT_READ|PROT_WRITE,
> MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40018000
> [pid 13645] read(6, "# sql/share/charsets/Index\n#\n# T"..., 4096) = 549
> [pid 13645] read(6, "", 4096)           = 0
> [pid 13645] close(6)                    = 0
> [pid 13645] munmap(0x40018000, 4096)    = 0
> [pid 13645] write(5, "\30\0\0\1\215 \377\377\377root\0MGL^FWI]\0qmail",
> 28) = 28
> [pid 13645] read(5, "\3\0\0\2", 4)      = 4
> [pid 13645] read(5, "\0\0\0", 3)        = 3
> [pid 13645] alarm(0)                    = 0
> [pid 13645] rt_sigprocmask(SIG_BLOCK, NULL, [], 8) = 0
> [pid 13645] alarm(0)                    = 0
> [pid 13645] fcntl64(0x5, 0x4, 0x802, 0) = 0
> [pid 13645] read(5, 0x804f980, 8192)    = -1 EAGAIN (Resource
> temporarily unavailable)
> [pid 13645] fcntl64(0x5, 0x4, 0x2, 0)   = 0
> [pid 13645] write(5, "\310\0\0\0\3SELECT login,uid,gid,home,p"..., 204)
> = 204
> [pid 13645] read(5, "\1\0\0\1", 4)      = 4
> [pid 13645] read(5, "\5", 1)            = 1
> [pid 13645] read(5, "\27\0\0\2", 4)     = 4
> [pid 13645] read(5, "\6passwd\5login\3@\0\0\1\375\3\3@\0", 23) = 23
> [pid 13645] read(5, "\25\0\0\3", 4)     = 4
> [pid 13645] read(5, "\6passwd\3uid\3\v\0\0\1\3\3\1\0\0", 21) = 21
> [pid 13645] read(5, "\25\0\0\4", 4)     = 4
> [pid 13645] read(5, "\6passwd\3gid\3\v\0\0\1\3\3\1\0\0", 21) = 21
> [pid 13645] read(5, "\26\0\0\5", 4)     = 4
> [pid 13645] read(5, "\6passwd\4home\3\310\0\0\1\375\3\1\0\0", 22) = 22
> [pid 13645] read(5, "\32\0\0\6", 4)     = 4
> [pid 13645] read(5, "\6passwd\10password\3\r\0\0\1\375\3\0\0\0", 26) =
> 26
> [pid 13645] read(5, "\1\0\0\7", 4)      = 4
> [pid 13645] read(5, "\376", 1)          = 1
> [pid 13645] brk(0x8056000)              = 0x8056000
> [pid 13645] read(5, "\'\0\0\10", 4)     = 4
> [pid 13645] read(5, "\5jason\0041000\0041000\21/home/virtual.o"..., 39)
> = 39
> [pid 13645] read(5, "\1\0\0\t", 4)      = 4
> [pid 13645] read(5, "\376", 1)          = 1
> [pid 13645] alarm(0)                    = 0
> [pid 13645] time([1070970103])          = 1070970103
> [pid 13645] rt_sigaction(SIGPIPE, {0x4016f0b0, [], 0x4000000},
> {SIG_IGN}, 8) = 0
> [pid 13645] send(4, "<21>Dec  9 07:41:43 checkpasswor"..., 70, 0) = 70
> [pid 13645] rt_sigaction(SIGPIPE, {SIG_IGN}, NULL, 8) = 0
> [pid 13645] _exit(1)                    = ?
> <... wait4 resumed> [WIFEXITED(s) && WEXITSTATUS(s) == 1], 0, NULL) =
> 13645
> --- SIGCHLD (Child exited) ---
> select(2, NULL, [1], NULL, {1200, 0})   = 1 (out [1], left {1200, 0})
> write(1, "-ERR authorization failed\r\n", 27-ERR authorization failed
> ) = 27
> _exit(1)                                = ?
> 
> 
> hope you can help
> mary x-mas
> Jason
> 
> 
> -----Original Message-----
> From: David Reoch [mailto:dave@xxxxxxxxxxxxx] 
> Sent: Monday, December 08, 2003 4:53 PM
> To: Jason King; qmail-sql@xxxxxxxxxx
> Subject: Re: checkpassword
> 
> 
> 
> Jason King wrote:
> 
> > Hi there I got the checkpassword to compile with no problems usesing
> the
> > checkpassword-0.90-sql-0.21.patch and it seems to run fine, when I run
> 
> > 
> > /var/qmail/bin/qmail-popup virtual.org /bin/checkpassword pwd 
> > 
> 
> Use your OS's process trace utility to follow the process.  On linux, do
> 
> this:
> 
> # strace -fF -v /var/qmail/bin/qmail-popup virtual.org \
> /bin/checkpassword pwd
> 
> dave
> 
> > It comes up and when I log into it, then is just tells me
> authorization
> > failed, I can see in the my sql logs that this dos work (the query
> gose
> > through) and if I goto the mysql console and do the same query it dos
> > come back.
> > 
> > Any thoughts.
> > 
> > -----------------------------------------------------------------
> > [This E-mail was scanned for viruses by the Freemotion mailman]
> > -----------------------------------------------------------------
> > 
> > 
> > 
> 
> -----------------------------------------------------------------
> [This E-mail was scanned for viruses by the Freemotion mailman]
> -----------------------------------------------------------------
> 
> 
> -----------------------------------------------------------------
> [This E-mail was scanned for viruses by the Freemotion mailman]
> -----------------------------------------------------------------
>