473,396 Members | 1,900 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

weird terminal display problems with encrypted passwords

LRW
I manage our mySQL database through putty (SSH terminal client).
And whenever I do a select * from the table that contains ENCODEd
passwords, the funky characters do funky things with the display.
From doing weird alignment things, to making it so that so long as
those characters are visible, the display is always scrolled to a line
where one of those screwy ASCII characters are. I can scroll up or
down, but as soon as I type something on the command line, the display
scrolls back so that particular odd character is on display line one.
Weird behavior like that.
Is there something I'm doing wrong with the table type? Something I
should set the putty terminal to (like a certain display type...I
don't know.)
Below is one of the tables that use ENCODE passwords and a sample
display.
Thanks for any suggestions!

mysql> select * from tbl_users;
+----+----------+----------+-------------+----------+--------+----------------------------------------+
| id | username | password | fullname | created | active | email
|
+----+----------+----------+-------------+----------+--------+----------------------------------------+
| 1 | liam | ËæËØ | LRW | 20040406 | 1 |
liam@clipped |
| 2 | chipper | ÛÐ-]¿í=j | Super Duane | 20040407 | 0 |
|
| 3 | mccarter | ýàõJ¾]" | Angela | 20040412 | 1 |
customerservice@clipped |
×e 4 | sarah | 0
LÒ | Sarah | 20040412 | 1 | sarah@clipped |
| 5 | duane | ªéüXòTÜ | Duane | 20040412 | 1 |
designer@clipped |
| 6 | Jerry1 | áÖJì | Jerry | 20040422 | 1 |
jerry@clipped |
| 7 | bryan | ÛÐ-]ÍJ | Bryan K | 20040512 | 1 |
|
| 8 | david | ÛÐ-éÍJ | David V | 20040512 | 1 |
|
}¼=j | Ken K | 20040512 | 0 |
|
+----+----------+----------+-------------+----------+--------+----------------------------------------+
9 rows in set (0.00 sec)

mysql> explain tbl_users;
+----------+------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| username | text | | | | |
| password | blob | | | | |
| fullname | text | YES | | NULL | |
| created | varchar(8) | | | | |
| active | char(1) | | | 1 | |
| email | text | | | | |
+----------+------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
Jul 20 '05 #1
0 1413

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Me | last post by:
I made a login script which retrieves username and password from a database, I can get it to work if the passwords in the database are not encrypted and if I dont encrypt the password when it is...
6
by: Ian Davies | last post by:
Hello I would like to query the user table of the mysql database from my VB application to check that a user's password entered in a text field on a form corresponds to that users password in the...
12
by: Charlie | last post by:
Hi: My host will not allow me use a trusted connection or make registry setting, so I'm stuck trying find a way to hide connection string which will be stored in web.config file. If I encrypt...
0
by: Milos Prudek | last post by:
I cannot set up password authentication with encrypted passwords. With plaintext passwords auth works fine. So my guess is that I am using an incorrect password encryption program. What...
26
by: David Garamond | last post by:
I read that the password hash in pg_shadow is salted with username. Is this still the case? If so, since probably 99% of all PostgreSQL has "postgres" as the superuser name, wouldn't it be better...
2
by: Bernard Dhooghe | last post by:
The information center writes: "Encryption Algorithm: The internal encryption algorithm used is RC2 block cipher with padding, the 128-bit secret key is derived from the password using a MD2...
5
by: Shmuel | last post by:
Hello, Is it possible to give to mysql_connect an encrypted (md5 or sha1) password? If not is there a workaround? I store passwords for users in database and don't want to use plain text...
0
by: wolfonenet | last post by:
Hi All, My setup is: WinXP Python 2.5.1 TKinter version: $Revision: 50704 $ Tcl: 8.4 Debugger: WinPdb
4
n8kindt
by: n8kindt | last post by:
i'm trying to create a secure scenario where no one will be able to know our encrypted database passcode. BUT if they login to a form in another database successfully, it will open the encrypted...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.