MailWatch password (web user)

[Information Services]

    [ The following text is in the "ISO-8859-1" character set. ]
    [ Your display is set for the "US-ASCII" character set.  ]
    [ Some characters may be displayed incorrectly. ]

Good point.  Thanks for replying though.  I did get it changed by
going through phpmyadmin.

Thanks

Casey

On 10/14/05, Chris Russell <Chris.Russell at knowledgeit.co.uk> wrote:
>  this is a sql query rather than another a mailscanner question,
>
>  However,
>
>    update users set password=md5('newpassword') where username='xxxx';
>
>  .. Assuming the username field is "username" (Check this with "describe
> users" from mysql)
>
> Cheers,
>
> Chris
>
>
> -----Original Message-----
> From: MailScanner mailing list [mailto:MAILSCANNER at JISCMAIL.AC.UK] On
> Behalf Of Information Services
> Sent: 14 October 2005 14:55
> To: MAILSCANNER at JISCMAIL.AC.UK
> Subject: MailWatch password (web user)
>
> I am trying to change the password for the MailWatch web user, but am
> having problems in doing so.
>
> I am running
>
> CentOS 4.1
> mysql-4.1.10a-2.RHEL4.1
> mailwatch-1.0.1
> mailscanner-4.44.1-1
> phpMyAdmin-2.6.3-pl1
>
>
> I have changed the password in:
>
> MailWatch.pm
> SQLBlackWhiteList.pm
> conf.php
>
> from the command line:
>
> mysql mailscanner -u (user) -p
> [changed the password]
> GRANT ALL ON mailscanner.* TO xxx at localhost IDENTIFIED BY 'password';
>
> flush privileges;
> \q;
>
> Then when I try to create a MailWatch Web User, I run into this problem
>
> mysql mailscanner -u (user) -p
> INSERT INTO users VALUES ('xxxx',md5('password'0,'xxxx','A','0');
> ERROR 1062 (23000): Duplicate entry 'xxx' for key 1
>
>
> So what do I need to do in order to change the password for this user?
>
> Casey
>
> ------------------------ MailScanner list ------------------------ To
> unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> 'leave mailscanner' in the body of the email.
> Before posting, read the Wiki (http://wiki.mailscanner.info/) and the
> archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
>
> Support MailScanner development - buy the book off the website!
>
> --
> This message has been scanned for viruses and dangerous content by the
> Nexent Internet Anti Virus and Spam Tagging Service and is believed to
> be clean.
>
>
>
>
>
>
> The contents of this e-mail may be privileged and are confidential.
> It may not be disclosed to or used by anyone other than the addressee(s), nor copied in any way. Any views or opinions presented are solely those of the author and do not necessarily represent those of Knowledge Limited.
>
> If received in error, please advise the sender, then delete it from your system.
>
> ------------------------ MailScanner list ------------------------
> To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
> 'leave mailscanner' in the body of the email.
> Before posting, read the Wiki (http://wiki.mailscanner.info/) and
> the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).
>
> Support MailScanner development - buy the book off the website!
>

------------------------ MailScanner list ------------------------
To unsubscribe, email jiscmail at jiscmail.ac.uk with the words:
'leave mailscanner' in the body of the email.
Before posting, read the Wiki (http://wiki.mailscanner.info/) and
the archives (http://www.jiscmail.ac.uk/lists/mailscanner.html).

Support MailScanner development - buy the book off the website!