That is fixed thanks to Hampton's user.c.patch.
Get the qmailadmin-0.39 Oct25 release and the vpopmail-4.9.5 Oct25
release.
Ken Jones
"Sylwester S. Biernacki" wrote:
>
> Almost two weeks ago I've posted this mail here and no one answered
> me....
> yesterday Patrick Freemond asked me if I've solved this problem.
> The answer is NOT and I can't get known what I'm doing wrong.
>
> This is how I was doing it:
> I've installed mysql, qmail, then vpopmail.
> At the end I've compiled qmailadmin with this parameters:
> ./configure --enable-cgi-bindir=/usr/local/apache/cgi-bin
>--enable-cgi-path=/cgi-bin/qmailadmin
> --enable-autoresponder-bin=/bin/autorespond --enable-vpopmaildir=/home/vpopmail
>
> Of course I had problems with compiling it on RH 6.2 with MySQL
> installed in /usr/local/mysql so I've added to Makefile this:
> COMMONLDADD = -L/home/vpopmail/lib -lvpopmail -L/usr/local/mysql/lib/mysql
>-lmysqlclient
>
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Then compilation went OK. I've installed it and tried to use.
> I've logged in and then I've choosen Pop accounts.
> On page with list of accounts there is a list of letters. When you
> click on letter you should get list of accounts which names are
> started with this letter. Of course when I've choosen letter "p" (like
> postmaster) and I've got
> vsql_getpw: Failed select
>
> Funny, isn't it ?
>
> Has anyone got this problem too (of course without Patrick :>) ?
> If yes please tell me how did you solve it.
>
> Thanks i.a.
>
> On 2000-10-13, at 10:07:03, Sylwester S. Biernacki wrote:
>
> > Hi,
> > yesterday I've compiled and run 0.39 version of qmailadmin.
> > And the problems has started :)
>
> > Vpopmail is compiled with MySQL support.
>
> > First problem is that Makefile doesn't seem to compile without adding
> > COMMONLDADD = -L/home/vpopmail/lib -lvpopmail -L/usr/local/mysql/lib/mysql
>-lmysqlclient
> >
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> > to it after ./configure script
> > Maybe it's because of my Linux box, but I've tested it on many RH
> > machines with compiled MySQL in /usr/local/mysql and everywhere works
> > the same way.
>
> > Second problem:
> > When I choose Pop Accounts it opens second page with list of
> > accounts. Of course I have >25 accounts on this test domain and when I
> > choose i.e. letter "o" to look at all accounts started on letter "o"
> > qmailadmin flows " vsql_getpw: Failed select " in place of accounts.
> > I looked at source code and even put there
> > FILE fd;
> > fd=fopen("/tmp/whatever","w");
> > fprintf(fd,"%s",SqlBuf);
> > fclose(fd);
>
> > Of course SQL command looks O.K. and even when I open mysql CLI and
> > copy/paste it it returns whole list of accounts in acctual domain.
>
> > Any ideas what is wrong and what to do with this ?
>
> --
> cheers,
> Sylwester S. Biernacki <[EMAIL PROTECTED]>
