Users table, username varchar value is wrong on older clusters upgraded to newer version.

This affects older cluster being upgraded to hsphere. New installs are not affected.

su - cpanel

psql hsphere

hsphere=# \d users

Table "public.users"

Column | Type | Modifiers

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

id | integer | not null

username | character varying(20) | not null

password | character varying(20) | not null

reseller_id | integer | not null

Indexes:

"users_pkey" primary key, btree (id)

"users_username_key" unique, btree (username)

"users_reseller" btree (reseller_id)



On a brand new install username is actually 22 characters as shown
below:



hsphere=# \d users

Table "public.users"

Column | Type | Modifiers

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

id | integer | not null

username | character varying(22) | not null

password | character varying(20) | not null

reseller_id | integer | not null

Indexes:

"users_pkey" primary key, btree (id)

"users_username_key" unique, btree (username)

"users_reseller" btree (reseller_id)





THE SOLUTION for postgres 7.x:



BEGIN;

ALTER TABLE users ADD username2 character varying(22);

UPDATE users SET username2 = username;

ALTER TABLE users DROP COLUMN username;

ALTER TABLE users RENAME username2 TO username;

CREATE UNIQUE INDEX users_username_key ON users USING btree (username);

select * from users;

#verify data if good, if it is then issue commit. If it is bad then issue rollback; instead.

COMMIT;



THE SOLUTION for postgres 8.x:

ALTER TABLE users ALTER COLUMN username TYPE varchar(22);


Parallels acknowledged bug on 1/9/2009