encryption/decryption

On 4/1/06, AKHILESH GUPTA <akhilesh.davim@gmail.com> wrote:

hi all,
just to ask u all one thing regarding encryption/decryption.

i am migrating my database from mysql to pgSQL using a php script.
in mysql there is a table 'users' where a field 'password' is there of type
varchar(30),
and is encrypted using AES algorithm

The 'users' table in the 'mysql' database is md5'ed. You can't decrypt it.

--
Postgresql & php tutorials
http://www.designmagick.com/

Hi Akhilesh,
Can you send the script please.... I want to see that.

--Nirmalya

--- AKHILESH GUPTA <akhilesh.davim@gmail.com> wrote:

hi all,
just to ask u all one thing regarding encryption/decryption.

i am migrating my database from mysql to pgSQL using a php script.
in mysql there is a table 'users' where a field 'password' is there
of type
varchar(30),
and is encrypted using AES algorithm, and when i check all the
records in
mysql it looks like:-

mysql> select * from USERS;

+----+----------+------------------+-------------------+------------+-------+

| id | name | password | password_modified | created_on
| admin
|

+----+----------+------------------+-------------------+------------+-------+

| 1 | Admin | \uffff\uffff\u6fde\uffff\uffff
\uffff/|\uffff9A | Y |
2005-08-10 |
Y |
| 2 | sangeeta |
\uffff\uffffX\uffff\uffff\u0215\u0635\uffffkg\uffffg\uffff
| Y | 2005-08-13 | Y |
| 3 | check1 |

\uffff\uffff\uffff\uffff\uffff\uffffb\uffff\uffff\u0496@\u0274\uffff4

|
Y | 2005-08-10 | Y |
| 4 | check2 | | Y | 2005-08-10
| N
|
| 5 | check3 |
V[6\uffff\uffff\uffffw\uffff\uffff\uffff\uffff.C'\uffff |
Y | 2005-08-10 | N |
| 16 | user |
5\uffff\uffff\uffff\uffff<\uffff.\uffff\uffff\uffff\uffff^k |
Y | 2005-08-10 | N |
| 6 | admin |
\uffff77\uffff\uffff\uffffs\uffff\uffff3h\uffffM\uffff%\uffff |
Y | 2005-08-10 | Y |
| 17 | anita |
\uffff\uffff\uffff\uffff\uffff\uffffH\uffff"\uffffhe)U\uffff |
Y | 2005-09-27 | Y |
| 1 | Akhilesh | cheeks | y | 2006-04-01
| y
|

+----+----------+------------------+-------------------+------------+-------+

9 rows in set (0.00 sec)

(all these "ufff\ufff\ufff<\ufff\U\ufff" the password field is
seems as
special characters like triangles and rectangles, u can say like
chinese
characters)

now, when i am running my script, then only one record, where
name='check2'
is copied (because no password is there in this case), but not any
other
record is displayed.........

plz help me in this case and do tell what should i do to copy all
the
records.......
(any suggestion either at the php/mysql/postgresql level)
do help me..............plzzzzzzzzz..............!
--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com