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

RE: checkpassword



Ok I got ya, thanks for the help,
But is there anyway to do this from windows.

I do not have a problem with this my self, but my customer reps will not
have a clue, they use a visual basic program that I wrote..

Any ideas welcom

-----Original Message-----
From: Michael Devogelaere [mailto:michael.devogelaere@xxxxxxxxxx] 
Sent: Tuesday, December 09, 2003 4:51 PM
To: Jason King
Subject: Re: checkpassword

Hi Jason,

That won't work: the password should be encrypted. You can encrypt it
with
simple tools like perl: perl -e "print crypt('test','MA')". That will
encrypt
'test' using the salt 'MA'. More information can be found in crypt(3).

Regards,
Michael.

On Tue, Dec 09, 2003 at 04:34:15PM -0400, Jason King wrote:
> 
> mysql> select password from passwd where login='jason' and
> virtual_host='virtual.org';
> +----------+
> | password |
> +----------+
> | test     |
> +----------+
> 1 row in set (0.00 sec)
> 
> mysql>
> 
> that is the result I get, and yes it dos have the select prvilage
> that was the first thing I checked..
> 
> BTW thanks for the help so far.
> 
> -----Original Message-----
> From: Michael Devogelaere [mailto:michael.devogelaere@xxxxxxxxxx] 
> Sent: Tuesday, December 09, 2003 3:52 PM
> To: Jason King
> Cc: qmail-sql@xxxxxxxxxx
> Subject: 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]
> > -----------------------------------------------------------------
> > 
> 
> -----------------------------------------------------------------
> [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]
-----------------------------------------------------------------


-----------------------------------------------------------------
[This E-mail was scanned for viruses by the Freemotion mailman]
-----------------------------------------------------------------