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
>
