Problem with schema.mysql 3.4

Hi friends,

I am in trouble!
I had RT 3.4 working perfectly.
I installed 3.6.1 with a new database and it looked me great!!
Then I am upgrading my old 3.4.1 database.
I type /opt/rt3/sbin/rt-setup-database --action schema
–datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --action acl
–datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --action insert
–datadir etc/upgrade/
Replacint to 3.5.

But this message appears:

Can’t locate mysql schema.
And folder etc/upgrade/3.5x is empty.

Could someone help me?

Thank you very much

-----Mensagem original-----De: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] Em nome de
rt-users-request@lists.bestpractical.com
Enviada em: sexta-feira, 7 de julho de 2006 10:37
Para: rt-users@lists.bestpractical.com
Assunto: RT-Users Digest, Vol 28, Issue 17

Send RT-Users mailing list submissions t
rt-users@lists.bestpractical.com

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
or, via email, send a message with subject or body ‘help’ to
rt-users-request@lists.bestpractical.com

You can reach the person managing the list at
rt-users-owner@lists.bestpractical.com

When replying, please edit your Subject line so it is more specific than
"Re: Contents of RT-Users digest…"

Today’s Topics:

  1. RE: SOMETHING WAS MISSING! (Duncan Shannon)
  2. Re: problems upgrading RT2 to RT3 (Jodok Ole Muellers)
  3. Re: import-1.0-to-2.0.pl dates are getting lost during
    migration (e.g. date_created => Created) (Jodok Ole Muellers)
  4. RT At A Glance (Roman Steven)
  5. Slow loading unless I alias /NoAuth/js and /NoAuth/css
    (Niels Huylebroeck)
  6. Printer friendly view for tickets (Maciak, TJ)
  7. Re: Printer friendly view for tickets (Todd Chapman)
  8. Hardware upgrade v3.0.10 to 3.60 (Tony Graziano)
  9. Re: Hardware upgrade v3.0.10 to 3.60 (Timothy Smith)
  10. RE: Printer friendly view for tickets (Maciak, TJ)

Message: 1
Date: Thu, 6 Jul 2006 22:05:45 -0500
From: “Duncan Shannon” dshannon@techfluent.com
Subject: RE: [rt-users] SOMETHING WAS MISSING!
To: “Mathew Snyder” jokermjs19@comcast.net, "Brent Geach"
brent@skyblue.eu.org
Cc: rt-users@lists.bestpractical.com
Message-ID:

2B7B7880538AA440B5FBCE7A56E8CB452B531F@TF-FS2.internal.techfluent.com

Content-Type: text/plain; charset=“us-ascii”

What I’ve found is that if you have a newer version that it usually
doesn’t matter. I had the same problem with XML::RSS. Make testdeps
wouldn’t find v1.05 however, I have v1.10 installed. Everything still
worked as expected.

I had some similar problems. I don’t remember exactly what I did…
futz around until it worked. Didn’t seem too hard… until I updated way
too many packages on my netbsd system (en masse) and it choked big time!

Message: 2
Date: Fri, 7 Jul 2006 09:40:04 +0200
From: Jodok Ole Muellers rt3-jolemuel@eu.uu.net
Subject: Re: [rt-users] problems upgrading RT2 to RT3
To: Jackie Hamilton kira@lightsphere.com
Cc: rt-users@lists.bestpractical.com
Message-ID: 20060707094004.0fcd84ce@lixus
Content-Type: text/plain; charset=US-ASCII

Hi Jackie,

I’ve had the same problems.
Downgrading to DBIx-SearchBuilder-1.01 solved the problem for me.
After the migration you can upgrade again to newest version.

jodok

I’m trying to upgrade a RT 2.0.14 db to RT 3.2.2. Am using the
rt2-to-rt3-1.23 scripts. The rt-2.0-to-dumpfile appeared to run ok,
although the metadata looks like it’s incomplete… here’s what it has
fo

Jodok Ole Muellers | Verizon Business
Internet Software System Engineer | Sebrathweg 20
EMEA Server & Service Management | D-44149 Dortmund, Germany
phone: +49 (0)231 972 1432 | vnet : 317 1432
mail : jolemuel@eu.uu.net | fax : +49 231 972 2587
pgp : gpg --keyserver blackhole.pca.dfn.de --recv-keys 5A2A106E

