[rt-users] Continous-Login problem after DB move

[Robert Waldner]

On 10/15/2013 09:37 AM, Robert Waldner wrote:
> Hi,
> 
> I'm using RT3.8.8 from the Debian packages with postgres on a different
> machine as a backend. Last night I moved the database from one machine
> (postgres-8.4) to another (postgres-9.1), and pg_dumpall|psql the whole DB.
> 
> Everything looks fine as far as content is concerned
> (creating/closing/moving/commenting on tickets etc.) - but after every
> link I click in the web-interface I have to login again.
> The sessions-table looks fine (to me) on the new DB host, and it's the
> very same on the old one:
> 
>                                    Table "public.sessions"
>    Column    |            Type             |       Modifiers        |
> -------------+-----------------------------+------------------------+-
>  id          | character(32)               | not null               |
>  a_session   | bytea                       |                        |
>  lastupdated | timestamp without time zone | not null default now() |

Ah, solved it - a colleague remembered something from a DB-move with
other software (typo3) and a similar problem.

The solution is to set:
   bytea_output = 'escape'                 # hex, escape
in postgresql.conf (default is 'hex').

cheers,
robert
-- 
// CERT Austria - Robert Waldner <waldner at cert.at>
// http://www.cert.at/ - T: +43 1 5056416 78
// Eine Initiative der nic.at GmbH
// http://www.nic.at/ - Firmenbuchnummer 172568b, LG Salzburg

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: OpenPGP digital signature
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20131015/5d831c40/attachment.sig>