search for: sqllog

...The server shall provide fileshare services to some Mac clients (OS 10.4.11). Mail is already running with pam_mysql auth against the mail user database, so we wanted to use it synchronously for samba auth. I just copied the settings from /etc/pam.d/smtp to /etc/pam.d/samba (I additionally enabled sqllog and verbose mode for debugging). When trying to connected with smbclient directly on the server, I receive the following error message: NT_STATUS_LOGON_FAILURE -------------------------------------------------------------------------- /etc/pam.d/samba auth sufficient pam_mysql.so user=samba pas...

...:10 websrv dovecot-auth: dbpasswd changed. Dec 29 12:22:10 websrv dovecot-auth: table changed. Dec 29 12:22:10 websrv dovecot-auth: usercolumn changed. Dec 29 12:22:10 websrv dovecot-auth: passwdcolumn changed. Dec 29 12:22:10 websrv dovecot-auth: crypt changed. Dec 29 12:22:10 websrv dovecot-auth: sqllog changed. Dec 29 12:22:10 websrv dovecot-auth: db_connect called. Dec 29 12:22:10 websrv dovecot-auth: returning 0 . Dec 29 12:22:10 websrv dovecot-auth: db_checkpasswd called. Dec 29 12:22:10 websrv dovecot-auth: pam_mysql: where clause = Dec 29 12:22:10 websrv dovecot-auth: SELECT p...

...ames of the database columns in the "grouptable" # we want it to interact with. Again the names match with those in the db SQLGroupInfo ftpgroup groupname gid members # set min UID and GID - otherwise these are 999 each SQLMinID 500 # Update count every time user logs in SQLLog PASS updatecount SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser # Update modified everytime user uploads or deletes a file SQLLog STOR,DELE modified SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'"...

...ecot-auth: logpidcolumn changed. dovecot-auth: logtimecolumn changed. dovecot-auth: db_connect called. dovecot-auth: returning 0 . dovecot-auth: db_checkpasswd called. dovecot-auth: pam_mysql: where clause = dovecot-auth: SELECT password FROM accountuser WHERE username='XXXX' dovecot-auth: sqlLog called. dovecot-auth: insert into log (msg, user, host, pid, time) values('AUTH SUCCESSFUL', 'XXXX', '', '14813' , NOW()) dovecot-auth: Returning 0 dovecot-auth: returning 0 . dovecot-auth: returning 0. dovecot-auth: pam_mysql: setcred called but not implemented. dov...

...v [%P] %h %t \"%r\" %s" # Define log-files to use TransferLog /var/log/proftpd/proftpd.xferlog ExtendedLog /var/log/proftpd/proftpd.access_log WRITE,READ write ExtendedLog /var/log/proftpd/proftpd.auth_log AUTH auth ExtendedLog /var/log/proftpd/proftpd.paranoid_log ALL default #SQLLogFile /var/log/proftpd/proftpd.mysql # Dynamic Shared Object (DSO) loading # See README.DSO and howto/DSO.html for more details # # General database support (http://www.proftpd.org/docs/contrib/mod_sql.html) LoadModule mod_sql.c # # Support for base-64 or hex encoded MD5 and SHA1 passwords from S...