At 10:30 07.09.2000 -0500, you wrote:
>Guenther Blatzheim wrote:
> >
> > After a long period, I recently upgraded from
> > vpopmail-4.8.5+mysql+sqwebmail-0.31 to
> > vpopmail-4.9.2+mysql+sqwebmail-0.99.
> >
> > Unfortunatly there are still some problems.
> >
> > - Compilation: I faced the same problems as discussed in the list with the
> > compilation of sqwebmail. The solution was (as still written in the list)
> > to include the mysql libs explicitly before calling the ./configuration
> script.
> >
> > - Mysql database errors: I still find alot of mysql errors like
> >
> > 000907 13:06:37 Aborted connection 12387 to db: 'centraldb' user: 'hero'
> > host: `xxxx.xxxx.com' (Got an error reading communication packets)
> >
> > Acording to the ChangeLog:
> >
> > >>>
> > 4.9.2
> > Aug 25 - set global close flag for mysql module fixes sqwebmail/mysql bug
> > <<<
> >
> > Is this the problem mentioned in the ChangeLog as fixed?
>
>No. The observed problem was that sqwebmail would not authenticate
>any user. Everyone would receive "Invalid ID or password".
>
> >
> > After some investigation, from my point of view the reason is the missing
> > of some "mysql_close();" statements after database operations in
> > functions!? Till now I introduced 2 new calls and could cut the errors-rate
> > to the half but didn't find all neccessary places yet.
>
>Where are the missing statements supposed to be?
Towards vpopmail-4.8.5 in vmysql.c at the end of the function:
void vupdate_rules(int fdm)
I introduced a vclose(). This reduces 30% of mysql errors in our installation.
> >
> > - APOP: sqwebmail-0.99+mysql and APOP authentification seems to be broken =
> > does not work, while "normal" passwords are fine. I'm not sure, if it is a
> > vpopmail or sqwebmail problem? Does anybody made the same experiences?
>
>I don't do any APOP testing with the releases.
Will it be possible to check?
>Ken Jones
-Guenther
