[vchkpw] vpopmail error with courier-imap

2006-04-24 Thread Oliver A. Rojo

hi!

I just installed vpopmail with mysql + courier-imap
Pop and smtp authentication is fine but when i login into my webmail, 
authdaemond is complaining...


authdaemond: vauth_getpw: failed select: SELECT pw_name, pw_passwd, 
pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd FROM 
1stweb_com WHERE pw_name = 'user' : ERROR:  syntax error at or near 1 
at character 94


What should I do?

--


Oliver A. Rojo




__

This email and any files transmitted with it are confidential 
and intended solely for the use of the individual or entity to 
whom they are addressed. If you have received this email in error 
please notify the system manager. Please note that any views or 
opinions presented in this email are solely those of the author 
and do not necessarily represent those of the company. Finally, 
the recipient should check this email and any attachments for the
presence of viruses. The company accepts no liability for any 
damage caused by any virus transmitted by this email.




Re: [vchkpw] vpopmail error with courier-imap

2006-04-24 Thread Stoyan Marinov




lol... this is a good one!
Try adding backquotes around the table name in vmysql.h and recompile vpopmail  courier-authlib.

Stoyan

On Tue, 2006-04-25 at 01:25 +0800, Oliver A. Rojo wrote:


hi!

I just installed vpopmail with mysql + courier-imap
Pop and smtp authentication is fine but when i login into my webmail, 
authdaemond is complaining...

authdaemond: vauth_getpw: failed select: SELECT pw_name, pw_passwd, 
pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell , pw_clear_passwd FROM 
1stweb_com WHERE pw_name = 'user' : ERROR:  syntax error at or near 1 
at character 94

What should I do?