How to check password has been changed correctly

Discussion in 'Server Operation' started by satimis, May 1, 2009.

  1. satimis

    satimis New Member

    Hi folks,

    Ubuntu 8.04
    MySQL


    Have created a database 'maildb' and ran following steps entering data afterwards.


    mysql> use maildb;

    mysql> show tables;
    Code:
    +------------------+
    | Tables_in_maildb |
    +------------------+
    | aliases		  | 
    | domains		  | 
    | users			| 
    +------------------+
    3 rows in set (0.01 sec)

    Ran following command mistakenly;
    Code:
    mysql> INSERT INTO users (id,name,maildir,crypt) VALUES
    	-> ([email protected]','root','root/', encrypt('apassword') );
    Query OK, 1 row affected (0.00 sec)
    Then exit mysql.

    I should replace 'apassword' with the password used on other files, say 'abcde'.

    Following data have been set on "users"

    mysql> DESCRIBE users;
    Code:
    +-----------------+----------------------+------+-----+-------------------------+-------+
    | Field		   | Type				 | Null | Key | Default				 | Extra |
    +-----------------+----------------------+------+-----+-------------------------+-------+
    | id			  | varchar(128)		 | NO   | PRI |						 |	   | 
    | name			| varchar(128)		 | NO   |	 |						 |	   | 
    | uid			 | smallint(5) unsigned | NO   |	 | 5000					|	   | 
    | gid			 | smallint(5) unsigned | NO   |	 | 5000					|	   | 
    | home			| varchar(255)		 | NO   |	 | /var/spool/mail/virtual |	   | 
    | maildir		 | varchar(255)		 | NO   |	 | blah/				   |	   | 
    | enabled		 | tinyint(3) unsigned  | NO   |	 | 1					   |	   | 
    | change_password | tinyint(3) unsigned  | NO   |	 | 1					   |	   | 
    | clear		   | varchar(128)		 | NO   |	 | ChangeMe				|	   | 
    | crypt		   | varchar(128)		 | NO   |	 | sdtrusfX0Jj66		   |	   | 
    | quota		   | varchar(255)		 | NO   |	 |						 |	   | 
    | procmailrc	  | varchar(128)		 | NO   |	 |						 |	   | 
    | spamassassinrc  | varchar(128)		 | NO   |	 |						 |	   | 
    +-----------------+----------------------+------+-----+-------------------------+-------+
    13 rows in set (0.00 sec)

    Ran following command to correct the mistake and it went through w/o complaint;
    mysql> UPDATE users SET `crypt`=encrypt('abcde') WHERE id='[email protected]';
    Code:
    Query OK, 1 row affected (0.02 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    

    Is there any way to check the password has been changed correctly? TIA


    B.R.
    satimis
     
  2. id10t

    id10t Member

    You could try connecting to the DB wiht the new password...
     
  3. satimis

    satimis New Member

    Hi id10,

    This password is NOT used to connect the DB. It is used controlling a set of mysql files created for setting up this mail server running virtual domain. The setup is NOT completed yet. I must make sure the change has been done correctly. On testing if problem popup I won't doubt it comes on the password.

    satimis
     
  4. falko

    falko Super Moderator ISPConfig Developer

    You put [email protected] in the database? root is a system user, so the database record has no effect.
     
  5. satimis

    satimis New Member

    Hi falko,

    I followed;

    "Add users and domains" on;
    http://flurdy.com/docs/postfix/index.html#data_add
    (7 Edition)

    to create a root user. This is my 2nd round building a mail server running virtual domain according to this doc which worked completely for me on my 1st round/build. Actually "Drop" this database is much easier because not much data entered. However I expect to learn something new to me, if possible. So I took the hard way.

    B.R.
    satimis
     

Share This Page