[rt-devel] Postgres, bytea and my ruined evening.

[Jesse Vincent]

Ah. the unicode fix is apparently a postgres 7.3 addition. I'll upload a
new change within the next few minutes that should resolve this, whicle
still not penalizing folks using pg 7.3
> 
> Nope, no go.
> 
> 
> # make initialize-database
> /usr/bin/perl //opt/rt3/sbin/rt-setup-database --action init --dba pg72
> - --prompt-for-dba-password
> In order to create a new database and grant RT access to that database,
> this script needs to connect to your Pg instance on localhost as pg72.
> Please specify that user's database password below. If the user has no database
> password, just press return.
> 
> Password: Now creating a database for RT.
> Creating Pg database rt3.
> DBD::Pg::db do failed: ERROR:  Multi-byte support is not enabled at
> //opt/rt3/sbin/rt-setup-database line 182, <STDIN> line 1.
> ERROR:  Multi-byte support is not enabled at //opt/rt3/sbin/rt-setup-database
> line 182, <STDIN> line 1.
> *** Error code 255
> 
> Stop in /usr/download/rt/rt-3-0-0rc3.
> 
> 
> 
> 
> Just to backtrack, I extracted a fresh copy of rc3.  Grabbed the aegis url you 
> listed, extracted the file from that url from within the extracted rc3 dir. 
> Had to give execute permission to ./configure and then I used:
> 
> ./configure --with-db-type=Pg --with-db-port=65432 --with-db-dba=pg72
> - --with-db-rt-user=rt --with-rt-pass=xxxxxx
> 
> 
> 
> ~~ 
> Andy Harrison
> Great Works Internet
> System Operations
> ajharrison at gwi.net
> RSA 1024 pgp key: http://www.nachoz.com/andy.pub
> 
> -----BEGIN PGP SIGNATURE-----
> Version: PGP 6.5.8
> 
> iQCVAwUBPnnDcFPEkLgodAWVAQHCqAQAsw2WNdo036mtgYsG6NTvUO5HVk+3MPUT
> 7Aw4lCFtx6uwmliHdqQ2uhrkE9D4J7GNNbPDUkNeKS+OsSxhav0vC4APTiVcKe69
> QZlmfX6itTXTd//mWTndKiO1Xb2WdiyLhvbISziZ8mLdVmXDmGo+sXPaWqK6nBih
> B1U7+VFBFeA=
> =Y0TY
> -----END PGP SIGNATURE-----

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.