Task #4760 (closed)
Opened 13 years ago
Closed 12 years ago
BUG: problems setting up a db
Reported by: | cblackburn | Owned by: | cblackburn |
---|---|---|---|
Priority: | minor | Milestone: | OMERO-4.4 |
Component: | General | Version: | n.a. |
Keywords: | n.a. | Cc: | jamoore |
Resources: | n.a. | Referenced By: | n.a. |
References: | n.a. | Remaining Time: | 0.0d |
Sprint: | 2012-01-17 (6) |
Description
On Ubuntu 9.10 using a newly created db,
psql -h localhost -U omero omero < OMERO4.2__0.sql
fails,
... NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "password_pkey" for table "password" CREATE TABLE ERROR: value too long for type character(24) ERROR: current transaction is aborted, commands ignored until end of transaction block ...
The relevant lines in the sql are,
insert into password values (0,'LSjpGNDDKH/7iZyIwB8OTA=='); insert into password values (1,'');
so not longer than 24.
Change History (3)
comment:1 Changed 12 years ago by cblackburn
- Milestone changed from Unscheduled to OMERO-Beta4.4
- Owner set to cblackburn
- Sprint set to 2012-01-17 (6)
- Status changed from new to accepted
comment:2 Changed 12 years ago by cblackburn
- Remaining Time set to 0.5
comment:3 Changed 12 years ago by cblackburn
- Remaining Time changed from 0.5 to 0
- Resolution set to invalid
- Status changed from accepted to closed
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
I have been unable to recreate this on 4.2.x or 4.3.x