Thanks Richard,
It was an error in the vmysql.h select statement for the GETALL
function, remove the pw_domain column.
It is in vpopmail-4.10.31
Nice work!
Ken
"Richard T. Wareing" wrote:
>
> I forgot to mention what version of QMailAdmin, it is 0.70, which
> shouldn't really be a factor since I think the problem lies in Vpopmail.
>
> Rich...
>
> -----Original Message-----
> From: Richard T. Wareing
> Sent: Thursday, August 02, 2001 1:27 PM
> To: [EMAIL PROTECTED]
> Subject: Vpopmail 4.10.30 - Vmysql.c possible bug
>
> I installed a completely fresh copy of Vpopmail 4.10.30 on a box, along
> with Qmailadmin (and cleaned out the vpopmail mysql DB, forcing it to
> recreate a new one) and noticed that under the "comment" section in the
> web qmailadmin web interface the names weren't showing up properly,
> instead printing out a "0" where the name should be.
>
> I made a change to the vauth_getall function in vmysql.c source in
> vpopmail 4.10.30 that seemed to fix this:
>
> if ((row_getall = mysql_fetch_row(res_read_getall)) != NULL) {
> strncpy(vpw.pw_name,row_getall[0],SMALL_BUFF);
> strncpy(vpw.pw_passwd,row_getall[2],SMALL_BUFF);
> vpw.pw_uid = atoi(row_getall[3]);
> vpw.pw_gid = atoi(row_getall[4]);
> strncpy(vpw.pw_gecos,row_getall[5],SMALL_BUFF);
> strncpy(vpw.pw_dir,row_getall[6],SMALL_BUFF);
> strncpy(vpw.pw_shell, row_getall[7],SMALL_BUFF);
> #ifdef CLEAR_PASS
> strncpy(vpw.pw_clear_passwd, row_getall[8],SMALL_BUFF);
> #endif
>
> It seems that vpw.pw_gecos was being filled with row_getall[4]
> originally which is the gid (i.e. 0). Could somebody more familiar with
> this source code perhaps verify this fix?
>
> Thanks!
>
> Richard Wareing
>
> -----Original Message-----
> From: Ken Jones [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 1:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: converting mysql table from large to usual
>
> sec wrote:
> >
> > Hi,
> > is there any tools to convert mysql large format table to usual
> >
> > i mean to large (--enable-large-site=y) to usual
> > (--enable-large-site=n)
> >
> > How can i do this?
>
> I don't think anyone has written code to do this.
>
> Ken Jones
> inter7.com
