Get a laugh out of a newbie - Couldn't find schema for mysql

Hello,

Newbie here…

Trying to not be too annoying, but could a newbie
-ever- hope to achieve such a thing ?

:slight_smile:

mysql 4.1.xx
Rt 3.0.5
fastcgi/mysql selected.

make initialize_database blows up:

Now populating database schema.
Creating database schema.
Couldn’t find schema for mysql.
make: *** [initialize-database] Error 2

Any clues ?

In your extract rt setup folder do a ls in the etc folder and see if
there file called schema.mysql. if not re-download the rt-3.0.5 tar file

Michael-----Original Message-----
From: Richard Irving [mailto:rirving@onecall.net]
Posted At: Friday, September 12, 2003 4:37 PM
Posted To: RT
Conversation: [rt-users] Get a laugh out of a newbie - Couldn’t find
schema for mysql
Subject: [rt-users] Get a laugh out of a newbie - Couldn’t find schema
for mysql

Hello,

Newbie here…

Trying to not be too annoying, but could a newbie
-ever- hope to achieve such a thing ?

:slight_smile:

mysql 4.1.xx
Rt 3.0.5
fastcgi/mysql selected.

make initialize_database blows up:

Now populating database schema.
Creating database schema.
Couldn’t find schema for mysql.
make: *** [initialize-database] Error 2

Any clues ?

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Well, it worked.

Thank you…

Next stop was the ACL’s… fixed.

but, alas, yet another issue…

rt_user using password “YES”

I tried adding, and GRANTING the privs…but it
fails anyway…

obviously, something is over-riding me ?

I am sure being a newbie, this is an easy one…

  • cough *

Thanks in Advance!

Richard Irving wrote:

What is it stuck on? Adding the rt_user?

If you are trying to do it manually use this

GRANT SELECT,INSERT,CREATE,INDEX,UPDATE,DELETE ON rt3 TO
rt_user@localhost IDENTIFIED BY “a-password”;

You really shouldn’t have any issues with this…

Michael

Posted At: Friday, September 12, 2003 7:17 PM
Posted To: RT
Conversation: [rt-users] Get a laugh out of a newbie - Couldn’t find
schema for mysql
schema for mysql

Well, it worked.

Thank you…

Next stop was the ACL’s… fixed.

but, alas, yet another issue…

rt_user using password “YES”

I tried adding, and GRANTING the privs…but it
fails anyway…

obviously, something is over-riding me ?

I am sure being a newbie, this is an easy one…

  • cough *

Thanks in Advance!

Richard Irving wrote:

Hello,

Newbie here…

Trying to not be too annoying, but could a newbie
-ever- hope to achieve such a thing ?

:slight_smile:

mysql 4.1.xx
Rt 3.0.5
fastcgi/mysql selected.

make initialize_database blows up:

Now populating database schema.
Creating database schema.
Couldn’t find schema for mysql.
make: *** [initialize-database] Error 2

Any clues ?


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Someone online here said they had RedHat 9,
Apache, and RT all working as a platform…

Any chance we could talk you out of
versions of all the above…

Using RH 9, 3.0.5 RT, and 4.0.14 MySql,
Perl 5.8.0, and CPAN DBI’s (1.67 ?)…

is about as friendly as pulling ones
own teeth…

Thanks!

Someone online here said they had RedHat 9,
Apache, and RT all working as a platform…

Any chance we could talk you out of
versions of all the above…

Using RH 9, 3.0.5 RT, and 4.0.14 MySql,
Perl 5.8.0, and CPAN DBI’s (1.67 ?)…

is about as friendly as pulling ones
own teeth…

There has been extensive discussion about RT on RH9 on this list. The
archives should have plenty of information. Konwn gotcha’s:

  • the mod_perl shipped for apache2 is a beta release, earlier packages
    had a severe bug that
    kept RT from working. One possible solution is to use mod_fastcgi
    with apache2, one other
    to downgrade to apache 1.3.x and mod_perl1

  • LANG/LC_ALL set to something with UTF might cause problems while
    compiling perl modules
    from CPAN. One possible solution was to set LANG=C and LC_ALL=C
    before compilation

  • perl 5.8.0 has a bug that keeps the Storable Perl Module shipped with
    RH9 from working
    correctly. One possible solution is to upgrade Storable - a version
    including a
    workaround has been released

  • MySQL 4.x is recommended for RT, but not shipped by RH. The .rpms
    provided by mysql.com
    seem to make Redhat users happy

  • The Statistics package needs GD::Graph and the newest version of that
    needs libgd 2.x, but
    Redhat only ships version 1.8.4. You need to either get an older
    version of GD::Graph or a
    newer version of libgd to get the pretty images

  • There might be other problems I forgot in this short list. But it is
    possible to have RT 3
    running on RH9

Regards,
Harald

  • the mod_perl shipped for apache2 is a beta release, earlier packages
    had a severe bug that
    kept RT from working. One possible solution is to use mod_fastcgi
    with apache2, one other
    to downgrade to apache 1.3.x and mod_perl1

Easier (IMO) is to upgrade to mod_perl-1.99_09 from the Rawhide source,
which is absent the bugs that hinder RT (or at least some of them.)

Regards,
Mick Szucs mick@onramp.ca
Onramp Network Services Inc.

Red Hat 9 - 2.4.20-8smp
RT 3.0.5
RTFM 2.0RC2
Mysql 4.0.14
Apache 2.0.40
Perl 5.8.0
Cpan 1.76
Storable 2.08

