pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedencryption/decryption
3+ messages / 3 participants
[nested] [flat]
* encryption/decryption
@ 2006-04-01 10:55 AKHILESH GUPTA <akhilesh.davim@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: AKHILESH GUPTA @ 2006-04-01 10:55 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-sql
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"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: encryption/decryption
@ 2006-04-01 11:07 chris smith <dmagick@gmail.com>
parent: AKHILESH GUPTA <akhilesh.davim@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: chris smith @ 2006-04-01 11:07 UTC (permalink / raw)
To: AKHILESH GUPTA <akhilesh.davim@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-sql
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: encryption/decryption
@ 2006-04-01 15:08 Nirmalya Lahiri <nirmalyalahiri@yahoo.com>
parent: AKHILESH GUPTA <akhilesh.davim@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Nirmalya Lahiri @ 2006-04-01 15:08 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-04-01 15:08 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-01 10:55 encryption/decryption AKHILESH GUPTA <akhilesh.davim@gmail.com>
2006-04-01 11:07 ` chris smith <dmagick@gmail.com>
2006-04-01 15:08 ` Nirmalya Lahiri <nirmalyalahiri@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox