Upgrade to vpopmail-4.10.7..
Sean
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Ben Beuchler" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 25, 2001 12:13 PM
Subject: Re: vuserinfo on different box to main vpopmail install, shared
filer
> 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
> >
>
>
