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
