<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR><!--[if !mso]>
<STYLE>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</STYLE>
<![endif]-->
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:vt100;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>The Oracle readme said that the DB needs to be
prepared.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>So i ran the schema.Oracle file via the SQLPlus and it
inserted all the tables and indexes.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>So i now have the database setup, just empty. No
data.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>Then, while running the 'make initialize-database' there's
a step in that script to insert the schema. Since i already did that - i
commented it out, just like the Wiki suggests.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>So that step should be skipped and it should just try to
insert the required data into the DB.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>And that's where i'm stuck at this
point.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>After some googling i found that i might have a problem
with the DBD::Oracle. Apparently it tried installing that module as a
64-bit.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>But my Perl is 32-bit. This seems to be a common
occurence.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>Here's what i'm getting when trying to run 'make
initialize-database' :</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>/usr/bin/perl //usr/local/rt3_ora/sbin/rt-setup-database
--action init --dba mwpoc --prompt-for-dba-password<BR>Unquoted string "error"
may clash with future reserved word at /usr/local/rt3_ora/etc/RT_SiteConfig.pm
line 286.<BR>In order to create or update your RT database,this script needs to
connect to your Oracle instance on clorad1.aig.com as mwpoc.<BR>Please specify
that user's database password below. If the user has no database<BR>password,
just press return.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>Password: <BR>DSN component 'CLORAD1' is not in
'name=value' format at /usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line
627<BR>DBI connect('CLORAD1;port=1521','mwpoc',...) failed: Can't connect using
this syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103<BR>Failed to
connect to dbi:Oracle:CLORAD1;port=1521 as mwpoc: Can't connect using this
syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line 103,
<STDIN> line 1.<BR>make: *** [initialize-database] Error
255</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=671384117-17052007><FONT face=vt100
color=#0000ff size=2>The hostname where oracle Db is running is clorad1.aig.com.
Instance/Service name is CLORAD1.</FONT></SPAN></DIV><BR>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Justin Brodley
[mailto:jbrodley@sumtotalsystems.com] <BR><B>Sent:</B> Thursday, May 17, 2007
1:40 PM<BR><B>To:</B> Baytalskiy, Sal;
rt-users@lists.bestpractical.com<BR><B>Subject:</B> RE: [rt-users] Desperately
ned Oracle help<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">I
would make sure the variable is set everywhere, the initial data is imported
with the schema, that you commented out. Out of curiosity why are you
commenting out the “schema” the only reason you would do this is if the
database was already created with all the appropriate tables. Our oracle guys
just setup the RT user as per the oracle readme and then we just ran
initialize-database and it created the rest. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: navy; FONT-FAMILY: 'Calibri','sans-serif'">Justin
Brodley<o:p></o:p></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'"> Baytalskiy, Sal
[mailto:Sal.Baytalskiy@AIG.com] <BR><B>Sent:</B> Thursday, May 17, 2007 10:34
AM<BR><B>To:</B> Justin Brodley;
rt-users@lists.bestpractical.com<BR><B>Subject:</B> RE: [rt-users] Desperately
ned Oracle help<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'vt100','serif'">Thanks a
lot, Justin!!!</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'vt100','serif'">This is
very valuable info!</SPAN><o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'vt100','serif'">However,
i'm not at that step yet. I've just built RT with Oracle support and was
trying to run 'make initialize-database'</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'vt100','serif'">I've
commented out the 'insert_schema()' method call, cause schema is already in
place.</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'vt100','serif'">I was
expecting the thing to insert the initial RT data into the DB. But that's
where it was failing.</SPAN><o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'vt100','serif'">Do you
think i should set the variable you mentioned in the shell and try running it
again?</SPAN><o:p></o:p></P>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<P class=MsoNormal><o:p> </o:p></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=2>
</DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Justin
Brodley<BR><B>Sent:</B> Thursday, May 17, 2007 1:20 PM<BR><B>To:</B>
Baytalskiy, Sal; rt-users@lists.bestpractical.com<BR><B>Subject:</B> RE:
[rt-users] Desperately ned Oracle help</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Sal-
It has to do with Apache and your CGI handler not knowing the oracle
parameters. We use Fast CGI on Redhat connecting to a remote Oracle servers.
I had to add the following lines to my httpd.conf
file:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">#
RT STUFF FOR APACHE<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">SetEnv
LD_LIBRARY_PATH
/u01/app/oracle/product/10.2.0/client_1/lib<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">SetEnv
ORACLE_HOME /u01/app/oracle/product/10.2.0/client_1<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">SetEnv
ORACLE_SID rt<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">SetEnv
TWO_TASK rt<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">(change
above variables to your implementation)<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">In
Httpd conf I also had to change the initialization string for Fastcgi, this
is the line in my config.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">FastCgiServer
/opt/rt3/bin/mason_handler.fcgi -idle-timeout 120 -processes 4 -initial-env
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/client_1/lib -initial-env
ORACLE_HOME=/u01/app/oracle/product/10.2.0/client1 -initial-env
ORACLE_SID=rt -initial-env TWO_TASK=rt<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">Some
of this might be a bit excessive but I was trying everything and spent a ton
of time on the fastcgi and apache websites trying to figure this out. Once
this was all completed I was successful in getting DBI Searchbuilder
working. This took about a 12 hours of research and trial and error on my
part, and I’ve meant to go back and put this information in the wiki but
haven’t had a chance. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"> Justin
Brodley<o:p></o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of
</B>Baytalskiy, Sal<BR><B>Sent:</B> Wednesday, May 16, 2007 9:49
PM<BR><B>To:</B> rt-users@lists.bestpractical.com<BR><B>Subject:</B>
[rt-users] Desperately ned Oracle help<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Hey
everyone!</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">As ive already
mentioned - i'm being forced to use Oracle for my RT 3.6.3
instance.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Well, today i finally
got an Oracle 10g instance up and loaded the schema.Oracle file into
it.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Did the ./configure
for RT(./configure --prefix=/usr/local/rt3_ora --with-db-type=Oracle
--with-db-host=clorad1.example.com --with-db-port=1521
--with-db-rt-host=localhost --with-db-dba=rtusr --with-db-database=clorad1
--with-db-rt-user=rtusr --with-db-rt-pass=*****
)</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Everything was
ok.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">While doing make
initialize-database i got this error: Unable to load DBIx::SearchBuilder
database handle for 'Oracle'.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Realized that i don't
have DBD::Oracle installed, so i downloaded that from CPAN and installed
that.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">There were errors
during the install and i found a workaround to delete -xarch=v9 from the
Makefile. After that install finished.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Then i followed the
Wiki and commented out</SPAN> <SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">the insert_schema()
method call.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">But i'm still getting
errors trying to init the DB.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Test suggested by the
Wiki (TWO_TASK=FOO perl -MDBI -le 'DBI->connect("DBI:Oracle:", "rt3",
"rt3")') seems to be successful. Or at least it doesn't give any
errors.</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">This is the error i
get while doing make initialize-database :</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">DSN component
'CLORAD1' is not in 'name=value' format at
/usr/perl5/site_perl/5.8.4/sun4-solaris-64int/DBI.pm line 627<BR>DBI
connect('CLORAD1;port=1521','rtusr',...) failed: Can't connect using this
syntax without specifying a HOST and one of SID INSTANCE_NAME SERVER
SERVICE_NAME at //usr/local/rt3_ora/sbin/rt-setup-database line
103<BR>Failed to connect to dbi:Oracle:CLORAD1;port=1521 as rtusr: Can't
connect using this syntax without specifying a HOST and one of SID
INSTANCE_NAME SERVER SERVICE_NAME at
//usr/local/rt3_ora/sbin/rt-setup-database line 103, <STDIN> line
1.<BR>make: *** [initialize-database] Error 255</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">PLEASE HELP
!!!</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal> <o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Thanks in
advance,</SPAN><o:p></o:p></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'vt100','serif'">Sal.</SPAN><o:p></o:p></P></DIV></BLOCKQUOTE></DIV></BLOCKQUOTE></BODY></HTML>