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

[Andy Harrison]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 20-Mar-2003, Jesse Vincent wrote message "[rt-devel] Postgres, bytea and my
ruined evening."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> After extensive discussions with the current developer of DBD::Pg
> (Thanks, David!), I've come to the conclusion that re-engineering our
> database independence layer to support bytea is a medium/big fix that
> has scary performance implications. Thankfully, we never got around to
> storing raw binary data in the bytea fields that we use. So, it's back
> to "text" columns instead of "bytea".  (At the same time, I added a
> field "LastUpdated" to the in-database session cache, which will make a
> lot of people happy a month or three from now.)
> 
> Can someone from the Postgres camp grab 
> 
> http://fsck.com/aegis/aegis.cgi/rt.3.0.C26.tar.gz?file@aetar+project@rt.3.0+ch
> ange at 26
> 
> and tell me if it deals better?
> 
> 
>       -j
> -- 
> http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.
> _______________________________________________
> rt-devel mailing list
> rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel



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-----