Ouch. Reacted too fast without verifying properly. The msg_main table
does not log e-mails, but only discussion board entries. So the only
way the procedure previously posted would work is when the offender
would have used the same account to post a message as well. Small chance.
So, here's another (tested) possibility.
By way of example (I wanted to make sure I got it right this time), I
sent myself a test mail which in email.log shows up as:
Thu Oct 31 10:04:04 2002
Subject: test email
From: [log in to unmask]
Bcc: [log in to unmask]
Then I searched the /usr/local/blackboard/httpd/logs/access_log (if
you're on Windows, you probably won't be running apache, and you'd need
to look at how things are logged there) for near time, and the strings
"POST" and "mail":
# grep '31/Oct/2002:10:0' access_log | grep mail | grep POST
10.34.20.9 - m04979 [31/Oct/2002:10:04:05 +0100] "POST
/bin/common/user_sendmail_select.pl HTTP/1.1" 200 -
The third field in the record is the user's login id. And again, you
can find the details in the database.
SQL> select * from users where user_id='m04979';
Kate, as to e-mail logging, the only blackboard logging I know of is the
email.log. So, I think you've been passing on the right message.
And yes, the anonymous/non-anonymous is just a Y/N flag in msg_main
called POST_AS_ANNON_IND, so you can find offending users if you like.
Sorry about the initial mis-direction. Hope this helps you better.
Herta
Kate Boardman wrote:
>This might be a really stupid comment/realisation, but does this mean that
>if you know what you are looking for in the database that Bb does actually
>log sent email (I've been telling people there's no way at all of getting
>back/any copy of messages sent...)
>
>And while I'm here - just a comment to be potentially aware of: when you
>copy courses or organisations (5.5.1) we are consistently finding that
>messages on the discussion board which were posted as anonymous reappear
>with their names attached. (I've also been telling staff that we can't find
>out who posted an anonymous message, but clearly, if you know where to look
>this isn't true...) Therefore somehow a similar type of instruction to the
>one Herta offers here must be able to identify the authors of inapproriate
>anonymous message postings.
>
>kate
>
>~~~~~~~~~~~~~~~~~~~~~
>Kate Boardman
>Learning Technologies Team
>IT Service
>University of Durham
>South Road
>Durham DH1 3LE
>
>Tel.: 0191 374 1502
>Email: [log in to unmask] <mailto:[log in to unmask]>
>Web: http://www.dur.ac.uk/k.l.boardman
>
>
>-----Original Message-----
>From: MLE Blackboard/Courseinfo userslist
>[mailto:[log in to unmask]]On Behalf Of Herta Van den
>Eynde
>Sent: 30 October 2002 12:33 PM
>To: [log in to unmask]
>Subject: Re: Inappropriate emails
>
>
>Don't know what platform you're on, but you can probably 'translate'
>from linux + oracle.
>
>First check out /usr/local/blackboard/tools/logs/email.log to get
>information about the offending email. Let's assume it was sent by
>someone who changed his/her email to "[log in to unmask]".
>
>Next, open your database, and execute the equivalent of
>SQL> select * from msg_main
> where posted_email = [log in to unmask]
> order by dtcreated;
>pick out the record you're looking for, and note down the users_pk1
>field. Let's assume it is 1001.
>Now all you have to do is find out which user is 1001:
>SQL> select * from users
> where pk1 = 1001;
>
>Normal suspect treatment applies.
>
>Herta Van den Eynde
>Toledo system management
>
>K.U.Leuven - Ludit
>W.de Croylaan 52A
>B-3001 Heverlee
>Belgium
>tel: +32 (0)16 322 166
>fax: +32 (0)16 322 999
>
>Mark Gamble wrote:
>
>
>
>>Does anybody know of a way to either check emails sent through
>>Blackboard for inappropriate content, or, after the event, to find out
>>who sent them. This seems dead obvious but one enterprising soul has
>>changed email account details to an impossible address and then sent an
>>offensive email to a member of staff. Blackboard does not make obvious
>>which account the email was sent by......
>>--
>>Regards
>>Mark
>>
>>Mark Gamble - Head, AV-Media Services, Learning Resources
>>Tel ext 2260 Fax 2259 Mobile 077 200 686 05
>>
>>http://lrweb.luton.ac.uk/av-media/
>>
>>
|