How to check password has been changed correctly

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
	-> ('root@localhost','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='root@localhost';

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

 

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

 

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

 

You put root@localhost in the database? root is a system user, so the database record has no effect.

 

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