Web interface username & password
-
- Posts: 6
- Joined: 31 Mar 2015 09:52
Web interface username & password
Dear All
Kindly note that i'm a new here and this is the first time that i'm using Efa, i configured the VM, and i have the root pssword, but when i try to use the web interface i cannot login.
could you please guide me that how i can login to it.
Thank you
Kindly note that i'm a new here and this is the first time that i'm using Efa, i configured the VM, and i have the root pssword, but when i try to use the web interface i cannot login.
could you please guide me that how i can login to it.
Thank you
Re: Web interface username & password
Hi
lost password: https://efa-project.org/wiki/Lost_password
Initial Configuration: https://efa-project.org/wiki/Initial_Configuration
Post Configuration: https://efa-project.org/wiki/Post_Configuration
http://yourEFAserver or https://yourEFAserver
Does it help?
lost password: https://efa-project.org/wiki/Lost_password
Initial Configuration: https://efa-project.org/wiki/Initial_Configuration
Post Configuration: https://efa-project.org/wiki/Post_Configuration
http://yourEFAserver or https://yourEFAserver
Does it help?
-
- Posts: 6
- Joined: 31 Mar 2015 09:52
Re: Web interface username & password
Hi
I follow the below link and i use the below command
/usr/bin/mysql -u mailwatch -p XXXXXXXXX mailscanner -e "UPDATE users SET password = md5('XXXXXXX') WHERE user=admin'"
but still i cannot access the web interface.
Waiting your feedback
I follow the below link and i use the below command
/usr/bin/mysql -u mailwatch -p XXXXXXXXX mailscanner -e "UPDATE users SET password = md5('XXXXXXX') WHERE user=admin'"
but still i cannot access the web interface.
Waiting your feedback
Re: Web interface username & password
I'm not sure, but it seems that there is no space in "-p<MailwatchPWD>".
Do you consider this?
user=admin'
should be
user='admin'"
/usr/bin/mysql -u mailwatch -pMailwatchPWD mailscanner -e "UPDATE users SET password = md5('YourNewUserPassword') WHERE user='YourUsername'"
Do you consider this?
user=admin'
should be
user='admin'"
/usr/bin/mysql -u mailwatch -pMailwatchPWD mailscanner -e "UPDATE users SET password = md5('YourNewUserPassword') WHERE user='YourUsername'"
- shawniverson
- Posts: 3650
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
-
- Posts: 6
- Joined: 31 Mar 2015 09:52
Re: Web interface username & password
Thank you for you reply but still not working
I use the below command exactly , and I add ' before admin
/usr/bin/mysql -u mailwatch -p XXXXXXXXX mailscanner -e "UPDATE users SET password = md5('XXXXXXX') WHERE user='admin'"
but when i press Enter it will give me" the attached file "
and when I re-login to Web interface it's fail login.
Thank you for your support
I use the below command exactly , and I add ' before admin
/usr/bin/mysql -u mailwatch -p XXXXXXXXX mailscanner -e "UPDATE users SET password = md5('XXXXXXX') WHERE user='admin'"
but when i press Enter it will give me" the attached file "
and when I re-login to Web interface it's fail login.
Thank you for your support
- Attachments
-
- error.JPG (50.82 KiB) Viewed 40644 times
Re: Web interface username & password
You still have a blank space between -p and password!?
Re: Web interface username & password
Please keep in mind that the username is the user you gave during the setup.
You can list your users with the command:
To reset use the mentioned reset command.
and ofcourse change yourusername and yourpassword.
You can list your users with the command:
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "select * from users"
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = md5('YOURPASSWORD') WHERE user='YOURUSERNAME'"
Version eFa 4.x now available!
-
- Posts: 6
- Joined: 31 Mar 2015 09:52
Re: Web interface username & password
Dear Dark83
Kindly note that i run that command but nothing change still i cannot access the web interface.( Checked the attached file error_2).
could you please advice me , what shall i do , and as i told you that i have the root password, but my problem only when that i cann't access the web interface. ( error_3)
waitting your advice.
Thank you
Kindly note that i run that command but nothing change still i cannot access the web interface.( Checked the attached file error_2).
could you please advice me , what shall i do , and as i told you that i have the root password, but my problem only when that i cann't access the web interface. ( error_3)
waitting your advice.
Thank you
- Attachments
-
- Error_3.JPG (33.11 KiB) Viewed 40618 times
-
- Error_2.JPG (36.64 KiB) Viewed 40618 times
Re: Web interface username & password
Are you sure your username is 'admin'?
You entered the username during the initial setup, so if you entered something else then you need to use that username instead of 'admin'.
(also you forgot the backticks (`) so the command you entered does not work.
)
First try to get a list of your users with the command:
This should output atleast 1 row that contains an username.
You entered the username during the initial setup, so if you entered something else then you need to use that username instead of 'admin'.
(also you forgot the backticks (`) so the command you entered does not work.
![Whistle :whistle:](./images/smilies/eusa/whistle.gif)
First try to get a list of your users with the command:
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "select * from users"
Version eFa 4.x now available!
-
- Posts: 6
- Joined: 31 Mar 2015 09:52
Re: Web interface username & password
Appreciate you support first of all.
but my friend i run the command so many times, and i got a new error ( check the attached file ).
i don't know what shall i do now,k because i fed up![Smile :)](./images/smilies/icon/smile.gif)
Waiting your feedback
but my friend i run the command so many times, and i got a new error ( check the attached file ).
i don't know what shall i do now,k because i fed up
![Smile :)](./images/smilies/icon/smile.gif)
Waiting your feedback
- Attachments
-
- error_4.JPG (34.64 KiB) Viewed 40610 times
Re: Web interface username & password
Do this first
You should get one line back that looks like this:
If you do, type in
it will succeed or fail.
if it fails, do this
You should get back a line like
if you do, type in
If either mysql command works and you are connected to the database, type in this
post those results
Warning: do not post your passwords. We only need the results of the final query, or the results from the mysql command if they both failed.
Code: Select all
cat /etc/EFA-Config |grep SQL|grep MAILWATCHSQLPWD
where XXX...XXX is your mysql password.MAILWATCHSQLPWD:XXX...XXX
If you do, type in
Code: Select all
mysql -umailwatch -pXXX...XXX mailscanner
if it fails, do this
Code: Select all
cat /etc/EFA-Config |grep SQL|grep MYSQLROOTPWD
where YYY...YYY is your mysql root password.MYSQLROOTPWD:YYY....YYY
if you do, type in
Code: Select all
mysql -uroot -pYYY...YYY mailscanner
Code: Select all
select * from users;
Warning: do not post your passwords. We only need the results of the final query, or the results from the mysql command if they both failed.
Re: Web interface username & password
Hi alkarakiomar
Try the methode pdwalker mentioned,
Looking at the screenshots you have some of the quotes wrong so it is not working the line should be:
Note after the -p it should be a backtick not a quote, same for the last one for mailscanner that is a backtick not a single quote ![Smile :)](./images/smilies/icon/smile.gif)
But try the way pdwalker mentioned, that way you don't have to use the longer command.
Try the methode pdwalker mentioned,
Looking at the screenshots you have some of the quotes wrong so it is not working the line should be:
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "select * from users"
![Smile :)](./images/smilies/icon/smile.gif)
But try the way pdwalker mentioned, that way you don't have to use the longer command.
Version eFa 4.x now available!
-
- Posts: 6
- Joined: 31 Mar 2015 09:52
Re: Web interface username & password
Hi Dark83
hope you are fine and everything is under control not like me
Please find the attached file ( error_5
),
i follow all your steps but still it fail
Best regards,
hope you are fine and everything is under control not like me
![Smile :)](./images/smilies/icon/smile.gif)
Please find the attached file ( error_5
![Smile :)](./images/smilies/icon/smile.gif)
i follow all your steps but still it fail
Best regards,
- Attachments
-
- error_5.JPG (92.96 KiB) Viewed 40604 times
Re: Web interface username & password
Because he wrotes
/usr/...
/usr/...
Re: Web interface username & password
Yup I see a whole lot of typing mistakes, make sure it is exactly as mentioned above.
Version eFa 4.x now available!
Re: Web interface username & password
yeah, until you get the commands typed in properly, it's hard to go forward.
use the commands as I've written them. It'll take a few more steps, but there are fewer changes to make a mistake.
use the commands as I've written them. It'll take a few more steps, but there are fewer changes to make a mistake.
Re: Web interface username & password
Hi,
i have to change the administrator's password, did a try with the command below, but i always receive a error message :
[root@mx2 ~]# /usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = md5('my-new-password') WHERE user='adminefa'"
ERROR 1054 (42S22) at line 1: Unknown column 'user' in 'where clause'
Is there a other way to change this password ?
Thanks
Best regards
i have to change the administrator's password, did a try with the command below, but i always receive a error message :
[root@mx2 ~]# /usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = md5('my-new-password') WHERE user='adminefa'"
ERROR 1054 (42S22) at line 1: Unknown column 'user' in 'where clause'
Is there a other way to change this password ?
Thanks
Best regards
![Arrow :arrow:](./images/smilies/icon/arrow.gif)
![Talk to the hand :hand:](./images/smilies/eusa/hand.gif)
Re: Web interface username & password
the fieldname is username and not user
+-------------------+-----------------------------+
| username | password |
+-------------------+-----------------------------+
| titi | $some password |
| tata@testdomain | $another password |
Code: Select all
select username, password from mailscanner.users;
| username | password |
+-------------------+-----------------------------+
| titi | $some password |
| tata@testdomain | $another password |
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
Re: Web interface username & password
hi,
i'm sorry, but i'm not able to find how to change this password...
It's urgent, as we HAVE to change it a.s.a.p., as someone else have this password ...![Sad :(](./images/smilies/icon/sad.gif)
Thanks
i'm sorry, but i'm not able to find how to change this password...
It's urgent, as we HAVE to change it a.s.a.p., as someone else have this password ...
![Sad :(](./images/smilies/icon/sad.gif)
Thanks
![Arrow :arrow:](./images/smilies/icon/arrow.gif)
![Talk to the hand :hand:](./images/smilies/eusa/hand.gif)
Re: Web interface username & password
show users and passwd's
update password for username: adminefa
TIP.
If you login to mysql -> use mailscanner; -> the update query is much easier. By creating a .my.cnf in your root directory , you can even login without typing (or grepping) passwords.
Code: Select all
mysql -u root -p`cat /etc/EFA-Config | grep MYSQLROOTPWD | sed 's/.*://'` mailscanner -e "Select username, password from users"
Code: Select all
/usr/bin/mysql -u root -p`cat /etc/EFA-Config | grep MYSQLROOTPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = PASSWORD('mysecretpassword') WHERE username ='adminefa'"
If you login to mysql -> use mailscanner; -> the update query is much easier. By creating a .my.cnf in your root directory , you can even login without typing (or grepping) passwords.
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
Re: Web interface username & password
Hi,
i did a try with
/usr/bin/mysql -u root -p`cat /etc/EFA-Config | grep MYSQLROOTPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = PASSWORD('mysecretpassword') WHERE username ='adminefa'"
and now i'm haning with : Bad Username or Password
The password is changed, because the show command show me a other and shorter crypted password ...
Is there a other way, to reset it to the original password ?
i did a try with
/usr/bin/mysql -u root -p`cat /etc/EFA-Config | grep MYSQLROOTPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = PASSWORD('mysecretpassword') WHERE username ='adminefa'"
and now i'm haning with : Bad Username or Password
The password is changed, because the show command show me a other and shorter crypted password ...
Is there a other way, to reset it to the original password ?
![Arrow :arrow:](./images/smilies/icon/arrow.gif)
![Talk to the hand :hand:](./images/smilies/eusa/hand.gif)
Re: Web interface username & password
did the test, to be sure.
Create user tempadm with password dirkjan
Check if user is created ( and show the md5 pwd for 'dirkjan' )
To update a password for user tempadm
After the first time login the password changes in the db.
Check to see the difference
Via Tools and link-> User Management you can change passwords (as user tempadm with password dirkjan is not a secret anymore
)
Create user tempadm with password dirkjan
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "INSERT INTO users SET username = 'tempadm', password = MD5('<dirkjan>'), fullname = 'tempadm', type ='A'"
Code: Select all
mysql -u root -p`cat /etc/EFA-Config | grep MYSQLROOTPWD | sed 's/.*://'` mailscanner -e "Select username, password, MD5('dirkjan') as pwd from users"
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/EFA-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = MD5('dirkjan') WHERE username = 'tempadm'"
Check to see the difference
Code: Select all
mysql -u root -p`cat /etc/EFA-Config | grep MYSQLROOTPWD | sed 's/.*://'` mailscanner -e "Select username, password, MD5('dirkjan') as pwd from users"
Via Tools and link-> User Management you can change passwords (as user tempadm with password dirkjan is not a secret anymore
![Idea :idea:](./images/smilies/icon/idea.gif)
“We are stuck with technology when what we really want is just stuff that works.” -Douglas Adams
Re: Web interface username & password
![Bang Head :angry-banghead:](./images/smilies/angry/banghead.gif)
![Bang Head :angry-banghead:](./images/smilies/angry/banghead.gif)
![Bang Head :angry-banghead:](./images/smilies/angry/banghead.gif)
I was on that Tools and links, but i was to stupid to don't read the first line, User Managemant ...
I only did a search on "password" ....
![Chased With An Axe :violence-axechase:](./images/smilies/violence/axechase.gif)
I will have to learn to read more.
MANY thanks for your help.
Best regards
![Arrow :arrow:](./images/smilies/icon/arrow.gif)
![Talk to the hand :hand:](./images/smilies/eusa/hand.gif)
Re: Web interface username & password
Since this is the first hit from Google, updated path and table for 4.x - the MailWatch Settings -> Reset MailWatch Admin did not work for me, presumably due to invalid characters in the password - as best I can tell, I was unable to set a password that contained a single quote (') character but I was unable to grasp that from the error message, so I resorted to the direct method (below, or as per above).
To list users:
To change the password:
HTH
To list users:
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/eFa/MailWatch-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "select * from users"
Code: Select all
/usr/bin/mysql -u mailwatch -p`cat /etc/eFa/MailWatch-Config | grep MAILWATCHSQLPWD | sed 's/.*://'` mailscanner -e "UPDATE users SET password = md5('password') WHERE username='admin'"