Message: 3
Date: Fri, 7 Jul 2006 09:45:48 +0200
From: Jodok Ole Muellers rt3-jolemuel@eu.uu.net
Subject: Re: [rt-users] import-1.0-to-2.0.pl dates are getting lost
during migration (e.g. date_created => Created)
To: RT-Users@lists.bestpractical.com
Message-ID: 20060707094548.61c52252@lixus
Content-Type: text/plain; charset=US-ASCII

Looks like downgrading to DBIx-SearchBuilder-1.01 solves the problem.
I can’t tell exactly right now cause the migration or 52.0000 tickets is
still running and takes days. I am wondering if it is possible to run
import-1.0-to-2.0 do to incremental migrations (e.g. by commenting out
everything except MigrateTickets and MigrateTransactions and use a “select *
from each_req where id > $where_we_last_stopped” ?

Hello,

PROBLEM: import-1.0-to-2.0.pl does not keep correct dates and
requestors (e.g. date_created )
WANTED: patch for import-1.0-to-2.0.pl or rt-2-0-0

Message: 4
Date: Fri, 7 Jul 2006 06:28:00 -0400
From: “Roman Steven” romansteve@gmail.com
Subject: [rt-users] RT At A Glance
To: rt-users@lists.bestpractical.com
Message-ID:
552eaa670607070328o6ea668d1ie996dd65e1f1db04@mail.gmail.com
Content-Type: text/plain; charset=“iso-8859-1”

HI,

I’ve added several new statuses, but they are not being picked up in the RT
At A Glance. I know where to modify the code for RT 345 to include those
statuses, but I’m not sure how to do this wiht RT 360.

Thanks,
Roman
-------------- next part --------------
An HTML attachment was scrubbed…
URL:
http://lists.bestpractical.com/pipermail/rt-users/attachments/20060707/4abc8
8a0/attachment-0001.htm

Message: 5
Date: Fri, 07 Jul 2006 14:36:23 +0200
From: Niels Huylebroeck niels@bubbles-it.be
Subject: [rt-users] Slow loading unless I alias /NoAuth/js and
/NoAuth/css
To: rt-users@lists.bestpractical.com
Message-ID: 44AE5547.3090300@bubbles-it.be
Content-Type: text/plain; charset=ISO-8859-1

My pages on this 3.6.0 installation load really slow compared to older
(3.4.x) installations.

I noticed that if I Alias those NoAuth directories loading goes a lot faster
as CSS and JS files are not being parsed by my FastCGI interpreter.

Now I thought I was out of the woods, but turns out some of the CSS and JS
uses the mason (?) parser.
So what happens is some elements of the UI are broken. It’s not that
dramatic but I fear it has impact on certain functionality. (haven’t found
any case yet but haven’t tested
thoroughly)

Is there any other way to optimize the speed at which pages load?
I noticed most of the delay in loading a pages comes from loading multiple
documents (which are linked in the html) and parsing each of those pages and
encrypting them (SSL) takes a lot of time.

Vriendelijke groeten, ^ Bubbles IT
^ Oude Heerweg 175
Niels Huylebroeck ^ 9160 Lokeren, Belgie
Systeembeheerder, Programmeur ^ Tel: +32(0)9/355 13 31
niels@bubbles-it.be ^ Fax: +32(0)9/355 13 41

… Key : http://www.bubbles-it.be/pgp/niels.asc
… Fingerprint : 3885 CC0B C7A4 78CC 47DE 47AF 896A 6C40 80FA AF0F …
… Keyserver : http://pgp.mit.edu Key-ID : 0x80FAAF0F …

A diplomat is a person who can tell you to go to hell in such a way that you
actually look forward to the trip.
Caskie Stinnett, “Out of the Red”

Message: 6
Date: Fri, 7 Jul 2006 09:15:10 -0400
From: "Maciak, TJ"tmaciak@ci.grand-rapids.mi.us
Subject: [rt-users] Printer friendly view for tickets
To: rt-users rt-users@lists.bestpractical.com
Message-ID:
<“H0000c1a01a5b2c2.1152278110.frozone1.grand-rapids.mi.us*”@MHS>
Content-Type: text/plain; charset=“us-ascii”

Has anyone out there implemented some kind of printer friendly view for just
the ticket information??

I read in a back article someone saying RT would have printing style sheets
in the next major release but

It did not indicate when that would be? Any ballpark idea on when that will
be available??

Thanks for info/help.

T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713

F: (616)456-3448

-------------- next part --------------
An HTML attachment was scrubbed…
URL:
http://lists.bestpractical.com/pipermail/rt-users/attachments/20060707/51113
7a7/attachment-0001.htm

Message: 7
Date: Fri, 7 Jul 2006 09:24:30 -0400
From: Todd Chapman todd@chaka.net
Subject: Re: [rt-users] Printer friendly view for tickets
To: “Maciak, TJ” tmaciak@ci.grand-rapids.mi.us
Cc: rt-users rt-users@lists.bestpractical.com
Message-ID: 20060707132429.GD25776@chaka.net
Content-Type: text/plain; charset=us-ascii

Has anyone out there implemented some kind of printer friendly view
for just the ticket information??

I read in a back article someone saying RT would have printing style
sheets in the next major release but

It did not indicate when that would be? Any ballpark idea on when
that will be available??

3.6 is out now and has printer friendly css stylesheet.

Message: 8
Date: Fri, 07 Jul 2006 09:22:42 -0400
From: “Tony Graziano” tgraziano@myitdepartment.net
Subject: [rt-users] Hardware upgrade v3.0.10 to 3.60
To: rt-users@lists.bestpractical.com
Message-ID: s4ae27ed.049@mail.myitdepartment.net
Content-Type: text/plain; charset=US-ASCII

I’m guessing I have to do at least “two” steps to make the database upgrade
from 3.0.10 to 3.6.0?

Is this advisable? I didn’t see any schema/acl upgrade notes in 3.6 for
version 3.0.10. Does this mean I have to go to an earlier version of RT and
"bump" the acvl/schema "twice?

I would be going from mysql 3.23.58 to 4.1.20.

Any thoughts or experiences would be appreciated.

Thanks,

Tony

Message: 9
Date: Fri, 07 Jul 2006 09:34:16 -0400
From: “Timothy Smith” tsmith@loc.gov
Subject: Re: [rt-users] Hardware upgrade v3.0.10 to 3.60
To: rt-users@lists.bestpractical.com,tgraziano@myitdepartment.net
Message-ID: s4ae2ab1.083@loc.gov
Content-Type: text/plain; charset=US-ASCII

“Tony Graziano” tgraziano@myitdepartment.net 07/07/06 9:22 AM >>>
I’m guessing I have to do at least “two” steps to make the database
upgrade from 3.0.10 to 3.6.0?

As per the README:
You may also need to update RT’s database. To find out, type:
ls etc/upgrade
For each item in that directory whose name is greater than
your previously installed RT version, run:
/opt/rt3/sbin/rt-setup-database --action schema
–datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --action acl
–datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --action insert
–datadir etc/upgrade/
Since all version numbers in etc/upgrade in the 3.6.0 distribution are
greater than 3.0.10, run the above commands aganst each of the directories
sequentially in order of increasing version number. You do not need to
download any versions of RT older than the current release. Backing up first
is a good idea.

This does seem to confuse a lot of people; perhaps new documentation is in
order?

Tim Smith

Message: 10
Date: Fri, 7 Jul 2006 09:35:47 -0400
From: "Maciak, TJ"tmaciak@ci.grand-rapids.mi.us
Subject: RE: [rt-users] Printer friendly view for tickets
To: todd todd@chaka.net
Cc: rt-users rt-users@lists.bestpractical.com
Message-ID:
<“H0000c1a01a5bd52.1152279346.frozone1.grand-rapids.mi.us*”@MHS>
Content-Type: text/plain; charset=“US-ASCII”

Ahhh! I was thinking major release meant like 4.x

Do you know how difficult it was to migrate from 3.4.x to 3.6.x ??

Did it cause any major problems?

T.J. Maciak

Internet/Intranet Developer
Department of IT
City of Grand Rapids
P: (616)456-3713
F: (616)456-3448

Then I am upgrading my old 3.4.1 database.
I type /opt/rt3/sbin/rt-setup-database --action schema
–datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --action acl
–datadir etc/upgrade/
/opt/rt3/sbin/rt-setup-database --action insert
–datadir etc/upgrade/
Replacint to 3.5.

But this message appears:

Can’t locate mysql schema.
And folder etc/upgrade/3.5x is empty.

I think that is fine.  It just means there weren't any changes.  I 

think the 3.6.1 folder only has one of those files as well.