I'm having a problem with this as well, however I'm using mysql authentication on vpopmail 4.9.10. When I try to run vuserinfo I get: [root@mail bin]# ./vuserinfo [EMAIL PROTECTED] vsql_getpw: failed select I have setup vpopmail with large site. Here is the strace output and a select statement to prove that I'm not on glue and the user and domain exist =) : fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0 read(3, 0x8056738, 8192) = -1 EAGAIN (Resource temporarily unavai lable) fcntl64(3, F_SETFL, O_RDWR) = 0 write(3, "L\0\0\0\3select pw_name, pw_passwd, "..., 80) = 80 read(3, "9\0\0\1", 4) = 4 read(3, "\377(\4You have an error in your SQL"..., 57) = 57 fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40 018000 ioctl(1, TCGETS, {B38400 opost isig icanon echo ...}) = 0 write(1, "vsql_getpw: failed select\n", 26vsql_getpw: failed select ) = 26 fcntl64(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0 read(3, 0x8056738, 8192) = -1 EAGAIN (Resource temporarily unavai lable) fcntl64(3, F_SETFL, O_RDWR) = 0 write(3, "\1\0\0\0\1", 5) = 5 shutdown(3, 2 /* send and receive */) = 0 close(3) = 0 munmap(0x40018000, 4096) = 0 _exit(0) = ? mysql> select * from test_com where pw_name="test"; +---------+---------------+--------+--------+-----------+----------------------- ---------------+-----------+ | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | pw_shell | +---------+---------------+--------+--------+-----------+----------------------- ---------------+-----------+ | test | WImaDxBHOuPBs | 0 | 0 | Test User | /home/vpopmail/domains /test.com/test | 100000000 | +---------+---------------+--------+--------+-----------+----------------------- ---------------+-----------+ 1 row in set (0.00 sec) It looks like there's a problem with the SQL statement that it's using. Unfortunatly, I'm not really sure how to figure out what the statement it is using is. What's my next step? Cheers, Tren. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - Tren Blackburn - Owner mailto:[EMAIL PROTECTED] = = End of Time Networks http://www.theendoftime.net - - (403) 269-2122 = =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- On Fri, 25 May 2001, Ben Beuchler wrote: > On Fri, May 25, 2001 at 03:08:50PM +0100, Jack Howard wrote: > > > First it tries to read /var/qmail/users/cdb (and gets a no such file), > > then it tries to open: > > > > ####/vpasswd.cdb, where #### is an odd capital B (but different), 2 u > > characters with accents, and an upside down question mark. This also > > returns "no such file". > > > > Checking on the actual mailservers there is indeed a cdb file in qmail's > > ~/users directory, however it doesn't exist on the Linux box, even > > though both qmail and vpopmail are running. > > You need a coopy of the /var/qmail/users/cdb file from the mail server > on the linux box. It uses that file to figure out which directory to > look in for the vpasswd.cdb file. If it can't find the users/cdb file, > it uses garbage for the path to the vpasswd.cdb file rather than failing > with an error. > > -Ben > > -- > Ben Beuchler There is no spoon. > [EMAIL PROTECTED] -- The Matrix >