>>INSERT INTO passwd VALUES ('1','abc','','simone',65534,65534,'','','');
>>
>>Problem:
>>
>>1) I can't login pop3 and imap and in mysql-query-logfile can't see query
>>and/or connection from courier

>You completely messed up things...

>- login with one nummeric char is at least unusual
Ok, I change
>- 'abc' is not a crypted password
how can is possibles to insert crypt password whit sql command ?? Now I
modify the configuration in order to use clear password
##NAME: MYSQL_CRYPT_PWFIELD:0
#
# Either MYSQL_CRYPT_PWFIELD or MYSQL_CLEAR_PWFIELD must be defined.  Both
# are OK too. crypted passwords go into MYSQL_CRYPT_PWFIELD, cleartext
# passwords go into MYSQL_CLEAR_PWFIELD.  Cleartext passwords allow
# CRAM-MD5 authentication to be implemented.

#MYSQL_CRYPT_PWFIELD    crypt

##NAME: MYSQL_CLEAR_PWFIELD:0
#
#
 MYSQL_CLEAR_PWFIELD    clear

>- user has no home and no maildir
Does is really maildir create by maildirmake ????

>- the uid/gid looks also very suspicious
Yes are not really ... I don't understand ... If user authentication are
provide by db, why uid/gid may be really defined ?? and where ??? in
/etc/passwd ???

Yes, this insert is only for test, and is wrong, but before that I can't see
connection in mysql-query-log from courier...

this is query privileges on db
GRANT All ON maildb.* TO username@localhost IDENTIFIED BY 'password';

Therefore, now I'm need of a clarification in order to correctly insert
 the parameters of the query

>>2) User may insert on hand by sql insert ??? no command from courier
package
>>are available to do this ???

>if you feel uncomfortable with sql and want to stick with
>the RPM use authuserdb instead. As long as there is nothing
>in the query-log from mysql things wont work anyway.

Is not problem for me write Sql sintax, and I can create php front-end to
insert user in mysql db : )

>>3) where /usr/lib/courier-imap/libexec/logger store data logfile ???

>Its sent to syslog, check the manpages for logger, syslogd
>and syslogd.conf.

ok : )
therefore this sintax in /etc/syslog.conf can work better...

imap.*          /path/to/imap/logfile
pop3.*          /path/to/pop3/logfile
imap-ssl.*              /path/to/imap-ssl/logfile
pop3-ssl.*              /path/to/pop3-ssl/logfile

right ??? ;-)

>Roland


I'm sorry, but is my first experience with mail, imap and friends .... I
need to install a webmail for my site...
Thank's a lot for your time : )

Bye
Simone


_______________________________________________
courier-users mailing list
[EMAIL PROTECTED]
Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users

Reply via email to