Below is an output of a rt-test-dependencies --with-mysql
perl:
5.8.0…found
MASON dependencies:
Params::Validate 0.02…found
Cache::Cache …found
Exception::Class …found
HTML::Mason 1.16…found
MLDBM …found
Errno …found
FreezeThaw …found
Digest::MD5 2.27…MISSING
Digest::MD5 version 2.27 required–this is only version
2.20 at (eval 32) line 2.
CGI::Cookie 1.20…found
Storable …found
Apache::Session 1.53…found
MAILGATE dependencies:
HTML::TreeBuilder …found
HTML::FormatText …found
Getopt::Long …found
LWP::UserAgent …found
CLI dependencies:
Getopt::Long 2.24…found
CORE dependencies:
Digest::MD5 2.27…MISSING
Digest::MD5 version 2.27 required–this is only version
2.20 at (eval 45) line 2.
DBI 1.37…MISSING
DBI version 1.37 required–this is only version 1.32 at
(eval 46) line 2.
Test::Inline …found
Class::ReturnValue 0.40…found
DBIx::SearchBuilder 0.92…MISSING
DBIx::SearchBuilder version 0.92 required–this is only
version 0.90 at (eval 49) line 2.
Text::Template …found
File::Spec 0.8…found
HTML::Entities …found
Net::Domain …found
Log::Dispatch 2.0…found
Locale::Maketext 1.06…found
Locale::Maketext::Lexicon 0.25…found
Locale::Maketext::Fuzzy …found
MIME::Entity 5.108…found
Mail::Mailer 1.57…found
Net::SMTP …found
Text::Wrapper …found
Time::ParseDate …found
File::Temp …found
Term::ReadKey …found
Text::Autoformat …found
Text::Quoted …found
DEV dependencies:
Regexp::Common …found
Time::HiRes …found
Test::Inline …found
WWW::Mechanize …found
MYSQL dependencies:
DBD::mysql 2.1018…found

Thanks,
Michael-----Original Message-----
From: Richard Irving [mailto:rirving@onecall.net]
Posted At: Monday, September 15, 2003 3:52 PM
Posted To: RT
Conversation: [rt-users] rt-users
Subject: [rt-users] rt-users

Someone online here said they had RedHat 9,
Apache, and RT all working as a platform…

Any chance we could talk you out of
versions of all the above…

Using RH 9, 3.0.5 RT, and 4.0.14 MySql,
Perl 5.8.0, and CPAN DBI’s (1.67 ?)…

is about as friendly as pulling ones
own teeth…

Thanks!

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Any --install returns what?

A.-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of RT
Sent: Tuesday, September 16, 2003 3:21 PM
To: Richard Irving
Cc: rt-users@lists.fsck.com
Subject: RE: [rt-users] rt-users

Red Hat 9 - 2.4.20-8smp
RT 3.0.5
RTFM 2.0RC2
Mysql 4.0.14
Apache 2.0.40
Perl 5.8.0
Cpan 1.76
Storable 2.08

Below is an output of a rt-test-dependencies --with-mysql
perl:
5.8.0…found
MASON dependencies:
Params::Validate 0.02…found
Cache::Cache …found
Exception::Class …found
HTML::Mason 1.16…found
MLDBM …found
Errno …found
FreezeThaw …found
Digest::MD5 2.27…MISSING
Digest::MD5 version 2.27 required–this is only version
2.20 at (eval 32) line 2.
CGI::Cookie 1.20…found
Storable …found
Apache::Session 1.53…found
MAILGATE dependencies:
HTML::TreeBuilder …found
HTML::FormatText …found
Getopt::Long …found
LWP::UserAgent …found
CLI dependencies:
Getopt::Long 2.24…found
CORE dependencies:
Digest::MD5 2.27…MISSING
Digest::MD5 version 2.27 required–this is only version
2.20 at (eval 45) line 2.
DBI 1.37…MISSING
DBI version 1.37 required–this is only version 1.32 at
(eval 46) line 2.
Test::Inline …found
Class::ReturnValue 0.40…found
DBIx::SearchBuilder 0.92…MISSING
DBIx::SearchBuilder version 0.92 required–this is only
version 0.90 at (eval 49) line 2.
Text::Template …found
File::Spec 0.8…found
HTML::Entities …found
Net::Domain …found
Log::Dispatch 2.0…found
Locale::Maketext 1.06…found
Locale::Maketext::Lexicon 0.25…found
Locale::Maketext::Fuzzy …found
MIME::Entity 5.108…found
Mail::Mailer 1.57…found
Net::SMTP …found
Text::Wrapper …found
Time::ParseDate …found
File::Temp …found
Term::ReadKey …found
Text::Autoformat …found
Text::Quoted …found
DEV dependencies:
Regexp::Common …found
Time::HiRes …found
Test::Inline …found
WWW::Mechanize …found
MYSQL dependencies:
DBD::mysql 2.1018…found

Thanks,
Michael
-----Original Message-----
From: Richard Irving [mailto:rirving@onecall.net]
Posted At: Monday, September 15, 2003 3:52 PM
Posted To: RT
Conversation: [rt-users] rt-users
Subject: [rt-users] rt-users

Someone online here said they had RedHat 9,
Apache, and RT all working as a platform…

Any chance we could talk you out of
versions of all the above…

Using RH 9, 3.0.5 RT, and 4.0.14 MySql,
Perl 5.8.0, and CPAN DBI’s (1.67 ?)…

is about as friendly as pulling ones
own teeth…

Thanks!

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm