Hi,
My config is:
qmail 1.0.3
MySQL 5.0.15
vpopmail 5.4.10
qmailadmin 1.2.9
The problem is that I cannot view existing email accounts for a domain.
For example, I can login to qmailadmin with the postmaster account and
when I click the *Email Accounts*
</cgi-bin/qmailadmin/com/showusers?user=postmaster&time=1147785864&dom=bluechip.ro&>
link the message is "No users left to view, please return to the
previous page". Also, if I want to create a new user and click the
Create Email Account link, I get a blank page. All other functions are
working, like managing robots and forwards, changing passwords.
</cgi-bin/qmailadmin/com/adduser?user=postmaster&dom=bluechip.ro&time=1147785864&>
I set MySQL to log all queries and I noticed that there is a SELECT used
by qmailadmin which returns an error. The command is "select pw_name,
pw_pa00000". Apache log is showing me the same thing:
[Tue May 16 16:41:34 2006] [error] [client xxx.xxx.xxx.xxx] vmysql: sql
error[5]: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '' at line 1, referer: http://mail.domain.com/cgi-bin/qmailadmin
There are other SELECT command logged which are ok:
select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell ,
pw_clear_passwd from vpopmail where pw_name = "postmaster" and pw_domain
= "domain.com"
Dont have any idea what's with that odd SELECT...
Thanks for your replies,
Arthur
