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]>
